MySQL: DDL Replication

Learn about DDL replication in MySQL.

Limitation of DDL Replication in MySQL

The DDL operation CREATE TABLE AS SELECT is not supported. Oracle GoldenGate Extract for MySQL abends with the following error when it encounters this DDL.

DDL statement "CREATE TABLE AS SELECT" is detected for table table-name at binary log
number binlog number and offset binlog offset. The DDL operation "CREATE TABLE AS SELECT"
is not supported. Execute all 'CREATE TABLE AS SELECT' DDL operations manually to the target
database and start Extract by adding Extract parameter TRANLOGOPTIONS WARNCREATEASSELECT. Once
Extract gets past the 'CREATE TABLE AS SELECT' operation, restart Extract after disabling the
parameter TRANLOGOPTIONS WARNCREATEASSELECT.

Note:

See TRANLOGOPTIONS WARNCREATEASSELECT in the Parameters and Functions Reference for Oracle GoldenGate for details.