- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Cloud
- Data
Protect and Recover Databases in Google Cloud
Configure backup and availability protections for a Cloud SQL for PostgreSQL database, create a known data state, simulate a controlled data loss event, and restore the database to verify successful recovery.
Lab Info
Table of Contents
-
Challenge
Configure Database Availability and Backup Protections
Inspect the existing Google Cloud SQL for PostgreSQL instance, review its availability and backup settings, configure automated backups with a seven-day retention period, enable regional high availability with a standby instance in another zone, and verify that the database meets the required availability and backup protections.
-
Challenge
Create a Recoverable Data State and Simulate Data Loss
Connect to the Cloud SQL PostgreSQL database from the provided Compute Engine VM, create and populate a sample customer table with five records, and verify the data before capturing a known recoverable state through an on-demand backup. After confirming the backup completes successfully, simulate accidental data loss by deleting the records and verify that the table is empty.
-
Challenge
Restore and Verify the Protected Database
Locate the previously created Cloud SQL on-demand backup and restore it to the designated recovery instance. Verify the instance's network configuration and availability, connect to the restored PostgreSQL database, and confirm that all five original customer records have been recovered and the database is operational, demonstrating successful recovery from the simulated data loss.
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.