Mysql集群方案(一) - Cluster & Replication 介绍

对数据库集群处于初步学习阶段,记录备忘

扫盲:

提到Mysql集群(Mysql Cluster),其实有两类方案, 名字上的Mysql Cluster只是其中一类.

Mysql Cluster 将数据放内存中

A MySQL Cluster consists of a set of computers, each running a one or more processes which may include a MySQL server, a data node, a management server, and (possibly) a specialized data access programs. The relationship of these components in a cluster is shown here:

如上图，这个系统中，最小的集群可能是如此：
NodeIP AddressManagement (MGM) node192.168.0.10MySQL server (SQL) node192.168.0.20Data (NDBD) node "A"192.168.0.30Data (NDBD) node "B"192.168.0.40

topology

Replication -  Read/Write

Replication - Separate Read & Write

Using replication to improve the performance during scaleout

Comparison

RequirementsMySQL ReplicationMySQL Replication + HeartbeatMySQL Heartbeat + DRBDMySQL ClusterAvailability    Automated IP failoverNoYesYesNoAutomated database failoverNoNoYesYesTypical failover timeUser/script-dependentVaries< 30 seconds< 3 secondsAutomatic resynchronization of dataNoNoYesYesGeographic redundancy supportYesYesYes, when combined with MySQL ReplicationYes, when combined with MySQL ReplicationScalability    Built-in load balancingNoNoNoYesSupports Read-intensive applicationsYesYesYes, when combined with MySQL ReplicationYesSupports Write-intensive applicationsNoNoYesYesMaximum number of nodes per groupOne master, multiple slavesOne master, multiple slavesOne active (primary), one passive (secondary) node255Maximum number of slavesUnlimited (reads only)Unlimited (reads only)One (failover only)Unlimited (reads only)

http://haka.sharera.com/blog/BlogTopic/54291.htm