Deployment
Tungsten Replicator creates a unique replication interface between two databases. Because Tungsten 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 question.
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 Target host. More information can be found in "Introduction".
Tungsten Replicator is the core replication component of Tungsten Clustering. For more details on the specific of Tungsten Clustering refer to the Clustering sections of this documentation, a good place to start would be the "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 below.
| Tungsten Term | Traditional Term | Description |
|---|---|---|
| dataserver | Database | The database on a host. Datasources include MySQL, or Oracle. |
| datasource | Host or Node | One member of a dataservice and the associated Tungsten components. |
| staging host | - | 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 installation. |
| staging directory | - | 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 service:
- Configure each host that will be used within your dataservice (See "Host Configuration")
- Configure your MySQL installation, so that Tungsten Replicator can work with the database. (See "MySQL Database Setup")
- Prepare and configure the target environment