|Replication Operation Support|
|ddlscan Supported||Yes, for mixed Oracle/MySQL|
Tungsten Replication supports replication to and from Oracle as a datasource, and therefore also supports replication between Oracle databases. This allows replication of data from Oracle to other database appliers, including MySQL. CDC Replication is supported from Oracle 10g and 11g. See the Database Support prerequisites for more details.
Three variations of Oracle-based replication are officially supported:
MySQL to Oracle
For configuration, see Section 6.2, “Deploying MySQL to Oracle Replication”
Oracle to MySQL
For configuration, see Section 5.7.3, “Creating an Oracle to MySQL Deployment”
Oracle to Oracle
For configuration, see Section 5.7.4, “Creating an Oracle to Oracle Deployment”
Replication in these configurations operates using two separate replicators:
Replicator on the master extracts the information from the source database into THL.
Replicator on the slave reads the information from the remote replicator as THL, and applies that to the target database.