MySQL Forums
Forum List  »  Replication

Re: Problems with Replication
Posted by: PER JØ'RGENSEN
Date: April 28, 2019 10:37PM

Hi Again.
I have not found the golden way yet - since I cannot get the Replication working both ways.
I have created a diagram here --https://www.linuxin.dk/files/Replication%20flow.png that'll describe my scenario.

Now problem with getting the replication channel running from C --> B --> A - all data flows through as expected, but as soon as I create the replication channels for A --> B --> C -- the data flow stop onj Server B .
Server A Replicate to Server B but not to C
Server C replicates to Server B but not to Server A

I tried several settings regarding replication filters - but still stuck with all data on Server B - still only with replication ( I havent started rewrite the DB yes

My Dopubt is here - since the documentation says:
ON Server A:
log-bin = mysql-bin
binlog_do_db = autolog,Custom_Data
replicate_do_db = b2a:autolog

Server B:
log-bin = mysql-bin
binlog_do_db = autolog,Custom_Data
replicate_do_db = c2b:autolog
replicate_do_db = a2b:Custom_Data

Server C:
log-bin = mysql-bin
binlog_do_db = autolog,Custom_Data
replicate_do_db = b2c:Custom_Data

But my doubt is here then - whjy this wont work - should this be running in multi instanses so that you have a seperate DB for each way

Options: ReplyQuote


Subject
Views
Written By
Posted
851
April 25, 2019 02:06AM
277
April 25, 2019 10:31AM
269
April 26, 2019 01:17AM
Re: Problems with Replication
277
April 28, 2019 10:37PM


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.