Migrate from DB on Amazon EC2 to Amazon RDS for MySQL with HA using AWS DMS for E-Commerce Platform
We helped our top E-commerce platform customer to Migrate from DB on Amazon EC2 to Amazon RDS for MySQL with HA using AWS DMS
About the client
The customer’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
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.
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.
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 email@example.com, if you wish to explore further on this deployment.