Web lists-archives.com

Re: slave to master




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.alshinhab@xxxxxxxxx
tuxawy@xxxxxxxxxxxxxxxxx

On Fri, Apr 29, 2016 at 11:03 AM, Johan De Meersman <vegivamp@xxxxxxxxx>
wrote:

> ----- Original Message -----
> > From: "Jason Mallory" <Jason.Mallory@xxxxxxxxxxx>
> > 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
>
>