iDash Database tables that are synched by the synching process:
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.