OceanBase Internals: Transactions, Replay, SQL Engine, and Unit Placement

OceanBase targets high availability and scalability in a shared-nothing cluster. The core engineering challenge is to make four critical subsystems work together with predictable…

January 17, 2026 · 8 min · 1517 words · Jack Yu

How to Use the HTTP API in TiDB with TLS Enabled

Many customers have TLS enabled, which is different from the lab environment.

May 22, 2023 · 1 min · 56 words · Jack Yu

How to Compare Data Consistency between MySQL and PostgreSQL

Recently, I encountered a problem where a user wanted to synchronize data from PostgreSQL to TiDB (which uses the same protocol as MySQL) and wanted to know whether the data after…

May 9, 2021 · 3 min · 461 words · Jack Yu

How to Implement a Simple Load Using Sysbench

Sysbench is a tool commonly used in database testing. Since version 1.0, it has supported more powerful custom functions, allowing users to conveniently write some Lua scripts to…

December 14, 2020 · 3 min · 499 words · Jack Yu

How to Read TiDB Source Code (Part 5)

When using TiDB, you may occasionally encounter some exceptions, such as the “Lost connection to MySQL server during query” error. This indicates that the connection between the…

September 8, 2020 · 5 min · 892 words · Jack Yu

How to Read TiDB Source Code (Part 4)

This article will introduce some key functions and the interpretation of logs in TiDB.

July 31, 2020 · 7 min · 1397 words · Jack Yu

How to Read TiDB Source Code (Part 3)

In the previous article, we introduced methods for viewing syntax and configurations. In this article, we will discuss how to view system variables, including default values,…

July 28, 2020 · 8 min · 1648 words · Jack Yu

How to Read TiDB Source Code (Part 2)

Continuing from the previous article, we learned how to set up the environment for reading code and where to start reading the code. In this part, we’ll introduce methods for…

July 12, 2020 · 4 min · 791 words · Jack Yu

How to Read TiDB Source Code (Part 1)

There are many articles on reading the source code of TiDB, often referred to as the “Twenty-Four Chapters Scriptures”. However, these introductions typically proceed from a macro…

July 6, 2020 · 6 min · 1247 words · Jack Yu

How TiDB Implements the INSERT Statement

In a previous article “TiDB Source Code Reading Series (4) Overview of INSERT Statement”, we introduced the general process of the INSERT statement. Why write a separate article…

July 11, 2018 · 11 min · 2221 words · Jack Yu