I would like to implement High Availability for MySQL8, is this version supported by drbd, heartbeat, corosync, pacemaker? I've looked around online to that regard but there isn't much information about MySQL8. What is the ideal HA cluster for MySQL8?

  • DRBD only protects against disk failure; what about all the other things that can fail? – Rick James Feb 29 at 0:33

Those days I won't recommend you to use these technique to MySQL HA. I love pacemaker but it's not suitable for datbases are those are much more complex.

I would recommend you to use MySQL InnoDB Cluster that handles everything, from orchestration to routing. It provides you everything you need built-in, split-brain prevention, quorum, data consistency, automatic data provisioning, ...

Take a look at :


|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.