Continuent software is no longer available from VMware, Inc., but support for valued customers who acquired the software from VMware is currently provided by Continuent Ltd. An up-to-date version of the below documentation is available here

Continuent Tungsten 4.0 Manual

Continuent Ltd


This manual documents Continuent Tungsten 4.0, up to and including 4.0.5.

Build date: 2017-01-23 (cece4c8-dirty)

Up to date builds of this document: Continuent Tungsten 4.0 Manual (Online), Continuent Tungsten 4.0 Manual (PDF)

Table of Contents

1. Legal Notice
2. Conventions
3. Quickstart Guide
1. Introduction
1.1. Tungsten Replicator
1.1.1. Transaction History Log (THL)
1.2. Tungsten Manager
1.3. Tungsten Connector
2. Deployment
2.1. Host Types
2.1.1. Manager Hosts
2.1.2. Connector (Router) Hosts
2.1.3. Replicator Hosts
2.1.4. Witness Hosts
2.2. Requirements
2.2.1. Operating Systems Support
2.2.2. Database Support
2.2.3. RAM Requirements
2.2.4. Disk Requirements
2.2.5. Java Requirements
2.2.6. Cloud Deployment Requirements
2.3. Deployment Sources
2.3.1. Using the TAR/GZipped files
2.3.2. Using the RPM and DEB package files
2.4. Best Practices
2.4.1. Best Practices: Deployment
2.4.2. Best Practices: Operations
2.4.3. Best Practices: Maintenance
2.5. Prepare Hosts
2.5.1. Prepare MySQL Hosts
2.5.2. Prepare Connector Hosts
2.5.3. Prepare Active Witness Hosts
2.5.4. Deploy SSH Keys
2.6. Deploying SSL Secured Replication and Administration
2.6.1. Creating the Truststore and Keystore
2.6.2. SSL and Administration Authentication
2.6.3. Configuring the Secure Service through tpm
2.6.4. Configuring Connector SSL
2.6.5. Connector SSL Example Procedure
3. Deployment: MySQL Topologies
3.1. Deploying a Master/Slave Cluster
3.1.1. Prepare: Master/Slave Cluster
3.1.2. Install: Master/Slave Cluster
3.1.3. Best Practices: Master/Slave Cluster
3.2. Deploying Multisite/Multimaster Clusters
3.2.1. Prepare: Multisite/Multimaster Clusters
3.2.2. Install: Multisite/Multimaster Clusters
3.2.3. Best Practices: Multisite/Multimaster Clusters
3.2.4. Configuring Startup on Boot
3.2.5. Resetting a single dataservice
3.2.6. Resetting all dataservices
3.2.7. Provisioning during live operations
3.2.8. Dataserver maintenance
3.3. Deploying a Composite (SOR) Cluster
3.3.1. Prepare: Composite (SOR) Cluster
3.3.2. Install: Composite (SOR) Cluster
3.3.3. Best Practices: Composite (SOR) Cluster
3.4. Replicating Data Out of an Existing Cluster
3.5. Replicating Data Into an Existing Dataservice
3.6. Deploying Additional Datasources, Managers, or Connectors
3.6.1. Adding Datasources to an Existing Deployment
3.6.2. Adding Active Witnesses to an Existing Deployment
3.6.3. Adding Passive Witnesses to an Existing Deployment
3.6.4. Adding Connectors to an Existing Deployment
3.6.5. Adding a remote Composite Cluster
3.7. Replicating from a Cluster to a Datawarehouse
3.8. Deploying Tungsten Connector Only
3.9. Migrating and Seeding Data
3.9.1. Migrating from MySQL Native Replication 'In-Place'
3.9.2. Migrating from MySQL Native Replication Using a New Service
3.9.3. Seeding Data through MySQL
3.9.4. Seeding Data through tungsten_provision_thl
4. Deployment: Advanced
4.1. Deploying Parallel Replication
4.1.1. Application Prerequisites for Parallel Replication
4.1.2. Enabling Parallel Apply
4.1.3. Channels
4.1.4. Disk vs. Memory Parallel Queues
4.1.5. Parallel Replication and Offline Operation
4.1.6. Adjusting Parallel Replication After Installation
4.1.7. Monitoring Parallel Replication
4.1.8. Controlling Assignment of Shards to Channels
4.2. Starting and Stopping Continuent Tungsten
4.2.1. Restarting the Replicator Service
4.2.2. Restarting the Connector Service
4.2.3. Restarting the Manager Service
4.2.4. Restarting the Multisite/Multimaster Replicator Service
4.3. Configuring Startup on Boot
4.3.1. Configuring Multisite/Multimaster Replicator Startup on Boot
4.4. Upgrading Continuent Tungsten
4.4.1. Upgrading using the Staging Method (with ssh Access)
4.4.2. Upgrading when using INI-based configuration, or without ssh Access
4.4.3. Upgrading from Continuent Tungsten 1.5.3/1.5.4 to Continuent Tungsten 4.0
4.4.4. Installing an Upgraded JAR Patch
4.5. Downgrading to an Earlier Release
4.6. Removing Datasources, Managers or Connectors
4.6.1. Removing a Datasource from an Existing Deployment
4.6.2. Removing a Connector from an Existing Deployment
5. Operations Guide
5.1. The Continuent Tungsten Home Directory
5.2. Establishing the Shell Environment
5.3. Checking Dataservice Status
5.3.1. Latency or Relative Latency Display
5.3.2. Getting Detailed Information
5.3.3. Understanding Datasource Roles
5.3.4. Understanding Datasource States
5.3.5. Changing Datasource States
5.3.6. Datasource Statuses
5.3.7. Datasource States and Policy Mode Interactions
5.4. Policy Modes
5.4.1. Setting Policy Modes
5.5. Switching Master Hosts
5.5.1. Automatic Master Switch
5.5.2. Manual Master Switch
5.6. Datasource Recovery Steps
5.6.1. Recover a failed slave
5.6.2. Recover a failed master
5.7. Composite Cluster Switching, Failover and Recovery
5.7.1. Composite Cluster Site Switch
5.7.2. Composite Cluster Site Failover (Forced Switch)
5.7.3. Composite Cluster Site Recovery
5.8. Managing Transaction Failures
5.8.1. Identifying a Transaction Mismatch
5.8.2. Skipping Transactions
5.9. Creating a Backup
5.9.1. Using a Different Backup Tool
5.9.2. Automating Backups
5.9.3. Using a Different Directory Location
5.9.4. Creating an External Backup
5.10. Restoring a Backup
5.10.1. Restoring a Specific Backup
5.10.2. Restoring an External Backup
5.10.3. Restoring from Another Slave
5.10.4. Manually Recovering from Another Slave
5.10.5. Rebuilding a Lost Datasource
5.10.6. Resetting an Entire Dataservice from Filesystem Snapshots
5.11. Migrating and Seeding Data
5.11.1. Migrating from MySQL Native Replication 'In-Place'
5.11.2. Migrating from MySQL Native Replication Using a New Service
5.11.3. Seeding Data through MySQL
5.11.4. Seeding Data through tungsten_provision_thl
5.12. Reset a Continuent Tungsten Dataservice
5.12.1. Reset a Single Site in a Multisite/Multimaster Topology
5.12.2. Reset All Sites in a Multisite/Multimaster topology
5.13. Replicator Fencing
5.13.1. Fencing a Slave Node Due to a Replication Fault
5.13.2. Fencing Master Replicators
5.14. Performing Database or OS Maintenance
5.14.1. Performing Maintenance on a Single Slave
5.14.2. Performing Maintenance on a Master
5.14.3. Performing Maintenance on an Entire Dataservice
5.14.4. Making Online Schema Changes
5.14.5. Upgrading or Updating your JVM
5.15. Performing Continuent Tungsten Maintenance
5.15.1. Changing Configuration
5.16. Connector Automatic Reconnect
5.17. Monitoring Continuent Tungsten
5.17.1. Managing Log Files with logrotate
5.17.2. Monitoring Status Using cacti
5.17.3. Monitoring Status Using nagios
6. Tungsten Connector
6.1. Connector/Application Basics
6.2. Clients and Deployment
6.2.1. Connection Pools
6.3. Routing Methods
6.3.1. Connector Routing Methods
6.3.2. Connector Quality of Service (QoS) Selection
6.3.3. Connector Load Balancers
6.3.4. Specifying Required Latency
6.3.5. Setting Host Affinity and Direct Reads
6.3.6. Smartscale Routing
6.3.7. Direct Routing
6.3.8. SQL Routing
6.3.9. Host-based Routing
6.3.10. Port-based Routing
6.3.11. Read-only Routing
6.4. Using Bridge Mode
6.4.1. Enabling Bridge Mode
6.5. User Authentication
6.5.1. File Format
6.5.2. Direct Routing
6.5.3. Host Options
6.5.4. Updates
6.5.5. Generating Entries from a Script
6.5.6. Synchronizing Data
6.5.7. Limitations
6.5.8. Host-based Authentication
6.6. Connector Operational States
6.6.1. Connections During Automatic Failure/Failover
6.6.2. Connections During Manual Switch/Failover
6.6.3. Connections During Connection Failures
6.6.4. Other Errors
6.6.5. Connector Keepalive
6.6.6. Connector Change User as Ping
6.7. Connector/Manager Interface
6.8. Connector Inline Command Interface
6.8.1. Connector tungsten cluster status Command
6.8.2. Connector tungsten connection count Command
6.8.3. Connector tungsten connection status Command
6.8.4. Connector tungsten flush privileges Command
6.8.5. Connector tungsten gc Command
6.8.6. Connector tungsten help Command
6.8.7. Connector tungsten mem info Command
6.8.8. Connector tungsten show [full] processlist Command
6.8.9. Connector show slave status Command
6.8.10. Connector tungsten show variables Command
6.9. Advanced Configuration
6.9.1. Using Multiple Dataservices
6.9.2. Using with HA Proxy
6.10. Connector General Limitations
7. Command-line Tools
7.1. The cctrl Command
7.1.1. cctrl Command-line Options
7.1.2. cctrl Modes
7.1.3. cctrl Commands
7.2. The check_tungsten_latency Command
7.3. The check_tungsten_online Command
7.4. The check_tungsten_progress Command
7.5. The check_tungsten_services Command
7.6. The cluster_backup Command
7.7. The connector Command
7.8. The ddlscan Command
7.8.1. Optional Arguments
7.8.2. Supported Templates and Usage
7.9. The deployall Command
7.10. The dsctl Command
7.10.1. dsctl get Command
7.10.2. dsctl set Command
7.10.3. dsctl reset Command
7.10.4. dsctl help Command
7.11. Script
7.12. The manager Command
7.13. The multi_trepctl Command
7.13.1. multi_trepctl Options
7.13.2. multi_trepctl Commands
7.14. The replicator Command
7.15. The Command
7.16. The startall Command
7.17. The stopall Command
7.18. The thl Command
7.18.1. thl list Command
7.18.2. thl index Command
7.18.3. thl purge Command
7.18.4. thl info Command
7.18.5. thl help Command
7.19. The trepctl Command
7.19.1. trepctl Options
7.19.2. trepctl Global Commands
7.19.3. trepctl Service Commands
7.20. The tpasswd Command
7.21. The tungsten_health_check Script
7.22. The tungsten_monitor Script
7.23. The tungsten_nagios_backups Command
7.24. The tungsten_nagios_online Command
7.25. The tungsten_provision_thl Command
7.25.1. Provisioning from RDS
7.25.2. tungsten_provision_thl Reference
7.26. The tungsten_provision_slave Script
7.27. The tungsten_read_master_events Script
7.28. The tungsten_set_position Script
7.29. The undeployall Command
7.30. The Command
7.31. The zabbix_tungsten_latency Command
7.32. The zabbix_tungsten_online Command
7.33. The zabbix_tungsten_progress Command
7.34. The zabbix_tungsten_services Command
8. The tpm Deployment Command
8.1. Comparing Staging and INI tpm Methods
8.2. Processing Installs and Upgrades
8.3. tpm Staging Configuration
8.3.1. Configuring default options for all services
8.3.2. Configuring a single service
8.3.3. Configuring a single host
8.3.4. Reviewing the current configuration
8.3.5. Installation
8.3.6. Upgrades from a Staging Directory
8.3.7. Configuration Changes from a Staging Directory
8.4. tpm INI File Configuration
8.4.1. Creating an INI file
8.4.2. Installation with INI File
8.4.3. Upgrades with an INI File
8.4.4. Configuration Changes with an INI file
8.5. tpm Commands
8.5.1. tpm configure Command
8.5.2. tpm connector Command
8.5.3. tpm diag Command
8.5.4. tpm fetch Command
8.5.5. tpm firewall Command
8.5.6. tpm help Command
8.5.7. tpm install Command
8.5.8. tpm mysql Command
8.5.9. tpm promote Command
8.5.10. tpm promote-connector Command
8.5.11. tpm query Command
8.5.12. tpm reset Command
8.5.13. tpm reset-thl Command
8.5.14. tpm restart Command
8.5.15. tpm reverse Command
8.5.16. tpm ssh-copy-cert Command
8.5.17. tpm start Command
8.5.18. tpm stop Command
8.5.19. tpm update Command
8.5.20. tpm validate Command
8.5.21. tpm validate-update Command
8.6. tpm Common Options
8.7. tpm Configuration Options
8.7.1. A tpm Options
8.7.2. B tpm Options
8.7.3. C tpm Options
8.7.4. D tpm Options
8.7.5. E tpm Options
8.7.6. F tpm Options
8.7.7. H tpm Options
8.7.8. I tpm Options
8.7.9. J tpm Options
8.7.10. L tpm Options
8.7.11. M tpm Options
8.7.12. N tpm Options
8.7.13. O tpm Options
8.7.14. P tpm Options
8.7.15. Q tpm Options
8.7.16. R tpm Options
8.7.17. S tpm Options
8.7.18. T tpm Options
8.7.19. U tpm Options
8.7.20. V tpm Options
8.7.21. W tpm Options
9. Replication Filters
9.1. Enabling/Disabling Filters
9.2. Enabling Additional Filters
9.3. Filter Status
9.4. Filter Reference
9.4.1. ansiquotes.js Filter
9.4.2. BidiRemoteSlave (BidiSlave) Filter
9.4.3. breadcrumbs.js Filter
9.4.4. BuildAuditTable Filter
9.4.5. BuildIndexTable Filter
9.4.6. CaseMapping (CaseTransform) Filter
9.4.7. CDCMetadata (CustomCDC) Filter
9.4.8. ColumnName Filter
9.4.9. ConsistencyCheck Filter
9.4.10. DatabaseTransform (dbtransform) Filter
9.4.11. dbrename.js Filter
9.4.12. dbselector.js Filter
9.4.13. dbupper.js Filter
9.4.14. dropcolumn.js Filter
9.4.15. dropcomments.js Filter
9.4.16. dropmetadata.js Filter
9.4.17. dropstatementdata.js Filter
9.4.18. Dummy Filter
9.4.19. EnumToString Filter
9.4.20. EventMetadata Filter
9.4.21. foreignkeychecks.js Filter
9.4.22. Heartbeat Filter
9.4.23. insertsonly.js Filter
9.4.24. Logging Filter
9.4.25. MySQLSessionSupport (mysqlsessions) Filter
9.4.26. NetworkClient Filter
9.4.27. nocreatedbifnotexists.js Filter
9.4.28. OptimizeUpdates Filter
9.4.29. PrimaryKey Filter
9.4.30. PrintEvent Filter
9.4.31. Rename Filter
9.4.32. ReplicateColumns Filter
9.4.33. Replicate Filter
9.4.34. SetToString Filter
9.4.35. Shard Filter
9.4.36. shardbyseqno.js Filter
9.4.37. shardbytable.js Filter
9.4.38. TimeDelay (delay) Filter
9.4.39. tosingledb.js Filter
9.4.40. truncatetext.js Filter
9.4.41. zerodate2null.js Filter
9.5. JavaScript Filters
9.5.1. Writing JavaScript Filters
A. Release Notes
A.1. Continuent Tungsten 4.0.5 GA (4 Mar 2016)
A.2. Continuent Tungsten 4.0.4 GA (24 Feb 2016)
A.3. Continuent Tungsten 4.0.3 Not Released (NA)
A.4. Continuent Tungsten 4.0.2 GA (1 Oct 2015)
A.5. Continuent Tungsten 4.0.1 GA (20 Jul 2015)
A.6. Continuent Tungsten 4.0.0 GA (17 Apr 2015)
B. Prerequisites
B.1. Staging Host Configuration
B.2. Host Configuration
B.2.1. Creating the User Environment
B.2.2. Configuring Network and SSH Environment
B.2.3. Directory Locations and Configuration
B.2.4. Configure Software
B.2.5. sudo Configuration
B.3. MySQL Database Setup
B.3.1. MySQL Version Support
B.3.2. MySQL Configuration
B.3.3. MySQL User Configuration
B.4. Oracle Database Setup
B.4.1. Oracle Version Support
B.4.2. Oracle Environment Variables
C. Terminology Reference
C.1. Transaction History Log (THL)
C.1.1. THL Format
C.2. Generated Field Reference
C.2.1. Terminology: Fields accessFailures
C.2.2. Terminology: Fields active
C.2.3. Terminology: Fields activeSeqno
C.2.4. Terminology: Fields appliedLastEventId
C.2.5. Terminology: Fields appliedLastSeqno
C.2.6. Terminology: Fields appliedLatency
C.2.7. Terminology: Fields applier.class
C.2.8. Terminology: Fields
C.2.9. Terminology: Fields applyTime
C.2.10. Terminology: Fields autoRecoveryEnabled
C.2.11. Terminology: Fields autoRecoveryTotal
C.2.12. Terminology: Fields averageBlockSize
C.2.13. Terminology: Fields blockCommitRowCount
C.2.14. Terminology: Fields cancelled
C.2.15. Terminology: Fields channel
C.2.16. Terminology: Fields channels
C.2.17. Terminology: Fields clusterName
C.2.18. Terminology: Fields commits
C.2.19. Terminology: Fields committedMinSeqno
C.2.20. Terminology: Fields criticalPartition
C.2.21. Terminology: Fields currentBlockSize
C.2.22. Terminology: Fields currentEventId
C.2.23. Terminology: Fields currentLastEventId
C.2.24. Terminology: Fields currentLastFragno
C.2.25. Terminology: Fields currentLastSeqno
C.2.26. Terminology: Fields currentTimeMillis
C.2.27. Terminology: Fields dataServerHost
C.2.28. Terminology: Fields discardCount
C.2.29. Terminology: Fields doChecksum
C.2.30. Terminology: Fields estimatedOfflineInterval
C.2.31. Terminology: Fields eventCount
C.2.32. Terminology: Fields extensions
C.2.33. Terminology: Fields extractTime
C.2.34. Terminology: Fields extractor.class
C.2.35. Terminology: Fields
C.2.36. Terminology: Fields filter.#.class
C.2.37. Terminology: Fields
C.2.38. Terminology: Fields filterTime
C.2.39. Terminology: Fields flushIntervalMillis
C.2.40. Terminology: Fields fsyncOnFlush
C.2.41. Terminology: Fields headSeqno
C.2.42. Terminology: Fields intervalGuard
C.2.43. Terminology: Fields lastCommittedBlockSize
C.2.44. Terminology: Fields lastCommittedBlockTime
C.2.45. Terminology: Fields latestEpochNumber
C.2.46. Terminology: Fields logConnectionTimeout
C.2.47. Terminology: Fields logDir
C.2.48. Terminology: Fields logFileRetainMillis
C.2.49. Terminology: Fields logFileSize
C.2.50. Terminology: Fields masterConnectUri
C.2.51. Terminology: Fields masterListenUri
C.2.52. Terminology: Fields maxChannel
C.2.53. Terminology: Fields maxDelayInterval
C.2.54. Terminology: Fields maxOfflineInterval
C.2.55. Terminology: Fields maxSize
C.2.56. Terminology: Fields maximumStoredSeqNo
C.2.57. Terminology: Fields minimumStoredSeqNo
C.2.58. Terminology: Fields name
C.2.59. Terminology: Fields offlineRequests
C.2.60. Terminology: Fields otherTime
C.2.61. Terminology: Fields pendingError
C.2.62. Terminology: Fields pendingErrorCode
C.2.63. Terminology: Fields pendingErrorEventId
C.2.64. Terminology: Fields pendingErrorSeqno
C.2.65. Terminology: Fields pendingExceptionMessage
C.2.66. Terminology: Fields pipelineSource
C.2.67. Terminology: Fields processedMinSeqno
C.2.68. Terminology: Fields queues
C.2.69. Terminology: Fields readOnly
C.2.70. Terminology: Fields relativeLatency
C.2.71. Terminology: Fields resourcePrecedence
C.2.72. Terminology: Fields rmiPort
C.2.73. Terminology: Fields role
C.2.74. Terminology: Fields seqnoType
C.2.75. Terminology: Fields serializationCount
C.2.76. Terminology: Fields serialized
C.2.77. Terminology: Fields serviceName
C.2.78. Terminology: Fields serviceType
C.2.79. Terminology: Fields shard_id
C.2.80. Terminology: Fields simpleServiceName
C.2.81. Terminology: Fields siteName
C.2.82. Terminology: Fields sourceId
C.2.83. Terminology: Fields stage
C.2.84. Terminology: Fields started
C.2.85. Terminology: Fields state
C.2.86. Terminology: Fields stopRequested
C.2.87. Terminology: Fields store.#
C.2.88. Terminology: Fields storeClass
C.2.89. Terminology: Fields syncInterval
C.2.90. Terminology: Fields taskCount
C.2.91. Terminology: Fields taskId
C.2.92. Terminology: Fields timeInStateSeconds
C.2.93. Terminology: Fields timeoutMillis
C.2.94. Terminology: Fields totalAssignments
C.2.95. Terminology: Fields transitioningTo
C.2.96. Terminology: Fields uptimeSeconds
C.2.97. Terminology: Fields version
D. Files, Directories, and Environment
D.1. The Continuent Tungsten Install Directory
D.1.1. The backups Directory
D.1.2. The releases Directory
D.1.3. The service_logs Directory
D.1.4. The share Directory
D.1.5. The thl Directory
D.1.6. The tungsten Directory
D.2. Log Files
D.3. Environment Variables
E. Internals
E.1. Extending Backup and Restore Behavior
E.1.1. Backup Behavior
E.1.2. Restore Behavior
E.1.3. Writing a Custom Backup/Restore Script
E.1.4. Enabling a Custom Backup Script
E.2. Character Sets in Database and Continuent Tungsten
E.3. Understanding Replication of Date/Time Values
E.3. Best Practices
E.4. Memory Tuning and Performance
E.4.1. Understanding Tungsten Replicator Memory Tuning
E.4.2. Connector Memory Management
E.5. Tungsten Replicator Stages
E.6. Continuent Tungsten Schemas
F. Troubleshooting
F.1. Contacting Support
F.1. Creating a Support Account
F.1. Generating Diagnostic Information
F.1. Open a Support Ticket
F.1. Open a Support Ticket via Email
F.1. Getting Updates for all Company Support Tickets
F.2. Error/Cause/Solution
F.2.1. Triggers not firing correctly on slave
F.2.2. Attempt to write new log record with equal or lower fragno: seqno=3 previous stored fragno=32767 attempted new fragno=-32768
F.2.3. [S1000][unixODBC][MySQL][ODBC 5.3(w) Driver]SSL connection error: unknown error number [ISQL]ERROR: Could not SQLConnect
F.2.4. Latency is high: master:ONLINE, progress=41331580333, THL latency=78849.733
F.2.5. Connector shows errors with " Broken pipe"
F.2.6. Event application failed: seqno=20725782 fragno=0 message=java.sql.SQLDataException: Data too long for column 'eventid' at row 1
F.2.7. ERROR 1010 (HY000) at line 5094506: Error dropping database (can't rmdir './mysql-bin/', errno: 17)
F.2.8. ERROR 1580 (HY000) at line 5093787: You cannot 'DROP' a log table if logging is enabled
F.2.9. ERROR 2013 (HY000) at line 583: Lost connection to MySQL server during query
F.2.10. Replicator runs out of memory
F.2.11. Replicator reports an Out of Memory error
F.2.12. There were issues configuring the sandbox MySQL server
F.2.14. Backup/Restore is not being my host back to normal
F.2.15. cctrl reports MANAGER(state=STOPPED)
F.2.16. Replication latency very high
F.2.17. Missing events, or events not extracted correctly
F.2.18. pendingExceptionMessage": "Unable to update last commit seqno: Incorrect datetime value: '2016-03-13 02:02:26' for column 'update_timestamp' at row 1
F.2.19. Error: could not settle on encryption_client algorithm
F.2.20. Backup agent name not found: xtrabackup-full
F.2.21. The master replicator stopped with a JDBC error.
F.2.22. element 'mysql_readonly' not found in path
F.2.23. trepctl status hangs
F.2.24. Replicator fails to connect after updating password
F.2.25. Starting replication after performing a restore because of an invalid restart sequence number
F.2.26. Lots of entries added to replicator log
F.2.27. Unable to update the configuration of an installed directory
F.2.28. Services requires a reset
F.2.29. Too many open processes or files
F.2.30. cctrl hangs
F.2.31. MySQL is incorrectly configured
F.3. Known Issues
F.3.1. Triggers
F.4. Troubleshooting Timeouts
F.5. Troubleshooting Backups
F.6. Running Out of Diskspace
F.7. Troubleshooting SSH and tpm
F.8. Troubleshooting Data Differences
F.9. Comparing Table Data
F.10. Troubleshooting Memory Usage
G. Frequently Asked Questions (FAQ)
G.1. Cloud Deployment and Management
G.2. General Questions
H. Ecosystem Support
I. Configuration Property Reference

List of Tables

1.1. Key Terminology
2.1. Key Terminology
6.1. Routing Method Selection
6.2. Inline Interface Commands
7.1. cctrl Command-line Options
7.2. cctrl Command-line Options
7.3. cctrl Command-line Options
7.4. cctrl Command-line Options
7.5. cctrl Command-line Options
7.6. cctrl Command-line Options
7.7. cctrl Command-line Options
7.8. cctrl Command-line Options
7.9. cctrl Command-line Options
7.10. cctrl Command-line Options
7.11. cctrl Commands
7.12. cctrldatasource Commands
7.13. check_tungsten_latency Options
7.14. check_tungsten_online Options
7.15. check_tungsten_progress Options
7.16. check_tungsten_services Options
7.17. cluster_backup Command-line Options
7.18. ddlscan Command-line Options
7.19. ddlscan Supported Templates
7.20. dsctl Commands
7.21. dsctl Command-line Options
7.22. dsctl Command-line Options
7.23. manager Commands
7.24. multi_trepctl Command-line Options
7.25. multi_trepctl--output Option
7.26. multi_trepctl Commands
7.27. replicator Commands
7.28. replicator Commands Options for condrestart
7.29. replicator Commands Options for console
7.30. replicator Commands Options for restart
7.31. replicator Commands Options for start
7.32. setupCDC.conf Configuration Options
7.33. thl Options
7.34. trepctl Command-line Options
7.35. trepctl Replicator Wide Commands
7.36. trepctl Service Commands
7.37. trepctl backup Command Options
7.38. trepctl clients Command Options
7.39. trepctl offline-deferred Command Options
7.40. trepctl online Command Options
7.41. trepctl purge Command Options
7.42. trepctl reset Command Options
7.43. trepctl setrole Command Options
7.44. trepctl shard Command Options
7.45. trepctl status Command Options
7.46. trepctl wait Command Options
7.47. tpasswd Common Options
7.48. tungsten_health_check Command-line Options
7.49. tungsten_monitor Command-line Options
7.50. tungsten_provision_slave Command-line Options
7.51. tungsten_read_master_events Command-line Options
7.52. tungsten_set_position Command-line Options
8.1. TPM Deployment Methods
8.2. tpm Core Options
8.3. tpm Commands
8.4. tpm Common Options
8.5. tpm Configuration Options
C.1. THL Event Format
D.1. Continuent Tungsten Directory Structure
D.2. Continuent Tungsten tungsten Sub-Directory Structure