Configuring Multiple Instances for MySQL Group Replication

You can protect a MySQL instance for group replication using a primary Commvault instance.

Before You Begin

1. The host name of the Commvault client and MySQL cluster member must be the same for all nodes.

2. Verify that all the cluster clients can communicate with each other using cvd and cvfwd ports.

3. If the proxy backup settings are enabled on the clients, disable it.

4. Add the bEnableMySQLClusterBackup additional setting on all the clients.

   Tip

   You can also add the additional setting at the client group level.

5. If you want to perform log backups and point-in-time restores with MySQL enterprise backups, add the bEnableMEBLogBackup additional setting on the CommServe server.

6. Create a MySQL instance on all cluster nodes.

7. Configure the same database user for all MySQL instances.

8. Enable MySQL enterprise backup on all MySQL instances.

9. Grant all privileges to the database user configured for MySQL instance.

   mysql> grant all privileges on *.* to ‘user_name@’localhost’;
   mysql> grant all privileges on *.* to ‘user_name@’mgr_hosts_part_of_cluster’;

Procedure

1. From the CommCell Browser, go to Client Computers > client > MySQL.

2. Right-click the instance, and then click Properties.

   The Properties of MySQL Instance dialog box appears.

3. On the Cluster Settings tab, do the following:

   1. Select the Enable Cluster Backup check box.

   2. Beside Cluster Instances, click Add.

      The Select cluster instances dialog box appears.

   3. Select the cluster instances that you want to include.

      Note

      The backups are offloaded to the standby nodes in the order the instances appear in the selected list. To change the order, use the down arrow button and the up arrow button .

   4. Click OK.

   5. To run the backup always on the primary server, select the Use primary for backup check box.

   6. To run the backup on the primary server when a failover occurs on the secondary servers (called as replicas), select the Enable failover to primary check box.

4. Click OK.

5. From the CommCell Browser, go to primary Commvault instance > default subclient.

6. Right-click the default subclient, and then click Properties.

   The Subclient Properties dialog box appears.

7. On the Cluster Settings tab, select the Use cluster backup check box.

8. Click OK.

Results

The Commvault software represents the primary Commvault instance with a symbol P.