Chapter 1. Introduction

Tungsten Replicator™ is an open source replication engine supporting a variety of different extractor and applier modules. Data can be extracted from MySQL, Oracle and Amazon RDS, and applied to a variety of transactional stores, NoSQL stores such as and datawarehouse stores. For a full list of supported sources and targets, see Table 1.1, “Supported Extractors” and Table 1.2, “Supported Appliers” below

During replication, Tungsten Replication assigns data a unique global transaction ID, and enables flexible statement and/or row-based replication of data. This enables data to be exchanged between different databases and different database versions. During replication, information can be filtered and modified, and deployment can be between on-premise or cloud-based databases. For performance, Tungsten Replicator™ provides support for parallel replication, and advanced topologies such as fan-in, star and multi-master, and can be used efficiently in cross-site deployments.

Tungsten Replicator™ is the core foundation for the Continuent Tungsten clustering solution for HA, DR and geographically distributed solutions.

Features in Tungsten Replicator from version 5.2 onwards

  • Includes support for replicating into Hadoop (including Apache Hadoop, Cloudera, HortonWorks, MapR, Amazon EMR)

  • Includes support for replicating into Amazon Redshift, including storing change data within Amazon S3

  • Includes support for replicating into PostgreSQL, Elasticsearch, Apache Cassandra and Apache Kafka

  • Includes support for replicating to and from Amazon RDS (MySQL) deployments

  • SSL Support for managing MySQL deployments

  • Network Client filter for handling complex data translation/migration needs during replication

Table 1.1. Supported Extractors

The table below shows the version of Tungsten Replicator that support was added for the specific extractor

Source

2.x

3.x

4.x

5.0-5.2

5.3

6.x

MySQL (5.0 to 5.6)

x

x

x

x

x

x

MySQL 5.7

   

x

x

x

MariaDB (5.5, 10)

x

x

x

x

x

x

Amazon (MySQL) RDS

 

x

x

x

x

x

Google Cloud MySQL

   

x

x

x

Oracle CDC (9i to 11g)

x

x

x

x

x

x

Oracle Redo Reader (9i to 12c)

   

x

x

 

Oracle RAC (10g to 12c)

     

x


Table 1.2. Supported Appliers

The table below shows the version of Tungsten Replicator that support was added for the specific applier

Target

2.x

3.x

4.x

5.0-5.2

5.3

6.x

MySQL (incl MariaDB)

x

x

x

x

x

x

Amazon (MySQL) RDS

 

x

x

x

x

x

Google Cloud MySQL

   

x

x

x

Oracle (incl. Cloud)

  

x

x

x

x

PostgreSQL (incl. Cloud)

    

x

x

Hadoop

 

x

x

x

x

x

Vertica

x

x

x

x

x

x

Amazon Redshift

 

x

x

x

x

x

MongoDB

x

x

x

x

x

x

Apache Kafka

   

x

x

x

Apache Cassandra

   

x

x

x

Elasticsearch

   

x

x

x