How RedSQL Supercharged MySQL Performance and Achieved Zero‑Data‑Loss Replication

This article details Xiaohongshu's RedSQL MySQL kernel project, describing three major solutions—high‑throughput seckill optimization, a Binlog Server‑based zero‑data‑loss replication scheme, and second‑level DDL column addition—along with additional kernel enhancements that together delivered multi‑fold performance gains and improved stability.

DDLData ConsistencyPerformance Optimization

0 likes · 12 min read

How RedSQL Supercharged MySQL Performance and Achieved Zero‑Data‑Loss Replication

Tencent Database Technology

Jan 19, 2022 · Databases

Deep Dive into Tencent's Self‑Developed MySQL Kernel TXSQL and Its Architecture

This article provides a comprehensive overview of Tencent's self‑developed MySQL kernel TXSQL, covering its evolution, overall architecture, columnar storage engine, instant DDL capabilities, enterprise‑grade features, high‑availability mechanisms, performance optimizations, and the rigorous development and testing processes behind the product.

Columnar StoragePerformance OptimizationTXSQL

0 likes · 11 min read

Deep Dive into Tencent's Self‑Developed MySQL Kernel TXSQL and Its Architecture

Tencent Cloud Developer

May 25, 2018 · Databases

TXSQL: The Cloud‑Era Database Kernel – Overview, Design, and Future Directions

TXSQL is Tencent Cloud’s MySQL‑based kernel, engineered to handle massive scale, improve stability, performance, and security for diverse industries, featuring optimized redo‑logs, thread‑pool handling, encryption, audit plugins, and parallel replication, with a rigorous release process and future plans for engine‑level batch computation and RocksDB integration.

Performance OptimizationRocksDBTXSQL

0 likes · 10 min read

TXSQL: The Cloud‑Era Database Kernel – Overview, Design, and Future Directions

ITPUB

Jul 11, 2016 · Databases

Inside PostgreSQL: How the Database Kernel Works and Can Be Extended

This article explains PostgreSQL's kernel architecture, from client connection handling through parsing, rewriting, planning, and execution, illustrates scan and join algorithms, shows how to extend the kernel and build clustered deployments, and introduces Foreign Data Wrappers for integrating external data sources.

ClusterForeign Data WrapperIndex Scan

0 likes · 13 min read

Inside PostgreSQL: How the Database Kernel Works and Can Be Extended