MySQL Bugs: #43366: dynamic slave replication - modify replicate-do options from command line

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:	None
Category:	MySQL Server: Replication	Severity:	S4 (Feature request)
Version:	Any	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
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.
http://bugs.mysql.com/bug.php?id=39993

How to repeat:
N/A

Suggested fix:
Replication replicate-do* commands should be dynamic so this can be done from the command line on slaves.

Same is true of replicate-ignore-* statements.

If needed prior to making these changes it seems fine to stop the slave thread(s).

Thank you for a reasonable feature request.

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

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.

Closed.