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:

• Migrating MySQL to PostgreSQL With the AWS Database Migration Service
• Configuring Amazon Route 53 Routing Policies
• Introduction to the AWS Database Migration Service

Updates

June 7th, 2024 - Resolved WordPress application error message