← Back to team overview

maria-discuss team mailing list archive

Re: Regarding Automatic fail-over - Maxscale


Sure Guilaume. Thank you for your prompt response. I also thought that I am
over doing for this two server topology with binlog router etc. I thought
let the maxscale manage the replication portion as well using binlogrouter
(in case we extend the topology in future).

I will go thru your recommendation and post further in case anything
required. Thank you again.

On Tue, Aug 16, 2016 at 1:04 PM, Guillaume Lefranc <
guillaume.lefranc@xxxxxxxxxxx> wrote:

> 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
> Regards
> Guillaume
> 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