DB Replication Broken on Bahmni, Active - Passive


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.

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

  2. Postgres: https://bahmni.atlassian.net/wiki/spaces/BAH/pages/20643953/Troubleshooting+postgresql+replication+issues

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

1 Like

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