SymmetricDS can be used to replicate Firebird databases to the cloud for Disaster Recovery. Setup is fairly straightforward. Select the tables you want to sync and the direction you want to sync them and, voilà, you have a backup database. While this is all well and good, if the database relies on id generators for primary key generation, then when failing over to the slave database you will probably end up with generators that no longer reflect the next value to insert.

Read more Keeping Firebird Generators Up to Date in your DR Database

All SymmetricDS synchronization configurations require database connectivity. As a result questions often arise around the topic of database permissions. Specifically what permissions are required for the SymmetricDS user and do the SymmetricDS tables need to run in the same catalog or schema as the tables to be synchronized.

Read more Permissions

Anyone who has been on a night time support rotation can relate to the 3 AM phone call that gets you groggily out of bed, has you fixing some simple, but important problem, and then leaves you staring at the ceiling by 4 AM wondering if you should just go into work, because you know you aren't getting back to sleep. All of the engineers in our office have been there, done that, and didn't like it very much. That's one of the reasons we focus so much on resilient operations for SymmetricDS including our "Hands Off" Recovery of data synchronization. "Hands Off" recovery is pretty much exactly what it sounds like. SymmetricDS has been built from the ground up to recover and keep databases in sync without manual intervention any time it possibly can.

Read more "Hands Off" Recovery

At JumpMind we provide support services for a wide variety of customers across many industries. We enjoy working with our customers, learning about their synchronization scenarios, and answering any questions they may have. In all of our interactions, we've found that some customers have a real knack for making it easy to help them, while it's not as intuitive to others. In that spirit, here's JumpMind's top 3 ways to help us help you.

Read more Top 3 Ways to be the Best Support Customer

We were talking about Pi Day here at the JumpMind office which led us to reflect a bit on our roots. From the beginning, the SymmetricDS default port number has been 31415. Reflecting on that, we realized that most people might not know the history of JumpMind and SymmetricDS.

Read more JumpMind : The Pi in the Sky

When integrating data from one database to another, sometimes the schemas are not the same. JumpMind has come across a number of projects where there was a need to transform a very denormalized database into more of a canonical or normal form.

Read more Data Normalization using Transformations

 

Evaluating a new software product can be quite a challenge with so many products on the market and limited time and resources during the evaluation process. Through this blog I hope to present to you a quick overview of the fundamental building blocks of SymmetricDS in order to get your evaluation off on the right track.

Read more Crash Course on Concepts