"Hands Off" Recovery features in SymmetricDS have been refined over the years as we have built and helped maintain large data synchronization scenarios for our customers. When synchronizing two or three databases, manual intervention doesn't matter as much, but when synchronizing ten to fifty thousand databases it really becomes a "must have."

With large node network data sync scenarios, there are always a handful of databases that are offline or unreachable for one reason or another. A backhoe cuts through a network line, a hurricane causes long term power failures, a database becomes corrupt or needs regularly scheduled maintenance. Regardless of the reason, these outages need to be handled with the minimum amount of intervention, zero if possible. So when a database in your node network goes offline, SymmetricDS detects it, lets you know that it is having problems reaching that database, and then patiently keeps trying until the underlying cause rectifies itself. That might mean a network technician restoring network connectivity, a lineman bringing power back online or a database administrator fixing things up on the database end. Regardless, once the underlying problem is solved, SymmetricDS simply picks up where it left off and gets data back in sync. No manual intervention needed. So, you can sit back and watch it happen, or better yet, sleep through it!

Greg Wilmer
Author: Greg Wilmer

Greg has over 25 years experience in Information Technology spanning roles from developer to architect to VP and CIO.  He has designed and implemented products and systems for small shops, to Fortune 500 companies across many vertical markets including Retail, Health Care, Oil and Gas, Aerospace and many more.  His software experience spans signal processor work for AWACS planes to large scale integration projects for global enterprises.  He holds a Bachelors Degree in Computer Science from the Ohio State University and a Masters Degree in Engineering from MIT focusing on product design and development.