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?
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 :