search

cockroachdb / docs

CockroachDB user documentation
https://cockroachlabs.com/docs
Creative Commons Attribution 4.0 International
187 stars 453 forks source link

serverless restore: clarify that backups of multiregion databases can only get restored in MR enabled serverless clusters #17373

Open msbutler opened 1 year ago

msbutler commented 1 year ago

Michael Butler (msbutler) commented:

Clarify that MR databases can only be restored in MR enabled serverless clusters.

Note that the skip_localities_check restore flag is not a workaround. (The reason this flag doesn't work is a bit in the weeds-- essentially that flag allows for the backed up zonecfgs to get applied during a cluster restore even if backed up region zone cfgs do not match). There was some confusion here.

Jira Issue: DOC-8248

exalate-issue-sync[bot] commented 8 months ago

Kathryn Hancox (kathancox) commented: Michael Butler I am doing some testing here to try an improve the docs generally for restore and multi-region. I tested restoring a multi-region self-hosted cluster into a single-region serverless and this worked. Is that expected? I thought not… Or is that fine when we’re using customer-owned backups?

msbutler commented 8 months ago

multi-region self-hosted cluster

To clarify, did this self-hosted cluster have actual MR primitives set by zone configs, or were the nodes merely spread across a few regions?

Also, what kind of backup (e.g. table/database/cluster) did you take and what kind of restore did you take?