A community project sponsored by JumpMind Facebook Twitter Feed

Fast & Flexible Database Replication

SymmetricDS is open source database replication software that focuses on features and cross platform compatibility.

Cross Platform
Replicate data across different platforms, with compatibility for many databases. Sync from any database to any database in a heterogeneous environment.
Read More
Scale Out Performance
Optimized for performance and scalability, replicate thousands of databases asynchronously in near real time, and span replication across multiple tiers.
Read More
Flexible Configuration
Configure which tables and columns to sync, and in which direction. Subset rows and distribute them across databases. Combine, filter, and transform data.
Read More

SymmetricDS 3.10 was released, which includes 30 improvements, 5 new features, and 15 bug fixes! Here are some highlights:

Initial Loads

  • New sym_table_reload_status table tracks progress and statistics of loads by their ID
  • Queuing the load is faster using estimated row counts of tables
  • Extracting data is faster by eliminating SQL functions and formatting data in code
  • When loading multiple nodes, extracts are shared so common tables are only extracted once
  • Oracle/Tibero use two passes on tables with LOBs to optimize extraction under 4k limit
  • Loading is faster by deferring indexes and foreign key creation until the end of the load
  • New bulk loader support for Oracle (SQL*Loader) and Tibero (tbLoader)
  • Auto resolution of foreign key errors due to extracts running at different times on busy system

Change Data Capture

  • Enhanced fallback operations can now deal with chained foreign key and unique key exceptions
  • Faster insert performance on Postgres 9.5 using "on conflict" clause to detect conflicts
  • Oracle/Tibero LOBs optimized automatically for routing and extraction under 4k limit
  • Faster, more aggressive purge settings to keep system overall running better

Databases

  • Snowflake database as a load-only target with bulk loading

See the change log for more details.

Latest Release

SymmetricDS 3.10.2 is now available! Released on 2019-05-08.

There were 519 downloads this week.

Forum Feed

Site Search

What are you looking for?

Blog

  • Outgoing Loads - Get the Details
    Written by Eric Long

    The initial data load is an important first step for data replication, so in the latest version 3.10 of SymmetricDS Pro, we worked hard to improve the Outgoing Loads screen to make it easy to follow progress and see how long the load will take. Here are some highlights that benefit long-running loads.

Find us on Facebook

Code Commits