主機                        IP地址                用途ndb1_mgmd_sqld            192.168.1.100      Ndb node1+mgmd node1+sqld node1ndb2_sqld2                192.168.1.200      Ndb node2+sqld node2Mgmd:management serversqld:mysql serverndb:storaged node (share-nothing,base in memory)

shell>;groupadd mysqlshell>;useradd -g mysql mysqlshell>;tar zxfv mysql-max-4.1.12-pc-linux-gnu-i686.tar.gzshell>;cp -vr mysql-max-4.1.12-pc-linux-gnu-i686 /usr/local/mysql-max-4.1.12-pc-linux-gnu-i686shell>;cd /usr/localshell>;ln -s mysql-max-4.1.12-pc-linux-gnu-i686 mysqlshell>;cd mysql;scripts/mysql_install_db –user=mysqlshell>;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.servershell>;chkconfig --add mysql.servershell>;chkconfig –level 3 mysql.server off

shell>;cd /var/tmpshell>;tar -zxvf mysql-max-4.1.12a-pc-linux-gnu-i686.tar.gz /usr/local/bin '*/bin/ndb_mgm*'ConfigurationConfiguring the Storage and SQL Nodes在兩臺主機上執行如下過程：shell>;vi /etc/my.cnf[MYSQLD]                                        # Options for mysqld process:ndbcluster                                             # run NDB enginendb-connectstring=192.168.1.100          # location of MGM node[MYSQL_CLUSTER]                                # Options for ndbd process:ndb-connectstring=192.168.1.100          # location of MGM nodeConfiguring the Management Node在主機ndb1_mgmd_sqld1上執行如下過程shell>;mkdir /var/lib/mysql-clustershell>;cd /var/lib/mysql-clustershell>;vi config.ini[NDBD DEFAULT]            # Options affecting ndbd processes on all data nodes:NoOfReplicas=2            # Number of replicasDataMemory=80M            # How much memory to allocate for data storageIndexMemory=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 nodedatadir=/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 addressDataDir=/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 addressdatadir=/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)

shell>; ndb_mgm-- NDB Cluster -- Management Client --ndb_mgm>; showConnected to Management Server at: localhost:1186Cluster Configuration---------------------[ndbd(NDB)]     2 node(s)id=2    @192.168.0.100  (Version: 4.1.12, Nodegroup: 0, Master)id=3    @192.168.0.200  (Version: 4.1.12, Nodegroup: 0)[ndb_mgmd(MGM)] 1 node(s)id=1    @192.168.0.100  (Version: 4.1.12)[mysqld(SQL)]   1 node(s)id=4   (Version: 4.1.12)

shell>;/usr/local/mysql/bin/mysql -u root testMySQL>;DROP TABLE IF EXISTS City;CREATE TABLE City (ID int(11) NOT NULL auto_increment,Name char(35) NOT NULL default '',CountryCode char(3) NOT NULL default '',District char(20) NOT NULL default '',Population int(11) NOT NULL default '0',PRIMARY KEY  (ID)) ENGINE=NDBCLUSTER;MySQL>;INSERT INTO City VALUES (1,'Kabul','AFG','Kabol',1780000);INSERT INTO City VALUES (2,'Qandahar','AFG','Qandahar',237500);INSERT INTO City VALUES (3,'Herat','AFG','Herat',186800);