hands-on lab

Migrating a PostgreSQL Database With Minimal Downtime Using AWS DMS and Route53

Intermediate
Up to 1h 30m
22
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.

Description

AWS Database Migration Service (DMS) is a managed service that makes it easy to migrate data from one database to another. In this lab, you will migrate data from a self-managed PostgreSQL database to an Amazon RDS for PostgreSQL database instance using a DMS migration task. You will also deploy a new WordPress EC2 instance and establish a connection to the target Amazon RDS instance. Finally, you will update an Amazon Route53 record to route traffic to the new application.

AWS Database Migration Service (DMS) is a managed service that allows users to migrate data from one data store to another. DMS can be used to migrate data between on-premise databases and AWS, between different AWS databases, or between different databases in the cloud (i.e., Azure, GCP). DMS can also be used to continuously replicate data with high availability and consolidate databases.

In this lab, you will migrate data from a self-managed PostgreSQL database to an Amazon RDS for PostgreSQL database instance using a DMS migration task. You will also deploy a new WordPress EC2 instance and establish a connection to the target Amazon RDS instance. Once the new application is operational, you will perform a cutover to the new application with Route53 to minimize downtime.

Learning objectives

Upon completion of this intermediate-level lab, you will be able to:

  • Create source and target AWS Database Migration Service (DMS) endpoints
  • Migrate data from a self-managed PostgreSQL database to an Amazon RDS for PostgreSQL database instance using a DMS migration task
  • Deploy a new WordPress EC2 instance and establish a connection to the target Amazon RDS instance
  • Update an Amazon Route53 record to route traffic to the new application

Intended audience

  • Candidates for AWS Certified Solutions Architect – Associate & Professional Certifications
  • Cloud Architects
  • Software Engineers

Prerequisites

Familiarity with the following will be beneficial but is not required:

  • AWS Database Migration Service (DMS)
  • Amazon Relational Database Service (RDS)
  • Amazon Route53
  • Amazon Elastic Compute Cloud (EC2)
  • Amazon Machine Images (AMIs)

The following content can be used to fulfill the prerequisites:

Updates

June 7th, 2024 - Resolved WordPress application error message

Environment before

Environment after

About the author

Avatar
Jun Fritz, opens in a new tab
Cloud Labs Developer
Students
40,524
Labs
109
Courses
1
Learning paths
6

Jun is a Cloud Labs Developer with previous experience as a Software Engineer and Cloud Developer. He holds the AWS Certified Solutions Architect and DevOps Engineer Professional certifications. He also holds the AWS Certified Solutions Architect, Developer, and SysOps Administrator Associate certifications. 

Jun is focused on giving back to the growing cloud community by sharing his knowledge and experience with students and creating engaging content. 

Covered topics

Lab steps

Logging In to the Amazon Web Services Console
Reviewing the Existing WordPress Application
Configuring AWS Database Migration Service Endpoints
Running an AWS DMS Migration Task
Deploying a New WordPress Application Using an AWS AMI
Connecting to an EC2 Instance Using Amazon EC2 Instance Connect
Updating the Amazon Route53 Record