How Mydbops Scaled Dream11’s Aurora MySQL for IPL Peak Load

2024

CIO, Dream11, India 🇮🇳

All

Challenges

See how Mydbops enabled Dream11, India’s top fantasy sports platform, to handle 200K TPS during IPL with zero downtime and 20X performance boost.

To address Dream11’s database performance and scalability challenges, Mydbops implemented a holistic optimization and support strategy combining on-site expertise, architectural improvements, and 24x7 remote coverage:

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

Mydbops really helped us scale 20X in a very short span. They are excellent at database optimization, security, and maintenance. Above all, their attitude toward owning the client’s problems and treating them as their own is absolutely mind-blowing. Highly recommended.

Abhishek Ravi

Recent Works

Yulu's Data Breakthrough: 72% Storage Savings & Scalability with TiDB

High Availability & Performance Boost for Fintech on MySQL RDS

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.

How Mydbops Scaled Dream11’s Aurora MySQL for IPL Peak Load

Download Detailed Case Study

Client Overview

With the world’s largest population and a cricket craze like no other, India turns into a digital stadium during the IPL season. At the heart of this frenzy is Dream11, India’s #1 fantasy sports platform, serving over 14 million users across cricket, football, and kabaddi. With 1.5 million+ requests per minute during peak hours, Dream11 needed a database backbone that could scale instantly—without a second of delay or downtime.

↑

↓

200

Transactions per second

Writer node scaled to 200K transactions/sec

↑

↓

Performance Boost

Query performance improved by 20X

Zero

↑

↓

Downtime

Zero service interruption during major fixes

24x7x365

↑

↓

DB Coverage

Round-the-clock support by Remote DBA team

MySQL

Consulting Services

⭐️⭐️⭐️⭐️⭐️

Abhishek Ravi

CIO, Dream11, India 🇮🇳

Deployment Type

Database Stack

Outcome

Hybrid Cloud Deployment

Aurora MySQL on AWS Cloud

200K+ Transactions per second

Deployment Type

Hybrid Cloud Deployment

Database Stack

Aurora MySQL on AWS Cloud

Outcome

200K+ Transactions per second

Business Challenges

Overview

Here’s a snapshot of the key database challenges Dream11 faced before partnering with Mydbops.

‼️ Crash at 6K QPS (Queries Per Second): The Aurora writer node would fail once traffic spiked beyond 6,000 QPS. This instability risked outages during IPL matches—when user activity was highest.

‼️ Scalability Ceiling on Highest Aurora Tier: Despite using top-tier Aurora infrastructure, Dream11 faced vertical scaling limitations. Aurora instances had hit their peak compute and I/O limits.

‼️ No MySQL-native Scaling Strategy: The system lacked effective horizontal scaling or partitioning strategies aligned with MySQL best practices for large user bases.

‼️ Insufficient 24/7 Database Coverage: Dream11 required hands-on, round-the-clock DBA support to monitor spikes and proactively handle issues during critical game events.

Business Challenges

Overview

Here’s a snapshot of the key database challenges Dream11 faced before partnering with Mydbops.

‼️

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:

→ Scale for Peak IPL Traffic: Handle 10X load spikes during key moments like team announcements and toss.

→ Zero-Downtime Enhancements: Apply schema and query changes without disrupting the live user experience.

→ Boost Query Performance: Refactor queries and eliminate full-table scans to improve TPS and latency.

→ Round-the-Clock Reliability: Enable 24x7 monitoring with a Remote DBA team for proactive support.

Goals

The key objectives the client was aiming to achieve:

→

[Goal 1]

→

[Goal 1]

→

[Goal 1]

Solution Provided by Mydbops

▸ On-Site Performance Audit at Mumbai HQ:

Mydbops consultants were deployed on-site to work closely with Dream11’s engineering team. The audit included slow query log analysis, performance schema inspection, and load testing simulations.

‍

▸ Schema Refactoring & Partitioning:

Tables receiving heavy writes were horizontally partitioned based on match/event IDs. This significantly reduced IOPS and improved insert throughput.

‍

▸ Query Optimization & Indexing:

Indexing strategy was realigned to actual access patterns. Joins and SELECTs were restructured to avoid temporary tables and reduce latency.

‍

▸ Zero-Downtime Rollouts with Online DDL:

All critical changes were made using online DDL strategies like pt-online-schema-change, ensuring no disruption to end users.

‍

▸ Aurora Parameter Tuning & Writer Scaling:

Aurora configurations such as innodb_buffer_pool_size, max_connections, and read/write splitting were optimized to squeeze maximum performance from the writer.

‍

▸ 24x7 Remote DBA Setup:

Mydbops deployed a dedicated Remote DBA pod that provided real-time alerts, incident response, and health checks across all critical components.

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

✅ 200K TPS on Aurora Writer

Dream11 successfully handled over 200,000 transactions per second, during the IPL toss and match start windows—their peak times.

‍

✅ 20X Query Performance Boost

Optimized queries executed significantly faster, reducing CPU and I/O consumption and allowing for smoother user experiences even at high scale.

‍

✅ Drastic Drop in Load and Crashes Eliminated

Post-optimization, no DB crashes were observed—even under IPL match loads. System stability reached an all-time high.

‍

✅ Cloud Infra Usage Became Cost-Efficient

With optimized query execution paths and partitioning, Dream11 got more out of their existing Aurora instances—delaying the need for costlier vertical scaling.

‍

✅ Compliant and Efficient Data Archival

Partitioning also enabled easy archival of old match data, aligning with compliance needs and reducing table bloat.

‍

✅ 24x7 Incident-Free IPL Season

Thanks to proactive monitoring, all IPL matches were supported without a single unplanned DB incident.

‍

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.

When your platform is expected to perform under the pressure of millions of concurrent users—especially during high-stakes events like the IPL—you need more than just infrastructure. You need expert-led database engineering. Mydbops helped Dream11 scale, stabilize, and thrive during peak demand with Aurora MySQL optimizations, zero-downtime rollouts, and 24x7 expert coverage.

‍

Ready to scale your database like Dream11? Let Mydbops engineer your database for maximum performance and zero disruptions—whether you're expecting 10X traffic surges or need continuous uptime.

Book a Free DB Strategy Call

Recent Works

Yulu's Data Breakthrough: 72% Storage Savings & Scalability with TiDB

High Availability & Performance Boost for Fintech on MySQL RDS

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.