a new param replicate-wild-rewrite-table for rewrite table name in slave
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Triaged
|
Wishlist
|
Unassigned |
Bug Description
There is a param replicate-
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-
can translate all updates in tables that match the "test_%.abc_%" patten, into test.abc.
summary: |
- a new param eplicate-wild-rewrite-table for rewite table name in slave + a new param replicate-wild-rewrite-table for rewite table name in slave |
summary: |
- a new param replicate-wild-rewrite-table for rewite table name in slave + a new param replicate-wild-rewrite-table for rewrite table name in slave |
tags: | added: contribution |
Changed in percona-server: | |
status: | In Progress → Triaged |
assignee: | 林晓斌 (dingqi-lxb) → nobody |
no longer affects: | percona-server/5.5 |
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