Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
If you are relying on distributed recovery to configure the user on all members, when s2 connects to the seed s1 the replication user is replicated or cloned to s1. [mysqld] # # Disable other storage engines # ... At this point, the group has one ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-locally.html
For example: [mysqld] # server configuration datadir=<full_path_to_data>/data/s1 basedir=<full_path_to_bin>/mysql-8.4/ port=24801 socket=<full_path_to_sock_dir>/s1.sock These settings configure MySQL server to use the data directory created earlier ... The most common way to deploy Group Replication is using multiple server instances, to provide high ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-failure-detection.html
In a replication group, each member has a point-to-point communication channel to each other member, creating a fully connected graph. These connections are managed by the group communication engine (XCom, a Paxos variant) and use TCP/IP sockets. In ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-member-actions.html
In this state, it does not accept updates from any clients, even users who have the CONNECTION_ADMIN or SUPER privilege. When this member action is enabled, asynchronous connection failover for replicas is active for a replication channel on a Group ... The following functions can be used to enable and disable actions for members of a group to take in specified situations, and to reset the configuration to the default setting for all member ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrading-member.html
To upgrade a member of a group: Connect a client to the group member and issue STOP GROUP_REPLICATION. Disable Group Replication from starting up automatically so that you can safely connect to the member after upgrading and configure it without it ... This section explains the steps required for upgrading a member of a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
This is the same value displayed in the Id column of the SHOW PROCESSLIST statement, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. unauthenticated user ... Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
Execution of log-flushing statements or commands requires connecting to the server using an account that has the RELOAD privilege. (See Section 6.10, “Unix Signal Handling in MySQL”.) Signals enable log flushing to be performed without having to ... As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
INET_NTOA(expr) Given a numeric IPv4 network address in network byte order, returns the dotted-quad string representation of the address as a string in the connection character set. INET6_NTOA(expr) Given an IPv6 or IPv4 network address represented ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-send-buffers.html
This parameter is used in the config.ini file [tcp] section, and denotes the amount of unsent data (in bytes) that must be present in the send buffer before the connection is considered overloaded. When such an overload condition occurs, ... The NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...