2.9.4 Inbound Replication

Note

Inbound replication is only supported with MySQL HeatWave on OCI.

• Replicating DDL operations: Before a table is loaded into HeatWave, RAPID must be defined as the table secondary engine; for example:

  mysql> ALTER TABLE orders SECONDARY_ENGINE = RAPID;

  Before MySQL 8.0.31, DDL operations are not permitted on tables defined with a secondary engine. In those releases, before replicating a DDL operation from an on-premise instance to a table on the DB System that is defined with a secondary engine, you must set the SECONDARY_ENGINE option to NULL; for example:

  mysql> ALTER TABLE orders SECONDARY_ENGINE = NULL;

  Setting the SECONDARY_ENGINE option to NULL removes the SECONDARY_ENGINE option from the table definition and unloads the table from HeatWave. To reload the table into HeatWave after the DDL operation is replicated, specify the SECONDARY_LOAD option in an ALTER TABLE statement.

  mysql> ALTER TABLE orders SECONDARY_LOAD;