solidDB® advanced replication is a capability to replicate the data across disparate computer nodes in a network to meet the needs of your applications. With advanced replication, the data can be as close to the application as implied by the latency, performance, or availability requirements. The core of advanced replication is asynchronous replication based on the publish/subscribe model. In the solidDB® context, the replication type used in advanced replication is called synchronization.
This guide introduces you to synchronization concepts and architecture and describes how to set up, use, and administer a solidDB® using advanced replication.
This guide assumes the reader has general database management system (DBMS) knowledge and a familiarity with SQL. It also assumes that you are already knowledgeable about solidDB®. You may want to read Getting Started Guide and Administrator Guide before reading this manual.
Tip: solidDB® offers also another replication solution using IBM InfoSphere CDC replication technology, which is documented in the CDC Replication User Guide.
Overview of replication in solidDB®
With solidDB®, data replication can be implemented with three different technologies: advanced replication, IBM InfoSphere CDC replication, and solidDB® High Availability (HotStandby).
Advanced replication
Advanced replication uses built-in SQL extensions and is targeted for occasional or event-based asynchronous replication in N+M topologies.
IBM InfoSphere CDC replication
IBM InfoSphere CDC replication uses transaction log reading and is targeted for occasional or continuous replication flow. It supports heterogeneous environments.
HotStandby replication
HotStandby replication is targeted for High Availability systems that need very fast failover and recovery functionality, using 1+1 topology.