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

Verify

To verify the repplication configuration, we will again insert data and check if that data is replicated

Insert Data into Oracle

Now, we can verify if the Golden Gate Replication Worked

Golden Gate Replication

Finally, we can check if the data is replicated on the MySQL

Verify MySQL