1．?先了解一下你是否应该用MySQL集群。

减少数据中心结点压力和大数据量处理，采用把MySQL分布，一个或多个application对应一个MySQL数据库。把几个MySQL数据库 公用的数据做出共享数据，例如购物车，用户对象等等，存在数据结点里面。其他不共享的数据还维持在各自分布的MySQL数据库本身中。

2．?集群MySQL中名称概念.(如上图)

1）Sql结点（SQL node--上图对应为MySQLd）:分布式数据库。包括自身数据和查询中心结点数据.

2）数据结点(Data node -- ndbd):集群共享数据(内存中).

3）管理服务器(Management Server – ndb_mgmd):集群管理SQL node,Data node.

3．配置

MySQL-max版本，当然现在MySQL集群系统windonws平台上面不被支持.

安装MySQL就不多说了，网上一大堆，简明扼要。

A:192.168.1.251 – Data node和Management Server.

B:192.168.1.254 – SQL node.

当然，你也可以让一个机器同时为3者。

A,B my.inf加上：

[MySQLD]??????????????????????? ?



ndbcluster?????????????????????#?run?NDB?engine ?


ndb-connectstring
=
192
.168.1.251?#?location?of?MGM?node ?


? ?


#?Options?for?ndbd?process: ?


[MySQL_CLUSTER]???????????????? ?


ndb-connectstring
=
192
.168.1.251?#?location?of?MGM?node ?


? ?


A:?/var/lib/MySQL-cluster/config.ini ?


[NDBD?DEFAULT]??? ?


NoOfReplicas
=
1
???#?Number?of?replicas ?


DataMemory
=
80M
???#?How?much?memory?to?allocate?for?data?storage ?


IndexMemory
=
18M
??#?How?much?memory?to?allocate?for?index?storage ?


?????????????????#?For?DataMemory?and?IndexMemory,?we?have?used?the ?


?????????????????#?default?values.?Since?the?"world"?database?takes?up ?


?????????????????#?only?about?500KB,?this?should?be?more?than?enough?for ?


?????????????????#?this?example?Cluster?setup. ?


#?TCP/IP?options: ?


[TCP?DEFAULT]???? ?


portnumber
=
2202
??#?This?the?default;?however,?you?can?use?any ?


?????????????????#?port?that?is?free?for?all?the?hosts?in?cluster ?


?????????????????#?Note:?It?is?recommended?beginning?with?MySQL?5.0?that ?


?????????????????#?you?do?not?specify?the?portnumber?at?all?and?simply?allow ?


?????????????????#?the?default?value?to?be?used?instead ?


#?Management?process?options: ?


[NDB_MGMD]????????????????????? ?


hostname
=
192
.168.1.251??????????#?Hostname?or?IP?address?of?MGM?node ?


datadir
=/var/lib/MySQL-cluster?#?Directory?for?MGM?node?logfiles ?


#?Options?for?data?node?"A": ?


[NDBD]????????????????????????? ?


#?(one?[NDBD]?section?per?data?node) ?


hostname
=
192