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

Bug #29703	replicate-* rules should be dynamically configurable
Submitted:	11 Jul 2007 1:11
Reporter:	Kolbe Kegel
Status:	Verified
Category:	Server: Replication	Severity:	S4 (Feature request)
Version:	all	OS:	Any
Assigned to:	Libing Song	Target Version:
Triage:	Triaged: D5 (Feature request)

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