MySQL数据库HA方案
之前研究数据库的高可用性，需要用到数据库的同步和备份，下面是我对MySQL的HA的一些研究。
根据《MySQL 5.0 Reference Manual》中提供的HA方案，主要由以下几种：
|
Requirements |
MySQL Replication |
MySQL Replication + Heartbeat |
MySQL Heartbeat + DRBD |
MySQL Cluster |
MySQL + memcached |
|---|---|---|---|---|---|
|
Availability |
|
|
|
|
|
|
Automated IP failover |
No |
Yes |
Yes |
No |
No |
|
Automated database failover |
No |
No |
Yes |
Yes |
No |
|
Typical failover time |
User/script-dependent |
Varies |
< 30 seconds |
< 3 seconds |
App dependent |
|
Automatic resynchronization of data |
No |
No |
Yes |
Yes |
No |
|
Geographic redundancy support |
Yes |
Yes |
Yes, when combined with MySQL Replication |
Yes, when combined with MySQL Replication |
No |
|
Scalability |
相关新闻>>最新推荐更多>>>
|
