I have two MySQL servers set up with replication - lets say A and B for ease.
Currently B is a slave of A
To allow me to switch over to A in event of failure, I want to make this replication circular, so A is also a slave of B.
I know how to set this up using "change master to", but having read the documentation I am not clear on how to make sure that A starts replicating from B at the very end of B's binlog so it doesn't start to try and apply a bunch of SQL queries to the master that I don't want it to?
Am I making any sense?