Synchronization mechanism for serialized data log replay in database systems

A system comprising:

• a processor;
• and a non-transitory computer readable media having computer executable instructions stored therein, which, when executed by the processor, causes the system to perform operations comprising:
• receiving transaction log information from a primary database system at a secondary database system, the transaction log information comprising a first marker identifying a beginning of an operation comprising a plurality of sub-operations and a second marker identifying an end of the operation;
• parsing the transaction log information one operation at a time in an order operations appear in the transaction log;
• identifying the first marker;
• creating a lock state after replaying the first marker to ensure proper serialization of the plurality of sub-operations;
• and terminating the lock state after replaying the second marker, wherein:
• the lock state locks tabes on the secondary database system, the first marker is a Data Definition Language (Data Definition Language) Start (DDLStart) transaction log record and the second marker is a DDL End (DDLEnd) transaction log record;
• and a DDL Operation Scope object on a DDL Operation thread stack controls writing of the DDLStart and DDLEnd transaction log records so that that the DDLEnd is always written regardless of how the DDL operation thread exits.