ignore_cascade_delete

Use this system parameter to specify whether CDC Replication replicates delete operations on a replicated table that result from the delete of parent rows in tables with referential integrity relationships (ON DELETE CASCADE rule).

Versions supported–CDC Replication Engine for MariaDB Source version 11.4 and later

Applies to

Source datastores

Values

Set this parameter to one of the following values:

TRUE: Specifies that when a parent row is deleted, CDC Replication replicates only the delete of the parent row. This option can be useful if you have the ON DELETE CASCADE rule in force at the target.
FALSE: Specifies that when a parent row is deleted, CDC Replication replicates the delete operations from child rows that result from the ON DELETE CASCADE rule.

Default Setting

FALSE