Ok, here’s some new information. After I set up the master/master between the two clusters, I restarted mysql on all nodes, and it started replicating!!
So now if I insert a row into any node in DC1, it shows up in all other nodes in that DC, and then mysql replication pushes it over to the other node and it shows up there as well. But now, it wont stop replicating!! It’s like an infinite loop! It keeps replicating the same row into the table on all the nodes. Here’s the table
create table test1 (col1 int);
All I did was insert a number 1 a total of one time. And within seconds, every node had hundreds of rows with 1 in it! Its like it doesnt know that it already received that row and its trying to re-apply it!! I cant make it stop! Even when I drop the table, and then recreate it, replication KEEPS GOING! New rows just keep showing up!
Now I have to go figure out how to clear up all the queued up replication that I DON’T want to apply.
How do I stop this? Would global transaction IDs help here? But that’s not available until MariaDB 10.0.2.
What’s the solution here?