Embracing NewSQL: Why We Chose TiDB over MongoDB and MySQL

In this post, PalFish explains why they chose TiDB over MongoDB and MySQL. The key factors were their application requirements and their perspective on NewSQL databases. | Continue reading


@pingcap.com | 3 years ago

How to Scale Out a Real-Time Data Warehouse for Second-Level Analytics

By combining Apache Flink and TiDB, we offer an efficient, easy-to-use, real-time data warehouse with horizontal scalability and high availability. | Continue reading


@pingcap.com | 3 years ago

Why PalFish Chose TiDB over MongoDB

In this post, PalFish explains why they chose TiDB over MongoDB and MySQL. The key factors were their application requirements and their perspective on NewSQL databases. | Continue reading


@pingcap.com | 3 years ago

Flink and TiDB: A Scale-Out Real-Time Data Warehouse for Second-Level Analytics

By combining Apache Flink and TiDB, we offer an efficient, easy-to-use, real-time data warehouse with horizontal scalability and high availability. | Continue reading


@pingcap.com | 3 years ago

DM 2.0 GA: Secure, Easy, Highly Available Data Migration

DM 2.0 has reached general availability. It supports highly available migration tasks and shard merging and migration in optimistic mode. | Continue reading


@pingcap.com | 3 years ago

Choosing Enterprise-Grade Disaster Recovery Solution for the Financial Industry

Financial companies have stringent requirements for high availability and disaster recovery, which many databases cannot meet. This article describes how TiDB addresses both these issues with a range of options that make it an excellent choice for the industry. | Continue reading


@pingcap.com | 3 years ago

Metrics Relation Graph Helps DBAs Quickly Locate Performance Problems

TiDB v4.0.7 introduced a new feature: the metrics relation graph. It helps users clearly see the relationship between different performance metrics in a database cluster and thus quickly locate the root causes of performance problems. | Continue reading


@pingcap.com | 3 years ago

Metrics Relation Graph Helps DBAs Quickly Locate Performance Problems in TiDB

TiDB v4.0.7 introduced a new feature: the metrics relation graph. It helps users clearly see the relationship between different performance metrics in a database cluster and thus quickly locate the root causes of performance problems. | Continue reading


@pingcap.com | 3 years ago

Making an HTAP Database a Reality: What I Learned from PingCAP's VLDB Paper

Recently, VLDB published the PingCAP paper, TiDB: A Raft-based HTAP Database. In this article, a DBA at PalFish shares his thoughts on the article and his expectations for TiDB's future development. | Continue reading


@pingcap.com | 3 years ago

Migrating from Exadata to a Scale-Out HTAP Database for Near Real-Time Analytics

As its business quickly grew, ZTO Express found Exadata, Kudu, and HBase couldn't meet their database requirements. They migrated from Exadata to TiDB to scale out their database and perform multi-dimensional analytics in near real time. | Continue reading


@pingcap.com | 3 years ago

Bank of China Uses a Scale-Out Database to Support Zabbix Monitoring at Scale

To monitor their large-scale IT infrastructure, Bank of China chose TiDB, a scale-out relational database, to replace Zabbix's MySQL backend. Learn how they use TiDB to manage over 10,000 monitored devices and 18 TB data. | Continue reading


@pingcap.com | 3 years ago

TiCDC GA: Offering High-Availability Replication Services for Production

TiCDC is TiDB's change data capture framework. It is now generally available. This post introduces its features, application scenarios, and real-world case studies. | Continue reading


@pingcap.com | 3 years ago

TiCDC Offers High-Availability Replication Services for Production Environments

TiCDC is TiDB's change data capture framework. It is now generally available. This post introduces its features, application scenarios, and real-world case studies. | Continue reading


@pingcap.com | 3 years ago

Using a Distributed Database to Achieve Horizontal Scaling Without Downtime

Bank of Beijing sought an open-source, horizontally scalable database to scale out their database. Learn how they use TiDB to achieve database scaling with zero downtime. | Continue reading


@pingcap.com | 3 years ago

Lessons from TiDB's No. 1 Bug Hunters Who've Found 400 Bugs in Popular DBMSs

Dr. Manuel Rigger and his colleague have found 400+ bugs in popular DBMSs, including 50+ TiDB bugs. Learn their experience in finding logic bugs in DBMSs. | Continue reading


@pingcap.com | 3 years ago

Lessons from TiDB's No. 1 Bug Hunters Who've Found 400 Bugs in Popular DBMSs

Dr. Manuel Rigger and his colleague have found 400+ bugs in popular DBMSs, including 50+ TiDB bugs. Learn their experience in finding logic bugs in DBMSs. | Continue reading


@pingcap.com | 3 years ago

Chaos Mesh 1.0: Chaos Engineering on Kubernetes Made Easier

Today, we are proud to announce the general availability of Chaos Mesh® 1.0, following its entry into CNCF as a sandbox project in July, 2020. After 10 months of effort within the open-source community, Chaos Mesh is now ready in terms of functionality, scalability, and ease of u … | Continue reading


@pingcap.com | 3 years ago

We Use a Scale-Out HTAP Database for Real-Time Analytics and Complex Queries

Xiaohongshu receives more than 100 million rows of data every day. They adopted TiDB because it supports both transactional and analytical queries, real-time data analytics, and horizontal scalability. | Continue reading


@pingcap.com | 3 years ago

Chaos-Mesh-Action: Integrate Chaos Engineering with GitHub Action

Chaos Mesh is a cloud-native chaos testing platform that orchestrates chaos in Kubernetes environments. This article shares how to use chaos-mesh-action, a GitHub action to integrate Chaos Mesh into the CI process. | Continue reading


@pingcap.com | 3 years ago

TiDB Operator: Database Operations Expert in Kubernetes

This post analyzes the pros and cons of running databases in Kubernetes. It also introduces TiDB Operator, a tool for managing TiDB clusters in Kubernetes, and describes how large companies are using it in their production environments as well as their best practices. | Continue reading


@pingcap.com | 3 years ago

TiDB Operator: Your TiDB Operations Expert in Kubernetes

This post analyzes the pros and cons of running databases in Kubernetes. It also introduces TiDB Operator, a tool for managing TiDB clusters in Kubernetes, and describes how large companies are using it in their production environments as well as their best practices. | Continue reading


@pingcap.com | 3 years ago

We Build an HTAP Database That Simplifies Your Data Platform

This post talks about why HTAP matters in a database platform, how TiDB implements HTAP, and how you can apply TiDB in different scenarios. | Continue reading


@pingcap.com | 3 years ago

We Chose an HTAP Database over MySQL for Horizontal Scaling and Complex Queries

After trying out different database solutions, BIGO chose TiDB. In this post, a BIGO DBA talks about TiDB 4.0's new features, how they benefit BIGO's business, and BIGO's plan to use TiDB 4.0 even more in the future. | Continue reading


@pingcap.com | 3 years ago

HTAP Support in TiDB Cloud

Today, we're glad to announce that TiDB Cloud, our fully managed database service powered by TiDB, now supports Hybrid Transactional/Analytical Processing (HTAP) workloads. | Continue reading


@pingcap.com | 3 years ago

How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud

This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning. | Continue reading


@pingcap.com | 3 years ago

PingCAPers Make Their Debut at VLDB

The 46th VLDB conference will be broadcast online from August 31st to September 4th. PingCAP is honored to attend this conference, and we will share two papers with you TiDB: A Raft-based HTAP Database and Interleaved Multi-Vectorizing. | Continue reading


@pingcap.com | 3 years ago

Celebrate TiKV Graduation Within CNCF

The Cloud Native Computing Foundation (CNCF) today just announced that TiKV has become the twelfth project to graduate, joining other graduated projects such as Kubernetes, Jaeger, Harbor, etc. | Continue reading


@pingcap.com | 3 years ago

We Chose a Distributed SQL Database to Complement MySQL

VIPKid chose TiDB to manage its high data volume, highly concurrent write application. Learn how TiDB excels in that scenario, along with multidimensional queries, data life cycle management, and real-time analytics. | Continue reading


@pingcap.com | 3 years ago

PingCAP Successfully Completes SoC 2 Type 1 Examination for TiDB Cloud

PingCAP, provider of the cloud-native hybrid transactional/analytical processing (HTAP) TiDB database, successfully completes an SOC 2 Type 1 examination for TiDB Cloud. | Continue reading


@pingcap.com | 3 years ago

TiDB Cloud: Managed SQL at Scale on AWS and GCP

This post introduces in detail the features of TiDB Cloud - the fully managed, horizontally scaling, cloud-native, distributed SQL database in the cloud. | Continue reading


@pingcap.com | 3 years ago

Building an Automated Testing Framework Based on Chaos Mesh and Argo

This article describes how we use TiPocket, an automated testing framework, to build a full Chaos Engineering testing loop for TiDB. | Continue reading


@pingcap.com | 3 years ago

Japan's Largest Mobile Payment Company Migrates from Aurora to TiDB

As PayPay's business grew, their payment management database became a bottleneck. Learn why PayPay chose TiDB over Aurora to handle their most crucial data and how efficiently they migrated to TiDB. | Continue reading


@pingcap.com | 3 years ago

Create a Scale-Out Hive Cluster with a Distributed, MySQL-Compatible Database

This post shows how to deploy a Hive cluster with TiDB to achieve horizontal scalability of Hive Metastore. | Continue reading


@pingcap.com | 3 years ago

How TiDB's HTAP Makes Truly Hybrid Workloads Possible

This post introduces the design details of the HTAP architecture of TiDB, including the real-time updatable columnar engine, the multi-Raft replication strategy, and smart selection. | Continue reading


@pingcap.com | 3 years ago

Early Impressions of Go from a Rust Programmer

Nick Cameron is a long-time Rust programmer who has recently started using Go. In this post, he talks about his early impressions of Go. Read this post to learn more. | Continue reading


@pingcap.com | 3 years ago

Cluster Diagnostics: Troubleshoot Cluster Issues with a Minimal Learning Curve

TiDB 4.0 introduces cluster diagnostics, a built-in widget in TiDB Dashboard, which lets you diagnose cluster problems within a specified time range. You can summarize the diagnostic results and cluster-related load monitoring information in a diagnostic report. | Continue reading


@pingcap.com | 3 years ago

Cluster Diagnostics: Troubleshoot Cluster Issues Using Only SQL Queries

TiDB 4.0 introduces cluster diagnostics, a built-in widget in TiDB Dashboard, which lets you diagnose cluster problems within a specified time range. You can summarize the diagnostic results and cluster-related load monitoring information in a diagnostic report. | Continue reading


@pingcap.com | 3 years ago

A Few More Reasons Rust Compiles Slowly

This is the fourth episode of the Rust Compile Time series. It discusses some factors that cause Rust to build slow, including LLVM, compiler architecture, and linking. | Continue reading


@pingcap.com | 3 years ago

Rust's Compilation Units

The third episode of the Rust Compile Time series discusses why Rust's compilation units are so big and how that affects compile times. | Continue reading


@pingcap.com | 3 years ago

Rust's Compilation Units

The third episode of the Rust Compile Time series discusses why Rust's compilation units are so big and how that affects compile times. | Continue reading


@pingcap.com | 3 years ago

VLDB 2020: TiDB, a New Line for HTAP Databases

PingCAP will publish a research paper "TiDB: A Raft-based HTAP Database" in the August issue of the Proceedings of the VLDB Endowment. The reviewer believes that this paper will start a new line of research and products. | Continue reading


@pingcap.com | 3 years ago

TiDB 4.0 GA: An Elastic, Real-Time HTAP Database Is Ready for Cloud

TiDB 4.0 has reached general availability. It's an elastic, real-time Hybrid Transactional/Analytical Processing (HTAP) database, and, best of all, it's now ready for the cloud. | Continue reading


@pingcap.com | 3 years ago

TiDB 4.0 GA

TiDB 4.0 has reached general availability. It's an elastic, real-time Hybrid Transactional/Analytical Processing (HTAP) database, and, best of all, it's now ready for the cloud. | Continue reading


@pingcap.com | 3 years ago

Generics and Compile-Time in Rust

ARM Macs are imminent; why they make sense, and why the implications could be far-reaching, for not just Apple but also Intel. | Continue reading


@pingcap.com | 3 years ago

We Improved TPC-C Performance by 50% and TPC-H Performance by 100%

TiDB 4.0 release greatly outperforms TiDB 3.0. Our TPC-C benchmark improved by about 50% and our TPC-H benchmark improved by about 100%. | Continue reading


@pingcap.com | 3 years ago

Easier Troubleshooting for Distributed Databases

TiDB 4.0 introduces TiDB Dashboard, which provides various built-in widgets in a graphical interface that let you easily diagnose, monitor, and manage your clusters in one place. Now you can troubleshoot TiDB clusters more easily. | Continue reading


@pingcap.com | 3 years ago

Pessimistic Locking: Better MySQL Compatibility, Fewer Rollbacks Under High Load

With improvements in stability and functionality in TiDB 4.0, we finally remove the experimental label for pessimistic locking, making it a generally available feature. See how pessimistic locking behaves in TiDB. | Continue reading


@pingcap.com | 3 years ago

Open-Source TiCDC: Replication Latency in Milliseconds for 100 TB Clusters

TiDB 4.0 introduces TiCDC, an open-source feature that replicates TiDB's incremental changes to downstream platforms. It shows only millisecond replication latency for 100+ TB clusters. | Continue reading


@pingcap.com | 3 years ago