Tungsten Replicator

Tungsten Replicator 6.1.14

Build: 35

Release Date: 17 Aug 2021

End of Life Date: 15 Aug 2024

Product End of Life

This release is past End of Life.

Release 6.1.14 contains a number of bug fixes and improvements in the Connectors, and improved handling of systemd integration, additionally XA transaction support is now available.

Improvements, new features and functionality (8)

Command-line Tools (4)

Improved the tpm command's internal logic and introduced a new sub-command, tpm ask.
Issue: CT-1573
New ddlscan template (ddl-mysql-staging.vm) available to generate ddl required for staging tables when deploying the batch applier on a MySQL target.
Issue: CT-1587
3 new tpm flags have been added:
These flags can be used to provide a custom systemd configuration that will be used in place of the default, generated one. This is typically useful when ExecStartPre or ExecStartPost commands are needed
Issue: CT-1555
Added tpm support for tuning maxDelayInterval, used to tune parallel apply. Usage example:
```
property=replicator.store.parallel-queue.maxDelayInterval=120
```
This sets the max delay interval to 2 minutes
Issue: CT-1541

Backup and Restore (1)

A new tpm option has been added --backup-options
This property can be used to pass options directly to the backup binary (Xtrabackup, mariabackup etc). This can be especially useful when the xtrabackup and MySQL versions differ. Generally, MySQL is always ahead of xtrabackup and in some situations xtrabackup will fail if the underlying MySQL patch release does not match the xtrabackup patch release. In this scenario, you could utilise the new option to force xtrabackup to not check the versions, for example:
```
backup-options=--no-server-version-check
```
Multiple options can be passed as a space-separated list, for example.
```
backup-options=--option1 --option2 --option3
```
Note
Options passed are specific to the underlying binary and are not validated by Tungsten, therefore you must ensure you only use options that are valid, and check syntax accurately.
Issue: CT-1595

Core Replicator (3)

Support for XA transactions has been added.
Issue: CT-925
When using the MySQL Batch Applier, you can now choose to log rows into an error table that would otherwise have either generated a duplicate key error.
This is disabled by default, but can be enabled and configured by using the following two new properties:
```
property=replicator.applier.dbms.errorTablePrefix=error_xxx_ 
property=replicator.applier.dbms.batchLogDuplicateRows=true
```
In addition, if your tables contain Foreign Keys, you can choose to disable them during the data loading process using the following property:
```
property=replicator.applier.dbms.disableForeignKeys=true
```
Issue: CT-1589
When using the MySQL Batch Applier, you can now choose to drop all deletes by specifying the following tpm property:
```
property=replicator.applier.dbms.skipDeletes=true
```
This is disabled (false) by default.
Issue: CT-1588

Bug Fixes (1)

Command-line Tools (1)

The tpm update command now properly parses the --ini argument.
Issue: CT-1551