7
MYSQL High Availability 高可用解决方案对比. http://dev.mysql.com/doc/refman/5.1/en/ha-overview.html
|
Requirements |
MySQL Replication |
MySQL Replication + Heartbeat |
MySQL Heartbeat + DRBD |
MySQL Cluster |
|
Availability |
|
|
|
|
|
Automated IP failover |
No |
Yes |
Yes |
No |
|
Automated database failover |
No |
No |
Yes |
Yes |
|
Typical failover time |
User/script-dependent |
Varies |
< 30 seconds |
< 3 seconds |
|
Automatic resynchronization of data |
No |
No |
Yes |
Yes |
|
Geographic redundancy support |
Yes |
Yes |
Yes, when combined with MySQL Replication |
Yes, when combined with MySQL Replication |
|
Scalability |
|
|
|
|
|
Built-in load balancing |
No |
No |
No |
Yes |
|
Supports Read-intensive applications |
Yes |
Yes |
Yes, when combined with MySQL Replication |
Yes |
|
Supports Write-intensive applications |
No |
No |
Yes |
Yes |
|
Maximum number of nodes per group |
One master, multiple slaves |
One master, multiple slaves |
One active (primary), one passive (secondary) node |
255 |
|
Maximum number of slaves |
Unlimited (reads only) |
Unlimited (reads only) |
One (failover only) |
Unlimited (reads only) |