mysql集群 开机自起_在window 单机环境下将mysql cluster创建为自启动服务

假设我的mysql cluster根目录是：D:\devlop_apps\mysql-cluster-gpl-7.3.2-winx64

1、在根目录下创建my.ini文件，nbd_mgmd在启动时默认会搜索根目录下的my.ini文件，文件内容如下：

[mysqld]

# innodb_buffer_pool_size = 128M

log_bin

basedir =D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64

datadir =D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/data

port =3306

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

2、在根目录下分别创建ndb_data/49/、ndb_data/1/、ndb_data/2/目录和ndb_data/49/config.ini文件。

#

# Configuration file for MyCluster

#

[NDB_MGMD DEFAULT]

Portnumber=1186

[NDB_MGMD]

NodeId=49

HostName=127.0.0.1

DataDir=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/ndb_data/49/

Portnumber=1186

[TCP DEFAULT]

SendBufferMemory=4M

ReceiveBufferMemory=4M

[NDBD DEFAULT]

BackupMaxWriteSize=1M

BackupDataBufferSize=16M

BackupLogBufferSize=4M

BackupMemory=20M

BackupReportFrequency=10

MemReportFrequency=30

LogLevelStartup=15

LogLevelShutdown=15

LogLevelCheckpoint=8

LogLevelNodeRestart=15

DataMemory=1M

IndexMemory=1M

MaxNoOfTables=4096

MaxNoOfTriggers=3500

NoOfReplicas=2

StringMemory=25

DiskPageBufferMemory=64M

SharedGlobalMemory=20M

LongMessageBuffer=32M

MaxNoOfConcurrentTransactions=16384

BatchSizePerLocalScan=512

FragmentLogFileSize=64M

NoOfFragmentLogFiles=16

RedoBuffer=32M

MaxNoOfExecutionThreads=2

StopOnError=false

LockPagesInMainMemory=1

TimeBetweenEpochsTimeout=32000

TimeBetweenWatchdogCheckInitial=60000

TransactionInactiveTimeout=60000

HeartbeatIntervalDbDb=15000

HeartbeatIntervalDbApi=15000

[NDBD]

NodeId=1

HostName=127.0.0.1

DataDir=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/ndb_data/1/

[NDBD]

NodeId=2

HostName=127.0.0.1

DataDir=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/ndb_data/2/

[MYSQLD DEFAULT]

[MYSQLD]

NodeId=53

HostName=127.0.0.1

[API]

NodeId=50

HostName=127.0.0.1

4、启动ndb_mgmd.exe

D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/bin/ndb_mgmd.exe --ndb-nodeid=49 --config-dir=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/ndb_data/49/ --config-file=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/ndb_data/49/config.ini

5、启动两个ndbd.exe

--initial参数是当此数据节点第一次启动时使用，在以后启动时，此参数不需要(如果使用，会清空此节点的数据，慎之)。

D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/bin/ndbd.exe --ndb-nodeid=1 --ndb-connectstring=127.0.0.1:1186

D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/bin/ndbmtd.exe --ndb-nodeid=2 --ndb-connectstring=127.0.0.1:1186

6、启动mysqld.exe

D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/bin/mysqld.exe --no-defaults --datadir=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/data/ --tmpdir=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/ndb_data/53/tmp --basedir=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/ --socket=D:/devlop_apps/mysql-cluster-gpl-7.3.2-winx64/ndb_data/53/mysql.socket --port=3306 --ndbcluster --ndb-nodeid=53 --ndb-connectstring=127.0.0.1:1186