Recovery Drill
Use a standalone ppk drill mysql to drill down in an isolated environment when you need to confirm that the backup files, decryption process, SQL import and recovery process are still working properly. This command is not equivalent to production restoration, nor does it overwrite the production library by default.
Steps to follow
- Select a real backup point and prepare the test environment.
- When the backup file is in the object store, first download it locally:
peppykeep backup download-artifact --apply --remote-key project-a/backup.ppke --output-file /tmp/backup.ppke --config-home /path/to/conf
- When the backup file is an encrypted file, complete the decryption first:
ppk decrypt --input /tmp/backup.ppke --output /tmp/backup.ppk --apply --config-home /path/to/conf
- First, execute dry-run to confirm the walkthrough library, workspace, private key, and validate SQL:
ppk drill mysql --project-key project-a --backup-file /tmp/backup.ppke --target-db-name ppk_drill_project_a --config-home /path/to/conf
- After confirmation, add
--apply, and the CLI will automatically decrypt, unpack, import SQL, and generate a walkthrough report. - Check that critical directories, critical files, and critical data are fully available and document the time-consuming and additional dependencies of this restore.
results verification
- Critical directories and critical data have been restored successfully.
- Private keys, passwords, and recovery environments are all available for use during the walkthrough.
- The new dependencies and processing steps added in this walkthrough have been documented.
Order Details: