"Proxysql"
- MySQL ProxySQL 配置:connection / query / route / response 四段 lifecycle 跟 query rule 設計
ProxySQL 是 MySQL 生態的 connection pool + query routing 標準。本文走 connection → query parse → route → response 四段 lifecycle、query rule engine 的 rule chain 設計、Hostgroup / Server / User 三層 schema、配置 step-by-step(讀寫分離 + replica lag-aware routing)、5 production 踩雷(query rule 順序錯亂 / connection 漂移 / write 路由到 replica / runtime / disk schema drift / mirror traffic 副作用)、跟 Replication / Orchestrator / HAProxy 整合
- MySQL ProxySQL Routing Lab
MySQL ProxySQL hostgroup、read/write split、query rule、backend health 與 routing evidence