Bug #23290 FEATURE REQUEST: Don't listen tcp-port until the slave is "up to date"
Submitted: 14 Oct 2006 11:50 Modified: 28 Dec 2012 19:30
Reporter: Daniel Caballero Rodr�guez Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:5.0.24 OS:Any (R4HES)
Assigned to: CPU Architecture:Any
Tags: replication, Seconds_Behind_Master, slave, wait

[14 Oct 2006 11:50] Daniel Caballero Rodr�guez
Description:
Hello,

 I some environments (like a master to master replication setup) it would be nice to have this feature:

 - when a server starts, it doesn't open the tcp_port until its "Seconds_behing_master" is < N,

 - If this feature is difficult to implement, maybe it's useful to add an option very similar to --port-open-timeout; the only difference needed is that the server must not try to open the port the first time (only it'd try n seconds after the engine is started).

  Thanks a lot,

       Daniel Caballero

How to repeat:
-

Suggested fix:
-
[28 Dec 2012 19:30] Sveta Smirnova
Thank you for the reasonable feature request.

Currently you can add and option --slave-skip-start to your configuration file, then start SQL thread only, watch when if catches up IO thread and only then start IO thread.