Hi,
Replication has been broken in our setting and i would like to trouble shoot in current scenario instead of resetting up the replication. Expecting help.
Hi,
Replication has been broken in our setting and i would like to trouble shoot in current scenario instead of resetting up the replication. Expecting help.
MySQL: https://bahmni.atlassian.net/wiki/spaces/BAH/pages/20643941/MySQL+Replication+Problems In that page, you will also find some links for troubleshooting for other problems.
Also bahmni command line tool, provides step to setup replication. https://bahmni.atlassian.net/wiki/spaces/BAH/pages/35291242/Install+Bahmni+on+CentOS+Advanced+Installation+Options Check the replication section
@sanjayap, I think the issue has been resolved now.
Issue was “Relay log read failure: Could not parse relay log event entry”.
To solve this issue we have followed the steps on https://alexzeng.wordpress.com/2013/10/17/how-to-fix-mysql-slave-after-relay-log-corrupted/
Thanks @ajeenckya its super helpfull we are checking with other facility as well, as per discussion, lets make this to resume mechanism whenever power failure persists such a way like heartbeat mechanism ( Thoughts ) later we can see out this option @angshuonline we face the replication break oftenly due to power constraint (Due to lightning), Please suggest if there are any ways to resume this by heart beat check mechanism.