Chapter 8. Operations Guide

Table of Contents

8.1. The Tungsten Replication Home Directory
8.2. Establishing the Shell Environment
8.3. Checking Replication Status
8.3.1. Understanding Replicator States
8.3.2. Replicator States During Operations
8.3.3. Changing Replicator States
8.4. Managing Transaction Failures
8.4.1. Identifying a Transaction Mismatch
8.4.2. Skipping Transactions
8.5. Provision or Reprovision a Slave
8.6. Creating a Backup
8.6.1. Using a Different Backup Tool
8.6.2. Using a Different Directory Location
8.6.3. Creating an External Backup
8.7. Restoring a Backup
8.7.1. Restoring a Specific Backup
8.7.2. Restoring an External Backup
8.7.3. Restoring from Another Slave
8.7.4. Manually Recovering from Another Slave
8.8. Deploying Automatic Replicator Recovery
8.9. Migrating and Seeding Data
8.9.1. Migrating from MySQL Native Replication 'In-Place'
8.9.2. Migrating from MySQL Native Replication Using a New Service
8.9.3. Seeding Data through MySQL
8.9.4. Seeding Data through tungsten_provision_thl
8.10. Using the Parallel Extractor
8.10.1. Advanced Configuration Parameters
8.11. Switching Master Hosts
8.12. Configuring Parallel Replication
8.13. Performing Database or OS Maintenance
8.13.1. Performing Maintenance on a Single Slave
8.13.2. Performing Maintenance on a Master
8.13.3. Performing Maintenance on an Entire Dataservice
8.13.4. Upgrading or Updating your JVM
8.14. Making Online Schema Changes
8.15. Upgrading Tungsten Replicator
8.15.1. Upgrading Tungsten Replication to use tpm
8.15.2. Upgrading Tungsten Replication using tpm
8.15.3. Installing an Upgraded JAR Patch
8.16. Monitoring Tungsten Replication
8.16.1. Managing Log Files with logrotate
8.16.2. Monitoring Status Using cacti
8.16.3. Monitoring Status Using nagios

There are a number of key operations that enable you to monitor and manage your replication cluster. Tungsten Replicator includes a small number of tools that can help with this process, including the core trepctl command, for controlling the replication system, and thl, which provides an interface to the Tungsten History Log and information about the changes that have been recorded to the log and distributed to the slaves.

During the installation process the file /opt/continuent/share/ will have been created which will seed the shell with the necessary $PATH and other details to more easily manage your cluster. You can load this script manually using:

shell> source /opt/continuent/share/

Once loaded, all of the tools for controlling and monitoring your replicator installation should be part of your standard PATH.