Distributed Database Synchronization



To make smart decisions, seize opportunities and run their business effectively, companies need accurate and timely information made available across their enterprise. Inaccessible and inconsistent data leads to bad decisions, dissatisfied customers and operational errors. Unfortunately, with data being generated and stored by countless devices and databases around the world, it’s not easy to keep everything up to date. Most data replication and synchronization technologies are designed for periodic bulk transfers, don’t make efficient use of expensive WAN links, and don’t scale well because of the need to process routing rules in software.

Solution Summary

Pairing Solace’s messaging appliance with change data capture (CDC) software enables the real-time synchronization of data across any number of geographically dispersed databases. The CDC software identifies data changes and passes them to Solace appliances which forward them to other systems that need that data. Solace’s solution can route up to 200,000 guaranteed messages per second to any number of recipients, queuing them until delivery is confirmed so WAN throughput is not restricted by the need to receive acknowledgements upon successful receipt of each update.

Advantages and Benefits

  • Efficient WAN utilization: Solace’s solution makes efficient use of WAN bandwidth by sending just one copy of each message across the WAN and fanning them out at the edge of the network, and by only sending updates across the WAN when at least one system on the other side is subscribed to receive it.
  • Reduced operational complexity: Solace’s solution can perform local and remote synchronization across many different vendors’ databases, eliminating the complication and cost of employing different synchronization strategies for each kind of system.
  • Reduced load on database servers: One of the major challenges with continuous data replication is the workload it adds to production database servers. Solace’s solution offloads the work of directing traffic and transforming messages, freeing up applications and database to focus on their primary function.