Tungsten Clustering 6.1.19

Build: 22

Release Date: 17 Oct 2022

End of Life Date: 15 Aug 2024

Product End of Life

This release is past End of Life.

Release 6.1.19 contains a number of critical bug fixes and improvements, specifically for customers using Parallel Replication.

Behavior Changes (3)

The following changes 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 (1)

• The check_tungsten.sh was deprecated in release 6.1.18 and has now been removed from this release.
  Issue: CT-1939

Core Replicator (1)

• repl-svc-extractor-multi-frag-service-detection is now turned **ON** by default. Event shards are determined at extraction time. With fragmented events, the shard cannot be determined by only reading the first fragment, but needs to check the last fragment as well. With this setting turned OFF, there is no issue with pipelines that don't need it, i.e. no parallel apply downstream replicas. However, as this is done at extract time, THL contains this information, and adding or changing a replica using parallel apply could introduce issues.

  Note

  It can be disabled if you see a performance overhead but this should be done with caution. For Aurora<>Aurora Active/Active deployments it is essential that this property be left ON.
  Issue: CT-1959

Connector (1)

• Improved tungsten show processlist by running underlying commands in parallel.
  Issue: CT-1569

Improvements, new features and functionality (6)

Command-line Tools (4)

• A new standalone status script has been added called tungsten_get_status that shows the datasources and replicators for all nodes in all services along with seqno and latency.
  Issue: CT-1962
• The tpm ask command has five new variables available: dsrole & dsstate for the current datasource, and trrole & trstate for the current replicator, and nodeinfo which displays all 4 of the new variables.
  Issue: CT-1944
• The tpm ask stages and tpm ask allstages commands have been added to display the Replicator stages for the current node (stages) and the stages for each role (allstages).
  Issue: CT-1943
• The tpm command calls to glob have been improved to be more strict and compliant.
  Issue: CT-1940

Connector (2)

• Added a connector mode command to print which mode the connector is running in, either "bridge" or "proxy"
  Issue: CT-1799
• The connector graceful-stop command now supports systemd service manager properly. The connector stop command now takes an optional argument that will make it a graceful stop. If connector stop is run without the parameter, it will stop the connector immediately. If a positive number of seconds is passed, it will wait, at most, this timeout for connections to disconnect (refusing new connections), after which it will force close all connections and shutdown the connector. connector graceful-stop behavior is unchanged: without the parameter, the connector will wait "forever" for connections to disconnect. A positive timeout in seconds can be passed to sever connections after the given delay
  Issue: CT-1921

Bug Fixes (8)

Installation and Deployment (1)

• The tpm install and tpm update commands now properly support the thl-port option for cross-site subservices.
  Issue: CT-1953

Command-line Tools (2)

• The tpm mysql command will now gracefully handle being run on a non-database node.
  Issue: CT-1946
• Fixes an issue where the pause state would be badly displayed under no load, when the pause reaches the defined time. Note this is only a display issue : once an event is received, the pause state and displayed remaining time will be reset correctly.
  Issue: CT-1942

Core Replicator (3)

• Fixed an issue where the replicator would hang after applying a DROP TABLE event, that originally failed on the primary, but got logged into the binlog.
  Issue: CT-1973
• Fixed an issue where the shard_id stored in the trep_commit_seqno table would show an incorrect shard after processing a skipped event (an event from another channel)
  Issue: CT-1967
• Fixes an issue that would leave a transaction uncommitted longer than necessary.
  Issue: CT-1958

Filters (1)

• The BidiRemoteSlaveFilter could fail to correctly flag fragmented events in unprivileged environments (Aurora, for example) In such an environment (multi-active, unprivileged database access), a new setting was introduced to force extraction process to read ahead to the last fragment to detect the service name (false by default). Enabled with repl-svc-extractor-multi-frag-service-detection=true
  Issue: CT-1351

Connector (1)

• Connector now auto detects default authentication plugin by retrieving MySQL data source variable default_authentication_pluginrather than just using MySQL server version
  Issue: CT-1926