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
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]