Scaling Beyond Limits: How EasyPost Future-Proofed Its Infrastructure with Distributed SQL
When legacy infrastructure hits its limits, innovation isn’t just a choice — it’s a necessity. For EasyPost, a leader in logistics technology, scaling up meant more than just more hardware. It meant a fundamental shift in their approach to data. In this customer story, we explore how EasyPost’s infrastructure team, led by Head of Infrastructure […]
Secure by Design: How TiDB Cloud Protects Your Data and Simplifies Compliance
When security controls fail, the consequences aren’t just technical—they’re financial, legal, and reputational. A single database misconfiguration cost one company $10 million in fines. TiDB Cloud prevents these risks, offering enterprise-grade security without unnecessary complexity. In this post, we’ll explore how TiDB Cloud protects your data, compare the security features of its Serverless and Dedicated […]
Optimizing Backup Verification: How to Enhance Performance and Reliability in TiDB
With the release of TiDB 8.5, TiDB BR (Backup & Restore) has made a significant change: Full-table checksum verification is now turned off by default during backups. This update boosts backup efficiency by cutting unnecessary overhead while keeping data integrity intact. In this post, we’ll explain how TiDB has optimized backup verification, the expected performance […]
TiDB Index Optimization: Detect and Remove Unused Indexes for Better Performance
Indexes are essential for optimizing database query performance, reducing the need to scan large amounts of data. However, as applications evolve, business logic changes, and data volume grows, indexing inefficiencies emerge. This leads to: Left unaddressed, these indexing issues can cause higher storage costs, degraded performance, and operational inefficiencies. That’s why regular index audits are […]
Accelerating Query Performance: The Benefits of TiDB’s In-Memory Engine (IME)
If you’ve ever struggled with slow queries or high resource consumption in your database, you’re not alone. Many databases, including those built on Multi-Version Concurrency Control (MVCC), face query performance degradation over time. While MVCC is essential for managing concurrent access, excessive historical data scanning can slow down queries and overload system resources — a […]
Comparing Vitess and TiDB: Cross-Shard Queries, Consistency, and AZ Outages
TiDB focuses on simplicity, transparency, and high availability, providing a robust foundation for distributed SQL workloads. While concerns about cross-shard queries and availability zone (AZ) outages are valid, TiDB’s architecture minimizes these risks, ensuring reliable and efficient application performance. However, when comparing TiDB and Vitess — an orchestrator for sharded MySQL instances — the architectural differences […]
Time’s Up! How TiDB Efficiently Handles Expired Data
Managing large-scale data efficiently is a critical challenge for modern databases, especially when dealing with time-sensitive data that can quickly become outdated. Starting from TiDB 6.5 and becoming generally available in TiDB 7.0, TTL (Time To Live) automates the deletion of expired data, offering a powerful, customizable solution for maintaining data freshness while minimizing operational […]
Unleashing 50x Performance: In-Depth Analysis of TiDB DDL Framework Optimizations
Managing schema changes in traditional databases often leads to downtime, blocking, and operational complexity. TiDB has long simplified this process with its online DDL capabilities, allowing developers to evolve their databases without disrupting applications. As user bases and data volumes have surged, however, index creation was increasingly becoming a performance bottleneck. To address this, we […]
Node Groups in TiDB Cloud: The Key to Scaling Workloads with Predictable Performance and Control
As modern applications scale, ensuring consistent, predictable performance across different workloads becomes increasingly challenging. Transactional queries, real-time analytics, and batch jobs often compete for resources, leading to slowdowns, inefficient resource allocation, and unpredictable database behavior. With Node Groups in TiDB Cloud, organizations can assign dedicated TiDB node compute resources to specific workloads within a single […]
TiDB Cloud CONNECTED Care: Elevate Your Support with Seamless, Real-Time Connectivity
TiDB Cloud has always delivered a high-performance, distributed SQL solution. However, we’re now taking it a step further with TiDB Cloud CONNECTED Care, our refreshed support service. Whether you’re a new customer exploring TiDB Cloud or an existing user looking to upgrade to Enterprise or Premium tiers, CONNECTED Care offers seamless, real-time connectivity, ensuring you […]
Blazing-Fast Cluster Recovery: How TiDB 8.1 Redefines Large-Scale Data Restoration
Backup and restore are critical for ensuring business continuity, with the Recovery Time Objective (RTO) serving as a key metric for assessing restore performance. As TiDB continues to grow in popularity for its scalability, many users have datasets reaching hundreds of terabytes (TBs). That means the challenge of ensuring a fast RTO for such large […]
4 Database Trends Data-Intensive Businesses Need to Watch in 2025
It’s that time of year again for a look back at the database industry. 2024 wasn’t so much about groundbreaking database technologies, but rather the explosive growth of AI-plus-data applications. That said, core database tech hasn’t remained idle either, as cloud infrastructure became the de facto standard for deployment. So, without further adieu, here are […]