Skip to content

Logical Replication 

Logical replication in CrateDB is a method of data replication across multiple clusters based on the publish-subscribe model. The publisher, a database instance, makes data available through publications, which contain tables available for replication. Subscribers can pull data from the publications of the publisher, and replicated tables on a subscriber can be published further to other clusters, allowing for chaining subscriptions. A cluster can have both publications and subscriptions.

In addition to data, all types of operations, including INSERT, DELETE, UPDATE, and schema changes, are also replicated. With logical replication, you can replicate only a selection of data to specific locations without the need to duplicate all the data.

{ FOR TABLE table_name [, ...] | FOR ALL TABLES
CONNECTION ‘path_to_publisher’
PUBLICATION publication_name [, ...]
[ WITH (parameter_name [= value], [, ...], ...)

Benefits of logical replication

  • Collecting data close to the source (Edge) and replicating only specific data to a central cluster
  • Synchronizing data from multiple sources into one single location
  • Ensuring data recovery in case of cluster failure

Use cases for logical replication

  • Centralized reporting, which replicates data from multiple geographically distant clusters back to a centralized reporting cluster. 
  • Data locality optimization by replication of data from a large cluster to a large number of smaller localized clusters for low latency access. 
  • Disaster recovery.
  • Replication between different compatible versions of CrateDB.

Product documentation

Logical replication

Additional resources

On-demand webinar

How to leverage CrateDB 4.8 to its full potential.

 Timestamp: 17:38 – 24:16

[Version 4.8 is when logical replication got introduced]



Feature Focus: Logical Replication

In this blog post, we introduce a new key feature in CrateDB 4.8: logical replication. Logical replication enables you to achieve high availability, effective failover management, and reduce search latency.

Read more

Want to learn more about logical replication?