Documentation Home
MySQL Enterprise Backup 4.1 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.3Mb
PDF (A4) - 1.3Mb
HTML Download (TGZ) - 196.3Kb
HTML Download (Zip) - 225.7Kb


MySQL Enterprise Backup 4.1 User's Guide  /  Using MySQL Enterprise Backup  /  Using MySQL Enterprise Backup with Group Replication

Chapter 8 Using MySQL Enterprise Backup with Group Replication

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 4.1.2 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_host column in the performance_schema.replication_group_members table 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 localhost for host_name, 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'@'host_name 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 SELECT on performance_schema.replication_group_members should be repeated to allow access from all member hosts of the group (which are host1, host2, and host3 in 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_';