Design A Highly Available MySQL Clusters With Orchestrator And ProxySQL In GCP — Part 2
In part1, we explained how we are going to approach the HA setup. Here we can see how to install and configure Orchestrator and ProxySQL, then do the failover testing.
Install and configure MySQL Replication:
We need a MySQL with 4 Read replica and the 4'th replica will have a replica for it. And we must have to use GTID replication. Because once the master failover done, the remaining replicas will start replicating from the new master. Without GTID its not possible, but as an alternate Orchestrator provides Pseudo-GTID.
VM Details: …[Read more]