6.1.3. Creating an Oracle to MySQL Deployment
Replication Operation Support
The Oracle extractor enables information to be extracted from an Oracle
database, generating row-based information that can be replicated to other
replication services, including MySQL. The transactions are extracted by
Oracle by capturing the change events and writing them to change tables;
Tungsten Replicator extracts the information from the change tables and uses
this to generate the row-changed data that is then written to the THL and
applied to the destination.
Replication from Oracle has the following parameters:
Data is replicated using row-based replication; data is extracted by
row from the source Oracle database and applied by row to the target
DDL is not replicated; schemas and tables must be created on the
target database before replication starts.
Tungsten Replicator relies on two different users within Oracle
configuration the configuration, both are created automatically during
the CDC configuration:
Publisher — the user designated to
issue the CDC commands and generates and is responsible for the
CDC table data.
Subscriber — the user that reads the
CDC change table data for translation into THL.
The slave replicator (applier), writes information into the target
MySQL database using a standard JDBC connection.
The basic process for creating an Oracle to MySQL replication is as