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
• Status: Verified
• 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

Description:
Hi, on a replication environment, it would be useful to have a config property like:

autoSwitchToMasterOnSlaveXSecsBehindMaster=1

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,