Limitations

The following features are not supported by the CDC Replication Engine for MariaDB Source.

Partitioned tables

MariaDB partitioned tables are not supported. Source tables must be normal tables, not views, materialized views, partition root tables, or foreign tables. Attempts to replicate tables other than normal tables will result in an error.

Truncate operations

TRUNCATE commands are not replicated. A workaround is to use delete operations instead. To avoid accidental truncate invocations, you can revoke the TRUNCATE privilege from tables.

DDL replication

Replication of DDL operations is not supported for MariaDB sources, but DDL awareness is supported.

Considerations for FLOAT and DOUBLE data types

In MariaDB, the FLOAT and DOUBLE data types sometimes cause confusion because they are approximate and not stored as exact values. As a result, the DECIMAL data type is preferred to avoid such data approximations.

For more detail, see the following topics in the MariaDB documentation:

• Floating-Point Types (Approximate Value) - FLOAT, DOUBLE
• Problems with Floating-Point Values

Journal control field

The &USER journal control field is not supported.

Primary and standby configuration

CDC Replication can only replicate from the primary node and not from the standby node.