Apologies if this has been asked before, but I couldn’t find any threads that covered my issue.
I have two separate DB Clusters (Pre-Prod and DR), each with 3 servers running happily. I need to somehow enable replication from the Pre-Prod cluster over to the DR cluster, but am struggling to find a suitable solution.
I’ve tried using regular MySQL one-way replication from Pre-Prod’s master to DR’s master, but there are issues where the bin files aren’t coming across correctly.
Has anyone had experience with this and could suggest the best way of configuring this moving forwards?
Once configured, I’ll then do the same for Live → DR, but for now it’s just a case of finding a solution that will work.
Thanks in advance,