Tungsten Clustering 7.0.3

Build: 141

Release Date: 4 Apr 2023

End of Life Date: 28 Jun 2026

Release 7.0.3 contains a number of key bug fixes and improvements.

Behavior Changes (10)

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:

Installation and Deployment (1)

• Added LimitNOFILE=infinity in systemd scripts to workaround an issue with open files limit for clusters installed with systemd
  Issue: CT-2023

Command-line Tools (8)

• The tpm report command with with --extra now shows the associated Connector listener ports and mode per port for when the connector mode is "listeners".
  Issue: CT-2087
• The tpm command now prints a warning when running as the root OS user during operations that make changes.
  Issue: CT-2064
• The tungsten_find_seqno command is now a wrapper for tpm find-seqno.
  Issue: CT-2059
• Enabling a custom backup script does not require it to be made the default option anymore, i.e. Settingbackup-method to the custom backup script is not required anymore.
  Issue: CT-2039
• The tungsten_skip_all command (along with alias tungsten_skip_seqno) now shows the full pendingExceptionMessage instead of just pendingError, and the More choice shows the pendingErrorEventId and the pendingError.
  Issue: CT-2030
• The tps.pl backup tool now shows the available command-line arguments when the TAB key is pressed.
  Issue: CT-1246
• The tpm ssh-copy-cert command has been deprecated and removed in this release.
  Issue: CT-828
• Deprecated tungsten_get_position and tungsten_set_position scripts have been removed.
  Issue: CT-638

Manager (1)

• Increased the default manager liveness heartbeat interval from 1s to 3s.
  Issue: CT-2095

Improvements, new features and functionality (11)

Command-line Tools (7)

• The tungsten_get_ports command now uses values based on values obtained from tpm query values when possible for the greatest output accuracy.
  Issue: CT-2008
• The tungsten_get_ports command now supports the/opt/continuent/tungsten/tungsten-connector/conf/interfaces.json file, if found.
  Issue: CT-2003
• Shell command tab completion for Tungsten-specific commands has been updated to support recent additions and changes.
  Issue: CT-2057
• When in Connector Proxy mode, the tpm report command now displays the Direct and SmartScale status via Channel 2: Connector to Database
  Issue: CT-2037
• The tpm ask summary command has two new keys, isSmartScale andisDirect, which are also available individually on the command line.
  Issue: CT-2035
• A new command, tpm copy-keys, has been added to assist with the distribution of security-related files after an INI-based installation. This tool requires ssh access between the cluster nodes for the copy to work.
  Issue: CT-1910
• A new thl tail command has been added, allowing you to view the live THL changes as they are generated.
  Issue: CT-405

Core Replicator (1)

• THL transfer protocol can now be changed dynamically. This can be done using the trepctl command tool

  shell> trepctl setdynamic -property replicator.thl.protocol.client.serialization -value DEFLATE 
  Property replicator.thl.protocol.client.serialization successfully set to DEFLATE

  This can also be done through the API

  curl --user tungsten:secret --insecure --request POST 'https://127.0.0.1:8097/api/v2/replicator/service/alpha/thl/inflight-protocol' -d 
  '{
      "payloadType":"StringPayload",
      "payloadVersion":"1",
      "payload":
          {
            "value":"legacy"
          }
  }'  
  
  { 
    "payloadType": "StringPayload", 
    "payloadVersion": "1", 
    "payload": 
        { 
          "value": "THL inflight protocol is now set to legacy" 
        } 
  }

  Issue: CT-1862

Connector (3)

• A new advanced listeners feature has been added to the connector for even greater control of client connectivity.

  For more details, see "Advanced Listeners"

  Issue: CT-2000

• Added user-based authentication to existing host-based authentication to restrict connections per host and per user.

  For more details, see "Host-based Authentication"

  Issue: CT-1978
• Improved smart scale handling of session and global changes so they're all played against connected replica or in case of reconnection. As an example, SET SESSION TRANSACTION READ ONLY will be sent to both primary and replica connections so that a subsequent SELECT @@SESSION.transaction_isolation will return the expected value, even if executed on a replica.
  Issue: CT-1600

Bug Fixes (16)

Command-line Tools (11)

• Fixed a tpm issue trying to restore an empty policy.
  Issue: CT-2074
• Suppressed wrong tpm errors with autodetect hosts.
  Issue: CT-2072
• The tpm diag command will now locate and kill any remaining tpm diag child processes on the calling host.
  Issue: CT-2068
• Fixes an issue when tprovision would delete the MySQL PEM files in the datadir.
  Issue: CT-2067
• tpm now builds affinity the same way in bridge and proxy modes.
  Issue: CT-2060
• The tungsten_find_events command no longer fails with error Undefined subroutine &main::info
  Issue: CT-2058
• The tpm validate-update command now performs the delete-service checks properly.
  Issue: CT-2054
• The tpm update command no longer aborts with a Dataservice was NOT removederror when service names with a hyphen are defined in the configuration. We strongly discourage the use of hyphens (-) in service names and recommend underscores (_) instead.
  Issue: CT-2052
• The tpm ask keys command now lists all available keys properly.
  Issue: CT-2041
• The tungsten_get_status command now handles shunned nodes properly.
  Issue: CT-2026
• Fixed rsync availability check in TPM to error out early when the executable is not found in the path
  Issue: CT-1028

Core Replicator (3)

• Fixed an issue where status would fail if issued while a service was reconfiguring (in the middle of a setrole command for example).
  Issue: CT-2081
• Fixed an issue where an extracted JSON field could be invalid, with doubled commas in JSON arrays.
  Issue: CT-2049
• Fixed an issue that was occurring when an ALTER USER is applied on a mysql instance that uses lower case identifiers.
  Issue: CT-2024

Connector (2)

• Fixed an issue in Dynamic Active-Active environments where smartScale would always read from the site with write affinity, even if a different site is specified for read-affinity.
  Issue: CT-2040
• Fixed an issue with CLIENT_QUERY_ATTRIBUTES and/or CLIENT_DEPRECATE_EOF flags that would prevent fallback bridge mode to handle proxy connections properly.
  Issue: CT-2020