Single replica manager for Percona XtraDB Cluster

The feature is a tech preview. Before using this feature in production, we recommend that you test restoring production from physical backups in your environment, and also use the alternative backup method for redundancy.

The single replica manager is a simplified version of the Replication manager for Percona XtraDB Cluster and is intended to manage a single replica.

The single replica manager requires using a global transaction identifier (GTID) (Oracle implementation).

To use the single replica manager script, edit the script and adjust the ‘sourceCandidates’ and ‘replCreds’ variables. If the Percona XtraDB Cluster nodes are ‘10.1.1.10’, ‘10.1.1.11’, and ‘10.1.1.12’, and the replication user is ‘repluser’ with a password set to ‘replpass’, the variables should look like the following:

sourceCandidates="10.1.1.10 10.1.1.11 10.1.1.12"
replCreds="source_user='repl', source_password='replpass'"

The credentials to the local MySQL server should be located in the ~/.my.cnf file of the user under which the cron job is defined. The last step is to enable the cron job that runs every minute:

* * * * * /usr/bin/replication_manager.sh 

If you face any issues, do the following:

touch /tmp/replication_manager.log 
chmod a+w /tmp/replication_manager.log

Check the bash trace file for any issues. During the maintenance on the replica, do the following:

touch /tmp/replication_manager.off

Once the maintenance is over, remove the file.

Contact us

For free technical help, visit the Percona Community Forum.

To report bugs or submit feature requests, open a JIRA ticket.

For paid support and managed or consulting services , contact Percona Sales.

---

Last update: 2023-03-28