Tungsten Replicator creates a unique replication interface between two databases.
Because Tungsten Replicator is independent of the dataserver it
affords a number of different advantages, including more flexible
replication strategies, filtering, and easier control to pause, restart, and
skip statements between hosts.
Replication is supported from, and to, different dataservers using different
technologies through a series of extractor and applier components which
independently read data from, and write data to, the dataservers in
The replication process is made possible by reading the binary log on each
host. The information from the binary log is written into the Tungsten
Replicator Transaction History Log (THL), and the THL is then transferred
between hosts and then applied to each slave host. More information can be
found in Chapter 1, Introduction.
Before covering the basics of creating different dataservices, there are
some key terms that will be used throughout the setup and installation
process that identify different components of the system. these are
summarised in Table 2.1, “Key Terminology”.
Table 2.1. Key Terminology
The database on a host. Datasources include MySQL, or Oracle.
Host or Node
One member of a dataservice and the associated Tungsten components.
The machine (and directory) from which Tungsten Replicator is installed
and configured. The machine does not need to be the same as any of
the existing hosts in the cluster.
The directory where the installation files are located and the
installer is executed. Further configuration and updates must be
performed from this directory.
Before attempting installation, there are a number of prerequisite tasks
which must be completed to set up your hosts, database, and Tungsten Replicator
Setup a staging host from
which you will configure and manage your installation.
Configure each host that will
be used within your dataservice.
Depending on the database or environment you are using, you may need to
perform additional configuration steps for the dataserver:
The following sections provide guidance and instructions for creating a
number of different deployment scenarios using Tungsten Replicator.