For how to use MySQL Enterprise Backup to back up and subsequently restore a Group Replication member, see Using MySQL Enterprise Backup with Group Replication.
For MySQL Enterprise Backup 8.0.12 and later: When working with
a Group Replication
setup, mysqlbackup makes the backup history
available to all members of the server group by making sure that the
backup_history table is updated on a primary node
after each mysqlbackup operation. The feature
requires the following to be true:
Host names or host addresses contained in the
member_hostcolumn in the
performance_schema.replication_group_memberstable must be resolvable by mysqlbackup.
The same user has been created on every member of the server group to allow mysqlbackup to access the server from any host in the group. This is a sample statement for creating such a user on every member host:
CREATE USER 'mysqlbackup'@'host_name' IDENTIFIED BY 'password';
Do not use
, as that prevents mysqlbackup from connecting from another member host of the group.
All the required privileges, as described in Section 4.1.2, “Grant MySQL Privileges to Backup Administrator”, have been granted to the user with which mysqlbackup connects to the servers, and in the following manners:
Privileges are granted to the user created as discussed in the last bullet (
'mysqlbackup'@'in the example), not to
'mysqlbackup'@'localhost'as illustrated in Section 4.1.2, “Grant MySQL Privileges to Backup Administrator”.
For any of the privileges, make sure it is granted for the user to connect from any member host. For example, on each host, the grant statement for
performance_schema.replication_group_membersshould be repeated to allow access from all member hosts of the group (which are
host3in this example):
GRANT SELECT ON performance_schema.replication_group_members TO 'mysqlbackup'@'host1'; GRANT SELECT ON performance_schema.replication_group_members TO 'mysqlbackup'@'host2'; GRANT SELECT ON performance_schema.replication_group_members TO 'mysqlbackup'@'host3';
Or, if it is possible and secure for your setup, use a wildcard to do the same with one statement; for example:
GRANT SELECT ON performance_schema.replication_group_members TO 'mysqlbackup'@'host_';