cluster 实践（cluster 实践）.docVIP

cluster 实践（cluster 实践） Cluster configuration 10.152.8.130 management node 10.152.8.91 data node SQL node 10.152.8.92 data node SQL node 1, on three servers respectively To install Cluster C (the default path) 2, created in the management node C Generate c:/mysql/bin and C:/mysql/mysql-cluster (after the first boot, a similar ndb_1_config.bin.1 file will be generated in this folder, as if to load the configuration later) And the c:/mysql/bin/cluster-logs directory, copy ndb_mgmd.exe and ndb_mgm.exe to the 172.16.0.162 directory of c:/mysql/bin in the download decompression file directory mysql/bin. Two files are generated under the c:/mysql/bin of the management node server, my.ini and config.ini. The contents of my.ini are: [mysql_cluster] Config_file=c:/mysql/bin/config.ini The contents of the config.ini file are: [NDBD DEFAULT] NoOfReplicas=2 Datadir=d:\mysqlcluster\datanode\mysql\bin\cluster-data Datamemory=1G Indexmemory=200M [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] [NDB_MGMD] Nodeid=1 HostName=10.152.8.130 Datadir=c:\mysql\bin\cluster-logs [NDBD] Nodeid=2 HostName=10.152.8.91 DataDir=d:\mysqlcluster\datanode\mysql\bin\cluster-data [NDBD] Nodeid=3 HostName=10.152.8.92 DataDir=d:\mysqlcluster\datanode\mysql\bin\cluster-data [MYSQLD] Nodeid=4 HostName=10.152.8.91 [MYSQLD] Nodeid=5 HostName=10.152.8.92 2, At all data nodes Create in D disk D:\mysqlcluster\datanode\mysql\bin\cluster-data D:\mysqlcluster\datanode\mysql\cluster-data Copy the ndbd.exe from the mysql/bin directory after the package is unpacked to d:\mysqlcluster\datanode\mysql\bin Create my.ini files under d:mysqlcluster\datanode\mysql\bin. Content for [mysqld] Ndbcluster [mysql_cluster] Ndb-connectstring=10.152.8.130 3, Create in all SQL nodes D:\mysqlcluster\sqlnode Copy the entire directory of the MySQL in the Cluster installation package to d:\mysqlcluster\sqlnode Modify d:\mysqlcluster\sqlnode\mysql\my-default.ini or create a my.ini file under d:\mysqlcluster\sqlnode\mysql Content for: [my