A.8. Tungsten Clustering 6.1.18 GA (7 Sept 2022)

Version End of Life. 15 Aug 2024

Release 6.1.18 contains a number of minor bug fixes and improvements.

Behavior Changes

The following changes have been made to Tungsten Cluster and may affect existing scripts and integration tools. Any scripts or environment which make use of these tools should check and update for the new configuration:

Command-line Tools

  • The check_tungsten.sh script has been deprecated and no longer maintained. It will be removed in the next patch release and users should use the newer tmonitor commands.

    Issues: CT-1038

  • The tungsten_find_orphaned command now places the log file in $CONTINUENT_ROOT/service_logs/, not /tmp/

    Issues: CT-1866

Backup and Restore

  • From v8 of xtrabackup, the --stream=tar option was removed, meaning that backups could fail if using the newer release of the Percona tools

    In this release, the backups will now create the backup and then manually compress it

    Warning

    This change will increase the required disk space for backups to allow the post-backup compression to complete.

    Issues: CT-1346

Tungsten Manager

  • A failsafe shunned cluster (Caused by a network split) will be auto recovered after the network connection is re-established.

    Issues: CT-241

Improvements, new features and functionality

Command-line Tools

  • The tungsten_merge_logs command now supports the --before TIMESTAMP and --after TIMESTAMP filters

    Issues: CT-1869

  • The tungsten_generate_haproxy_for_api and tpm generate-haproxy-for-api commands now support using connector hosts in the backend definitions via -c, and extra backend flags to the backend hosts lines using -f.

    Issues: CT-1909

  • The tungsten_generate_haproxy_for_api and tpm generate-haproxy-for-api commands no longer call the Perl Data::Dumper module.

    Issues: CT-1915

  • The tpm ask isBridge and tpm ask isCoordinator commands have been back-ported to v6.

    Issues: CT-1916

  • The tungsten_reset_manager command now supports the ability to simply print out the path or paths to be cleared, one per line via the -l or --list arguments.

    Issues: CT-1917

Core Replicator

  • The thl list command now displays an approximative field size in bytes for row-based replication.

    Issues: CT-1847

  • Added a new feature that enables pausing a replicator stage for some amount of time.

    This will pause the given stage for 100 seconds.:

    trepctl pause -stage thl-to-q -time 100

    This will pause the stage indefinitely (or until restart, etc) Add -y to avoid the prompt message whether you are sure.

    trepctl pause -stage thl-to-q

    For the previous 2 commands, running a pause command again will override the previous command.

    This will resume the suspended stage (Note that if the stage is not paused, this will have no effect):

    trepctl resume -stage thl-to-q

    Note

    Please note this pause does not survive a replicator restart or a service offline/online.

    Issues: CT-1912

Tungsten Manager

  • Added a new option to TPM manager-replicator-offline-timeout=<timeout_in_sec> that configures the timeout for the manager to wait until the replicator goes offline. When parallel applier is in use the default timeout was too low, so it’s now user configurable so that it can be adjusted to suit different topologies. If not supplied, the default is 180 (3 minutes). This value should be sufficent in most use cases.

    Issues: CT-1892

Bug Fixes

Installation and Deployment

  • Fixes issues where fixed properties and filters passed to tpm in service stanzas were not being configured correctly

    Issues: CT-1463

Command-line Tools

  • replicator start offline would not properly pass the offline argument to systemd scripts when installed through deployall.

    Issues: CT-1836

  • undeployall script would not properly uninstall systemd services on some distributions including amazon linux.

    Issues: CT-1845

  • The tpm diag command now passes when the nodename defined in the tungsten.ini is the shortname, and DNS returns the FQDN.

    Issues: CT-1908

  • The tpm diag command now gathers the mysql.log file when SSL is enabled in the server

    Issues: CT-1933

  • The tpm diag command now behaves properly when the MySQL server is logging to STDERR.

    Issues: CT-1935

Backup and Restore

  • Fixed an issue where an xtrabackup generated by the replicator would fail to be restored using trepctl restore command.

    Issues: CT-1575

  • During the backup/restore process the MySQL certificates are kept intact.

    Issues: CT-1841

  • Restore will now succeed even if only one incremental backup has been created.

    Issues: CT-1842

  • Incremental backups can now be restored more then once.

    Issues: CT-1850

Core Replicator

  • Fixes an issue that would prevent a service from going offline at a specified time (trepctl online -until-time) when parallel apply is enabled. This is a rework of CT-1243.

    Issues: CT-1684

  • Fixed a possible issue when recovering an old primary as a replica after failover when parallel apply is enabled, that could lead the replica to be unable to come online and require a reprovisioning of this replica.

    Issues: CT-1890

  • Fixes an issue that prevented geometry datatypes with SRID from being replicated.

    Issues: CT-1904

  • Fixed an issue where filtered events would trigger a useless update to the service trep_commit_seqno table while it is overwritten anyway once the last statement of the applied event is done, just prior to committing the whole block.

    Issues: CT-1931