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
Triage: Triaged: D5 (Feature request)

[31 Mar 2008 12:32] Sveta Smirnova
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.