Ends in
00
hrs
00
mins
00
secs
SHOP NOW

💝 48-Hour Valentine's Sale Extension! Get 30% OFF Any Reviewer. Use coupon code: VDAYSALE2026 & 5% OFF Store Credits/Gift Cards
Back to Course

GCP PlayCloud Labs

0% Complete
0/0 Steps
  1. GCP PlayCloud Labs
  2. Guided Lab: How to Launch a GCP Compute Engine Linux Instance
  3. Guided Lab: Creating a VM Using Instance Templates
  4. Guided Lab: Creating and Managing Instance Groups in Compute Engine
  5. Guided Lab: Creating a Spot VM Instance
  6. Guided Lab: Configuring Shielded VM Options
  7. Guided Lab: Exploring Instance Metadata in Google Cloud
  8. Guided Lab: Vertically Scaling a VM Instance
  9. Guided Lab: Setting up a Web Server on a VM Instance
  10. Guided Lab: Using Startup Scripts in GCP VM Instances
  11. Guided Lab: Creating a Custom Image from a VM Instance with Web Server in Google Cloud
  12. Guided Lab: Creating VM Snapshots and Restoring a VM from a Snapshot
  13. Guided Lab: Setting Up and Managing a Database on a VM Instance
  14. Guided Lab: Installing WordPress on an Ubuntu VM Instance with LEMP Stack
  15. Guided Lab: Deploying a LAMP Stack on a Compute Engine VM
  16. Guided Lab: Reserving or Promoting a Static IP Address for a VM Instance
  17. Guided Lab: SSH Access to GCP VM Instance from Local Machine using SSH Key Pair
  18. Guided Lab: Guarding Your VM with Deletion Protection
  19. Guided Lab: Setting Up a Linux Bastion Host on GCP
  20. Guided Lab: Creating a Cloud Storage Bucket
  21. Guided Lab: Uploading, Organizing, and Managing Objects in Cloud Storage
  22. Guided Lab: Exploring Google Cloud Storage Classes
  23. Guided Lab: Hosting a Static Website in Google Cloud Storage Bucket
  24. Guided Lab: Protecting Data on Cloud Storage Bucket Against Accidental Delete and Overwrite Using Object Versioning
  25. Guided Lab: Using Cloud Storage Lifecycle Rules to Automate Object Management
  26. Guided Lab: Managing Cloud Storage Buckets via SSH Commands
  27. Guided Lab: Creating a Cloud SQL Instance
  28. Guided Lab: Running SQL Commands in Cloud SQL Studio
  29. Guided Lab: Creating and Restoring Cloud SQL Backups
  30. Guided Lab: Integrating Cloud SQL Database instance with a VM instance
  31. Guided Lab: Connecting Cloud SQL Database with MySQL Workbench (Local)
  32. Guided Lab: Guarding Your Cloud SQL Instances with Deletion Protection
  33. Guided Lab: Creating a Cloud NAT Gateway
  34. Guided Lab: Creating a Google Kubernetes Engine (GKE) Cluster
  35. Guided Lab: Connecting to a Kubernetes Engine Cluster
  36. Guided Lab: Deploying a Simple Web Application on GKE
  37. Guided Lab: Creating a Custom Virtual Private Cloud (VPC)
  38. Guided Lab: Establishing VPC Peering for Secure Cross‑Network Communication
  39. Guided Lab: Configuring Firewall Rules to Secure and Access a VM
  40. Guided Lab: Creating an Application Load Balancer
  41. Guided Lab: Creating a Network Load Balancer
GCP PlayCloud Labs Guided Lab: Guarding Your Cloud SQL Instances with Deletion Protection
In Progress
Lesson 32 of 41
In Progress

Guided Lab: Guarding Your Cloud SQL Instances with Deletion Protection

Jon-Bonso

Description

Accidental deletions of Cloud SQL instances can result in data loss, downtime, and costly recovery efforts. Google Cloud’s Instance deletion protection feature ensures that your Cloud SQL instances remain safe until you explicitly disable protection.

In this lab, you’ll learn how to enable Instance deletion protection, test what happens when you attempt to delete a protected instance, and then disable protection to allow deletion when it’s truly intended.

Prerequisites

To ensure the successful completion of this lab, you must have prior experience in creating Cloud SQL instances and be familiar with their essential components. If you feel that your knowledge in this area is insufficient, we highly recommend taking this lab to gain the necessary understanding:

Objectives

In this lab, you will:

  • Enable Instance deletion protection on a Cloud SQL instance.
  • Observe the behavior when attempting to delete a protected instance.
  • Disable deletion protection to allow deletion.

Subscribe to access GCP PlayCloud Labs

Lab Steps

Create a Cloud SQL Instance with Deletion Protection

1. In the Cloud Console, navigate to SQL → Instances.

2. Click Create Sandbox Instance.

3. Enter an instance ID (e.g., protected-sql-instance).

4. Check the No password option.

5. Expand the Customize your instance section.

6. Scroll to the Deletion Protection option and check Prevent instance deletion, and uncheck the following options that are not required for your configuration:

  • Retain backups after instance deletion
  • Final backup on instance deletion

7. Leave other configurations at default values.

8. Click Create Instance.

Wait until the Cloud SQL instance creation is complete.

Attempt to Delete the Protected Instance

1. In the SQL Instances list, select your protected instance.

2. Click Delete.

3. You will see an error message: “You can’t delete this instance because deletion protection is enabled. To delete, you have to edit this instance and disable deletion protection first (editable in the Data Protection section).”

The instance cannot be deleted while deletion protection is active.

Disable Deletion Protection

1. Click on the instance name.

2. Select Edit.

3. Scroll to Deletion Protection and uncheck Prevent instance deletion.

4. Click Save.

Delete the Instance

1. Return to the SQL Instances list.

2. Select the instance and click Delete.

3. This time, the instance will be successfully deleted.

    Congratulations! You’ve successfully explored Cloud SQL’s deletion protection feature. This safeguard helps prevent costly mistakes by requiring explicit confirmation before removing critical database instances.

    Skip to content