MAVI

The challenge

MAVI is a furniture distribution company located in Guadalajara, Jalisco. They sell home goods both in physical stores and through their online store. With an extensive product catalog and a large customer base, MAVI faces demand fluctuations during peak sales seasons like Buen Fin, Christmas, and Mother's Day.

MAVI's database is essential for providing a proper user experience and ensuring successful online sales. However, their on-premise infrastructure and limited hardware could not handle the workload generated by thousands of requests and site visits. With an average of 120 million queries over a 6-month period, resources were quickly depleted and infrastructure costs exceeded the allocated budget.

The solution

To address these challenges, iNBest.cloud proposed migrating MAVI's database to Amazon RDS (Relational Database Service) with MySQL Server engine. The choice of RDS and Amazon Aurora MySQL was based on the advantages they offered to the business and their fit with MAVI's budgets.

To achieve high availability, an architecture was implemented that included a read replica to optimize read/write workloads. Additionally, an ElastiCache node with Redis, EC2, WAF, ACM, ALB, CodeCommit, and autoscaling were used to mitigate IT security risks and computing capacity, thus reducing the possibility of database failures.

Results

• Fully elastic system capable of handling up to 199 million queries
• 1.36 million database connections
• Additional RDS instances provisionable in hours
• Improved online sales by avoiding service denial