Verify HA DB in Synch in Idash

Document ID : KB000013938
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

We setup the primary and secondary on separate days one after the other. We would now like to confirm that the databases are in synch before we start to load historical data.    

How do we verify that the databases are in synch?     

How do we verify that we are running in HA mode?

Question:

How do we verify that the databases are in synch?     

How do we verify that we are running in HA mode?

Environment:
idash
Answer:

iDash Database tables that are synched by the synching process:

 

idash_blob

idash_config

idash_doc

 

How would a person know looking at the database? The tables that have the edited and deleted columns in them are the ones that are synched by iDash’s synching process. Synching means when either the primary or secondary database is down and the iDash server is up and doing normal operations and then the database that was down is restored at that time the above three tables will be synched by iDash’s synching process. After restoration of the database that down the other tables in the schema should be checked to see if a manual restoration is required.

 

How do we know that the HA synching is working? The iDash log files have “synching” related messages in the info.log files. Run the following queries in both the databases to verify the count are the same:

 

Select count(*) from idash_config where deleted=0;

Select count(*) from idash_blob where deleted=0;

Select count(*) from idash_doc where deleted=0;

 

If they do not match then add the missing records, if they do match then the synch process is working fine.