Josh Hicks

Josh has worked in the IT industry for over 15 years as a developer, tech lead, and architect. He has worked across a variety of businesses including retail, telecommunications, eduction, and healthcare. When he is not developing he enjoys whatever sporting event might be taking place.

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. 

Read more Filtering Dates in MySQL

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.

Read more Three Tier Replication Done in Two Tiers

There are a few ways you could receive constraint errors during replication. Below are some of the most common cases and solutions to avoid them.

Read more Why am I getting foreign key errors during replication?

SymmetricDS has been designed around the user upon numerous feature requests from our clients and the open source community. As a result there are a lot of different factors that play a role in how to use it within your project. At a higher level though here are some of the best practices we find should be considered for nearly all implementations.

Read more Best Practices using SymmetricDS

Data replication not only involves replicating changes moving forward but also the ability to load existing data between systems prior to replication being put in place.  Data loading was enhanced in SymmetricDS 3.8 to bring together all the features around this process into a new data load wizard.

Read more Data Load Wizard in SymmetricDS 3.8

JumpMind is excited to announce the release of 3.8. This release was primarily focused on performance based changes. Through the process of profiling the code base and addressing a lot of the pain points in the community, we were able to address some key performance improvements.

Read more SymmetricDS 3.8 Released!

In addition to replicating data changes from source to target you may also wish to populate a table on the target to monitor all events.  In this blog I will show you how to create a simple load filter that will record all changes captured by SymmetricDS into a simple audit table.  

Read more Capture all change events into an event table