Accidents do happen! Data can become corrupted. It can be unintentionally deleted and, in some rare cases, you can lose all your data.
Do you have a plan B to recover data in a timely manner?
Before Vertica version 7.2, you had two options: perform full backups and restore full backups (remove everything from the storage unit) or perform object-level backups and restore those individually (maintain separate storage units). But as of Vertica 7.2, you can have the best of both worlds. You can perform full backups and restore individual objects from that backup! This means you don?t have to waste time and resources on restoring data that you do not need at the moment.
This enhancement to the Vertica AWS Auto Scaling open-source package makes it quite easy to create a working replica of your existing cloud-hosted or on-premise Vertica cluster in Amazon Web Services.
Why should you always have a backup plan? Because something, inevitably, goes wrong. Whether you experience something as simple as a deleted record, or as serious as a full system deletion, you need a backup.
Backing up and restoring your database is an important part of basic database maintenance. Vertica lets you create both comprehensive and object-level backups. This article highlights the Vertica 7.x features that enhance the backup and restore process.