If you have deployed databases with high availability before, you
will know that a deployment does not always go your way, even
though you’ve done it a zillion times. You could spend a full day
setting everything up and may still end up with a non-functioning
cluster. It is not uncommon to start over, as it’s really hard to
figure out what went wrong.
So, deploying a MySQL Galera Cluster with redundant load
balancing takes a bit of time. This blog looks at how long time
it would take to do it manually vs using ClusterControl to perform the task. For those who
have not used it before, ClusterControl is an agentless
management and automation software for databases. It supports
MySQL (Oracle and Percona server), MariaDB, MongoDB (MongoDB inc.
and Percona), and PostgreSQL.
For manual deployment, we’ll be using the popular “Google
university” to …[Read more]