Creating consistent copies of a database

A non-transitory computer readable storage medium for storing instructions that when executed by one or more computer processors cause the one or more computer processors to perform steps comprising:

• streaming change data from a source database system to a plurality of target database systems, wherein the change data identifies database operations of a series of transactions committed at the source database system;
• receiving a plurality of timestamps from the plurality of target database systems, wherein a given one of the plurality of timestamps is indicative of a latest transaction of the series of transactions that has been processed by a respective one of the plurality of target database systems;
• determining, based on the plurality of timestamps, a pause timestamp to be subsequent to a latest of the plurality of timestamps by a time delay comprising an estimated time to configure a target database system to stop applying ones of the database operations based on the pause timestamp;
• sending, to the plurality of target database systems, the pause timestamp to cause each target database system to stop processing transactions of the series of transactions after reaching a particular transaction in the series that satisfies a condition involving the pause timestamp;
• and
• responsive to the plurality of target database systems stopping processing transactions of the series, sending an indication that the plurality of target database systems have reached a consistent state with respect to each other.

A system, comprising:

• one or more processors;
• and
• memory having program instructions stored thereon that are executable by the one or more processors to cause the system to perform steps comprising:
• streaming change data from a source database system to a plurality of target database systems, wherein the change data identifies database operations of a series of transactions committed at the source database system;
• receiving a plurality of timestamps from the plurality of target database systems, wherein a given one of the plurality of timestamps is indicative of a latest transaction of the series of transactions that has been processed by a respective one of the plurality of target database systems;
• determining, based on the plurality of timestamps, a pause timestamp to be subsequent to a latest of the plurality of timestamps by a time delay comprising an estimated time to configure a target database system to stop applying ones of the database operations based on the pause timestamp;
• sending, to the plurality of target database systems, the pause timestamp to cause each target database system to stop processing transactions of the series of transactions after reaching a particular transaction in the series that satisfies a condition involving the pause timestamp;
• and
• responsive to the plurality of target database systems stopping processing transactions of the series, sending an indication that the plurality of target database systems have reached a consistent state with respect to each other.