Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. However, this method is not compatible with starting Group Replication automatically, as specified by ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ip-address-permissions.html
To specify an allow list manually, use the group_replication_ip_allowlist system variable. This address is not the same as the MySQL server SQL protocol host and port, and is not specified in the bind_address system variable for the server instance.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; To check that the plugin was ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance.html
The information in this section is to help you configure a replication group to optimize the automatic handling of any recurring issues that you experience on your particular systems, such as transient network outages or workloads and transactions ... Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
This safeguard is particularly important when the server is configured to start Group Replication on server boot (group_replication_start_on_boot=ON), but it is also useful when Group Replication is started manually using a START GROUP_REPLICATION ...With this setting, you therefore need to pro-actively monitor the servers for ... The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves the group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
You can use the group_replication_autorejoin_tries system variable to force the member to try to rejoin the group automatically at this point. This feature is active by default; the member makes three auto-rejoin attempts. If you do not set an ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
You can do this manually by looking at the GTIDs, or you can compare the GTID sets using stored functions, as described in Section 19.1.3.8, “Stored Function Examples to Manipulate GTIDs”. For Group Replication, this includes both transactions ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
When deploying in single-primary mode, or changing the group to single-primary mode, this system variable must be set to OFF. When a new primary server is elected (automatically or manually), it is automatically set to read/write, and the other ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. The events that relate to the consistency of a system can be split into control operations, either manual or automatically triggered ... In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
If group members have been set up to support the use of a remote cloning operation as part of distributed recovery, this replication user is also used as the clone user on the donor, and requires the correct permissions for this role too. Group ...