ProxySQL automatic failover MySQL Master - Slave replication

[Anish Kumar A K]

Hello ,

Is ProxySQL have the feature to promote Slave as Master when automatic failover .?

If any , please share the details .

When I am reading ,   " The database proxy, MariaDB MaxScale, has built-in automatic failover. If it is enabled, and the master fails, it will promote the most up-to-date slave (based on GTID) to master and reconfigure the remaining slaves (ifany) to replicate from it. In addition, if automatic rejoin is enabled and the failed master is recovered, it will be reconfigured as a slave."

[Markus Bergholz]

On Fri, Feb 26, 2021 at 9:17 AM Anish Kumar A K <an...@6dtech.co.in> wrote:

Hello ,

Is ProxySQL have the feature to promote Slave as Master when automatic failover .?

You'll need also orchestrator: https://www.percona.com/blog/2016/11/09/orchestrator-and-proxysql/

 

If any , please share the details .

When I am reading ,   " The database proxy, MariaDB MaxScale, has built-in automatic failover. If it is enabled, and the master fails, it will promote the most up-to-date slave (based on GTID) to master and reconfigure the remaining slaves (ifany) to replicate from it. In addition, if automatic rejoin is enabled and the failed master is recovered, it will be reconfigured as a slave."

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/b188ade8-83cb-461e-ab77-1b59bcfc4d93n%40googlegroups.com.

[Anish Kumar A K]

Thanks for the quick response Mark . I am just reading the document from the below link .

https://github.com/openark/orchestrator .