Bug #43366 dynamic slave replication - modify replicate-do options from command line
Submitted: 4 Mar 2009 11:35 Modified: 10 Oct 2013 16:04
Reporter: Roger David Nay Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:Any OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[4 Mar 2009 11:35] Roger David Nay
If you are using replicate-do* statements in replication, with a large number of slaves, modifying the my.cnf file and restarting when you want to add a single table for replication is cumbersome.

There is a similar request to do this on the master side.

How to repeat:

Suggested fix:
Replication replicate-do* commands should be dynamic so this can be done from the command line on slaves.
[4 Mar 2009 11:55] Simon Mudd
Same is true of replicate-ignore-* statements.

If needed prior to making these changes it seems fine to stop the slave thread(s).
[4 Mar 2009 13:09] Valeriy Kravchuk
Thank you for a reasonable feature request.
[18 Aug 2010 8:35] Serge Kozlov
Notes for the patch:
1. Changes of suggested variables should affect to SHOW SLAVE STATUS;
2. Changes of suggested variables should be logged into error.log
[10 Oct 2013 16:04] Jon Stephens
This is fixed in 5.7.3+ by the addition of CHANGE REPLICATION FILTER. See BUG#67362 for changelog info. See http://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html for info about the statement.