Hi, I think you should have a look at MariaDB Connector[1].
It provides Load balancing and failover as Failover occurs when a connection to a primary database server fails and the connector will open up a connection to another database server. For example, server A has the current connection. After a failure (server crash, network down …) the connection will switch to another server (B). Load balancing allows load (read and write) to be distributed over multiple servers. I hope this will help you. [References] [1] https://mariadb.com/kb/en/mariadb/failover-and-high-availability-with-mariadb-connector-j/ -- Eng. Mahmoud Alshinhab AWS Cloud Support Engineer Fedora Ambassador Wiki : https://fedoraproject.org/wiki/User:Tuxawy mahmoud.alshin...@gmail.com tux...@fedoraproject.org On Fri, Apr 29, 2016 at 11:03 AM, Johan De Meersman <vegiv...@tuxera.be> wrote: > ----- Original Message ----- > > From: "Jason Mallory" <jason.mall...@iridium.com> > > Subject: RE: slave to master > > > > Master-master with load balancer would be best > > That's a bit brief, isn't it? :-) > > It's more than worth pointing out that your loadbalancer should not > actually be loadbalancing the connections; master-master replication > doesn't quite work the way you think it does in most scenarios. > > You only want the loadbalancer for the automated failover; but it should > never send requests to more than one master at any given time. Have it send > everything to your primary master only; and when that host fails, have it > send everything to the secondary master only, and never fail back > automatically. > > It's also worth noting that master-master is still not an officially > supported replication topology. Regular master-slave also works fine with > the above loadbalancer configuration; in that case you'll just treat the > slave as the new primary after failover; and will manually reconfigure the > broken master to be a slave (and adapt the loadbalancer config accordingly) > as repair. > > There does exist software that can do those reconfigurations by itself, > MMM is one such example. > > /Johan > > -- > Unhappiness is discouraged and will be corrected with kitten pictures. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
