Tungsten Clustering (for MySQL) 5.4 Manual

Continuent Ltd


This manual documents Tungsten Clustering (for MySQL), a high performance, High Availability and Disaster Recovery for MySQL clustering.

This manual includes information for 5.4, up to and including 5.4.1.

Build date: 2021-10-22 (3f4f503b)

Up to date builds of this document: Tungsten Clustering (for MySQL) 5.4 Manual (Online), Tungsten Clustering (for MySQL) 5.4 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.2.7. Docker Support Policy
2.3. Deployment Sources
2.3.1. Using the TAR/GZipped files
2.3.2. Using the RPM package files
2.4. Common tpm Options During Deployment
2.5. Best Practices
2.5.1. Best Practices: Deployment
2.5.2. Best Practices: Operations
2.5.3. Best Practices: Maintenance
2.6. Deployment Security
2.6.1. Enabling Security
2.6.2. Disabling Security
2.6.3. Creating Suitable Certificates
2.6.4. Installing from a Staging Host with Manually Generated Certificates
2.6.5. Installing via INI File with Manually Generated Certificates
2.6.6. Installing via INI File with CA-Signed Certificates
2.6.7. Replacing the JGroups Certificate from a Staging Directory
2.6.8. Replacing the TLS Certificate from a Staging Directory
2.6.9. Removing JGroups Encryption from a Staging Directory
2.6.10. Removing JGroups Encryption via INI File
2.6.11. Removing TLS Encryption from a Staging Directory
2.6.12. Removing TLS Encryption via INI File
2.6.13. Configuring Connector SSL
2.6.14. Creating the Truststore and Keystore
3. Deployment: MySQL Topologies
3.1. Deploying Standalone HA Clusters
3.1.1. Prepare: Standalone HA Cluster
3.1.2. Install: Standalone HA Cluster
3.1.3. Best Practices: Standalone HA Cluster
3.2. Deploying Composite Active/Passive Clustering
3.2.1. Prepare: Composite Active/Passive Cluster
3.2.2. Install: Composite Active/Passive Cluster
3.2.3. Best Practices: Composite Active/Passive Cluster
3.2.4. Adding a remote Composite Cluster
3.3. Deploying Multi-Site/Active-Active Clustering
3.3.1. Prepare: Multi-Site/Active-Active Clusters
3.3.2. Install: Multi-Site/Active-Active Clusters
3.3.3. Best Practices: Multi-Site/Active-Active Clusters
3.3.4. Configuring Startup on Boot
3.3.5. Resetting a single dataservice
3.3.6. Resetting all dataservices
3.3.7. Provisioning during live operations
3.3.8. Adding a new Cluster/Dataservice
3.3.9. Enabling SSL for Replicators Only
3.3.10. Dataserver maintenance
3.4. Deploying Tungsten Connector Only
3.5. Deploying Additional Datasources, Managers, or Connectors
3.5.1. Adding Datasources to an Existing Deployment
3.5.2. Adding Active Witnesses to an Existing Deployment
3.5.3. Replacing an Active Witness as a Full Cluster Node
3.5.4. Adding Passive Witnesses to an Existing Deployment
3.5.5. Adding Connectors to an Existing Deployment
3.5.6. Converting from a single cluster to a composite cluster
3.6. Replicating Data Into an Existing Dataservice
3.7. Replicating Data Out of a Cluster
3.7.1. Prepare: Replicating Data Out of a Cluster
3.7.2. Deploy: Replicating Data Out of a Cluster
3.8. Replicating from a Cluster to a Datawarehouse
3.8.1. Replicating from a Cluster to a Datawarehouse - Prerequisites
3.8.2. Replicating from a Cluster to a Datawarehouse - Configuring the Cluster Nodes
3.8.3. Replicating from a Cluster to a Datawarehouse - Configuring the Cluster-Extractor
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
4. Deployment: Advanced
4.1. Deploying Parallel Replication
4.1.1. Application Prerequisites for Parallel Replication
4.1.2. Enabling Parallel Apply During Install
4.1.3. Channels
4.1.4. Parallel Replication and Offline Operation
4.1.5. Adjusting Parallel Replication After Installation
4.1.6. Monitoring Parallel Replication
4.1.7. Controlling Assignment of Shards to Channels
4.1.8. Disk vs. Memory Parallel Queues
4.2. Starting and Stopping Tungsten Cluster
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 Multi-Site/Active-Active Replicator Service
4.3. Configuring Startup on Boot
4.3.1. Configuring Multi-Site/Active-Active Replicator Startup on Boot
4.4. Upgrading Tungsten Cluster
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. Installing an Upgraded JAR Patch
4.4.4. Installing Patches
4.5. Removing Datasources, Managers or Connectors
4.5.1. Removing a Datasource from an Existing Deployment
4.5.2. Removing a Composite Datasource/Cluster from an Existing Deployment
4.5.3. Removing a Connector from an Existing Deployment
5. Operations Guide
5.1. The 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. Understanding Replicator Roles
5.3.6. Changing Datasource States
5.3.7. Datasource Statuses
5.3.8. Datasource States and Policy Mode Interactions
5.4. Policy Modes
5.4.1. Setting Policy Modes
5.5. Switching Primary Hosts
5.5.1. Automatic Primary Failover
5.5.2. Manual Primary Switch
5.6. Datasource Recovery Steps
5.6.1. Recover a failed Replica
5.6.2. Recover a failed Primary
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.7.4. Composite Cluster Relay 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 Replica
5.10.4. Manually Recovering from Another Replica
5.10.5. Reprovision a MySQL Replica using rsync
5.10.6. Rebuilding a Lost Datasource
5.10.7. 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.12. Resetting a Tungsten Cluster Dataservice
5.12.1. Reset a Single Site in a Multi-Site/Active-Active Topology
5.12.2. Reset All Sites in a Multi-Site/Active-Active topology
5.13. Replicator Fencing
5.13.1. Fencing a Replica Node Due to a Replication Fault
5.13.2. Fencing Primary Replicators
5.14. Performing Database or OS Maintenance
5.14.1. Performing Maintenance on a Single Replica
5.14.2. Performing Maintenance on a Primary
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 Tungsten Cluster Maintenance
5.16. Monitoring Tungsten Cluster
5.16.1. Managing Log Files with logrotate
5.16.2. Monitoring Status Using cacti
5.16.3. Monitoring Status Using nagios
5.17. Rebuilding THL on the Primary
6. Tungsten Connector
6.1. Connector/Application Basics
6.1.1. Connector Control Flow
6.2. Basic Connector Configuration
6.3. Clients and Deployment
6.3.1. Connection Pools
6.4. Routing Methods
6.4.1. Connector Routing Methods
6.4.2. Connector Quality of Service (QoS) Selection
6.4.3. Connector Load Balancers
6.4.4. Specifying Required Latency
6.4.5. Setting Read Affinity and Direct Reads
6.4.6. Setting Negative Affinity
6.4.7. Smartscale Routing
6.4.8. Direct Routing
6.4.9. SQL Routing
6.4.10. Host-based Routing
6.4.11. Port-based Routing
6.4.12. Read-only Routing
6.5. Using Bridge Mode
6.5.1. Enabling Bridge Mode
6.6. User Authentication
6.6.1. user.map File Format
6.6.2. user.map Direct Routing
6.6.3. user.map Host Options
6.6.4. user.map Updates
6.6.5. Generating user.map Entries from a Script
6.6.6. Encrypting user.map Data
6.6.7. Synchronizing user.map Data
6.6.8. user.map Limitations
6.6.9. Host-based Authentication
6.7. Connector Operational States
6.7.1. Connections During Automatic Failure/Failover
6.7.2. Connections During Manual Switch
6.7.3. Connections During Connection Failures
6.7.4. Other Errors
6.7.5. Connector Keepalive
6.7.6. Connector Change User as Ping
6.8. Connector/Manager Interface
6.9. Connector Command-Line Interface
6.10. Connector Inline Command Interface
6.10.1. Connector tungsten cluster status Command
6.10.2. Connector tungsten connection count Command
6.10.3. Connector tungsten connection status Command
6.10.4. Connector tungsten flush privileges Command
6.10.5. Connector tungsten gc Command
6.10.6. Connector tungsten help Command
6.10.7. Connector tungsten mem info Command
6.10.8. Connector tungsten show [full] processlist Command
6.10.9. Connector show slave status Command
6.10.10. Connector tungsten show variables Command
6.11. Advanced Configuration
6.11.1. Working with Proxy Protocol v1
6.11.2. Using Multiple Dataservices
6.11.3. Connector Automatic Reconnect
6.11.4. Using the Connector with HA Proxy
6.11.5. Using Fall-Back Bridge Mode
6.11.6. Using the Max Connections Feature
6.11.7. Adjusting the Client Disconnect Delay During Manual Switch
6.11.8. Adjusting the Bridge Mode Forced Client Disconnect Timeout
6.11.9. Adjusting the Connnector Response to Resource Losses
6.11.10. Connector Logging Configuration
6.11.11. Connector SSL Advertisement Configuration
6.11.12. Connector IP Address Configuration
6.12. Connector General Limitations
7. Tungsten Manager
7.1. Tungsten Manager Introduction
7.2. Tungsten Manager Failover Tuning
7.3. Tungsten Manager Fault Detection, Fencing and Recovery
7.3.1. Tungsten Manager Definitions
7.3.2. Cluster Monitoring and Notification Events
7.3.3. Rule Organization - Detection, Investigation, Fencing, Recovery
8. Command-line Tools
8.1. The cctrl Command
8.1.1. cctrl Command-line Options
8.1.2. cctrl Modes
8.1.3. cctrl Commands
8.2. The check_tungsten_latency Command
8.3. The check_tungsten_online Command
8.4. The check_tungsten_policy Command
8.5. The check_tungsten_progress Command
8.6. The check_tungsten_services Command
8.7. The clean_release_directory Command
8.8. The cluster_backup Command
8.9. The connector Command
8.10. The ddlscan Command
8.10.1. Optional Arguments
8.10.2. Supported Templates and Usage
8.11. The deployall Command
8.12. The dsctl Command
8.12.1. dsctl get Command
8.12.2. dsctl set Command
8.12.3. dsctl reset Command
8.12.4. dsctl help Command
8.13. env.sh Script
8.14. The load-reduce-check Tool
8.14.1. Generating Staging DDL
8.14.2. Generating Live DDL
8.14.3. Materializing a View
8.14.4. Generating Sqoop Load Commands
8.14.5. Generating Metadata
8.14.6. Compare Loaded Data
8.15. The manager Command
8.16. The materialize Command
8.17. The multi_trepctl Command
8.17.1. multi_trepctl Options
8.17.2. multi_trepctl Commands
8.18. The query Command
8.19. The replicator Command
8.20. The startall Command
8.21. The stopall Command
8.22. The thl Command
8.22.1. thl Position Commands
8.22.2. thl list Command
8.22.3. thl index Command
8.22.4. thl purge Command
8.22.5. thl info Command
8.22.6. thl help Command
8.23. The trepctl Command
8.23.1. trepctl Options
8.23.2. trepctl Global Commands
8.23.3. trepctl Service Commands
8.24. The tpasswd Command
8.25. The tungsten_find_orphaned Command
8.25. Examples:
8.26. The tungsten_find_position Command
8.27. The tungsten_find_seqno Command
8.28. The tungsten_health_check Script
8.29. The tungsten_monitor Script
8.30. The tungsten_newrelic_event Command
8.31. The tungsten_nagios_backups Command
8.32. The tungsten_nagios_online Command
8.33. The tungsten_post_process Command
8.34. The tungsten_provision_thl Command
8.34.1. Provisioning from RDS
8.34.2. tungsten_provision_thl Reference
8.35. The tungsten_provision_slave Script
8.36. The tungsten_read_master_events Script
8.37. The tungsten_reset_manager Command
8.38. The tungsten_send_diag Script
8.39. The tungsten_set_position Script
8.40. The tungsten_skip_seqno Script
8.41. The undeployall Command
8.42. The zabbix_tungsten_latency Command
8.43. The zabbix_tungsten_online Command
8.44. The zabbix_tungsten_progress Command
8.45. The zabbix_tungsten_services Command
9. The tpm Deployment Command
9.1. Comparing Staging and INI tpm Methods
9.2. Processing Installs and Upgrades
9.3. tpm Staging Configuration
9.3.1. Configuring default options for all services
9.3.2. Configuring a single service
9.3.3. Configuring a single host
9.3.4. Reviewing the current configuration
9.3.5. Installation
9.3.6. Upgrades from a Staging Directory
9.3.7. Configuration Changes from a Staging Directory
9.3.8. Converting from INI to Staging
9.4. tpm INI File Configuration
9.4.1. Creating an INI file
9.4.2. Installation with INI File
9.4.3. Upgrades with an INI File
9.4.4. Configuration Changes with an INI file
9.4.5. Converting from Staging to INI
9.4.6. Using the translatetoini.pl Script
9.5. tpm Commands
9.5.1. tpm ask Command
9.5.2. tpm configure Command
9.5.3. tpm connector Command
9.5.4. tpm diag Command
9.5.5. tpm fetch Command
9.5.6. tpm firewall Command
9.5.7. tpm help Command
9.5.8. tpm install Command
9.5.9. tpm mysql Command
9.5.10. tpm promote-connector Command
9.5.11. tpm query Command
9.5.12. tpm reset Command
9.5.13. tpm reset-thl Command
9.5.14. tpm reverse Command
9.5.15. tpm ssh-copy-cert Command
9.5.16. tpm uninstall Command
9.5.17. tpm update Command
9.5.18. tpm validate Command
9.5.19. tpm validate-update Command
9.6. tpm Common Options
9.7. tpm Validation Checks
9.8. tpm Configuration Options
9.8.1. A tpm Options
9.8.2. B tpm Options
9.8.3. C tpm Options
9.8.4. D tpm Options
9.8.5. E tpm Options
9.8.6. F tpm Options
9.8.7. H tpm Options
9.8.8. I tpm Options
9.8.9. J tpm Options
9.8.10. L tpm Options
9.8.11. M tpm Options
9.8.12. N tpm Options
9.8.13. O tpm Options
9.8.14. P tpm Options
9.8.15. R tpm Options
9.8.16. S tpm Options
9.8.17. T tpm Options
9.8.18. U tpm Options
9.8.19. V tpm Options
9.8.20. W tpm Options
10. Replication Filters
10.1. Enabling/Disabling Filters
10.2. Enabling Additional Filters
10.3. Filter Status
10.4. Filter Reference
10.4.1. ansiquotes.js Filter
10.4.2. BidiRemoteSlave (BidiSlave) Filter
10.4.3. breadcrumbs.js Filter
10.4.4. CaseTransform Filter
10.4.5. ColumnName Filter
10.4.6. ConvertStringFromMySQL Filter
10.4.7. DatabaseTransform (dbtransform) Filter
10.4.8. dbrename.js Filter
10.4.9. dbselector.js Filter
10.4.10. dbupper.js Filter
10.4.11. dropcolumn.js Filter
10.4.12. dropcomments.js Filter
10.4.13. dropmetadata.js Filter
10.4.14. dropstatementdata.js Filter
10.4.15. Dummy Filter
10.4.16. EnumToString Filter
10.4.17. EventMetadata Filter
10.4.18. foreignkeychecks.js Filter
10.4.19. Heartbeat Filter
10.4.20. insertsonly.js Filter
10.4.21. Logging Filter
10.4.22. MySQLSessionSupport (mysqlsessions) Filter
10.4.23. NetworkClient Filter
10.4.24. nocreatedbifnotexists.js Filter
10.4.25. OptimizeUpdates Filter
10.4.26. PrimaryKey Filter
10.4.27. PrintEvent Filter
10.4.28. Rename Filter
10.4.29. Replicate Filter
10.4.30. ReplicateColumns Filter
10.4.31. Row Add Database Name Filter
10.4.32. SetToString Filter
10.4.33. Shard Filter
10.4.34. shardbyseqno.js Filter
10.4.35. shardbytable.js Filter
10.4.36. SkipEventByType Filter
10.4.37. TimeDelay (delay) Filter
10.4.38. tosingledb.js Filter
10.4.39. truncatetext.js Filter
10.4.40. zerodate2null.js Filter
10.5. Standard JSON Filter Configuration
10.5.1. Rule Handling and Processing
10.5.2. Schema, Table, and Column Selection
10.6. JavaScript Filters
10.6.1. Writing JavaScript Filters
10.6.2. Installing Custom JavaScript Filters
11. Performance, Tuning and Testing
11.1. Block Commit
11.1.1. Monitoring Block Commit Status
11.2. Improving Network Performance
11.3. Tungsten Replicator Block Commit and Memory Usage
11.4. Connector Memory Management
11.5. Functional Testing
11.5.1. Manual and Automatic Failover
11.5.2. Backup and Restore
11.5.3. Connectivity
11.5.4. Performance and Other Tests
A. Release Notes
A.1. Tungsten Clustering 5.4.1 GA (28 October 2019)
A.2. Tungsten Clustering 5.4.0 GA (31 July 2019)
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.2.6. SELinux Configuration
B.3. MySQL Database Setup
B.3.1. MySQL Version Support
B.3.2. MySQL Configuration
B.3.3. MySQL Configuration for Active/Active Deployments
B.3.4. MySQL Configuration for Heterogeneous Deployments
B.3.5. MySQL User Configuration
B.3.6. MySQL Unprivileged Users
B.4. Prerequisite Checklist
C. Troubleshooting
C.1. Contacting Support
C.1.1. Support Request Procedure
C.1.2. Creating a Support Account
C.1.3. Generating Diagnostic Information
C.1.4. Open a Support Ticket
C.1.5. Open a Support Ticket via Email
C.1.6. Getting Updates for all Company Support Tickets
C.1.7. Support Severity Level Definitions
C.1.8. Generating Advanced Diagnostic Information
C.2. Error/Cause/Solution
C.2.1. Lots of entries added to replicator log
C.2.2. Backup/Restore is not bringing my host back to normal
C.2.3. Services requires a reset
C.2.4. Error: could not settle on encryption_client algorithm
C.2.5. ERROR backup.BackupTask Backup operation failed: null
C.2.6. Unable to update the configuration of an installed directory
C.2.7. Cluster remains in MAINTENANCE mode after tpm update
C.2.8. Missing events, or events not extracted correctly
C.2.9. Triggers not firing correctly on Replica
C.2.10. [S1000][unixODBC][MySQL][ODBC 5.3(w) Driver]SSL connection error: unknown error number [ISQL]ERROR: Could not SQLConnect
C.2.11. Latency is high: master:ONLINE, progress=41331580333, THL latency=78849.733
C.2.12. Connector shows errors with "java.net.SocketException: Broken pipe"
C.2.13. The Primary replicator stopped with a JDBC error.
C.2.14. cctrl reports MANAGER(state=STOPPED)
C.2.15. trepctl status hangs
C.2.16. Attempt to write new log record with equal or lower fragno: seqno=3 previous stored fragno=32767 attempted new fragno=-32768
C.2.17. Replicator runs out of memory
C.2.18. ERROR 1010 (HY000) at line 5094506: Error dropping database (can't rmdir './mysql-bin/', errno: 17)
C.2.19. ERROR >> host1 >> can't alloc thread
C.2.20. ERROR 1580 (HY000) at line 5093787: You cannot 'DROP' a log table if logging is enabled
C.2.21. WARNING: An illegal reflective access operation has occurred
C.2.22. ERROR 2013 (HY000) at line 583: Lost connection to MySQL server during query
C.2.23. pendingExceptionMessage": "Unable to update last commit seqno: Incorrect datetime value: '2016-03-13 02:02:26' for column 'update_timestamp' at row 1
C.2.24. Too many open processes or files
C.2.25. Replication latency very high
C.2.26. Backup agent name not found: xtrabackup-full
C.2.27. WARN [KeepAliveTimerTask] - Error while sending a KEEP_ALIVE query to connection.
C.2.28. Event application failed: seqno=20725782 fragno=0 message=java.sql.SQLDataException: Data too long for column 'eventid' at row 1
C.2.29. element 'mysql_readonly' not found in path
C.2.30. cctrl hangs
C.2.31. Replicator fails to connect after updating password
C.2.32. There were issues configuring the sandbox MySQL server
C.2.33. Starting replication after performing a restore because of an invalid restart sequence number
C.2.34. MySQL is incorrectly configured
C.2.35. Replicator reports an Out of Memory error
C.3. Known Issues
C.3.1. Triggers
C.4. Troubleshooting Timeouts
C.5. Troubleshooting Backups
C.6. Running Out of Diskspace
C.7. Troubleshooting SSH and tpm
C.8. Troubleshooting Data Differences
C.8.1. Identify Structural Differences
C.8.2. Identify Data Differences
C.9. Comparing Table Data
C.10. Troubleshooting Memory Usage
D. Files, Directories, and Environment
D.1. The Tungsten Cluster 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. Terminology Reference
E.1. Transaction History Log (THL)
E.1.1. THL Format
E.2. Generated Field Reference
E.2.1. Terminology: Fields masterConnectUri
E.2.2. Terminology: Fields masterListenUri
E.2.3. Terminology: Fields accessFailures
E.2.4. Terminology: Fields active
E.2.5. Terminology: Fields activeSeqno
E.2.6. Terminology: Fields appliedLastEventId
E.2.7. Terminology: Fields appliedLastSeqno
E.2.8. Terminology: Fields appliedLatency
E.2.9. Terminology: Fields applier.class
E.2.10. Terminology: Fields applier.name
E.2.11. Terminology: Fields applyTime
E.2.12. Terminology: Fields autoRecoveryEnabled
E.2.13. Terminology: Fields autoRecoveryTotal
E.2.14. Terminology: Fields averageBlockSize
E.2.15. Terminology: Fields blockCommitRowCount
E.2.16. Terminology: Fields cancelled
E.2.17. Terminology: Fields channel
E.2.18. Terminology: Fields channels
E.2.19. Terminology: Fields clusterName
E.2.20. Terminology: Fields commits
E.2.21. Terminology: Fields committedMinSeqno
E.2.22. Terminology: Fields criticalPartition
E.2.23. Terminology: Fields currentBlockSize
E.2.24. Terminology: Fields currentEventId
E.2.25. Terminology: Fields currentLastEventId
E.2.26. Terminology: Fields currentLastFragno
E.2.27. Terminology: Fields currentLastSeqno
E.2.28. Terminology: Fields currentTimeMillis
E.2.29. Terminology: Fields dataServerHost
E.2.30. Terminology: Fields discardCount
E.2.31. Terminology: Fields doChecksum
E.2.32. Terminology: Fields estimatedOfflineInterval
E.2.33. Terminology: Fields eventCount
E.2.34. Terminology: Fields extensions
E.2.35. Terminology: Fields extractTime
E.2.36. Terminology: Fields extractor.class
E.2.37. Terminology: Fields extractor.name
E.2.38. Terminology: Fields filter.#.class
E.2.39. Terminology: Fields filter.#.name
E.2.40. Terminology: Fields filterTime
E.2.41. Terminology: Fields flushIntervalMillis
E.2.42. Terminology: Fields fsyncOnFlush
E.2.43. Terminology: Fields headSeqno
E.2.44. Terminology: Fields intervalGuard
E.2.45. Terminology: Fields lastCommittedBlockSize
E.2.46. Terminology: Fields lastCommittedBlockTime
E.2.47. Terminology: Fields latestEpochNumber
E.2.48. Terminology: Fields logConnectionTimeout
E.2.49. Terminology: Fields logDir
E.2.50. Terminology: Fields logFileRetainMillis
E.2.51. Terminology: Fields logFileSize
E.2.52. Terminology: Fields maxChannel
E.2.53. Terminology: Fields maxDelayInterval
E.2.54. Terminology: Fields maxOfflineInterval
E.2.55. Terminology: Fields maxSize
E.2.56. Terminology: Fields maximumStoredSeqNo
E.2.57. Terminology: Fields minimumStoredSeqNo
E.2.58. Terminology: Fields name
E.2.59. Terminology: Fields offlineRequests
E.2.60. Terminology: Fields otherTime
E.2.61. Terminology: Fields pendingError
E.2.62. Terminology: Fields pendingErrorCode
E.2.63. Terminology: Fields pendingErrorEventId
E.2.64. Terminology: Fields pendingErrorSeqno
E.2.65. Terminology: Fields pendingExceptionMessage
E.2.66. Terminology: Fields pipelineSource
E.2.67. Terminology: Fields processedMinSeqno
E.2.68. Terminology: Fields queues
E.2.69. Terminology: Fields readOnly
E.2.70. Terminology: Fields relativeLatency
E.2.71. Terminology: Fields resourcePrecedence
E.2.72. Terminology: Fields rmiPort
E.2.73. Terminology: Fields role
E.2.74. Terminology: Fields seqnoType
E.2.75. Terminology: Fields serializationCount
E.2.76. Terminology: Fields serialized
E.2.77. Terminology: Fields serviceName
E.2.78. Terminology: Fields serviceType
E.2.79. Terminology: Fields shard_id
E.2.80. Terminology: Fields simpleServiceName
E.2.81. Terminology: Fields siteName
E.2.82. Terminology: Fields sourceId
E.2.83. Terminology: Fields stage
E.2.84. Terminology: Fields started
E.2.85. Terminology: Fields state
E.2.86. Terminology: Fields stopRequested
E.2.87. Terminology: Fields store.#
E.2.88. Terminology: Fields storeClass
E.2.89. Terminology: Fields syncInterval
E.2.90. Terminology: Fields taskCount
E.2.91. Terminology: Fields taskId
E.2.92. Terminology: Fields timeInCurrentEvent
E.2.93. Terminology: Fields timeInStateSeconds
E.2.94. Terminology: Fields timeoutMillis
E.2.95. Terminology: Fields totalAssignments
E.2.96. Terminology: Fields transitioningTo
E.2.97. Terminology: Fields uptimeSeconds
E.2.98. Terminology: Fields version
F. Internals
F.1. Extending Backup and Restore Behavior
F.1.1. Backup Behavior
F.1.2. Restore Behavior
F.1.3. Writing a Custom Backup/Restore Script
F.1.4. Enabling a Custom Backup Script
F.2. Character Sets in Database and Tungsten Cluster
F.3. Understanding Replication of Date/Time Values
F.3. Best Practices
F.4. Memory Tuning and Performance
F.4.1. Understanding Tungsten Replicator Memory Tuning
F.4.2. Connector Memory Management
F.5. Tungsten Replicator Pipelines and Stages
F.6. Tungsten Cluster Schemas
G. Frequently Asked Questions (FAQ)
G.1. General Questions
G.2. Cloud Deployment and Management
H. Ecosystem Support
H.1. Continuent Github Repositories
I. Configuration Property Reference

List of Tables

1.1. Key Terminology
2.1. Key Terminology
6.1. Routing Method Selection
6.2. Connector Command Line Sub-Commands
6.3. Inline Interface Commands
8.1. cctrl Command-line Options
8.2. cctrl Command-line Options
8.3. cctrl Command-line Options
8.4. cctrl Command-line Options
8.5. cctrl Command-line Options
8.6. cctrl Command-line Options
8.7. cctrl Command-line Options
8.8. cctrl Command-line Options
8.9. cctrl Command-line Options
8.10. cctrl Command-line Options
8.11. cctrl Commands
8.12. cctrldatasource Commands
8.13. check_tungsten_latency Options
8.14. check_tungsten_online Options
8.15. check_tungsten_policy Options
8.16. check_tungsten_progress Options
8.17. check_tungsten_services Options
8.18. cluster_backup Command-line Options
8.19. connector Commands
8.20. ddlscan Command-line Options
8.21. ddlscan Supported Templates
8.22. dsctl Commands
8.23. dsctl Command-line Options
8.24. dsctl Command-line Options
8.25. dsctl Command-line Options
8.26. manager Commands
8.27. multi_trepctl Command-line Options
8.28. multi_trepctl--output Option
8.29. multi_trepctl Commands
8.30. query Common Options
8.31. replicator Commands
8.32. replicator Commands Options for condrestart
8.33. replicator Commands Options for console
8.34. replicator Commands Options for restart
8.35. replicator Commands Options for start
8.36. thl Options
8.37. trepctl Command-line Options
8.38. trepctl Replicator Wide Commands
8.39. trepctl Service Commands
8.40. trepctl backup Command Options
8.41. trepctl clients Command Options
8.42. trepctl offline-deferred Command Options
8.43. trepctl online Command Options
8.44. trepctl purge Command Options
8.45. trepctl reset Command Options
8.46. trepctl setrole Command Options
8.47. trepctl shard Command Options
8.48. trepctl status Command Options
8.49. trepctl wait Command Options
8.50. tpasswd Common Options
8.51. tungsten_find_position Options
8.52. tungsten_find_seqno Options
8.53. tungsten_health_check Command-line Options
8.54. tungsten_monitor Command-line Options
8.55. tungsten_post_process Options
8.56. tungsten_provision_slave Command-line Options
8.57. tungsten_read_master_events Command-line Options
8.58. tungsten_reset_manager Options
8.59. tungsten_send_diag Command-line Options
8.60. tungsten_set_position Command-line Options
9.1. TPM Deployment Methods
9.2. tpm Core Options
9.3. tpm Commands
9.4. tpm Common Options
9.5. tpm Validation Checks
9.6. tpm Configuration Options
D.1. Continuent Tungsten Directory Structure
D.2. Continuent Tungsten tungsten Sub-Directory Structure
E.1. THL Event Format