To see this working, head to your live site.

MySQL Failover

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.

2 answers0 replies

2 Comments

Piyush Ranjan

Oct 13, 2022

•

Please go through the document provided by MySQL, and check the link below. https://dev.mysql.com/blog-archive/automatic-asynchronous-replication-connection-failover/

murthy919

Oct 13, 2022

•

Replying to

Thanks for the reply. I tried this. but getting message

"2022-10-13T06:59:04.620012Z 7 [Note] Aborted connection 7 to db: 'unconnected' user: 'murthy' host: 'master1' (Got an error reading communication packets)"

I changed the max_allowed_packet=1024M, and disabled firewall ,still same.

do we have any document in our DBA Genesis Support ?