Explore distributed database architecture, performance optimization, high availability, data availability, HTAP workloads, DFX and AI workload ready database design with TiDB, TiKV, TiFlash, and TiDB X architecture
Key Features
- Understand the architecture and internals of TiDB, TiKV, TiFlash, PD, and TiDBX
- Optimize distributed database performance through SQL tuning, indexing, monitoring, and configuration management
- Design scalable, high-availability, HTAP, cloud-native, and AI-oriented database architectures
Book Description
Modern data platforms must scale elastically, remain available under submodule or data center failure, and support transactional, analytical, and AI-driven workloads without increasing operational complexity. This book uses TiDB as a production-grade reference architecture to explain how distributed SQL databases are designed, tuned, and operated at scale. You will begin with TiDB's architectural foundations, exploring how the SQL layer, TiKV, Placement Driver, Raft, MVCC, distributed transactions, and TiFlash work together to deliver horizontal scalability, strong consistency, and HTAP capabilities. You will then learn practical performance engineering, including table and index design, execution plan analysis, SQL optimization, monitoring, diagnostics, and configuration tuning. Next, you will examine scenario-based architectures covering high availability, asynchronous replication, online DDL, data consolidation, resource control, cloud-native deployment, DFX, and production data availability strategies. The final part introduces TiDB X and explores how database architecture is evolving for AI agents and intelligent cloud applications. By the end, you will be able to reason about TiDB from first principles, diagnose performance, and design resilient, cloud-native, AI-ready distributed database architectures with confidence.
What you will learn
- Understand TiDB architecture and distributed database principles
- Explore TiKV, TiFlash, PD, Raft, MVCC, and distributed transactions
- Optimize tables, indexes, SQL execution plans, and system configurations
- Monitor, diagnose, and troubleshoot database performance issues
- Design high-availability, asynchronous replication, and HTAP architectures
- Implement online DDL, resource control, and cloud-native optimization strategies
- understand TiDB X and AI-agent-oriented database design
- Apply distributed database concepts to production scenarios
Who this book is for
This book is for database architects, DBAs, backend engineers, SREs, platform engineers, cloud architects, and technical leaders who design, evaluate, or operate distributed SQL systems. It is especially useful for teams adopting TiDB for high-scale OLTP, real-time analytics, HTAP, SaaS, data consolidation, or cloud-native modernization. Readers should be comfortable with relational databases and SQL; familiarity with distributed systems, replication, Kubernetes, or performance troubleshooting will help but is not required.
