Tungsten Replicator Download
Amancio Mccrae
The master is busy with read/write requests from the app, and the slave is just recording whats happening, so ideally I want to run the tungsten replicator on the mysql slave as it is only reading as well.
The documentation and posts I found all point to running tungsten on the master, and to use it for replication throughout without using mysql master/slave, rather than that hybrid mode I have in mind.
Hi Robert,
Thanks for this article, it helped.
I'm having some confusion on how the THL are applied to the slave(s). Does the tungsten manager push these events to the slave(s)? Or do the slaves pull?
I am using MySQL btw and when I check the process list when dumping a file into a master, I am seeing a local connection (ex. slave1:35069). So it seems like tungsten is using an ssh tunnel to then apply through a localhost mysql connection? Just want to get clarification on the differences between tungsten and standard Mysql replication Hope this makes sense.
Thanks,
Moody
@Moody,
Glad you liked the article. Slaves pull from the master. They make a local copy of the THL records then apply that to the replica, generally using a JDBC connection in the case of relational DBMS like MySQL or using CSV in the case of data warehouses like Hadoop.
Check out the replicator docs at for more information or post to the discussion list at if you have more questions.
i am testing star replication with three nodes/services ( 2.0.7-278 ).
alpha as the node.
bravo and charlie as spokes.
setting it up via cookbook.
entries to a spoke are only replicated to the other spoke if i manualy copy the meta-databases after installation; i.e. tungsten_charlie to node bravo and tungsten_bravo to node charlie.
am i doing something wrong or is it because i am german :-)
thanks in advance
This is the Linux app named Tungsten Replicator whose latest release can be downloaded as tungsten-replicator-oss-4.0.0-18-src.tar.gz. It can be run online in the free hosting provider OnWorks for workstations.
Tungsten Replicator is a high performance, free and open source replication engine that supports a variety of extractor and applier modules. Data can be extracted from MySQL, Oracle and Amazon RDS, and applied to numerous transactional stores and datawarehouse stores (MySQL, Oracle, and Amazon RDS; NoSQL stores such as MongoDB; Vertica, Hadoop, and Amazon RDS).
Tungsten Replicator helps technically focused users solve host of problems and offers features that surpass those of most other open source replicators. During replication, Tungsten Replication allows data to be exchanged between different databases and database versions, information can be filtered and modified, and deployment can be between on-premise or cloud-based databases. It supports parallel replication and advanced topologies such as fan-in and multi-master. It can also be used efficiently in cross-site deployments.
This document provides an overview of replicating data from MySQL to MongoDB and Kafka using Tungsten Replicator. It reviews the replicator workflow, prerequisites for MongoDB and Kafka targets, and sample configurations. The presenter demonstrates Tungsten Replicator's ability to extract data from MySQL, convert rows to messages with metadata, and apply the messages to MongoDB collections or Kafka topics. Requirements like user accounts, ports, and Zookeeper configuration are discussed.Read less