MySQL群集双机模拟

核心提示： [NDB_MGMD] # Management process options:hostname=192.168.1.100 # Hostname or IP address of MGM nodedatadir=/var/lib/mysql-cluster # Directory for

[NDB_MGMD]　　　　　　　 # Management process options:

hostname=192.168.1.100 # Hostname or IP address of MGM node

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

[NDBD]　　　　　　　　　　　　 # Options for data node "A":

# (one [NDBD] section per data node)

HostName=192.168.1.100　　　　　 # Hostname or IP address

DataDir=/usr/local/mysql/data　 # Directory for this data node's datafiles

[NDBD]　　　　　　　　　　　　 # Options for data node "B":

hostname=192.168.1.200　　　　　 # Hostname or IP address

datadir=/usr/local/mysql/data　 # Directory for this data node's datafiles

[MYSQLD]　　　　　　　　　　　　 # SQL node options:

hostname=192.168.1.100　　　　 # Hostname or IP address

# Directory for SQL node's datafiles

# (additional mysqld connections can be

# specified for this node for various

# purposes such as running ndb_restore)

[MYSQLD] # SQL node options:

hostname=192.168.1.200　　　　 # Hostname or IP address

# Directory for SQL node's datafiles

# (additional mysqld connections can be

# specified for this node for various

# purposes such as running ndb_restore)

第一次启动

在主机ndb1_mgmd_sqld1上执行如下过程

shell> ndb_mgmd -f /var/lib/mysql-cluster/config.ini

在两台主机上执行如下过程