Project 9 - Recover DB data after corruption or accidental deletion has occurred.

Learn how to recover a corrupted or accidentally deleted WordPress database using AWS RDS snapshots and point-in-time restore. This lab covers backup strategies, restoration procedures, and instance renaming for seamless recovery.

Created by

Akinola Ojuola

Hours

0 Enrolled

    • (0 Reviews)

English

Last updated

Tue, 02-Dec-2025

Course description

In this real-world disaster recovery lab, you'll manage a WordPress website hosted on AWS with an RDS MySQL database. After provisioning the infrastructure using Terraform, you'll simulate a database corruption scenario by deliberately deleting critical tables. You'll then leverage AWS RDS automated and manual snapshots to perform a point-in-time restore, recovering the database to a known good state. Through hands-on steps, you'll learn how to rename RDS instances, update connectivity, and validate the restored application. By the end, you'll master RDS backup and recovery techniques essential for maintaining business continuity.

Additionally, all learners receive dedicated online support through our Slack workspace where you can ask questions, get troubleshooting help, and interact with our team throughout the entire project.

Click here to access Slack workspace link

What will i learn?

  • Provision a WordPress environment with RDS using Terraform
  • Create manual and automated RDS snapshots
  • Simulate database corruption and assess impact
  • Perform a point-in-time restore of an RDS database
  • Rename RDS instances to maintain application connectivity
  • Validate recovery and ensure website functionality is restored

Requirements

  • An AWS account with RDS and EC2 access
  • Basic knowledge of AWS networking and Terraform
  • Familiarity with MySQL and WordPress architecture
  • SSH client for accessing the Bastion host
  • Understanding of database backup and recovery concepts

Frequently asked question

Automated snapshots are taken daily during the backup window and retained based on the retention period. Manual snapshots are user-initiated and retained until explicitly deleted, providing more control over backup points.

AWS RDS supports point-in-time recovery (PITR) for up to the last 35 days, allowing restoration to any second within that period, not just snapshot times.

Renaming ensures the application continues to use the same endpoint (wordpress-db) without reconfiguration. The corrupted instance is renamed to avoid conflict, and the restored instance takes over the original identifier.

Akinola Ojuola

Cloud Solution Architect, DevOps Consultant & Trainer

Akinola Ojuola is a seasoned Cloud Solution Architect, DevOps Consultant and technical trainer with over 20 years of industry expertise. Throughout his career, he has worked with some of the world’s most prominent technology-driven organisations, including IBM, Fujitsu, Walmart, and MasterCard, delivering transformative solutions across various sectors. Akinola has trained and mentored more than 1,000 students across 18 countries on five continents. His commitment to real-world, practical learning has enabled hundreds of learners to launch successful careers in global tech companies. He is passionate about practical, real-world learning. His teaching approach blends deep technical knowledge with hands-on, enterprise-level experience. He holds multiple industry certifications and leads advanced projects in Cloud Architecture, DevOps, DevSecOps, and Artificial Intelligence for both private enterprises and public institutions.Whether you’re just starting or looking to advance your tech career, you’ll gain valuable, job-ready skills under his guidance.
View profile

$10

Lectures

1

Skill level

Intermediate

Expiry period

Lifetime

Certificate

Yes
Remove from cart Add to cart Buy now

Related courses

Intermediate

Project 1 - Deploy Amazon RDS Multi-AZ and Read Replica in AWS

0

(0 Reviews)

Compare

Learn how to build a highly available WordPress application on AWS using Amazon RDS with Multi-AZ automatic failover and read replicas.

$10

Hours

Beginner

Project 2- Enable S3 bucket versioning

0

(0 Reviews)

Compare

Learn how to enable and use Amazon S3 bucket versioning to protect your data from accidental deletion or overwrite. In this hands-on lab, you'll create public and private S3 buckets, upload files, enable versioning, and manage multiple object versions.

$10

Hours

Intermediate

Project 3 - Using DMS to Migrate MySQL to Amazon Aurora

0

(0 Reviews)

Compare

Learn how to migrate a MySQL database to Amazon Aurora using AWS Database Migration Service (DMS). This hands-on lab guides you through setting up source and target endpoints, configuring replication, and executing a seamless database migration.

$10

Hours

Beginner

Project 4 - EFS

0

(0 Reviews)

Compare

Learn how to create and mount an Amazon Elastic File System (EFS) to multiple Amazon EC2 instances. This lab covers security group configuration, EFS setup, instance deployment, and mounting verification.

$10

Hours

Intermediate

Project 5 - Secure Nginx webserver with Let'sEncrypt on an Ubuntu Instance with Certbot

0

(0 Reviews)

Compare

Learn how to secure an Nginx web server running on an Ubuntu EC2 instance using Let's Encrypt SSL/TLS certificates. This lab covers domain setup, Certbot installation, and automated certificate renewal.

$10

Hours

Advanced

Project 6 - Setup Highly Available Cluster using HA Proxy and Keepalived

0

(0 Reviews)

Compare

Learn how to build a highly available web cluster using HAProxy and Keepalived on AWS. This lab covers load balancer configuration, virtual IP management, automatic failover, and high availability verification.

$10

Hours

Beginner

Project 7 - Install MySQL DB server on EC2 instance and remotely connect to it.

0

(0 Reviews)

Compare

Learn how to install and configure a MySQL database server on an Amazon EC2 instance and connect to it remotely. This lab covers security group configuration, MySQL installation, user creation, and remote database access.

$10

Hours

Advanced

Project 8 - Deploy a Java Enterprise Application on Tomcat Server using Jenkins Pipeline

0

(0 Reviews)

Compare

Learn how to automate the deployment of a Java web application to a Tomcat server using a Jenkins CI/CD pipeline. This lab covers infrastructure provisioning with Terraform, Jenkins configuration, pipeline scripting, and automated deployment.

$10

Hours

Beginner

Project 10 - How to create a CRUD Serverless API with AWS Lambda, API Gateway and a DynamoDB from Scratch

0

(0 Reviews)

Compare

Learn how to build a fully serverless CRUD API using AWS Lambda, API Gateway, and DynamoDB. This hands-on lab covers creating a RESTful API, integrating services, and testing endpoints with real HTTP requests.

$10

Hours

Beginner

Project 11 - Application Load Balancer (ALB) - Session Stickiness

0

(0 Reviews)

Compare

Learn how to configure and test session stickiness on an AWS Application Load Balancer (ALB). This lab demonstrates cookie-based session affinity, failover behavior, and load distribution with hands-on testing.

$10

Hours

Intermediate

Project 12 - MySQL Master-Slave Replication on different AWS instances

0

(0 Reviews)

Compare

Learn how to set up MySQL Master-Slave replication across separate AWS EC2 instances. This lab covers replication configuration, data synchronization, and failover readiness using Terraform and MySQL.

$10

Hours

Intermediate

Project 13 - Setting Up a Monitoring Stack Using Grafana, Prometheus, and Node Exporter on Ubuntu

0

(0 Reviews)

Compare

Learn how to build a complete monitoring stack on Ubuntu using Grafana, Prometheus, and Node Exporter. Deploy a multi-server monitoring system, visualize real-time metrics, and gain hands-on experience with industry-standard observability tools.

$10

Hours

Industry-aligned, hands-on tech training in Cloud, DevOps, DevSecOps, Python AI and more —empowering learners worldwide with job-ready skills and global certifications.

Top categories

Useful links

Help

Subscribe to our newsletter