← Back to team overview

maria-discuss team mailing list archive

Re: Regarding Automatic fail-over - Maxscale


Hello Karthick,

if you have only two servers it does not make sense to use a binlog router
for failover. Binlog router has been conceived for the case when you have
many slaves connecting to an intermediate master.

If you want to manage this with two servers, you would have to configure
MaxScale with the multi-master monitor and set your servers with
bidirectional replication. MaxScale will pick up the server which has
read_only=0 as master.

You can also use MRM to manage the failover part. For more instructions
please visit https://github.com/mariadb-corporation/replication-manager


On Tue, Aug 16, 2016 at 9:28 AM Karthick Subramanian <
ksubramanian@xxxxxxxxxxxxxxx> wrote:

> Hi All,
> Can anyone help me to figure out this. I am planning to use Binlogrouter
> for replication (single master and single slave topology). I read from
> google forums for maxscale that with binlog router, it'snot possible to use
> automatic failover. Did anyone try this.
> From google forum (
> https://groups.google.com/forum/#!msg/maxscale/DnFT4eb0BbQ/cHQ3TLEfBAAJ;context-place=forum/maxscale
> )
> "With the 1.3.0 version of MaxScale, the binlogrouter accepts STOP SLAVE,
> START SLAVE and CHANGE MASTER TO ... commands. These can be used to
> change the master server but automating this process with the repmgr is
> not currently possible. Since the binlogrouter supports the normal slave
> management commands, using something like MHA could be possible:
> https://code.google.com/p/mysql-master-ha/ "
> Could anyone help me to understand whether I can use binlog router along
> with automatic failover feature using maxscale. I have read this blog using
> shell script we can achieve, but not sure whether with binlog router, it ll
> work? (
> https://mariadb.com/blog/mariadb-automatic-failover-maxscale-and-mariadb-replication-manager
> )
> Regards,
> Karth
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
Guillaume Lefranc
Remote DBA Services Manager
MariaDB Corporation

Follow ups