2.29. Tungsten Replicator 6.0.3 GA (5 September 2018)

Version End of Life. 31 July 2020

Release 6.0.3 is a bugfix release.

Improvements, new features and functionality

  • Oracle Applier

    • Oracle connection strings can now be configured using the Oracle TNS name, rather than purely the Oracle service or SID names. To use this option, specify the TNS name using the --datasource-oracle-service option to tpm. This will configure the connection using the service name or TNS name if this can be determined. If the TNS name cannot be resolved automatically, use the --oracle-redo-tnsadmin-home to specify the directory where the Oracle tnsnames.ora file is located.

      To use the JDBC listener rather than the TNS service, use the --datasource-oracle-sid option.

      Issues: CT-380

    • Oracle support has been improved, adding support for Oracle TNS naming and support for extracting Oracle RAC using the Oracle Redo Reader functionality.

      Support has been added for extracting data from Oracle RAC hosts. To enable extraction from Oracle RAC requires use of the new Oracle service name (TNS) specification, and a different option to tpm to enable different Redo Reader configuration.

      To enable extraction from an Oracle RAC instance, use the --oracle-redo-rac-enabled=true option to tpm. In addition, you should specify the connection information to Oracle using the --datasource-oracle-service option to specify the TNS name, and optionally specify the location of the tnsnames.ora file using the --oracle-redo-tnsadmin-home option to tpm.

      If your RAC environment uses a different edition ASM than used by the core Oracle deployment, the --oracle-redo-asm-home option can be used to specify the home directory for the ASM version in use.

      Currently, this includes an action script for use with Oracle RAC hosts to be used when switching RAC hosts during operation in the event of a failure. The action script can be found in support/oracle-rac-scripts/action_script.scr.

      Issues: CT-660, CT-666

  • Core Replicator

    • The output from thl list now includes the name of the file for the correspnding THL event. For example:

      SEQ# = 0 / FRAG# = 0 (last frag)
      - FILE = thl.data.0000000001
      - TIME = 2018-08-29 12:40:57.0
      - EPOCH# = 0
      - EVENTID = mysql-bin.000050:0000000000000508;-1
      - SOURCEID = demo-c11
      - METADATA = [mysql_server_id=5;dbms_type=mysql;tz_aware=true;is_metadata=true;service=alpha;shard=tungsten_alpha;heartbeat=MASTER_ONLINE]
      - TYPE = com.continuent.tungsten.replicator.event.ReplDBMSEvent
      - OPTIONS = [foreign_key_checks = 1, unique_checks = 1, time_zone = '+00:00', ##charset = US-ASCII]

      Issues: CT-550

    • The replicator has been updated to support the new character sets supported by MySQL 5.7 and MySQL 8.0, including the UTF-8-mb4 series.

      Issues: CT-700, CT-970

Bug Fixes

  • Installation and Deployment

    • During installation, tpm attempts to find the system commands such as service and systemctl used to start and stop databases. If these were not in the PATH, tpm would fail to find a start/stop for the configured database. In addition to looking for these tools in the PATH tpm also explicitly looks in the /sbin, /bin, /usr/bin and /usr/sbin directories.

      Issues: CT-722

  • Command-line Tools

    • Using tpm diag, the command would ignore options on the command-line, including --net-ssh-option.

      Issues: CT-610

    • When running tpm diag, the operation would fail if the /etc/mysql directory does not exist.

      Issues: CT-724

    • Due to the operating taking a long time or timing out, the capture of the output from lsof has been removed from running tpm diag.

      Issues: CT-731

  • Oracle Applier

    • When performing an Oracle installation for applying data, tpm would report an issue with permissions not required for app;ying data into Oracle.

      Issues: CT-664

    • The prepare-offboard-fetcher.pl script has been updated to address an issue with one of the checks made during execution.

      Issues: CT-665

  • Core Replicator

    • The LOAD DATA INFILE would fail to be executed and replicated properly.

      Issues: CT-10, CT-652

    • The trepsvc.log displayed information without highlighting the individual services reporting the entries making it difficult to identify individual log entries.

      Issues: CT-659

    • When replicating data that included timestamps, the replicator would update the timestamp value to the time within the commit from the incoming THL. When using statement based replication times would be correctly replicated, but if using a mixture of statement and row based replication, the timestamp value would not be set back to the default time when switching between statement and row based events. This would not cause problems in the applied host, except when log_slave_updates was enabled. In this case, all row-based events after a statement based event would have the same timestamp value applied.

      Issues: CT-686