X

Migrate from DB on Amazon EC2 to Amazon RDS for MySQL with HA using AWS DMS for Nalli E-Commerce Platform 

Industry

E- Commerce Platform

Offering

Amazon Aurora PostgreSQL

Cloud

AWS

Published On

November 02, 2022

About the client

Nalli’s website is currently running on Magento with customization. The application is hosted and managed by WebScale (a third-party hosting vendor) in PaaS. The development and customization of the application are handled by the customer and a third-party development team. At present, they cannot perform much customization due to the lack of visibility provided by Webscale. The problem was that they couldn’t scale consistently and justify the cost and DB performance. During peak periods, such as holidays and promotional events, the previous architecture was incapable of justifying the investment and ensuring stability. Given the regular stability difficulties, the performance-to-spending ratio has declined.

Also, managing MySQL databases on Amazon Elastic Compute Cloud (Amazon EC2) instances is time-consuming and expensive. Moving these databases to an Amazon Relational Database Service (Amazon RDS) for MySQL DB instances will make your work easier while also saving you money on IT. Multi-AZ, scalability and automated backups are all available with Amazon RDS for MySQL

Solution Requirements

The customer having time-consuming and expensive ways to manage MySQL databases on Amazon Elastic Compute Cloud(Amazon EC2) instances

The customer had an existing data size of 550 GB and needed to migrate to the Amazon RDS mySQL database.

It has been expected to grow annually by 850 GB in size, and it has a total of 436 tables in the database in total.

Planned to migrate the entire database to MySQL RDS for the faster performance and availability.

Solution

Plan the migration

Configure the source: MySQL database on EC2 instance

Configure the target: Amazon RDS for MySQL

Configure AWS SCT and create a schema in the target database

Migrate data using AWS DMS

Migrate the application and cut over

Validate the schema and data in source vs. target databases.

Success Area

The read performance of the database has been increased and thus application performance was increased

The availability of the application has been increased

Decreased the downtime's on the peak season, by implemented Multi Az in the RDS

CDN delivers the e-commerce website with low latency and high transfer speeds. WAF has been implemented on CDN to protect the web application against threats.

Please write to us at contactus@1cloudhub.com, if you wish to explore further on this deployment.

Sharing is caring!

Comments are closed.