I have gone through the link
http://queuemetrics.com/manuals/QM_AdvancedConfig-chunked/ar01s12.html and planning to build HA for Queuemetrics.
In the link what I understood is we have SITE A and SITE B where both has separate DB Server, and the both DB server were having Master to Master replication, when the WAN goes down the local DB will get revoked and the agents will be still active. The logical concept I got it.
Coming to the practicality, I see some line in the link as follows,
and run the following command to make server3 a slave of server2 (it is important that you replace the values in the following command with the values you got from the SHOW MASTER STATUS command that we ran on server2!):where I don't understand what is server 3, all we have is only 2 servers, one in SITE A and the other in SITE B.
Any comments / advice would be appreciated.
Regards