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:

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

Issues: CT-1538

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

Issues: CT-1541

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.

Issues: CT-1542

3 new tpm flags have been added:

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

Issues: CT-1555

Improved the tpm command's internal logic and introduced a new sub-command, tpm ask.

Issues: CT-1573

Improved the check_tungsten_online command:

Issues: CT-1578

New ddlscan template (ddl-mysql-staging.vm) available to generate ddl required for staging tables when deploying the batch applier on a MySQL target.

Issues: CT-1587

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

Issues: CT-1595

Support for XA transactions has been added.

Issues: CT-925

A new tpm option has been added replica-tx-commit-level

Valid 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.

Issues: CT-1241

tpm was failing to check application password when single quoted.

Issues: CT-1257

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.

Issues: CT-1543

The tpm update command now properly parses the --ini argument.

Issues: CT-1551

The tungsten_generate_haproxy_for_api and tpm generate-haproxy-for-api command now properly skips sub-services in Composite Active/Active clusters.

Issues: CT-1552

The tpm connector --samples command no longer displays the password in any example.

Issues: CT-1593

The tpm connector command now works when the application user's password contains double quotes.

Issues: CT-1596

The check_tungsten_services -r command no longer takes an extended time to complete when the manager is not running.

Issues: CT-1599

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.

Issues: CT-1560

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.

Issues: CT-1564