MySQL Forums
Forum List  »  Replication

Channel Wise replicate-do-db statements
Posted by: sourabh maggo
Date: July 12, 2016 12:14PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Channel Wise replicate-do-db statements
1313
July 12, 2016 12:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.