Mode switching in high availability disaster recovery (HADR) systems

A computer implemented method to provide mode switching in a high availability disaster recovery (HADR) system, comprising:

• determining an average commit wait time associated with replicating data from a primary database to a replication database based on a previous average commit wait time and a current commit wait time by summing products of the previous average commit wait time and the current commit wait time with respective weightage factors;
• determining whether the average commit wait time is greater than or equal to a predefined maximum commit wait time;
• incrementing a counter when the average commit wait time is greater than or equal to the predefined maximum commit wait time;
• determining whether the counter is greater than or equal to a predefined threshold and whether a predefined timer associated with the counter is expired;
• and
• switching the primary database from a synchronous mode to an asynchronous mode for replicating the data when the counter is greater than or equal to the predefined threshold and the predefined timer is running.

A computing system, comprising:

• at least one processor;
• and
• one or more memory devices communicative with the at least one processor, wherein the one or more memory devices store instructions to:
• determine an average commit wait time associated with replicating data from a primary database to a replication database based on a previous average commit wait time and a current commit wait time by summing products of the previous average commit wait time and the current commit wait time with respective weightage factors;
• determine whether the average commit wait time is greater than or equal to a predefined maximum commit wait time;
• increment a counter when the average commit wait time is greater than or equal to the predefined maximum commit wait time;
• determine whether the counter is greater than or equal to a predefined threshold and whether a predefined timer associated with the counter is expired;
• and
• switch the primary database from a synchronous mode to an asynchronous mode for replicating the data when the counter is greater than or equal to the predefined threshold and the predefined timer is running.