Skip to main content
Tungsten Replicator

Tungsten Replicator 6.1.17

Build: 42
Release Date: 16 May 2022
End of Life Date: 15 Aug 2024
Product End of Life

This release is past End of Life.

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 (2)

  • Changed output of thl purge command when no lower and upper bounds are given from 'Deleting events where' to 'Deleting all events'.
    Issue: CT-1738
  • The tpm diag command now gathers the output of the tpm ask summary command
    Issue: CT-1827

Backup and Restore (1)

  • Additional messaging has been added to the output displayed when running tprovision.
    Issue: CT-1689

Improvements, new features and functionality (4)

Command-line Tools (1)

  • Added the ability to turn auto recovery on or off dynamically, removing the need to run tpm update. This is done by running the following command:
    shell> trepctl -service servicename setdynamic -property replicator.autoRecoveryMaxAttempts -value <number>
    Note
    The service must be offline before changing the property
    Issue: CT-1088

Core Replicator (1)

  • Added a new property to allow configuration of character set used during batch loading into MySQL targets.

    Default is utf8mb4. Override using the following:

    property=replicator.applier.dbms.loadCharset=utf8
    Issue: CT-1647

Security (1)

  • Replaced official log4j library with a secured version in which all vulnerable classes have been removed. This prevents exposing the software following a (user) misconfiguration of the log4j properties
    Issue: CT-1810

Other Issues (1)

  • IPv6 host addresses are now fully supported. Can be enabled with the following configuration property:
    prefer-ip-stack="6"
    By default, IPv4 is enabled, which equates to the value of "4" in the above property.
    Issue: CT-1537

Bug Fixes (16)

Installation and Deployment (2)

  • When services are deployed with systemd and MySQL could not start due to an error, tpm would not be able to later start MySQL
    Issue: CT-1734
  • deployall script now properly displays the executable prefix for restarting services, typically mm_treplicator in Multi-Site/Active-Active replicator-only installs, as well as the full path to component binaries
    Issue: CT-1835

Command-line Tools (6)

  • The tpm command now communicates properly when there is no INI configuration file or staging-methoddeploy.cfg configuration defined.
    Issue: CT-1712
  • When MySQL services were badly installed, some distribution could show a “not-found” status within systemctl, confusing tpm
    Issue: CT-1677
  • tungsten_monitor.rb script no longer uses sudo to send emails if the configuration doesn't allow it.
    Issue: CT-1737
  • tpm now properly reports errors upon timeout executing commands. Typically, when a host is down, when upgrading or installing,tpm will now properly report that pinging this host failed.
    Issue: CT-1819
  • Improves the tpm diag command so that it waits 2 seconds for replicator thread dump to complete.
    Issue: CT-1792
  • The tpm update command no longer aborts during a staging deployment when the actual hostname does not match what is configured for the node names in tpm
    Issue: CT-1791

Backup and Restore (1)

  • Fixed an issue with latest xtrabackup 8.0.28
    Issue: CT-1838

Core Replicator (7)

  • When connecting to a THL server, a client will now connect to the next available host in its THL URI, if the first does not have the sequence number that the client requires. The client will then fail only if none of the hosts from the URI can provide the needed sequence number.
    Issue: CT-1558
  • Fixed an issue when using Parallel apply that would show a NullPointerException in case an event could either not be found or be corrupted in THL. This will now display a correct message Missing or corrupted event from storage
    Issue: CT-1722
  • Added more debug information for detecting possible hanging connections while a THL client connects to the THL server. Also, added socket timeout for the connection initialization
    Issue: CT-1760
  • Fixed an issue where trepctl was leaving JMX connections opened.
    Issue: CT-1752
  • Fixed the EnumToString and pkey filters to renew their database connections (every hour by default). This can be changed with the following properties:
    property=replicator.filter.enumtostring.reconnectTimeout=3600
    property=replicator.filter.pkey.reconnectTimeout=3600
    Issue: CT-1786
  • Fixed an issue with the batch loader where DATETIME and TIME datatypes with milliseconds would be replicated as .000 instead of the real millisecond value.
    Issue: CT-1739
  • Due to a change in binlogging behavior from MySQL 5.7 onwards (Including Aurora) when using the standalone Tungsten Replicator to configure bi-directional replication with unprivileged access (ie unable to control binlogging behavior), certain DDL statements failed to be tagged correctly causing them to be re-applied to the originating source database, resulting in replicator errors.
    Issue: CT-1083