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.)
Subject
Views
Written By
Posted
1356
March 21, 2016 12:31PM
911
March 23, 2016 04:52AM
Re: Replication and HA - some basic questions
1077
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.