Backup is an important maintenance routine for your database. The Vertica vbr Python script allows you to back up, restore, and copy your database to another cluster. Depending on the size of your data, you can:
Create full and incremental database backups.
Back up specific tables and schemas.
Similarly, you can restore a full database or specific tables from a backup. Vertica supports automatic backup and restore after you configure the runtime parameters in vbr.
For the purpose of this document and child documents:
The primary cluster is referred to as the source.
The secondary cluster is referred to as the target.
Backup always occurs on the source.
Restore always occurs on the target.
For the purpose of demonstration and conciseness, this document and child documents use a 2-node cluster, but you should use a 3-node cluster with a K-safety level of 1.
Depending on your data requirements, choose the appropriate Backup and Restore documents from the following: