Tungsten Clustering 6.1.14

Build: 35

Release Date: 17 Aug 2021

End of Life Date: 15 Aug 2024

Product End of Life

This release is past End of Life.

Release 6.1.14 contains a number of bug fixes and improvements in the Connectors, and improved handling of systemd integration, additionally XA transaction support is now available.

Improvements, new features and functionality (10)

Command-line Tools (7)

• Improved the check_tungsten_online command:

  • determine the cluster name by default if none is provided via -s
  • always check ls resources even if a dataservice name is provided
  • add an option to be node-specific, ignoring any status from other nodes
  Issue: CT-1578
• Improved the tpm command's internal logic and introduced a new sub-command, tpm ask.
  Issue: CT-1573
• New ddlscan template (ddl-mysql-staging.vm) available to generate ddl required for staging tables when deploying the batch applier on a MySQL target.
  Issue: CT-1587
• 3 new tpm flags have been added:

  • svc-systemd-config-connector
  • svc-systemd-config-replicator
  • svc-systemd-config-manager

  These flags can be used to provide a custom systemd configuration that will be used in place of the default, generated one. This is typically useful when ExecStartPre or ExecStartPost commands are needed
  Issue: CT-1555
• A new command-line tool tungsten show processlist has been added. This is a read-only script which will show the output from tungsten show processlist on all available Connectors.
  Issue: CT-1542
• Added tpm support for tuning maxDelayInterval, used to tune parallel apply. Usage example:

  property=replicator.store.parallel-queue.maxDelayInterval=120

  This sets the max delay interval to 2 minutes
  Issue: CT-1541
• Tungsten Connector upgrades are now performed with minimal downtime thanks to graceful-shutdown which is now also used when systemd services are installed.systemd definition file has been updated to prevent unwanted systemd-driven control of Tungsten components. 2 new settings have been added to definition files:

  • RemainAfterExit=yes so that systemd won't interfere when the binary is restarted after upgrade
  • GuessMainPID=no so that the PID can change without confusion inside systemd status

  Note that Tungsten has its own service manager (Tanuki service wrapper), systemd is only used for system startup launch of Tungsten components.

  Note

  After upgrade, the systemd status output might show "Active: active (exited)". This is expected since systemd doesn't know the new process to monitor after upgrade
  Issue: CT-1538

Backup and Restore (1)

• A new tpm option has been added --backup-options

  This property can be used to pass options directly to the backup binary (Xtrabackup, mariabackup etc). This can be especially useful when the xtrabackup and MySQL versions differ. Generally, MySQL is always ahead of xtrabackup and in some situations xtrabackup will fail if the underlying MySQL patch release does not match the xtrabackup patch release. In this scenario, you could utilise the new option to force xtrabackup to not check the versions, for example:

  backup-options=--no-server-version-check

  Multiple options can be passed as a space-separated list, for example.

  backup-options=--option1 --option2 --option3

  Note

  Options passed are specific to the underlying binary and are not validated by Tungsten, therefore you must ensure you only use options that are valid, and check syntax accurately.
  Issue: CT-1595

Core Replicator (1)

• Support for XA transactions has been added.
  Issue: CT-925

Manager (1)

• A new tpm option has been added replica-tx-commit-levelValid values of either 1 (default) or 2. Setting this value to 2 will change the underlying database property innodb_flush_log_at_trx_commit when the node becomes a replica, resetting it back to 1 if the node is promoted to a primary. This can improve performance on the apply rates for replicas.
  Issue: CT-1241

Bug Fixes (9)

Command-line Tools (7)

• The check_tungsten_services -r command no longer takes an extended time to complete when the manager is not running.
  Issue: CT-1599
• The tpm connector command now works when the application user's password contains double quotes.
  Issue: CT-1596
• The tpm connector --samples command no longer displays the password in any example.
  Issue: CT-1593
• The tungsten_generate_haproxy_for_api and tpm generate-haproxy-for-api command now properly skips sub-services inComposite Active/Active clusters.
  Issue: CT-1552
• The tpm update command now properly parses the --ini argument.
  Issue: CT-1551
• The --host argument to tpm connector now works properly. Support for the legacy --hosts is also included. Only one hostname may be specified to tpm connector.
  Issue: CT-1543
• tpm was failing to check application password when single quoted.
  Issue: CT-1257

Connector (2)

• When an RO_RELAXED connection is requested and no replica is available to serve the request, we will now properly reuse the current connection to the primary for executing the request.
  Issue: CT-1564
• With smartscale enabled, when no writes have been issued to the connection, the user session will remain uninitialized. In that situation, we now send reads to replicas.
  Issue: CT-1560