citusdata / citusdata/citus

Add replication slot propagation

Open
#6,905 2 comments 0 reactions 0 assignees View on GitHub
cdc
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

When using logical decoding and adding a new node, you currently have to create a slot on the new node before rebalancing to make sure you do not miss any changes. This will prevent scenarios like automatic rebalancing.

It would be useful if replication slots can be propagated to new and existing nodes.

In this case, we cannot use pg_dist_object for bookkeeping, since replication slots do not have an OID. We might need a new metadata table that is synchronized across nodes.

Alternatively, we could automatically propagate all logical slots from the coordinator that do not belong to Citus when adding a node.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.