Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, which can be can be run on any member of the group. When this is done, the current primary becomes a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-instances.html
In this example, three instances are used for the group, which is the minimum number of instances to create a group. The first step is to deploy at least three instances of MySQL Server, this procedure demonstrates using multiple hosts for the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-getting-started.html
This section provides a detailed tutorial with the steps required to create a replication group with at least three members. MySQL Group Replication is provided as a plugin for the MySQL server; each server in a group requires configuration and ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-gtids.html
The settings are made automatically on the Group Replication channels when they are created, or when a member server in a replication group is upgraded. Group Replication uses GTIDs (global transaction identifiers) to track exactly which ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ip-address-permissions.html
These addresses, and the localhost IP address for IPv4 and IPv6 are used to create an automatic Group Replication allowlist. When and only when the XCom communication stack is used for establishing group communications ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
While traffic is flowing, transactions can be externalized on some members before the others, especially if some members have less write throughput than others, creating the possibility of stale reads. In multi-primary mode ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance.html
Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated recovery. If a member server instance leaves voluntarily or stops communicating with the group, the remaining members agree a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
Setting a timeout means you do not need to pro-actively monitor for servers that are in a minority group after a network partition, and you can avoid the possibility of creating a split-brain situation (with two versions of the group membership) due ... By default, members that find themselves in a minority due to a network partition do not automatically leave the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
In that situation, to re-create the group, it must be started by bootstrapping as if it was being started for the first time. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade-with-mysqlbackup.html
Repeat this process to create a suitable number of new instances, for example to be able to handle a failover. As part of a provisioning approach you can use MySQL Enterprise Backup to copy and restore the data from a group member to new members.