Product

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 […]

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 […]

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 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 […]

What if you could interact with your data just like you would with a colleague? No need for complicated SQL queries or advanced data analysis tools—just ask your data a question and get an immediate, clear answer. Sounds like magic, right? Well, it’s not. It’s TiDB’s Chat2Query, and it’s changing the game in how businesses […]

In today’s fast-paced business world, quick, data-driven decisions are crucial. However, for many, data analysis can seem daunting, especially without the technical skills to navigate complex databases. That’s where TiInsight shines: an intuitive and innovative platform built with the Chat2Query OpenAPI, designed to allow you to gain clear, actionable insights from complex data. An open-source […]

TiDB is a powerful, open-source distributed SQL database built for handling both transactional and analytical workloads. With its MySQL compatibility, horizontal scalability, and real-time HTAP capabilities, it’s designed for modern, cloud-native architectures. In this distributed SQL tutorial, we’ll walk you through setting up a local TiDB cluster for development and testing in just a few […]

Managing large transactions in distributed databases has always been a tough nut to crack. From processing millions of records during migrations to tackling complex workflows like ETL (Extract, Transform, Load), businesses need database solutions that are not only fast but also reliable. TiDB has long been at the forefront of distributed SQL database innovation, and […]

In today’s data-driven world, efficiently handling complex queries on large datasets is critical to keeping applications responsive and performant. For TiDB, a distributed SQL database designed to manage high-scale, high-demand environments, optimizing data access paths is essential to delivering smooth, efficient queries. This post dives into TiDB’s advanced approach to optimizing multi-column indexes. This is […]

Data loss can occur while using a database for various reasons, such as operator error, malicious hacker attacks, and server hardware failures. Backup and recovery technology is the final line of defense to ensure data can still be restored and used after such losses.  TiDB, as a native distributed database, fully supports various backup and […]

In the rapidly evolving field of artificial intelligence, generative AI (GAI) stands out as one of the most fascinating and groundbreaking advancements. GAI represents a major leap forward, enabling machines to generate original and creative content across various domains, including conversations, stories, images, videos, and music. As companies seek to harness the potential of GAI, […]

Today, it’s normal for apps to be available at any time of day, no matter where you are in the world. But to meet that expectation, you need to make sure your infrastructure can scale to match demand, work around failure, and maintain consistent performance. The good news is that several database platforms promise to […]