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