citusdata / citusdata/citus

Introduce citus_pause_node

Open
#6,557 6 comments 0 reactions 1 assignee Claimed by @gurkanindibay View on GitHub
high availability warm-up
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

Add a UDF that takes the same locks as citus_update_node, but doesn't do anything else. This is useful for a coordinated restart of a worker node. If a connection calls citus_pause_node any queries to that node would be held until the connection is released. This reduces the number of errors during a restart, by changing them from errors to higher latency.

1. BEGIN;
2. citus_pause_node(A)
3. restart node A
4. COMMIT/ROLLBACK

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.