Installing DDL Replication

To install DDL replication, you run the installation script that is provided with Oracle GoldenGate as the replication user. This user must have Create, Insert,Select, Delete, Drop, and Truncate database privileges. Additionally, this user must have write permission to copy the Oracle GoldenGate plugin in the MySQL plugin directory. For example, the MySQL plugin are typically in /usr/lib64/mysql/plugin/.

The installation script options are install, uninstall, start, stop, and restart.

The command to install DDL replication uses the install option, user id, password, and port number respectively:

bash-3.2$ ./ddl_install.sh install-option user-id password port-number

For example:

bash-3.2$ ./ddl_install.sh install root welcome 3306

The DDL replication installation script completes the following tasks:

  1. Ensures that you have a supported MySQL server version installed. DDL replication is supported for MySQL 5.7.10 and greater.
  2. Locates the MySQL plugin directory.
  3. Ensures that the ddl_rewriter, ddl_metadata plugins and the metadata_server files exist. If these files are not found, then an error message appears and the installation exits.
  4. Ensures that the plugins are already installed. If installed, the script exits with a message requesting you to uninstall first and then reinstall.
  5. Stops the metadata_server if it is running.
  6. Deletes the oggddl.history table if it exists.
  7. Starts the metadata_server as a daemon process.
  8. Installs the ddl_rewriter and ddl_metadata plugins.