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:
None 
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,

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.