Gluesync - SQL to NoSQL release notes and changelog

1.5

1.5.38

2024-05-07

  • Added support for AWSS3-like storages;

  • Added separate storage for Oracle Xstream for compatibility with DataGuard Logical standby;

  • GSSD-93: This release changes the Java heap memory behavior with a new max RAM limit set to 75%. For more information please refer to this useful link.

  • Fixed MySQL source connector case sensitivity;

  • Fixed MS SQL Server’s first migration error;

1.5.37

2024-04-16

  • Fixed Oracle null pointer in configuration

  • Fixed Sybase setup Statements

  • Fixed CheckMigrationCheckpointTableSetup table recreation condition

  • Fixed all databases migration checkpoint update query

  • Added logs to MS SQL Server source connector check state preservation component setup

1.5.36

2024-04-15

  • Updated Gluesync shared libraries to v0.10.1

  • Added validation query to Sybase source connector;

1.5.35

2024-03-15

  • Oracle Xstream source connector now provides the same support to datatypes as per Oracle-triggers source connectors, including support for CLOBs data types;

  • Improvements on Aerospike target connector that now includes support for TLS encryption using Netty event loops;

  • Added support for MongoDB source connector with none user authentication.

1.5.34

2024-03-11

  • Improved Couchbase target connector retry strategy;

  • Added Query entity support for Oracle Triggers source;

  • Improved Oracle source DATE types support.

1.5.33

2024-02-21

  • Improved AS400 source connector;

  • Other minor improvements.

1.5.32

2024-02-13

  • Fixed an issue affecting the first migration of entities with data modeling enabled;

1.5.31

2024-02-06

  • GSSD-80: Fixed an unhandled exception on MS SQL CDC source connector when Gluesync reads a single huge transaction with a row count greater than the given page size;

  • Improved AS400 journals support on IBM i series source connector.

1.5.30

2024-01-18

  • GSSD-86: Oracle Triggers source connector has been updated to fix an issue that in certain circumstances could have led to the creation of duplicated entries under the STATE PRESERVATION TABLE.

1.5.29

2024-01-15

  • MS SQL Server Change Data Capture connector: has been updated to fix sync delete operation for data modeling entities;

  • Oracle Triggers source connector: has been updated to fix sync delete operation for data modeling entities.

1.5.28

2024-01-12

  • MS SQL Server Change Tracking has more detailed logs for state preservation table creation;

  • IBM i (AS/400) has a new streamed transaction handling to improve performances;

  • Gluesync now outputs a log config file every 5 minutes for helping to track down config file changes over time;

  • GSSD-86: Oracle Triggers fix for last read transaction ID update.

1.5.27

2024-01-05

  • Added timer-based buffer SMTP appender for Logback;

  • Fixed logging of custom exceptions.

1.5.26

2024-01-04

  • For Oracle triggers-based source connector:

    • Added 4 parameters to Oracle Triggers configuration to customize JDBC timeouts;

    • Fixed a bug on Oracle Triggers that prevented some transactions from syncing if the affected table no longer receives changes;

  • Updated Logback framework dependency;

  • 🔥 NEW PostgreSQL native CDC source connector is now available and part of that release: it implements logical replication making use of PgSQL’s replication slot API through standard JDBC driver. Read more about this new source connector by following this link.

1.5.25

2023-12-18

  • For Oracle triggers-based source connector:

    • Improved query performance on the Action Log Table by adding a specific index;

    • Fixed upper/lower case issue for keys on data modeling mapper;

    • Added support for Query and DataModeling entities.

1.5.24

2023-12-07

  • For Oracle triggers-based source connector:

    • Improved consumed transaction query for Action Log Table;

    • Added mechanism to prevent duplicated row emissions;

    • Added not consumed rows retrieved.

1.5.23

2023-12-04

  • Fixed Oracle Triggers document keys generation;

1.5.22

2023-12-01

  • For Oracle triggers-based source connector the error handling in purge mechanism has been improved.

1.5.21

2023-12-28

  • For Oracle triggers-based source connector:

    • Added new streamed transactions handling to improve performance;

    • Added enableActionLogReadCheck parameter to the configuration to enable consumed transactions checks within the action logs table;

    • Set transactionIsolation to Connection.TRANSACTION_SERIALIZABLE when sourcing changes from the action logs table.

1.5.20

2023-11-29

  • For Aerospike target connector: fixed IllegalArgumentException that occasionally was throwing fields names too long error instead of its specific exception;

  • GSSD-71: Improved MS SQL Server CDC source connector transaction handling algorithm to better handle single-row transactions.

1.5.19

2023-11-27

  • GSSD-66: Fixed issue that caused license validation to fail if there was an empty line at the end of the file;

  • GSSD-67: Improved reading of new transactions on Oracle Triggers-based source connector, now it makes use of READ COMMITTED transaction isolation for all connections.

1.5.18

2023-11-24

  • Added JVM memory stats;

  • Fixed issue on Query entities for Oracle Xstream;

  • Improve error logging for MS SQL Server CDC source connector as well as Aerospike target connector.

1.5.17

2023-11-23

This release updates the following dependencies:

  • Updated Kotlin version;

  • Updated Gradle version;

  • Updated JDBC drivers;

  • Updated minor third-party library dependencies.

1.5.16

2023-11-20

  • For MS SQL Server CDC connector has been added support for recursion protection. Disabled by default to ensure maximum performance. Can be activated via configuration file if necessary;

  • Fixed an issue with Logback appenders after the upgrade causing logs to freeze;

  • Fixed an issue with the buffer pressure calculation (part of the monitoring feature) which in some cases could have led to experiencing values outside boundaries failing to reset;

  • In case of a retryable error the entity name has been added to the error log;

  • We carried out a major refactor on the SQL parser engine to make it more rugged when it comes to parsing syntax differences between databases especially in scenarios where characters like " " & ` ' ' ` are used to define schema names & table names;

  • Added support for using single quotes, double quotes or backticks on queries for some databases. Added bracket support for SQL Server (supported on Gluesync SQL to NoSQL only ATM).

  • Added connection check to connection pool to validate the returned connection

1.5.15

2023-11-02

  • MS SQL Server CDC connector enhancements:

    • A built-in set of SQL queries to fetch for CDC events has been put into place, rather than using Microsoft’s provided functions;

    • Gluesync at first initialization (meaning empty STATE_PRESERVATION entry) recovers from the last known LNS provided by SQL Agent.

1.5.14

2023-10-31

  • Fixed an issue when composing document IDs in case of user-defined primary keys (through entitiesKeyMapping feature) and empty prefix could result in having an unwanted _ (underscore) value as the first character;

  • Improved MS SQL Server CDC connector stability and performance.

1.5.13

2023-10-30

  • 🔥 NEW Native support for ARM64 CPUs;

    • Java SDK has been updated to Azul Zulu OpenJDK 11.0.21.

  • Fixed an issue where MSSQL CDC might have not consumed deletion events properly;

  • Fixed a bug on AS400 where applied column aliases weren’t ported to target when a deletion operation was performed;

1.5.12

2023-10-24

  • Fixed an issue that could prevent labels belonging to Prometheus metrics from being parsed properly;

1.5.11

2023-10-19

  • 🔥 NEW Microsoft SQL Server transaction-logs based source connector (previously only available as Change Tracking) that extends support for MS SQL Server versions starting from 2008;

    • This new source connector also comes with support for tables without primary keys;

  • Improvements on multi-threading support on Oracle Xstream source connector;

  • Oracle triggers-based source connector now creates a local index instead of a global index when usePartition is set to true inside GLUESYNC_ACTION_LOG table;

  • Improvements in license verification;

1.5.10

2023-10-09

  • Updated Aerospike Java SDK, now running on version 7.10;

  • Fixed a bug affecting Oracle Xstream source connector when OCI-39257: Message 39257 not found raises, now it is being properly handled without halting the replication process;

  • Fixed a bug affecting Oracle Xstream source connector when an incoming LCR presents a LOB TRIM action that in certain circumstances could lead the replication engine to silently stop for encountered error;

  • Full table migration now supports a new way for fetching pages of data from the source database, giving a 10x in terms of performance improvements compared to the legacy version. The legacy version will still be supported and available using the flag usePaginatedMigration set to true, the new version is now the default standard;

  • Added support for LOB fields under Oracle Xstream source connector.

1.5.6

2023-09-22

  • GSSD-34: Multiple IP Address Configuration on Aerospike target connector

1.5.0

Our new milestone release, to a full set of changes introduced with that major release please check the What’s new in Gluesync 1.5 section.

  • GSSD-8 added support for HEX values in the MS SQL Server source connector

1.4

1.4.25

2023-06-26

  • Fixed an issue with dependency injection affecting Sybase images;

  • 🔥 Added support for CDC over IBM AS/400 - i series databases.

1.4.24

2023-06-19

  • GSSD-10: Fixed level 2 joins not being reflecting updates;

  • GSSD-7: Level 2 Date/DateTime datatypes objects being written as a data structure rather than an ISO-8601 format;

  • Other minor fixes and general improvements.

  • Comes also with an improvement around binary values handling (partial GSSD-8 since it lacks a solution for HEX values)

1.4.24

2023-06-05

  • Minor improvements

1.4.14

2023-03-21

  • Fixes on _tablenames

1.4.13

2023-03-20

  • Fixes on MSSQL server temp table creation on duplicate entities involved

1.4.12

2023-03-14

  • GSSD-5: fix on partitions not getting dropped;

  • GSSD-3: triggers not working on Oracle when a MERGE statement is involved;

1.4.11

2023-03-08

  • Password base64 obfuscation

1.4.10

2023-02-28

  • GLUESYNC_ACTION_LOG table partitioning under Oracle trigger-based source connector for Oracle databases >11.X

1.4.9

2023-01-11

  • New license management via JWT token

Past changelogs are currently being imported and will be moved here soon.