Nykaa’s 70% AWS Cost Cut & 3X Performance Boost

2024

All

Challenges

Heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Heading

Our Solutions

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5

Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

Item 1
Item 2
Item 3

Unordered list

Item A
Item B
Item C

Text link

Bold text

Emphasis

^Superscript

_Subscript

Key Benefits

Heading

Recent Works

High Availability & Performance Boost for Fintech on MySQL RDS

Nykaa’s 70% AWS Cost Cut & 3X Performance Boost

Need Expert Database Solutions?

Talk to a Database Expert Today!

Database solutions are provided by mydbops expert team

Mydbops set up High Availability (HA) Solutions with InnoDB or Percona Clusters, ensuring continuous uptime and fault tolerance.

Thank You!

We’ve got your request, our expert team will be contacting you shortly.

Oops! Something went wrong while submitting the form.

Nykaa’s 70% AWS Cost Cut & 3X Performance Boost

Download Detailed Case Study

Client Overview

Nykaa, India’s leading beauty and wellness e-commerce giant, serves millions of users with real-time transactions and a vast product catalog. At such scale, their systems demand exceptional uptime, fast database performance, and cost-efficient infrastructure. Despite hosting MySQL on Amazon RDS, Nykaa faced rising database costs, poor query performance, CPU spikes, and locking issues—impacting user experience and budgets.

↑

↓

Cost Savings

Massive savings post RDS optimization

↑

↓

Query Performance

Significantly faster response and data processing

↑

↓

CPU Usage

Heavy load dropped after query and config tuning

↑

↓

Concurrency Handling

Handled peak load with no locking issues

MySQL

Managed Services

⭐️⭐️⭐️⭐️⭐️

Deployment Type

Database Stack

Outcome

Cloud

Amazon RDS for MySQL

$30,851.71 Saved Monthly

Business Challenges

Overview

The client experienced major performance degradation and soaring infrastructure costs due to inefficient MySQL RDS configuration, query patterns, and scaling issues.

‼️ Database Slowness Due to Poor Query Design: Several unoptimized queries caused slow response times and blocked transactions, directly impacting user experience.

‼️ High CPU Usage on Master and Replicas: The master node and replicas frequently experienced CPU spikes, leading to latency in read/write operations.

‼️ DB Locking During High Concurrency: During flash sale events or peak evening hours, users faced slow page loads due to locking issues, resulting in abandoned carts and lost sales.

‼️ Over-Provisioned and Costly Infrastructure: The client was spending over $44,000 per month, including AWS Enterprise Support, without seeing corresponding performance benefits.

Business Challenges

Overview

The client experienced major performance degradation and soaring infrastructure costs due to inefficient MySQL RDS configuration, query patterns, and scaling issues.

‼️

A brief context of the client’s operations and the challenges they were facing. Focus on business-critical pain points such as performance issues, high cost, downtime, etc.

‼️

A brief context of the client’s operations and the challenges they were facing. Focus on business-critical pain points such as performance issues, high cost, downtime, etc.

‼️

A brief context of the client’s operations and the challenges they were facing. Focus on business-critical pain points such as performance issues, high cost, downtime, etc.

Goals

The key objectives the client was aiming to achieve:

→ Optimize Resource Usage: Scale down to appropriate instance sizes without impacting performance.

→ Improve Query Response Time: Reduce latency and ensure quick database responses for both read and write operations.

→ Handle Traffic Spikes Gracefully: Eliminate DB locks and improve concurrency handling during high user traffic.

→ Reduce AWS Expenditure Significantly: Cut unnecessary costs tied to oversized instances, high IOPS, and premium support.

Goals

The key objectives the client was aiming to achieve:

→

[Goal 1]

→

[Goal 1]

→

[Goal 1]

Solution Provided by Mydbops

Our team of MySQL consultants, with deep expertise in RDS and large-scale architectures, implemented a structured consulting process:

‍

▸ RDS Instance Review & Slow Query Profiling

We began with a detailed review of their RDS setup — including instance types, configurations, storage, and slow queries — using both AWS tools and our internal profiling frameworks.

▸ Right-Sizing of Instances

Master and replicas were resized from db.r4.16xlarge and db.r4.8xlarge to db.r4.8xlarge and db.r4.4xlarge respectively — slashing costs while keeping performance intact.

▸ Query Optimization and Indexing

We profiled high-load queries and added missing secondary indexes. Bad queries were rewritten and query plans optimized, cutting CPU and I/O load drastically.

▸ DB Parameter and Concurrency Tuning

RDS parameters (like max_connections, innodb_buffer_pool, query_cache_type, etc.) were tuned based on workload. This resolved locking issues and enabled smooth multi-user access.

▸ IOPS Optimization Planning

We proposed and planned for the removal of over-provisioned 5000 PIOPS, which were not providing proportional performance benefits.

▸ AWS Support Cost Elimination

Since Mydbops took over DB performance and reliability, the client was able to remove $15,000/month AWS Enterprise Support — a major cost saving.

‍

Initial AWS Database Infrastructure Cost Summary

SI:NO	Description	Instance Type	Storage	Multi AZ	PIOPS	Cost ($)
1	Master × 1	db.r4.16xlarge	1000GB	YES	5000	16,058.62
2	Slave × 3	db.r4.8xlarge	1000GB	NO	5000	13,223.21
3	AWS Enterprise Support	NIL	NIL	NIL	NIL	15,000.00
TOTAL						$44,281.83

‍

All calculations were made using AWS cost calculator.

‍

Optimized AWS Database Infrastructure Cost Summary

SI:NO	Description	Instance Type	Storage	Multi AZ	PIOPS	Cost ($)
1	Master × 1	db.r4.8xlarge	1000GB	YES	5000	8,051.84
2	Slave × 3	db.r4.4xlarge	1000GB	NO	5000	5,378.28
3	AWS Enterprise Support	NIL	NIL	NIL	NIL	0.00
TOTAL						$13,430.12

‍

Solution Provided by Mydbops

▶

Our Engagement

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed sit amet faucibus eros, et gravida nunc. Fusce vitae leo at felis placerat varius. Aenean mollis ligula sed ipsum elementum, ut sollicitudin libero tincidunt. Vivamus ultricies dolor sit amet orci aliquam, ac suscipit nisl posuere. Fusce id velit sed arcu fermentum scelerisque. Morbi ultricies auctor nisi id lobortis. Nam tempor tempor velit, sit amet ullamcorper ligula dapibus at.

▶

Implementation Strategy

Results and Impact

Key Outcomes

✅ 3x Boost in Query Performance

Optimized indexes and rewritten queries drastically reduced response time and improved application fluidity.

✅ $30,851 Saved Monthly

Instance downsizing + support cancellation resulted in a >70% reduction in monthly AWS costs.

✅ 3x Drop in CPU Load on Master Node

Reduced CPU spikes led to a more stable production environment.

✅ 2x Better Concurrency Handling

Users were able to browse and checkout during peak traffic with no locking issues.

✅ Improved Observability

Our team set up monitoring dashboards and health checks to ensure DB performance remains optimal long-term.

Results and Impact

Key Outcomes

✅

A brief context of the client’s operations and the challenges they were facing. Focus on business-critical pain points such as performance issues, high cost, downtime, etc.

✅

A brief context of the client’s operations and the challenges they were facing. Focus on business-critical pain points such as performance issues, high cost, downtime, etc.

✅

A brief context of the client’s operations and the challenges they were facing. Focus on business-critical pain points such as performance issues, high cost, downtime, etc.

This case study showcases how Mydbops can transform a struggling MySQL infrastructure into a lean, high-performing system — delivering real value in cost, performance, and scalability. The client was able to shift from firefighting mode to focusing on business growth.

If your database performance is draining your cloud budget or impacting your users, it’s time to talk to Mydbops. Let’s help you turn your database into a growth asset.

Let’s Cut Your AWS Costs

Recent Works

High Availability & Performance Boost for Fintech on MySQL RDS

Nykaa’s 70% AWS Cost Cut & 3X Performance Boost

Need Expert Database Solutions?

Talk to a Database Expert Today!

Thank You!

We’ve got your request, our expert team will be contacting you shortly.

Oops! Something went wrong while submitting the form.