Measuring snapshot delay between source database and its asynchronous replica

A system comprising:

• one or more data processors;
• and
• memory storing instructions stored on at least one data processor, which when executed result in operations comprising:
• executing, by at least one data processor, statements containing requests for database operations in a primary database system;
• generating, by at least one data processor, transaction logs containing information for replicating the statements or database operations;
• generating, by at least one data processor, a commit transaction log associated with a commit database operation;
• determining, by at least one data processor, that a defined period of time has elapsed since the commit transaction log has been generated;
• generating, by at least one data processor, a heartbeat transaction log;
• and
• sending, by at least one data processor, the transaction logs including the heartbeat transaction log to a secondary database system that mirrors the primary database system, the secondary database system generating a snapshot delay value based on a timestamp associated with either the commit database operation or the heartbeat transaction log.

A non-transitory computer program product storing instructions which, when executed by at least one data processor forming part of at least one computing device, implement operations comprising:

• executing, by at least one data processor, statements containing requests for database operations in a primary database system;
• generating, by at least one data processor, transaction logs containing information for replicating the statements or database operations;
• generating, by at least one data processor, a commit transaction log associated with a commit database operation;
• determining, by at least one data processor, that a defined period of time has elapsed since the commit transaction log has been generated;
• generating, by at least one data processor, a heartbeat transaction log;
• and
• sending, by at least one data processor, the transaction logs including the heartbeat transaction log to a secondary database system that mirrors the primary database system, the secondary database system generating a snapshot delay value based on a timestamp associated with either the commit database operation or the heartbeat transaction log.