mysql集群

1.配置管理节点

创建config.ini文件,添加以下内容

[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M

[ndb_mgmd]
NodeId=1
hostname=10.0.0.148
datadir=G:\Workspace\mysql-cluster

[ndbd]
NodeId=2
hostname=10.0.0.85
datadir=/usr/local/mysql/data

[ndbd]
NodeId=3
hostname=10.0.0.86
datadir=/usr/local/mysql/data

[mysqld]
NodeId=4
hostname=10.0.0.8


[mysqld]

[mysqld]

2.配置数据节点

[client]
port = 3306
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
port = 3306
character-set-server=utf8
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /temp/mysql.sock

ndb-connectstring="10.0.0.148"
ndbcluster

[mysql_cluster]
ndb-connectstring="10.0.0.148"

3.启动管理节点

ndb_mgmd --configdir=G:\Workspace\mysql-cluster -f config.ini

4.启动数据节点

./bin/ndbd --ndb-connectstring=10.0.0.148 --initial

5.用ndb_mgm监听服务

ndb_mgm -e show