citusdata / citusdata/citus

Cluster restore scenarios

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

Description

Hi.
I did not find information in the documentation about scenarios for restoring a cluster from a backup.

I consider 2 main scenarios for the case of restoring from a backup.

1. A logical data corruption that would require a full restore of all nodes to point in time (PITR) from a physical copy (for example pgbackrest)
Steps:
- stop coordinator, workers.
- restore data on all nodes at one point in time.
Are there any changes to the metadata on the coordinator?

2. Loss of one of the workers.
Steps:
- stop the cluster
- create a new worker
- restore data from a physical backup to the last available point in time from a backup of a lost worker.
Are there any changes to the metadata on the coordinator?

Are my steps correct?

Is it possible that the data on the workers after restoring from a backup will not be consistent with the metadata on the coordinator (for example, shardminvalue / shardmaxvalue or others)?
Maybe some other advice?
Thank you

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.