Some time ago I wrote a script to manage asynchronous replication
links between Percona XtraDB clusters. The original post can be
found here. The script worked well with Percona XtraDB Cluster but it wasn’t working
well with MariaDB®. Finally, the replication manager works
First, let’s review the purpose of the script. Managing
replication links between Galera based clusters is a tedious
task. There are many potential slaves and many potential masters.
Furthermore, each replication link must have only a single slave.
Just try to imagine how you would maintain the following
A complex replication topology
The above topology consists of five clusters and four …[Read more]