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.

Add a comment

For a large database, the conventional initial load that extracts each table, one by one, can run for days. Not everyone can wait for that, so here are some tips to improve initial load performance on SymmetricDS.

Add a comment

Since the beginning of the SymmetricDS project, change data capture has been supported on Oracle and Oracle RAC. That's because Oracle is a popular database management system, ranking #1 on the DB-Engines Ranking for years. Recently, I helped deploy SymmetricDS in a unique application environment based on Oracle RAC, where it was challenged to keep up with bulk, concurrent changes. By adjusting some new parameters specifically designed for RAC, we were able to meet performance requirements.

Add a comment

Supporting date time and timestamp values in MySQL can be challenging while replicating from a another database that uses different rules.   In this article we walk through some issues with syncing date time values into MySQL and how to filter them out so that your replication stay on track. 

Add a comment

One of the most common replication patterns we see here at JumpMind is a three tier setup with a central, regional, and site group.  Retailers commonly use this approach with groups named: corp, store, and register.   However we often see setups that try to reduce this approach down to two tiers with a similar set of functionality.  Deciding between a two or three tier approach can be tricky and each may have advantages and disadvantages based on your needs.  This article will help to explain these differences and hopefully help in making the best design choice for your needs.

Add a comment

Maybe it is because your current database platform does not support the functionality you need for a big data project, or maybe you require features that are in a more recent database version. Whatever the reason, migrating a database is often a very valuable and necessary task that allows your business to both keep up with changing technology as well as lower the overall costs of running old systems.

Add a comment