Follow us on Social Media:

MySQL Database Administrator

Boost Your Quick Knowledge in MySQL DBA Work, Concepts, Tips and Trick

Wednesday, 31 January 2018

MySQL Replication Troubleshooting:Show Slave Status working but master data not written in relay logs

Sometimes we are facing the issue with Master-Master / Master-Slave replication like Show Slave Status command showing without any error but really no such master data is replicated on slave server.


In this issue exactly master data not written in relay logs due to somehow Slave IO threads stuck that's why facing such type of issue .

In this case we can define above parameter in our My.ini/My.cnf file .
​MASTER_HEATBEAT_PERIOD is a value in seconds in the range between 0 to 4294967 with resolution in milliseconds. After the loss of a beat the SLAVE IO 
​thread will disconnect and try to connect again.​

​Note: This parameter is configure in master server. ​

No comments:

Please Like and Subscribe us ....

Please visit the website on daily basis , Your New articles will publish at any moment. Please Subscribe us for getting Latest Updates...