Single replica manager for Percona XtraDB Cluster¶
This feature is a tech preview. Before using this feature in a production environment, follow these steps:
• Test restoring production from physical backups in your environment.
• Use an alternative backup method to ensure 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.
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.