1. Oracle GoldenGate Microservices Documentation
  2. Extract
  3. MySQL: DDL Replication
  4. Plug-in Based DDL Configuration Prerequisites and Considerations
  5. Using the Metadata Server

Using the Metadata Server

You can use the following options with the metadata server:

  • You must have the Oracle GoldenGate metadata_server running to capture the DDL metadata.

  • Run the install script with start option to start the metadata server.

  • Run the install script with stop option to stop the metadata server.

  • Run the install script with restart option to stop the running metadata server and start again.

  • Oracle GoldenGate DDL replication uses two plugins as a shared library, ddl_rewriter and ddl_metadata, both of which must be installed on your MySQL server before Oracle GoldenGate replication starts.

  • The oggddl.history metadata history table is used to store and retrieve the DDL metadata history.

There is a single history table and metadata server for each MySQL server. If you want to issue and capture DDLs from multiple instances of an Extract process on the same database server at the same time, there is a possibility of conflict between accessing and populating the metadata history table. Oracle recommends that you do not run and capture DDLs using multiple Extract instances on the same MySQL server.