Migrating a PostgreSQL Database With Minimal Downtime Using AWS DMS and Route53
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:
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.