Channel Wise replicate-do-db statements
Hi Team,
Greetings of the day. We are already using MySQL 5.7.13 for some of our projects. While setting up replication i came up with one query in my mind that Is it possible to define "replicate-do-db", "replicate-ignore-db", "replicate-do-table" and so on parameters in such a way that i can define these params on channel basis.
For example, suppose i have 3 masters (M1, M2 and M3) and i want multi-master salve (Slave1) to replicate particular DBs from channel master M1 & M2. But want all Databases of M3 to get replicated on multi-master slave including default databases (mysql, information_schema and all).
In brief:
M1 has databases M1D1, mysql, information_schema, performance_schema, sys
M2 has databases M2D2, mysql, information_schema, performance_schema, sys
M3 has databases M3D3, mysql, information_schema, performance_schema, sys
Now i want Slave to replicate M1D1 only from M1, M2D2 only from M2 and All databases of M3.
Is there any way we can define "replicate-do-db" param on channel basis?.
Quick response will be highly appreciated.
Regards,
Sourabh Maggo