search

cockroachdb / cockroach

CockroachDB - the open source, cloud-native distributed SQL database.
https://www.cockroachlabs.com
Other
29.5k stars 3.7k forks source link

roachtest: add backup/restore operation #126481

Open itsbilal opened 2 days ago

itsbilal commented 2 days ago

As part of this issue, we should enhance backup/restore test coverage on the DRT/DRP clusters through adding an operation that does a backup, followed by a restore, followed by a verification of results between the backup and the restore.

One possible way to implement this operation is to do a backup of a table or db with an AS OF SYSTEM TIME, restore that backup into a db/table with a new name, and then SELECT both tables AS OF SYSTEM TIME and verify that the sums of some column(s) match. As part of the cleanup, we could DROP the restored db/table. Alternatively we could have the operation specifically look for a tpcc db/table, and run TPCC consistency checks on the restored db.

Jira issue: CRDB-39943

blathers-crl[bot] commented 2 days ago

cc @cockroachdb/test-eng

itsbilal commented 2 days ago

Adding this to T-testeng, but I expect this to be owned by the DRP team.