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.11.0 is now available! Released on 2019-11-15.

There were 464 downloads this week.

Forum Feed

Site Search

What are you looking for?

Blog

  • Common Batches Just Got Better
    Written by Eric Long

    Common batch mode was enhanced in SymmetricDS 3.11 to allow any group of nodes to share batches. Let's look at what common batches are and why this is a big deal for database replication with more than a couple nodes.

Find us on Facebook

Code Commits