SymmetricDS provides file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment. It supports multiple subscribers with one-direction or bi-directional, asynchronous data replication. It uses Web and database technologies to replicate data as a scheduled or near-realtime operation. The software has been designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage. It works with most operating systems, file systems, and databases, including Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2, H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite (including Android), Sybase ASE, and Sybase ASA (SQL Anywhere) databases.
This release includes eight new features, eight improvements, and eight bugfixes. New features include piloting configuration changes to a subset of nodes, easy reloading of tables, and improved recording of conflicts. Improvements include better logging to aid debugging, defaulting to an error for missing tables, and more documentation. Bugs include fixing the disabling of stream to file and recording a batch error message even if it occurs before or after batch processing.
This release fixes handling of large objects when tables need to be quoted and when targeting different catalogs. Improvements include upgrading the PostgreSQL driver, options for tuning the routing query, and an option for throttling the dbimport.