Abstract: A system performs write protection of data that being copied. The write protection protects the data from being corrupted by applications. The system allows writes that are part of the data transfer from the source database. The system uses triggers to implement write protection. The system stores a list of tenants that are write protected in a metadata table. The system implements a statement level trigger that caches the metadata table in memory. If the cache is determined to be older than the limit specified by the TTL, the system reloads the cache. The statement may perform multiple row level operations. A row level operation implements a row level trigger that checks the in-memory data structure to determine whether the tenant is write protected. If the tenant is determined to be write protected, the system rolls back the row level operation.

Abstract: A system generates consistent copies of data stored in a source database in a plurality of target database systems. The system sends a change data stream from the source database system to the target database systems for performing data updates. The system receives timestamps of a latest transactions processed by consumer processes updating the target database system. The system determines a pause timestamp that occurs after the received transactions. The updates to the target database systems are paused once a transaction corresponding to the pause timestamp is processed. The pause timestamp is used to generate a consistent copy of a source database system in a target database system using multiple partitioned change data streams, each partitioned change data stream processing transactions associated with a partition of the source database system.

Abstract: A system performs write protection of data that being copied. The write protection protects the data from being corrupted by applications. The system allows writes that are part of the data transfer from the source database. The system uses triggers to implement write protection. The system stores a list of tenants that are write protected in a metadata table. The system implements a statement level trigger that caches the metadata table in memory. If the cache is determined to be older than the limit specified by the TTL, the system reloads the cache. The statement may perform multiple row level operations. A row level operation implements a row level trigger that checks the in-memory data structure to determine whether the tenant is write protected. If the tenant is determined to be write protected, the system rolls back the row level operation.