Chapter 1. Introduction

Tungsten Replicator™ is a replication engine supporting a variety of different extractor and applier modules. Data can be extracted from MySQL, Amazon RDS MySQL, Amazon Aurora and Google Cloud SQL, and applied to a variety of transactional stores, NoSQL stores and datawarehouse stores. In addition, the replicator can extract from Oracle via CDC, available for Oracle versions up to and including 11g 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 Replicator 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 Tungsten Clustering™ 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

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

Table 1.1. Supported Extractors

Source

2.x (EOL)

3.x (EOL)

4.x (EOL)

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


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

Table 1.2. Supported Appliers

Target

2.x (EOL)

3.x (EOL)

4.x (EOL)

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

Amazon Aurora MySQL

   

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