Database Migration from OnPrem to AWS RDS
Prakash Rao
Posted on August 31, 2024
This project provides a step-by-step guide on how to migrate a WordPress website and MariaDB database from on-premises to AWS, using peering connections and AWS services such as EC2, RDS, and DMS. The guide covers setting up the simulated environment, creating VPC and peering connection, launching instances, setting up DMS replication, and testing..
Installation
To use this project, you need to have the following:
- A simulated AWS on-prem env with a WordPress website and MariaDB database.
- An AWS account with access to EC2, RDS, and DMS.
The guide covers the following steps:
- Assuming a simulated on-premises environment on AWS with a WordPress website and MariaDB database are already setup.
- Create an AWS VPC and peering connection between the on-premises (simulated) environment and the AWS VPC.
- Launch an EC2 instance in the AWS VPC and configure it as the new webserver for the WordPress website.
- Launch an RDS instance in the AWS VPC and configure it as the new database server for the MariaDB database.
- Set up DMS replication instance between the on-premises MariaDB database and the AWS RDS instance and start replicating.
- Test the migrated WordPress website by modifying the wordpress file where the ip is pointed to on-prem to DNS of MariaDB database.
- As a cleanup delete the instances, peering connection, DMS replication instance, RDS, EC2, etc.
CleanUp:
At the end as a cleanup delete the instances, peering connection, DMS replication instance, RDS, EC2, etc.
💖 💪 🙅 🚩
Prakash Rao
Posted on August 31, 2024
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.