Methods for preventing constraint violations at a target database by a database replication system where an application call, or a programmatic call by a database management system, forces a flush of a change log
Methods are provided for preventing constraint violations at a target database by a database replication system. The database replication system replicates database transactions from a change log of a source database to the target database. Each source database and each target database have one or more tables, and at least one of the target database tables has one or more constraints. The database replication system replicates database transactions from a change log for the source database to the target database. Each of the source database tables has an associated change log disk cache. For each database transaction, a database change is detected to the at least one of the source database tables that potentially causes a constraint violation at the target database as a result of one or more of the target database tables having one or more constraints. An application call, or a programmatic call by a database management system, is then made when the database change is detected to flush to a change log disk contents of the associated change log disk cache for the at least one of the source database tables which has a change log disk cache that may flush to the change log disk in a misordered manner compared to change log disk cache flushes from at least one other source database table. The application call, or the programmatic call by the database management system, prevents the potential constraint violation at the target database by the database replication system.
1. A method for preventing constraint violations at a target database by a database replication system, the database replication system replicating database transactions from a change log of a source database to the target database, each database transaction having a commit operation, each source database and each target database having one or more tables, at least one of the target database tables having one or more constraints, each of the source database tables having an associated change log disk cache, the method comprising for each database transaction:
(a) detecting a database change to the at least one of the source database tables that potentially causes a constraint violation at the target database as a result of one or more of the target database tables having one or more constraints; and
(b) making an application call, when the database change in step (a) is detected, to flush to a change log disk contents of the associated change log disk cache for the at least one of the source database tables which has a change log disk cache that may flush to the change log disk in a misordered manner compared to change log disk cache flushes from at least one other source database table,
wherein step (b) occurs prior to initiation of, and independent from, the commit operation being performed for the associated database transaction, and
wherein the application call prevents the potential constraint violation at the target database by the database replication system.
2. The method of claim 1 wherein the constraint violation is detected by attempting to apply the database change.
3. The method of claim 1 wherein the constraint violation is caused by referential integrity rules.
4. The method of claim 1 wherein database changes made at the source database which are replicated to the target database are in the form of a stream of database changes.
5. A method for preventing constraint violations at a target database by a database replication system, the database replication system replicating database transactions from a change log of a source database to the target database, each database transaction having a commit operation, each source database and each target database having one or more tables, at least one of the target database tables having one or more constraints, each of the source database tables having an associated change log disk cache, the target database being part of a database management system (DBMS), the method comprising for each database transaction:
(a) detecting a database change to the at least one of the source database tables that potentially causes a constraint violation at the target database as a result of one or more of the target database tables having one or more constraints; and
(b) making a programmatic call by the DBMS, when the database change in step (a) is detected, to flush to a change log disk contents of the associated change log disk cache for the at least one of the source database tables which has a change log disk cache that may flush to the change log disk in a misordered manner compared to change log disk cache flushes from at least one other source database table,
wherein step (b) occurs prior to initiation of, and independent from, the commit operation being performed for the associated database transaction, and
wherein the programmatic call by the DBMS prevents the potential constraint violation at the target database by the database replication system.
6. The method of claim 5 wherein the constraint violation is detected by attempting to apply the database change.
7. The method of claim 5 wherein the constraint violation is caused by referential integrity rules.
8. The method of claim 5 wherein database changes made at the source database which are replicated to the target database are in the form of a stream of database changes.