maria-discuss team mailing list archive
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 <
> 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/
>> "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-
>> 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