How to Use HAProxy to Test CockroachDB
yum install haproxy is effective for CentOS 7. After installation, you can start the service using systemctl start haproxy. But don’t rush yet.
Databases
Database internals, benchmarks, protocols, and practical notes from TiDB, OceanBase, CockroachDB, MySQL, and PostgreSQL.
How to Test CockroachDB Performance Using Benchmarksql
First of all, TPC-C is the de facto OLTP benchmark standard. It is a set of specifications, and any database can publish its test results under this standard, so there’s no issue…
How to Test CockroachDB Performance Using Sysbench
CockroachDB uses the PostgreSQL protocol. If you want to use Sysbench for testing, you need to enable pg protocol support in Sysbench. Sysbench already supports the pg protocol,…
How to View CMU DB Group's OLTP-Bench
OLTP-Bench is an open-source benchmarking tool platform for OLTP scenarios from CMU’s DB Group. It was designed to provide a simple, easy-to-use, and extensible testing platform.
How to Understand F1's Schema Change
The DDL paper on F1 serves as the foundation for TiDB’s DDL implementation. There are two main papers on F1: one provides an overview of F1’s DDL, and the other specifically…
Understanding the CAP Theorem
The CAP theorem has become one of the hottest theorems in recent years; when discussing distributed systems, CAP is inevitably mentioned. However, I feel that I haven’t thoroughly…
How to Implement MySQL X Protocol on TiDB
Start a new server for TiDB. The relevant configuration parameters such as IP, port, and socket need to be set. 2. Implement the reading and writing functionality for message…
How to Practice Using SQL
The text provided is a detailed set of instructions and queries for practicing SQL using PostgreSQL 9.4 BETA 2, focusing on creating and querying tables related to students,…