Scaling Databases with TiDB: AWS Community Day Bangalore 2025
Source: Dev.to
Senior Solution Architect Ankit Kapoor (TiDB) – “From Startup to Scale‑up: Your Database’s Growth Journey”
This is for you if you’ve ever struggled with database scaling.
The Problem We All Face
Manual Configuration Nightmares
- Shard mapping must be configured manually.
- Cross‑shard searches add needless complexity to application code.
- Under heavy load, concurrency constraints cause row‑level locking.
- Numerous housekeeping tasks consume valuable time.
Vertical Scaling Hits a Wall
- Mutex contention creates a bottleneck.
- Growth is limited by shared‑resource bottlenecks.
- Commodity hardware suffers from OOM problems and low CPU utilization.
Performance Issues That Hurt
- Writes remain a bottleneck while reads scale.
- Only eventual consistency is achievable.
- Analytical queries perform poorly on row‑based storage.
- Semantic search is sluggish.
Does that sound familiar? Most of us have been there – which is why…
What Is Distributed SQL?
Distributed SQL is not just a buzzword. It combines the best of both worlds:
- Horizontal scale of NoSQL databases.
- Transactional guarantees (ACID) of relational databases.
Scalability + ACID compliance = a powerful combination.
Enter TiDB: The Open‑Source Solution
Why TiDB Caught My Eye
- Founded: 2015 – 100 % open source.
- GitHub: 38 k+ ⭐ showing strong developer interest.
- Contributors: 800 + people continuously improving it.
- Adopters: 10 k + worldwide, 8 k + active Slack users.
Big‑name users: Pinterest, CAPCOM, Conga, Bolt, Ninja, and > 4 k enterprise adopters across 25 countries.
How TiDB Works – Architecture Made Simple
TiDB’s architecture is split into four primary components:
-
Compute Layer
- Handles SQL processing & query optimization.
- MySQL‑compatible (huge win for migration!).
-
Row Store
- Distributed key‑value storage.
- Ideal for OLTP workloads with strong consistency.
-
Columnar Store
- Enables real‑time analytics on transactional data.
- Uses a columnar engine for analytical queries.
-
Placement Driver (PD)
- Manages metadata.
- Automatically balances data distribution across nodes.
Key advantage: Storage and computation are completely decoupled, allowing independent scaling.
TiDB vs. Traditional Databases – The Real Difference
| Traditional DB | TiDB |
|---|---|
| Single‑master configuration. Read replicas use transaction‑log replication for reads; one instance handles writes. | Multiple TiDB instances handle both reads and writes concurrently while preserving ACID guarantees. |
| Computation layer is tied to storage. | Stateless, horizontally‑scalable compute layer. |
| Storage scaling is limited. | TiKV (storage layer) is horizontally scalable with many replicas. |
What This Means for DBAs
- Horizontal Scaling: Automatic sharding & seamless scaling – no manual intervention.
- 99.99 % Availability: Auto‑failover & self‑healing keep data accessible.
- Mixed Workloads: AI, analytical, and transactional workloads run on a single database.
- Strong Consistency: ACID transactions with global data integrity.
- Security: Enterprise‑grade encryption in‑flight and at‑rest.
- MySQL Compatibility: Easy migration path for existing MySQL users.
- Multi‑Cloud: Deploy on any preferred cloud platform.
- 100 % Open Source: Transparent, community‑driven development.
The Operational‑Simplicity Win
TiDB ships with integrated Grafana & Prometheus dashboards – instant monitoring, performance metrics, and health data out‑of‑the‑box, with no extra setup.
For teams lacking dedicated DevOps resources, this is a game‑changer.
Three Deployment Options on AWS
| Option | Description | Pricing | Availability |
|---|---|---|---|
| TiDB Cloud Serverless | Fully managed, effortless scalability. | Pay‑as‑you‑go. | 99.99 % (currently 99.9 %). |
| TiDB Cloud Dedicated | Fully managed, high performance. | Subscription starting at $2 / hour (volume discounts available). | 99.99 %. |
| TiDB Self‑Managed | Self‑managed for maximum control. | Custom pricing. | Premium support available. |
Conclusion
The AWS Community Day Bangalore session re‑shaped my view of database architecture. Traditional databases served us well for years, but modern applications demand more. TiDB delivers true scalability without sacrificing SQL or ACID guarantees.
- Proven at large enterprises.
- Open‑source and production‑ready.
If your current database is hitting scaling limits—or you’re designing a new system that must grow—TiDB belongs on your evaluation list.
AWS Community Day Bangalore continues to provide insightful, real‑world content from professionals tackling genuine challenges.
Session Highlight
Sessions like Ankit’s serve as a reminder of the importance of community gatherings, since they provide us with solutions that we might not otherwise come across.
References
Event
- Name: AWS Community Day Bangalore 2025
- Topic: Scaling Databases with TiDB
- Date: May 23, 2025
- Location: Conrad, Bengaluru
Also Published On
- AWS Builder Center
- Hashnode