Filtering DDL Generated by MySQL Heatwave Engine

MySQL database service is HeatWave enabled from MySQL database service version 8.0.33 and has RAPID cluster plug in installed. The RAPID cluster is attached to MySQL database service instance when you enable HeatWave on that instance. You can load any base table to HeatWave engine using the following DDL statement:

ALTER TABLE mysrc.emp secondary_engine = RAPID;
ALTER TABLE t1 secondary load;

After the table is loaded to the engine, this DDL statement is logged to the MySQL binary log.

• If DDL capturing for this table (mysrc.emp) is enabled on Oracle GoldenGate for MySQL Extract, then the preceding DDL statement is processed by the Extract and the DDL is written to the trail file by the Extract.

• If both source and target are MySQL Heatwave, then the DDL is successfully applied to the target MySQL.

• If the source is MySQL HeatWave and target is non-HeatWave, then Replicat throws an error similar to the following:

  ALTER TABLE vinsrc.emp1 secondary_load;

  ERROR 1286 (42000): Unknown storage engine 'rapid'

  To avoid this error, use the following DDL option in the Extract parameter file to filter these queries.

  DDL INCLUDE MAPPED , EXCLUDE INSTR 'secondary_load';