We are planning to eventually upgrade to a Percona XtraDB cluster for our primary databases. However, we are currently using the Percona XtraDB Cluster for our read replicas. One of the pods (cluster1-pxc-0) is configured to be a slave of our primary MySQL database and that takes care of synching with the other pods. We’ve setup our pxc configuration to have
skip-slave-start so that it does not start replication on the other 2 pods. However, we want replication to be automatically started on cluster1-pxc-0 because if the pod restarts, replication stops.
Any ideas on how to automatically start replication on only one pod?