In this blog post, I am going to explain an interesting issue which I faced in one of our client project . Few weeks back , I got an requirement from our support client to construct a new MariaDB Galera Cluster ( 10.2.21 ) and an async slave with GTID. The Complete requirement is as below.
- Need to construct the Galera cluster with 37 GB of data ( Using a given MySQL dump file )
- Have to configure an asynchronous slave under the 3 node Galera cluster
- The asynchronous slave was proposed with GTID to ease master node switchover.
So, as per the requirement the architecture will be,
How to achieve this ?
A high level steps
- Install MariaDB 10.2.21 server on all four nodes ( 3 Galera node with wsrep_on = ON & 1 async slave with …