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.
MASTER_HEARTBEAT_PERIOD=1


​​Clarification:

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...