[mysql_cluster]
# Options for management node process
ndb-connectstring=172.19.66.4
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataDir=C:/mysql/bin/cluster-data # Directory for each data node's data files
# Forward slashes used in directory path,
# rather than backslashes. This is correct;
# see Important note in text
DataMemory=80M # Memory allocated to data storage
IndexMemory=18M # Memory allocated to 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.
[ndb_mgmd]
# Management process options:
HostName=172.19.66.4 # Hostname or IP address of management node
DataDir=C:/mysql/bin/cluster-logs # Directory for management node log files
[ndbd]
# Options for data node "A":
# (one [ndbd] section per data node)
HostName=172.19.66.5 # Hostname or IP address
[ndbd]
# Options for data node "B":
HostName=172.19.66.7 # Hostname or IP address
[mysqld]
# SQL node options:
HostName=172.19.66.5 # Hostname or IP address
[mysqld]
# SQL node options:
HostName=172.19.66.7 # Hostname or IP address
到目前为止,manage节点就配置好了,现在测试一下
在开一个命令行窗口
出现以上效果,manage节点就没问题了。
第三步 配置data 节点
1.直接将压缩包解压到电脑:C盘(其实这里暂时只是用ndbd.exe,如果这台电脑只作为data 节点,就可以把其余的文件删除掉);
2.在c:mysql新建my.ini;
[mysql_cluster]
# Options for data node process:
ndb-connectstring=172.19.66.4 # location of management server
成功运行效果如下:
第四步 配置sql 节点
直接在my.ini中添加
[mysqld]
# Options for mysqld process:
ndbcluster # run NDB storage engine
ndb-connectstring=172.19.66.4 # location of management server
成功运行效果如下:
这样就全部配置好了
功能测试:
出现如下效果,就OK了
如下界面说明部分节点未连接:
——————————————————————配置中可能遇到的错误—————————————————————————————————————————————
问题一:端口被占用(常见的如3306),解决方法:只需找到占用该端口的程序,关闭即可
问题二:找不到“C:\mysql\bin\cluster-logs/log2out”,解决方法:在bin目录下新建cluster-logs文件
问题三:如觉得每次运行都需要转到当前目录太烦躁,解决方法:设置一下环境变量