E-commerce Database Migration to Improve Platform Capacity

Diversual was experiencing rapid expansion in its online sales business. However, they faced a bottleneck in their e-commerce infrastructure: during marketing campaigns, traffic spiked quickly, and their web infrastructure struggled to handle the load. As a result, they needed a partner with expertise in e-commerce solutions to help them scale their platform to meet market projections.

They approached us to support their existing e-commerce platform and serve as their infrastructure specialists for the migration process. This Database Migration involved moving the following applications to a new platform: Pelican and Prestashop eCommerce from Diversual.

The goal of the new platform was to handle marketing campaigns without service downtime, even during traffic surges. The migration had to incorporate new services and solutions to enhance the architecture, ensuring high availability, fault tolerance, and scalability.

Proposed Migration & Database Architecture

We helped the client migrate their platform by deploying a server for Prestashop, with the database stored on Amazon Aurora. Additionally, we implemented an automatic system that enables vertical scaling using AWS Lambda.

The services used included EC2, Aurora, Lambda, CloudWatch, and VPC.

The Cloud Levante team’s solution comprised:

• Migrating the platform to Amazon RDS to improve capacity.
• Implementing auto-scaling to optimize platform performance during traffic peaks.

Highly Available Solution Adaptable to Traffic Peaks

Amazon Relational Database Migration Service allowed Diversual to improve platform capacity, enhance end-user experience, ensure high availability, and reduce total cost of ownership (TCO). By leveraging Amazon Aurora, Diversual achieved a more flexible service that scales infrastructure up during high-demand periods and scales down during quieter times.

Deploying an Automatic Auto-Scaling System

This resulted in a more flexible cloud service, enabling Diversual to expand their infrastructure during traffic peaks and reduce it during low-demand periods. Auto-scaling allows Diversual to automatically adjust server capacity and other cloud services based on pre-defined scenarios, such as traffic levels and resource utilization.

As a result, they can continue scaling their marketing campaigns without limitations while reducing platform costs when traffic decreases.

Project Outcomes & Success Metrics

• Scalability: The platform is now scalable, easily adapting to the business’s real needs. It can efficiently handle increased traffic, improving overall performance.
• Cost Savings: Diversual only pays for the resources they use when they need them. Automatic shutdown of development environments further contributes to cost savings.
• Integration: The new platform unifies disparate data, making it accessible to automated processes, internal teams, and third-party partners, providing global control over the infrastructure.