Bug #82058 Replication: Auto switch to master on slave X Seconds_Behind_Master
Submitted: 29 Jun 2016 19:32 Modified: 11 Jul 2016 8:33
Reporter: Sebastián Ariel Cortés Email Updates:
Status: Verified Impact on me:
Category:Connector / J Severity:S4 (Feature request)
Version:From 5.1.39 OS:Any
Assigned to: Filipe Silva CPU Architecture:Any

[29 Jun 2016 19:32] Sebastián Ariel Cortés
Hi, on a replication environment, it would be useful to have a config property like:


And when we hit slave with readOnly = true, this would check the "show slave status" of the slave, and if it exceeds the variable, then do an auto switch to master.

This show_slave_status could be done x times per minute, to avoid executing it with each query.

How to repeat:
- Configure a replication master slave environment.
- Activate slave delay, to have some out of sync with master.
- Execute queries in readOnly=true mode.
[11 Jul 2016 8:33] Filipe Silva
Hi Sebastián,

This is a reasonable feature request. We shall discuss it internally and as result of that we may or may not implement it, as for now I'll consider it "verified".

Thank you,