Hi, Can someone please help me to configure the MySQL Replication and try the failover scenario.
I was successfully configure the Replication on 2 servers like 1 Master and 1 slave. Replication also working file. but I was fail to create the scenario failover. I am not sure where I did mistake and why its not working.
I was using mysql utilities. Do I need to configure HA or something. or any specific document to do it step by step ?
Thanks,
Murthy.
Please go through the document provided by MySQL, and check the link below. https://dev.mysql.com/blog-archive/automatic-asynchronous-replication-connection-failover/