MySQL Bugs: #29703: replicate-* rules should be dynamically configurable

Bug #29703	replicate-* rules should be dynamically configurable
Submitted:	10 Jul 2007 23:11	Modified:	10 May 2013 11:08
Reporter:	Kolbe Kegel	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S4 (Feature request)
Version:	all	OS:	Any
Assigned to:	_Status MIGRATED	CPU Architecture:	Any

Description:
It would be quite helpful in many situations if there was some way to dynamically configure replicate-* rules such as replicat-wild-do-table, replicate-do-db, etc.

This would be particularly helpful in environments where slaves are configured dynamically to replication certain databases and/or tables based on load and usage.

How to repeat:
n/a

Suggested fix:
The functionality could be added either by turning replicate-* options into proper variables or by adding flags to the CHANGE MASTER TO command.

We use this feature alot (replicate-do-db), and I agree that it would be great to be able to do this dynamically.

We add databases fairly often, and it would be nice not to have to restart the slave add the database to the do replicate list....

bug#48079 is marked as a dup of this bug

Bug #53777 was marked as a duplicate of this one.

A creative but unsupported workaround:
http://mituzas.lt/2009/07/30/evil-replication-management/

A duplicate of this bug : http://bugs.mysql.com/bug.php?id=67362