Product

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

Author: Xiaolei Dai, Database lead at Zhihu Efficient and reliable data migration is crucial for large-scale online services. Zhihu, one of China’s largest knowledge-sharing platforms, recently undertook the complex task of online migration for dozens of TiDB databases, totaling petabytes (PB) of data. This blog post, based on the expertise of Zhihu’s database lead, Dai […]

Discover how Kissflow moved from a traditional SQL-based system to a unified data strategy leveraging Hybrid HTAP.

During the recent HTAP Summit, I had the honor of celebrating another successful TiDB Future App Hackathon and announcing our winners. This year, we had close to 2,100 participants–about 40% increase from 2023–joining us from 80+ countries. If you visit the Hackathon project gallery, you will be able to see the winners and all other […]

The role of relational databases in processing large data volumes at scale has never been more critical. But what’s next for these databases as demands for AI and real-time operational intelligence add greater technical complexity? Join us at HTAP Summit 2024 for answers to this question (and more!) This event is a one-stop destination for […]

Online Data Definition Language (DDL) is a crucial feature for modern databases. 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 to ongoing activities. Online DDL is particularly […]

In the era of cloud computing and Software as a Service (SaaS), it’s essential to optimize resource use and scalability in databases. Multi-tenant architecture meets these needs by allowing a single database instance to serve multiple customers, or tenants. This ensures each tenant’s data remains isolated and secure, leading to enhanced cost efficiency, simplified management, […]

HTAP Summit, the only industry-leading conference focused on Hybrid Transactional/Analytical Processing (HTAP), has officially opened its 2024 call for proposals. Now in its third year, HTAP Summit, organized by PingCAP, gathers database experts, innovators, and enthusiasts to share knowledge and experience about distributed database architecture, real-time operational intelligence and ways modern data technologies can drive […]

This blog introduces Web3Bench, a hybrid transaction/analytical processing (HTAP) benchmark that addresses earlier limitations. Web3Bench is based on real-world Web3 use cases that utilize HTAP. Our data model is a simplified version of the decentralized blockchain Ethereum. We leverage a sample data set from Ethereum to build a scale factor-based data generator. The workload in […]

Database sharding is a data architecture strategy that increases database performance by splitting up data into chunks and then spreading these chunks “intelligently” across multiple database servers (or database instances). These chunks of data are called shards, while each shard contains a subset of our data. All shards represent the entire set of data, and […]

In this blog, we introduce TiDB Index Advisor—or TiAdvisor for short—a novel tool that automates index discovery to enhance user workload performance. We also outline the techniques employed in building this tool and provide use cases that validate its results. Why Do We Need a TiDB Index Advisor? Database indexes provide faster access to data. […]

Transactions—especially distributed transactions—are ubiquitous. Protocols around transactions are equally ubiquitous, even if we don’t immediately realize it. Take, for example, a common marriage ceremony. It’s essentially a two-phase commit (2PC) protocol. The officiant is the transaction coordinator (TC), and the couple getting married are the active participants. In the first phase, the TC asks each […]