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

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.

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