Solving the Distributed Backup Headache: How TiDB Delivers Transactional Consistency
Distributed database backups are not just about coordinating the copying of files from multiple machines. It is capturing a single, consistent point in time across a system that is actively processing transactions. In TiDB, data is distributed across many nodes. Transactions use MVCC with a two-phase commit protocol. Transactions may touch multiple partitions at once. […]
Raft Region Size: The Invisible Lever for Distributed Database Performance
If you have ever tuned a distributed database, you have probably adjusted obvious knobs: CPU, memory, replication factor, concurrency limits. But there is a quieter setting, one that rarely gets headlines, that has an outsized impact on performance, reliability, and operational sanity: Raft region size. In TiDB, via TiKV, region size refers to the size […]
Teaching AI Agents to Speak “Production” SQL: Introducing TiDB Skills
AI coding agents are excellent at producing code that “works on my machine”. But as every database engineer knows, there is a massive gap between a query that runs in a local Docker container and one that survives in a high-concurrency production environment. We keep seeing the same issues arise when agents generate SQL based […]
Seamless TiDB Cloud Upgrades: Replicating Production Workloads with Traffic Replay
Database upgrades are often a source of “performance anxiety.” Even with extensive testing, the gap between a sterile staging environment and the chaotic reality of production—characterized by shifting SQL parameters, bursty concurrency, and complex execution contexts—often leads to unexpected post-upgrade regressions. Traffic Replay on TiDB Cloud, an internal-only tool currently in development for a wider […]
Memory Fragmentation in Linux: What It Is, Why It Hurts, and How to Fix It
Managing memory in a high-performance database environment isn’t just about having enough RAM; it’s about how that RAM is organized. For SREs and DBAs, understanding the nuances of the Linux kernel’s memory management can be the difference between a smooth-running system and unpredictable tail latency. In this post, we’ll break down the core mechanics of […]
MySQL Alternatives at Scale: Why TiDB Beats MariaDB
Dive deep into two popular MySQL alternatives and discover why TiDB is a better option for extreme scalability and real-time analytics.
How Bling Migrated a Mission-Critical 25TB MySQL Database to TiDB
Every fast-growing SaaS platform eventually faces the same reality: scaling a single massive database becomes increasingly risky and expensive. At Bling (Part of the LWSA Group), a leading SaaS ERP platform serving the e-commerce markets in Brazil and Mexico, we hit this ceiling hard. Founded in 2009, Bling powers over 300,000 daily active users and […]
Build Fast. Run Lean. Why Mid-Market Teams Choose TiDB Cloud Essential
If you’re building software today, you’ve probably felt it: shipping new features takes longer than it should, and your database bill is higher than it needs to be. Not because your team isn’t capable. And not because your product is uniquely complex. But the data layer has quietly become the biggest drag on velocity and […]
Distributed SQL Database: Architecture, Scale, and High Availability
A distributed database is any system that spreads data across multiple nodes. However, a distributed SQL database is a stricter subset: it keeps full SQL semantics and ACID transactions, automatically partitions data for horizontal scale, and uses consensus replication (e.g., Raft) so writes are consistent and failover is predictable. In short, distributed SQL gives you […]
How Atlassian Scaled to 3M+ Tables: Multi-Tenant Control with TiDB
Atlassian is an enterprise software company that runs one of the world’s largest SaaS platforms. Best known for Jira, Confluence, Trello, and Bitbucket, the company helps teams plan, build, and run software. As tenant counts and compliance demands grew, Atlassian hit the limits of shared and siloed multi-tenancy models on a massive sharded PostgreSQL estate. […]
Effective MySQL Online DDL: Making Critical Database Schema Changes with Zero Downtime
Online Data Definition Language (DDL) is a crucial feature for modern databases and a cornerstone of MySQL modernization strategies. It allows schema changes without significant downtime or locking that could disrupt database operations. This means these operations carry out while the database continues to be available for reads and writes, minimizing downtime and avoiding disruption […]
How Manus 1.5 Uses TiDB X to Let Agents Ship Full-Stack Apps at Scale
Software is shifting from developer-driven to agent-driven. With Manus 1.5, AI agents don’t just “help you code”; they spin up full-stack applications end-to-end. Ideas move from prompt to deployed app in minutes. It’s a glimpse of what’s next: rapid iteration, parallel exploration, and continuous change without human bottlenecks. That speed creates a new reality for […]