实用心得：MySQL群集双机模拟方案

主机                        IP地址                用途
ndb1_mgmd_sqld            192.168.1.100      Ndb node1+mgmd node1+sqld node1
ndb2_sqld2                192.168.1.200      Ndb node2+sqld node2
Mgmd:management server
sqld:mysql server
ndb:storaged node (share-nothing,base in memory)

shell>;groupadd mysql
shell>;useradd -g mysql mysql
shell>;tar zxfv mysql-max-4.1.12-pc-linux-gnu-i686.tar.gz
shell>;cp -vr mysql-max-4.1.12-pc-linux-gnu-i686 /usr/local/mysql-max-4.1.12-pc-linux-gnu-i686
shell>;cd /usr/local
shell>;ln -s mysql-max-4.1.12-pc-linux-gnu-i686 mysql
shell>;cd mysql;scripts/mysql_install_db –user=mysql
shell>;chown -R root .;chown -R mysql data;chgrp -R mysql .
shell>;cp support-files/mysql.server /etc/rc.d/init.d/
shell>;chmod +x /etc/rc.d/init.d/mysql.server
shell>;chkconfig --add mysql.server
shell>;chkconfig –level 3 mysql.server off

shell>;cd /var/tmp
shell>;tar -zxvf mysql-max-4.1.12a-pc-linux-gnu-i686.tar.gz /usr/local/bin '*/bin/ndb_mgm*'
Configuration
Configuring the Storage and SQL Nodes
在两台主机上执行如下过程：
shell>;vi /etc/my.cnf
[MYSQLD]                                        # Options for mysqld process:
ndbcluster                                             # run NDB engine
ndb-connectstring=192.168.1.100          # location of MGM node

[MYSQL_CLUSTER]                                # Options for ndbd process:
ndb-connectstring=192.168.1.100          # location of MGM node

Configuring the Management Node
在主机ndb1_mgmd_sqld1上执行如下过程
shell>;mkdir /var/lib/mysql-cluster
shell>;cd /var/lib/mysql-cluster
shell>;vi config.ini
[NDBD DEFAULT]            # Options affecting ndbd processes on all data nodes:
NoOfReplicas=2            # Number of replicas
DataMemory=80M            # How much memory to allocate for data storage
IndexMemory=52M           # How much memory to allocate for 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.
[TCP DEFAULT]

[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)