You can back up CockroachDB to Commvault Unified Data Vault, allowing you to leverage Commvault's secure, scalable storage while maintaining your existing backup workflows.

Backing Up CockroachDB to Unified Data Vault

CockroachDB provides a BACKUP tool that workload administrators use to run backup and restore operations to AWS S3 or S3-compatible storage. With Commvault Unified Data Vault, you can replace your S3-compatible storage, keeping your backup scripts and standard operating procedures unchanged.

Getting Started

1. Backup admin configuration.

   Hosting an S3 endpoint is typically managed by backup, infrastructure, or MSP administrators who install, maintain, and host the endpoints for use by CockroachDB workload and application administrators.

   1. Create an S3 endpoint.

2. Workload admin configuration.

   Creating S3 vaults, creating/associating S3 users, and using S3 Vaults for backup and restore are typically performed by CockroachDB workload and application administrators.

   1. Create an S3 Vault.

   2. Get S3 Vault Keys.

Run CockroachDB Backup

Use the following command to back up CockroachDB to S3 Vault:

BACKUP INTO 's3://{BUCKET_NAME}?AWS_ACCESS_KEY_ID={KEY_ID}&AWS_SECRET_ACCESS_KEY={SECRET_ACCESS_KEY}&AWS_ENDPOINT={ENDPOINT_URL}'

List CockroachDB Backups

SHOW BACKUPS IN 's3://{BUCKET_NAME}?AWS_ACCESS_KEY_ID={KEY_ID}&AWS_SECRET_ACCESS_KEY={SECRET_ACCESS_KEY}&AWS_ENDPOINT={ENDPOINT_URL}’

Restore CockroachDB Backups

Use the following command to restore a CockroachDB database from S3 Vault:

RESTORE DATABASE <database_name> FROM LATEST IN 's3://<s3vault_name>/<folder>?AWS_ACCESS_KEY_ID=<key>&AWS_SECRET_ACCESS_KEY=<secret>&AWS_ENDPOINT=<endpoint_info>';