Hello Support ,
We are using Percona Server 5.7.14 and we want to achieve something like this:
- Master A has schema : Sakila
- Master B has schema : Sakila
Now There is a Slave C which has Schema Sakila_1 and Sakila_2.
We want to two use two channels one for Master A and one for Master B.
Please let us know what config change we need to do on Slave C (specific to replicate_rewrite_db) and multiple replication channels how we should start.
[mysqld]
masterA.replicate-rewrite-db = sakila -> sakila_1
masterB.replicate-rewrite-db=sakila -> sakila_2
…
Please let us know your thoughts on this.
I was going through this blog and thought may be possible with Percona server too - https://mariadb.com/blog/multisource-replication-how-resolve-schema-name-conflicts
Any inputs would be appreciated.
Many Thanks,
Mahesh