MySQL Bugs: #35707: Allow to tune replicate-do* options

Bug #35707	Allow to tune replicate-do* options
Submitted:	31 Mar 2008 12:32	Modified:	31 Mar 2008 12:33
Reporter:	Sveta Smirnova	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S4 (Feature request)
Version:	4.1, 5.0, 5.1, 6.0 BK	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently when I set replicate-do* option, slave ignores any updates to other tables.

But assume next situation.

There is database in which one wants to replicate of 3 tables instead of, say, 100. Easiest way to do it:

replicate-wild-ignore-table=test.%
replicate-do-table=test.a
replicate-do-table=test.b
replicate-do-table=test.c

But in this case is necessary to enumerate all other databases. It is annoying and in this case is easy to forget to replicate new database if one created after initial setup.

How to repeat:
See description.

Suggested fix:
Add possibility to tune replicate-do* options per database or something.