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.lefr...@mariadb.com> 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 < > ksubraman...@paycommerce.com> 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@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> > -- > Guillaume Lefranc > Remote DBA Services Manager > MariaDB Corporation >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
