Version End of Life. 15 Aug 2024
Release 6.1.19 contains a number of critical bug fixes and improvements, specifically for customers using Parallel Replication.
The following changes have been made to Tungsten Replicator 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:
repl_svc_extractor_multi_frag_service_detectionis 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.
Issues: CT-1959
Improvements, new features and functionality
The tpm command calls to glob have been improved to be more strict and compliant.
Issues: CT-1940
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).
Issues: CT-1943
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.
Issues: CT-1944
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 reseted correctly.
Issues: CT-1942
The tpm mysql command will now gracefully handle being run on a non-database node.
Issues: CT-1946
Fixes an issue that would leave a transaction uncommitted longer than necessary.
Issues: CT-1958
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)
Issues: CT-1967
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.
Issues: CT-1973
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
Issues: CT-1351