This guide walks through creating a three‑node MySQL environment, installing and configuring MariaDB, establishing master‑slave replication, and implementing read/write splitting on an application server using MySQL‑Proxy, complete with command‑line examples and configuration snippets.
This article explains what database middleware is, why it’s needed for scaling large data workloads, and provides detailed overviews of six popular middleware solutions—including MyCat, MySQL‑Proxy, DRDS, Atlas, Zebra, and ShardingSphere—highlighting their key features and use cases.
Using lightweight dynamic‑tracing tools that record allocator calls and page‑fault events, the authors diagnose a production MySQL‑proxy memory leak in TDSQL, generate focused flame‑graphs with custom memstacks and pgfaultstacks, and demonstrate a fast, source‑independent alternative to gdb or Valgrind.
This article introduces Atlas, a MySQL‑protocol data middle‑layer developed by Qihoo 360, and provides step‑by‑step instructions for downloading, installing, configuring, testing read/write operations, creating production users, and managing backends using its admin interface.
This article recounts the author’s year‑long experience transforming Sharding‑JDBC into the ShardingSphere ecosystem, detailing technical challenges, community building, Apache Incubator admission, and the project’s evolution into a financial‑grade distributed database solution.
