Method for ensuring replication when system resources are limited
A method is provided for replicating transaction data from a source database to a target database wherein the transaction data is communicated from a change queue associated with the source database to the target database. An initial path is provided between the change queue and the target database for transaction data to flow. The initial path has a maximum transaction load capacity. It is then detected whether the current transaction load is close or equal to the maximum transaction load capacity of the initial path. If so, another path is provided between the change queue and the target database. Also, a method is provided of replicating transaction data from a source database to a target database wherein an associated with the target database has a maximum transaction threshold limit. The applier normally posts transaction data to the target database only upon receipt of a commit step or operation associated with respective transaction data. First, it is detected as to whether the maximum transaction threshold limit of the applier has been reached. If so, a commit step or operation is prematurely conducted on at least some of the transaction data in the applier, thereby causing the transaction data to become posted to the target database and deleted from the applier.
1. A method of replicating transaction data from a source database to a target database, an applier being associated with the target database, the applier having a maximum transaction threshold limit, the applier normally posting transaction data to the target database only upon receipt of a commit step or commit operation associated with respective transaction data, the method comprising:
(a) receiving at the applier associated with the target database transaction data from the source database for replication to the target database and detecting whether the maximum transaction threshold limit of the applier has been reached, and;
(b) prematurely conducting a database transaction commit step or commit operation on at least some of the transaction data in the applier if the maximum transaction threshold limit of the applier has been reached, thereby causing the transaction data to become posted to the target database and deleted from the applier.
2. The method of claim 1 wherein undo events associated with aborted transactions at the source database are also replicated, the method further comprising:
(c) upon receipt of an undo event at the applier, conducting an undo event on the prematurely committed transaction data in the target database, thereby causing the transaction at the target database to also be aborted.
3. The method of claim 1 further comprising:
(c) the applier starting a new transaction upon receipt of a modification to a prematurely committed transaction.
4. The method of claim 1 wherein the maximum transaction threshold limit is the maximum transaction threshold capacity.
5. The method of claim 1 wherein the maximum transaction threshold limit is the maximum number of change events allowed to exist in the applier for a single transaction.
6. The method of claim 1 wherein the maximum transaction threshold limit is the maximum elapsed timespan of a transaction.