search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.84k stars 3.77k forks source link

backup: ability to backup individual files to multiple independent locations #64129

Closed dbist closed 12 months ago

dbist commented 3 years ago

Is your feature request related to a problem? Please describe. Organizations with regulatory responsibilities require to maintain backup sets for different duration of time, sometimes up to 20 years. Some database vendors have native capability to backup to two locations at the same time, here's a SQL Server example

BACKUP DATABASE AdventureWorks2014 
       TO DISK = 'C:\Mirror_01\AdventureWorks2014_Mirror_01.bak' 
MIRROR TO DISK = 'D:\Mirror_02\AdventureWorks2014_Mirror_02.bak' 
MIRROR TO DISK = 'E:\Mirror_03\AdventureWorks2014_Mirror_03.bak'
WITH FORMAT

Having ability to backup to multiple locations the same exact backup set is preferred.

Describe the solution you'd like

backup database to "'loc1', 'loc2', 'locN'";

Describe alternatives you've considered N/A

Jira issue: CRDB-6912

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!