1. Oracle GoldenGate Microservices Documentation
  2. Extract
  3. MySQL: DDL Replication
  4. Plug-in Based DDL Configuration Prerequisites and Considerations
  5. Upgrading from Plugin-based DDL Replication to Transaction Log-based DDL Replication

Upgrading from Plugin-based DDL Replication to Transaction Log-based DDL Replication

If you are using the plug-in based solution on MySQL 5.7 and plan to upgrade to MySQL 8.0, which uses transaction log based DDL replication, you need to:

  1. Uninstall the plug-in components as mentioned in Uninstalling Plug-In Based DDL Replication

  2. Upgrade your database.

  3. Re-enable DDL replication support based on the steps provided in MySQL: Prerequisites for Transaction Log Based DDL Configuration and check the prerequisites and configuration considerations.