a new param replicate-wild-rewrite-table for rewrite table name in slave

[林晓斌]

There is a param replicate-rewrite-db already, for from_db.* -> to_db.*

It is useful for environment that need split tables into several dbs in master, and collect all the updates into one db in slave.

Another requirement will be spliting table into several ones in on schema,
such as split a into a_01, a_02, .... a_n, for performance issues.

There may be requirement that need to collect all the a_% data into a single table, in slave.
So if there is way to translate updates from a_% into a, it will be convenient.

Patch follow based on Percona Server 5.5.18, offer a new param for the purpose above.
eg.
  replicate-wild-rewrite-table=test_%.abc_% -> test.abc
can translate all updates in tables that match the "test_%.abc_%" patten, into test.abc.

[Stewart Smith (stewart)]

Hi!

Thanks very much for the patch. Before we can incorporate it, we'll need a couple of things:
1) tests (while replication tests aren't always the easiest to write, it does help ensure that the feature continues to work)
2) A bzr branch with the changes commited
3) a merge request

let me know if there's any part of this I can help with.

cheers,
stewart

[Laurynas Biveinis (laurynas-biveinis)]

林晓斌, is the "In Progress" status of this bug up to date?

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2373