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@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