Configure Destination

In this section we will define Generic JDBC Adapter for MySQL replication, the steps are similar as the previous:

JDBC Drivers

MySQL

Properties File

Golden Gate (replicat)

So, let's get going.

Configure JDBC Drivers

Configure JDBC Driver

Configure MySQL

Configure my.cnf (e.g. /etc/my.cnf)

We can start mysql and configure MySQL for the replication

Start & Verify MySQL

Configure Properties File

Configure Properties File(e.g. TRG_OGGHOME/dirprm/jdbc_mysql.properties

Configure Golden Gate (replicat)

Configure Golden Gate