Bahmni reference application databases (technically openmrs database) are often deployed in replicated set up.

For this, MySql replication has to be set up.

Although, bahmni-environment has a script to set up replication, some manual intervention is required (e.g.  not automated in our CI set up).

Steps to Configure master:

1. Go to Master DB box.
2. sudo su root.
3. cd /packages/build/bahmni-environment/mysql-replication/v5.6
4. Update replication.properties with the master and slave host ip address.

   1. alternatively, add aliases to /etc/hosts file

      {{slave_db_ip}} bahmni-passive-db

5. from bahmni-environment, run the "master.sh" script
6.  Note down the log pos and log file.

7. Login to mysql and check the master status

   show master status;

8. ...

Steps to configure Slave

1. Login to slave db box
2. sudo su root
3. cd to /packages/build/bahmni-environment/mysql-replication/v5.6
4. Update replication.properties with the master and slave host ip address.

   1. alternatively, add aliases to /etc/hosts file

      {{master_db_ip}} bahmni-db

5. Update the log file and log pos values noted down on master on replication.properties
6. Copy the dump file from master onto slave
   1. /packages/build/bahmni-environment/mysql-replication/v5.6/mysql_master_dump.db (bahmni v0.76)
   2. scp bdshr@master-db-ip:/packages/build/bahmni-environment/mysql-replication/v5.6/mysql_master_dump.db /tmp
7. run script "slave.sh"
8. login to mysql and check the slave status

   1. show slave status;