ArticleDirectory
I. Software Packages
A) MySQL-ndb-management-5.0.90-1.i386.rpm
B) MySQL-ndb-management-5.0.90-1.i386.rpm
C) mysql-5.0.27.tar.gz
2. Install [Management Nodes]
A) rpm-IVH MySQL-ndb-tools-5.0.90-1.i386.rpm
B) rpm-IVH MySQL-ndb-management-5.0.90-1.i386.rpm
C) mkdir/var/lib/MySQL-Cluster
D) CD/var/lib/MySQL-Cluster
E) touch config. ini
[Ndbd default]
Noofreplicas = 2
[Mysqld default]
[Ndb_mgmd default]
[TCP default]
# Managment Server
[Ndb_mgmd]
Hostname = 192.168.1.67
# Storage engines
[Ndbd]
Hostname = 192.168.1.91
Datadir =/usr/local/MySQL/Data
# Datadir =/var/lib/MySQL-Cluster
[Ndbd]
Hostname = 192.168.1.92
Datadir =/usr/local/MySQL/Data
# Datadir =/var/lib/MySQL-Cluster
[Mysqld]
[Mysqld]
F)/usr/bin/ndb_mgm-initial
G)/usr/bin/ndb_mgmd Shutdown
H)/usr/bin/ndb_mgmd-F/var/lib/MySQL-cluster/config. ini [start a management node]
3. Install [data nodes]
A) CD/var/local/software
B) tar zxvf mysql-5.0.27.tar.gz
C) CD mysql-5.0.27
D ). /configure -- prefix =/usr/local/MySQL -- localstatedir =/usr/local/MySQL/data -- disable-maintainer-mode -- With-mysqld-user = MySQL -- With-Unix -socket-Path =/tmp/MySQL. sock -- without-comment -- without-Debug -- With-dependencies -- With-ndbcluster;
E) Make & make install
F) Finger MySQL
G) useradd MySQL
H) CD scripts
I)./mysql_install_db
J) chown-r MYSQL: MySQL/usr/local/MySQL
K) chown-r MYSQL: MySQL/usr/local/MySQL/Data
L) CD/usr/local/src/mysql-5.0.27/support-files/
(M) CP my-medium.cnf/etc/My. CNF
N) killall mysqld
O)/usr/local/MySQL/bin/mysqld_safe -- user = MySQL -- skip-grant-tables -- skip-Networking &
#/Usr/local/MySQL/bin/MySQL-u root MySQL
Mysql> Update user SET Password = PASSWORD ('000000') where user = 'root ';
Mysql> flush privileges;
Mysql> quit
Modify the remote access permission of the root user:
# Killall mysqld
#/Usr/local/MySQL/bin/mysqld_safe-user = MySQL &
#/Usr/local/MySQL/bin/MySQL-u root-p123456 MySQL
Mysql> grant all privileges on *. * To 'root' @ '%' identified by 'root' with grant option;
Mysql> flush privileges;
Mysql> quit
VI/etc/My. CNF
[Mysqld]
Ndbcluster
NDB-connectstring = 192.168.1.67
[Mysql_cluster]
NDB-connectstring = 192.168.1.67
Killall mysqld
/Usr/local/MySQL/bin/mysqld_safe &
/Usr/local/MySQL/libexec/ndbd-initial (initialize data node)
4. View Management Nodes
A)/usr/bin/ndb_mgmd Shutdown
B)/usr/bin/ndb_mgmd-F/var/lib/MySQL-cluster/config. ini
C)/usr/bin/ndb_mgm
-- NDB Cluster -- management client --
Ndb_mgm> show
Connected to management server at: localhost: 1186
Cluster configuration
---------------------
[Ndbd (NDB)] 2 node (s)
Id = 2 @ 192.168.1.91 (Version: 5.0.27, nodegroup: 0, Master)
Id = 3 @ 192.168.1.92 (Version: 5.0.27, nodegroup: 0)
[Ndb_mgmd (MGM)] 1 node (s)
Id = 1 @ 192.168.1.67 (Version: 5.0.90)
[Mysqld (API)] 2 node (s)
Id = 4 @ 192.168.1.92 (Version: 5.0.27)
Id = 5 @ 192.168.1.91 (Version: 5.0.27)
Ndb_mgm>
The above is displayed normally
V. Test node synchronization
A) In one of the data nodes,/usr/local/MySQL/bin/MySQL-uroot-P
B) Create Database member;
Use member;
Create Table admin (id int) engine = ndbcluster;
Insert into admin values (1 );
C) In another data node,/usr/local/MySQL/bin/MySQL-uroot-P
D) Create Database member;
E) Use member;
F) flush tables;
G) show tables;
H) the admin table is synchronized.
I) Select * from Admin
J) We can see that a record has been synchronized.
K) The cluster is normal.
Vi. Related commands
A)/usr/local/MySQL/libexec/ndbd-initial (initialize the data node)
B)/usr/bin/ndb_mgmd Shutdown (close the management node)
C)/usr/bin/ndb_mgmd-F/var/lib/MySQL-cluster/config. ini (start the management node)
D)/usr/bin/ndb_mgm to view Cluster Information
E) pS aux | grep MySQL check whether MySQL is started
F) pS aux | grep NDB check whether the management node is started
G) ndb_mgm-E "show ";
H) ndb_mgm> All stauts;
I) ndb_mgm> 2 status; (2 is the node number)
J) ndbd-no-wait-nodes = 2, 3
K) mysql> show engine NDB status;
L) ndb_mgm> clusterlog Info;
M) mysql> show status like 'ndb % ';
N) mysql> show warnings;
O) ndb_mgm> 2 stop;