[隐藏]

• 一、mysql集群安装
• 二、节点配置
• 三、首次启动节点
• 四、测试服务是否正常
• 五、安全关闭和重启

1. cd /tmp
2. wget http://cdn.mysql.com/Downloads/MySQL-Cluster-7.2/mysql-cluster-gpl-7.2.8-linux2.6-i686.tar.gz
3. tar xzf mysql-cluster-gpl-7.2.8-linux2.6-i686.tar.gz
4. mv mysql-cluster-gpl-7.2.8-linux2.6-i686 /usr/local/mysql

1. groupadd mysql
2. useradd -g mysql mysql
3. /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
4. chown -R root /usr/local/mysql
5. chown -R mysql /usr/local/mysql/data
6. chgrp -R mysql /usr/local/mysql
7. cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

1. vi /etc/my.cnf
2. 类似于：
3. # Options for mysqld process:
4. [MYSQLD]
5. ndbcluster                      # run NDB engine
6. ndb-connectstring=198.168.0.111  # location of MGM node
7. # Options for ndbd process:
8. [MYSQL_CLUSTER]
9. ndb-connectstring=198.168.0.111  # location of MGM node

1. mkdir /var/lib/mysql-cluster
2. cd /var/lib/mysql-cluster
3. vi config.ini
4. config.ini文件应类似于：
5. # Options affecting ndbd processes on all data nodes:
6. [NDBD DEFAULT]
7. NoOfReplicas=2    # Number of replicas
8. DataMemory=80M    # How much memory to allocate for data storage
9. IndexMemory=18M   # How much memory to allocate for index storage
10. # For DataMemory and IndexMemory, we have used the
11. # default values. Since the "world" database takes up
12. # only about 500KB, this should be more than enough for
13. # this example Cluster setup.
14. # TCP/IP options:
15. [TCP DEFAULT]
16. portnumber=2202   # This the default; however, you can use any
17. # port that is free for all the hosts in cluster
18. # Note: It is recommended beginning with MySQL 5.0 that
19. # you do not specify the portnumber at all and simply allow
20. # the default value to be used instead
21. # Management process options:
22. [NDB_MGMD]
23. hostname=198.168.0.111           # Hostname or IP address of MGM node
24. datadir=/var/lib/mysql-cluster  # Directory for MGM node logfiles
25. # Options for data node "A":
26. [NDBD]
27. # (one [NDBD] section per data node)
28. hostname=198.168.0.112         # Hostname or IP address
29. datadir=/usr/local/mysql/data   # Directory for this data node's datafiles
30. # Options for data node "B":
31. [NDBD]
32. hostname=198.168.0.113       # Hostname or IP address
33. datadir=/usr/local/mysql/data   # Directory for this data node's datafiles
34. # SQL node options:
35. [MYSQLD]
36. hostname=198.168.0.110           # Hostname or IP address
37. # (additional mysqld connections can be
38. # specified for this node for various
39. # purposes such as running ndb_restore)

1. /usr/local/mysql/bin/ndb_mgmd --configdir=/var/lib/mysql-cluster -f /var/lib/mysql-cluster/config.ini

1. /usr/local/mysql/bin/ndbd --initial

1. /usr/local/mysql/bin/mysqld_safe  &

1. /usr/local/mysql/bin/mysql -uroot -p
2. mysql> create database clusterdb;use clusterdb;
3. mysql> create table simples (id int not null primary key) engine=ndb;
4. mysql> insert into simples values (1),(2),(3),(4);
5. mysql> select * from simples;

1. /usr/local/mysql/bin/ndb_mgm -e shutdown

1. /usr/local/mysql/bin/ndb_mgmd --configdir=/var/lib/mysql-cluster -f /var/lib/mysql-cluster/config.ini

1. /usr/local/mysql/bin/ndbd