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…
Databases
Database internals, benchmarks, protocols, and practical notes from TiDB, OceanBase, CockroachDB, MySQL, and PostgreSQL.
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,…