I received many request about MySQL High Availability
Architecture. There are a lot of tools, but how can we use them
to achieve MySQL HA without over engineering everything.
To answer such demand, there is no generic architecture, of
course there are leaders in solutions, but put them together can
result in many different designs, I will start a series of
article on that topic. Feel free, as usual to comment, but also
recommend other tools that could be used in a future post.
So today’s post is related to MySQL InnoDB Cluster with
Hashicorp’s Consul.
Architecture
This is the overview of the deployed architecture:
As you can see, we have 3 data centers, but in fact we have only
two DCs on premises and one in the cloud. A large amount of
request are always …
[Read more]