MySQL Forums
Forum List  »  Replication

Re: Replication and HA - some basic questions
Posted by: Rick James
Date: March 25, 2016 06:58PM

My short answer for the "best" HA today: Galera.

Deploy MariaDB with Galera. Have 3 (or more) nodes scattered in 3 (or more) geographical locations. Put some form of proxy / load-balancer in front of them (several exist). Then you will be imune to virtually any "single point of failure", including disk failure, server failure, datacenter outage, etc.

And Galera-based solutions are multi-master, and "self healing".

MHA and Orchestrator are the chief contenders. Oracle's Fabric is getting close, the the Fabric node is a SPOF. If it fails, all clients stop.

Multi-master (and writing to all masters) is a nightmare in certain failure cases.

Galera requires InnoDB only, and ROW based replication. (You brought these up.)

Options: ReplyQuote

Written By
Re: Replication and HA - some basic questions
March 25, 2016 06:58PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.