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

Co-Founder & CTO, Yulu

Up
All

Challenges

01

Mydbops helped Yulu reduce storage by 72% and improve write scalability with a TiDB migration — enabling better performance for millions of urban users.

Mydbops replaced Yulu’s monolithic RDS MySQL with a scalable TiDB cluster, enabling distributed storage, seamless write scalability, and zero-downtime schema changes—while significantly reducing storage costs.

02

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.

03

Heading

04

Heading

05

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.

06

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.

07

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.

08

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.

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

  1. Item 1
  2. Item 2
  3. Item 3

Unordered list

  • Item A
  • Item B
  • Item C

Text link

Bold text

Emphasis

Superscript

Subscript

Key Benefits

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

Processor chip, symbolizing technology or database performance,

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.

It’s really impressive to see how Mydbops helped reduce our 18TB dataset down to just 3.4TB — a huge win in terms of efficiency and storage savings. As a valued partner, we truly appreciate your support and expertise in scaling Yulu’s infrastructure.

Naveen Dachuri

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.

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

Download Detailed Case Study

Client Overview

Yulu, a fast-growing urban mobility leader, serves millions through a network of IoT-enabled electric vehicles. With growing data from rides and operations, their RDS MySQL setup struggled — high IOPS, storage limits, and downtime risks. To scale and boost real-time performance, they needed a modern, cost-efficient database. Mydbops enabled a smooth TiDB migration, delivering greater scalability, 72% storage savings, and a future-ready data platform.
72
%
Storage Savings
Data volume optimized from 18TB to 3.4TB
99.999
%
Database Uptime
TiDB ensured uninterrupted service with built-in failover.
0 Downtime
During DDL Operations
Online schema changes without affecting app performance.
Real-time
Live Data Synchronization
Live replication enabled smooth switchover with near-zero RPO.
TiDB
Consulting Services
⭐️⭐️⭐️⭐️⭐️
It’s really impressive to see how Mydbops helped reduce our 18TB dataset down to just 3.4TB — a huge win in terms of efficiency and storage savings. As a valued partner, we truly appreciate your support and expertise in scaling Yulu’s infrastructure.
Naveen Dachuri
Co-Founder & CTO, Yulu
Deployment Type
Database Stack
Outcome
Cloud-Based Deployment
TiDB cluster on AWS
18 TerraByte → 3.4 TerraByte
Deployment Type
Cloud-Based Deployment
Database Stack
TiDB cluster on AWS
Outcome
18 TerraByte → 3.4 TerraByte

Business Challenges

Overview
Yulu’s fast-growing operations demanded a scalable and cost-efficient database layer. However, their monolithic MySQL setup was hitting limitations in terms of storage, write throughput, and availability.

‼️ Storage Bloat with Poor Compression: Yulu’s IoT data exceeded 18TB monthly. MySQL lacked efficient compression and smart storage handling, causing high IOPS demand, bloated AWS bills, and difficulty retaining historical data.

‼️ Write Bottlenecks During Traffic Spikes: RDS MySQL struggled with the volume of incoming IoT writes. During peak loads, IOPS throttling led to high write latency and occasional query failures.

‼️ Downtime from Schema Changes (DDL): DDL operations like adding columns in large MySQL tables led to locking and application slowdowns. Managing schema changes at scale was painful and risky.

‼️Low Availability with Single-Master Setup: A single-master database meant any failure caused downtime. Lack of automatic failover hurt service availability and user trust.

‼️ Scaling Limitations: The vertically scaled architecture couldn’t independently scale reads and writes. Replication lag and rigid scaling slowed performance during high demand.

Business Challenges

Overview
Yulu’s fast-growing operations demanded a scalable and cost-efficient database layer. However, their monolithic MySQL setup was hitting limitations in terms of storage, write throughput, and availability.
‼️
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:

Cut Storage & IOPS Costs: Reduce storage footprint and AWS expenses.

Improve Write Scalability: Handle high-volume IoT data without throttling.

Reduce DDL Downtime: Avoid app impact during schema changes.

Ensure High Availability: Eliminate single points of failure.

Adopt Scalable Architecture: Enable future growth with distributed design.

Goals
The key objectives the client was aiming to achieve:
→   
[Goal 1]
→   
[Goal 1]
→   
[Goal 1]

Solution Provided by Mydbops

Mydbops replaced Yulu’s monolithic RDS MySQL with a scalable TiDB cluster, enabling distributed storage, seamless write scalability, and zero-downtime schema changes—while significantly reducing storage costs.

In-depth Infrastructure & Workload Analysis

Our team began by auditing Yulu’s schema, indexes, and query patterns. We also studied traffic loads and application behavior to identify bottlenecks.

▸ Proposed & Deployed a Distributed TiDB Cluster

Based on Yulu’s scale and growth plans, we designed a production-grade TiDB architecture:

  • 3 TiKV (storage) nodes
  • 3 Placement Driver (PD) nodes
  • 2 TiDB SQL nodes

This ensured separation of compute and storage, fault tolerance, and distributed write/read operations.

▸ Live Migration Using DM Pipelines

To avoid long downtime, we used TiDB’s Data Migration (DM) tool. It allowed real-time replication from MySQL, letting Yulu continue operations on MySQL while data synced in the background.

▸ Efficient Storage with LSM Trees

TiDB’s TiKV storage engine uses Log-Structured Merge Trees, which optimize both disk I/O and compression. This led to a huge reduction in final storage size post-migration — from 18TB to 3.4TB.

▸ Enabled Online Schema Changes

We leveraged TiDB’s online DDL capabilities so schema changes could happen without locking tables — a major operational win over MySQL.

▸ High Availability Setup

TiDB’s automatic failover ensured availability, even if a node failed. This removed dependency on a single-master and minimized impact during maintenance or failure.

▸ Ongoing Performance Tuning & Best Practices

We optimized queries for distributed execution, reviewed resource usage, and established alerts and monitoring for proactive operations.

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
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.
Yulu's Scalable TiDB Architecture for Real-Time IoT Workloads This architecture manages millions of IoT records daily with zero downtime, real-time sync, and 72% storage savings. PD PD PD PD Cluster TiDB TiDB TiDB TiDB TiDB Cluster TiKV TiKV TiKV TiKV TiKV TiKV TiFlash TiFlash TiFlash Storage Cluster Application via MySQL Protocol TSO/Data location Metadata DistSQL API KV API

Results and Impact

Key Outcomes

✅  72% Storage Savings

Yulu’s disk usage dropped from 18TB to 3.4TB, saving costs on both storage and IOPS. The use of LSM trees in TiKV was critical in this outcome.

✅  Zero Downtime Schema Changes

DDL operations were now seamless and did not impact application availability. Developers could push schema updates with confidence.

✅  Improved Write Scalability

TiDB’s distributed architecture allowed writes to scale horizontally. The system handled traffic surges gracefully without hitting IOPS or compute bottlenecks.

✅  High Availability & Resilience

Automatic failovers and a multi-node setup removed single points of failure. This significantly increased reliability and reduced support escalations.

✅  Real-Time Sync with Minimal Cutover Risk

Thanks to live data replication during migration, Yulu experienced negligible downtime. The cutover to TiDB was smooth and controlled.

✅  Future-Ready for HTAP Workloads

Yulu is now positioned to explore Hybrid Transactional and Analytical Processing (HTAP), combining real-time operational workloads with in-depth analytical queries — all on TiDB.

Storage & Cost Optimization (MySQL ➝ TiDB) Metric Before (MySQL) After (TiDB) Change Data Size Total Storage 18 TB 3.4 TB ↓ 81% Storage Cost Monthly Expense High (SSD) Reduced (TiKV) Significant ↓ DDL Downtime Schema Changes High (Locking) Zero Eliminated IOPS Usage Performance Bottlenecked Smooth Optimized

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.

At the heart of every mobility revolution is data — and for Yulu, ensuring that data remains fast, scalable, and reliable was a non-negotiable need. With over 72% reduction in storage and dramatic improvements in write scalability, Yulu’s transformation wasn’t just technical — it was strategic. By partnering with Mydbops, they didn’t just migrate databases — they unlocked new possibilities, better cost efficiency, and peace of mind for their tech team.

This isn’t just a story about TiDB. It’s a story about choosing a partner who understands the urgency of performance, the weight of reliability, and the power of proactive architecture. If you're facing performance bottlenecks, spiraling cloud bills, or scalability roadblocks — you don’t have to solve them alone. We’re here to help.

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.
Download Case Study