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: