Ends in
00
days
00
hrs
00
mins
00
secs
SHOP NOW

🎉 Get 10% OFF and Save Big on All PlayCloud Subscription Plans - PlayCloud Sale!
Back to Course

GCP PlayCloud Labs

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