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
