MySQL读写分离架构(KHPM)

  1. Keepalived
  2. HAProxy
  3. ProxySQL
  4. MySQL

Keepalived+HAProxy 应用程序入口无单点故障
ProxySQL Cluster ProxySQL无单点故障
MHA MySQL无单点故障(MHA Manager后续用ORCH RAFT代替,实现无单点故障)

MySQL读写分离架构(KHPM)