AWS
Optimization of the
database of
MAVI via Amazon RDS
MAVI is a furniture distribution company located in Guadalajara, Jalisco. It sells household goods both in physical stores and through its online store. With a wide product catalog and a large customer base, MAVI deals with fluctuating demand during peak sales periods, such as Buen Fin (Good End), Christmas, and Mother's Day.
Problem
MAVI's database is critical to delivering a seamless user experience and ensuring successful online sales. However, its on-premise infrastructure and limited hardware couldn't handle the workload generated by thousands of requests and site visits. With an average of 120 million queries over a six-month period, resources were quickly depleted, and infrastructure expenses exceeded the allocated budget.
Our Solution
To address these challenges, iNBest.cloud proposed migrating MAVI's database to Amazon RDS (Relational Database Service) with the MySQL Server engine. The choice of RDS and Amazon Aurora MySQL was based on the advantages they offered to the business and their fit within MAVI's budget. Furthermore, since MAVI didn't have a database administrator (DBA) profile, MAVI's developers assumed responsibility for maintaining the database, so they were already familiar with MySQL and specifically Aurora.
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 was used to mitigate cybersecurity and compute capacity risks, thereby reducing the possibility of database failures. Cloudflare was used as a third-party application for DNS management, enhancing MAVI's security.
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 was used to mitigate cybersecurity and compute capacity risks, thereby reducing the possibility of database failures. Cloudflare was used as a third-party application for DNS management, enhancing MAVI's security.
Results
The implemented solution has stabilized the performance of MAVI's website, proving to be fully elastic and capable of handling up to 199 million queries and 1.36 million database connections. If necessary, additional RDSs can be provisioned in a matter of hours, providing flexibility and scalability to the system.
The client has experienced a successful learning curve and adoption of the AWS Cloud. By using Amazon RDS in its database, MAVI has improved online sales by avoiding denial of service issues, resulting in increased sales during peak periods.
In short, implementing Amazon RDS has enabled MAVI to optimize its database, achieve increased performance and availability, and adapt to the fluctuating demands of its business in a cost-effective and efficient manner.
The client has experienced a successful learning curve and adoption of the AWS Cloud. By using Amazon RDS in its database, MAVI has improved online sales by avoiding denial of service issues, resulting in increased sales during peak periods.
In short, implementing Amazon RDS has enabled MAVI to optimize its database, achieve increased performance and availability, and adapt to the fluctuating demands of its business in a cost-effective and efficient manner.
Contact us
and receive free consulting
Phone
(+52) 33 2309 0100
(+52) 55 6651 8800
+1 (973) 554 9068
hola@inbest.cloud
Phone
(+52) 33 2309 0100
(+52) 55 6651 8800
+1 (973) 554 9068
hola@inbest.cloud