Two new utility scripts have been added to the release to help with setting the Replicator position:

- tungsten_find_position, which assists with locating information in the THL based on the provided MySQL binary log event position and outputs a dsctl set command as output.

- tungsten_find_seqno, which assists with locating information in the THL based on the provided sequence number and outputs a dsctl set command as output.

Issues: CT-934

A new, beta-quality command has been included called prov-sl.sh which is intended to eventually replace the current tungsten_provision_slave script.

Currently, prov-sl.sh supports provisioning Replicas using mysqldump and xtrabackup tools, and is MySQL 8-compatible. 

The prov-sl.sh command is written in Bash, has less dependencies compared to the current version and is meant to fix a number of issues with the current version.

Backups are streamed from source to target so that an intermediate write to disk is not performed, resulting in faster provisioning times.

Logs are written to $CONTINUENT_ROOT/service_logs/prov-sl.log (i.e. /opt/continuent/service_logs/prov-sl.log).

For example, provision a Replica from [source db] using mysqldump (default):

shell> prov-sl.sh -s {source db}

As another example, use xtrabackup for the backup method, with 10 parallel threads (default is 4), and ssh is listening on port 2222:

shell> prov-sl.sh -s {source db} -n xtrabackup -t 10 -p 2222

Issues: CT-614, CT-723, CT-809, CT-855, CT-963

Upgraded the Drizzle driver to support MySQL 8 authentication protocols (SHA256, caching_sha2).

Issues: CT-914, CT-931, CT-966

The Redshift Applier now allows AWS authentication using IAM Roles. Previously authentication was possible via Access and Secret Key pairs only.

Issues: CT-980

For more information, see Section 4.2.2.1, “Redshift Preparation for Amazon Redshift Deployments”.

When executing mysqldump, all Tungsten tools no longer use the --add-drop-database flag as it will prevent MySQL 8+ from restoring the dump.

Issues: CT-935

Fixed a bug where tpm diag would generate an empty zip file if the hostnames contain hyphens (-) or periods (.)

Issues: CT-1032

Added support for missing charset GB18030 to correct WARN extractor.mysql.MysqlBinlog Unknown charset errors.

Issues: CT-915, CT-932

Loading data into Redshift would fail with the following error if a row of data contained a specific control character (0x00 (NULL))

Missing newline: Unexpected character 0x30 found at location nnn

Issues: CT-984

Now properly extracting the Geometry datatype.

Issues: CT-997

The ddl_map.json file used by the apply_schema_changes filter was missing a rule to handle ALTER TABLE statements when replicating between MySQL and Redshift

Issues: CT-1002

The extract_schema_change filter wasn't escaping " (double-quotes) and the generated JSON would then cause the applier to error with

pendingExceptionMessage: SyntaxError: missing } after property list »
(../../tungsten-replicator//support/filters-javascript/apply_schema_changes.js#236(eval)#1)

Issues: CT-1011