mysql分布式cluster.pdf

谭俊青***@MySQL实验室
()
上海爱可生信息技术有限公司
2010-04-03
CAP Theorem and NoSQL
Consistency
Availability
Partition Tolerance
CAP Theorem (2/3)
CAP Theorem (3/3)
MySQL HA Solution
 MySQL + Shared-Storage
 MySQL + DRBD (CP)
 Master + Slave (AP)
 Master + Slave(SemiSyncReplication) (CP/AP)
 Multi-Master (AP)
 MySQL Cluster (CAP? CP/AP)
MySQL + Shared-Storage
 Active/Passive
Web/App
Server
Active Server Cluster Management Passive Server
= Virtual IP =

Cluster Agent Cluster Agent
= Private IP = = Private IP =

SAN
MySQL + DRBD
Web/App
Server
Active Server Linux Heartbeat Passive Server
= Virtual IP =

= Private IP = = Private IP =

Secondary DRBD
Primary DRBD DRBD
Master + Slave
 Multi-Master
 Web/App
SemiSyncReplication Server
Master Server Linux Heartbeat Slave Server