This article explains Cobar’s sharding middleware and presents an optimization technique for handling ORDER BY and LIMIT queries across multiple databases, detailing the original approach, its inefficiencies with deep pagination, the step‑by‑step improved algorithm, performance analysis, limitations, and practical applicability.
This article explains how Cobar’s SQL parser converts SQL statements into an abstract syntax tree (AST), details the parser’s implementation options, demonstrates AST node definitions and visitor‑based traversal in Java, and explores practical applications such as sharding, feature extraction, and dangerous‑SQL interception.
This article describes how to implement a low‑overhead SQL audit feature for the Cobar database middleware by modifying its code, using an agent with Kafka, choosing UDP for inter‑process communication, and designing a custom ring‑buffer to achieve near‑baseline throughput with only minimal performance loss.
This article reviews three mainstream MySQL clustering solutions—MHA master‑slave replication, Oracle's MySQL Cluster, and Alibaba's open‑source Cobar—detailing their architectures, advantages, drawbacks, and practical deployment considerations for high availability and scalability.
