mysql HA

dba88

Hi

I want to do a POC for high availability and failover for a mysql database with master-slave or master -master replication.

would any help with recommended and best approach.

THanks

Charan

Dave Stokes-MySQL Community Team-Oracle

If you are talking about high availability in general, please refer to these blogs by LeFred on InnoDB Cluster https://lefred.be/content/category/mysql/innodb-cluster/ InnoDB cluster can be run in a single primary (read/write split) or multi-primary. You will need at lest three nodes for fault tolerance.

If you are talking about the MySQL Database Service's High Availability option then I will point you to this blog https://blogs.oracle.com/mysql/mysql-database-service-with-high-availability as it is very simple to set up. The InnoDB cluster is set up for you and managed for you.