Use this system parameter to specify whether CDC Replication replicates UPDATE
operations on a replicated table that result from the delete of parent rows in tables with
referential integrity relationships (ON DELETE SET NULL 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 CDC Replication does not replicate
UPDATE operations at child tables that result from the ON DELETE SET NULL rule.
Only the deletion of the parent row is replicated. This option can be useful if you have the
ON DELETE SET NULL rule in force at the target database and do not need these
updates replicated.
- FALSE
- Specifies that when a parent row is deleted at the source, CDC Replication replicates the UPDATE
operations from child rows in which one or more column values are set to NULL.
- Default Setting
- FALSE