Mysql cluster
Allikas: Kuutõrvaja
kolm masinat
install
gentoo
freebsd
131 10:40 cd /usr/ports/databases 132 10:40 ls 133 10:40 cd mysql50-server 134 10:40 nano Makefile 135 10:40 make 136 10:40 nano /etc/make.conf 137 10:41 nano Makefile 138 10:41 nano /etc/make.conf 139 10:41 make 140 10:41 make WITH_NDB=yes 141 11:30 make install WITH_NDB=yes
master
ndb_mgmd --config-file=/etc/config.ini
# file "config.ini" - 2 data nodes and 2 SQL nodes # This file is placed in the startup directory of ndb_mgmd (the # management server) # The first MySQL Server can be started from any host. The second # can be started only on the host mysqld_5.mysql.com [NDBD DEFAULT] NoOfReplicas= 2 DataDir= /var/lib/mysql-cluster [NDB_MGMD] Hostname= 193.40.0.184 DataDir= /var/lib/mysql-cluster [NDBD] HostName= 193.40.0.187 [NDBD] HostName= 193.40.0.183 [MYSQLD] [MYSQLD]
node 1
cat /etc/mysql/my.cnf [mysql_cluster] ndb-connectstring=193.40.0.184 [mysqld] ndbcluster ndb-connectstring=193.40.0.184
node2
cat /usr/local/etc/my.cnf [mysql_cluster] ndb-connectstring=193.40.0.184 [mysqld] ndbcluster ndb-connectstring=193.40.0.184
node1
ndbd --initial
node2
/usr/local/libexec/ndbd --initial
master
localhost ~ # 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 @193.40.0.187 (Version: 5.0.44, Nodegroup: 0, Master) id=3 @193.40.0.183 (Version: 5.0.45, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=1 @193.40.0.184 (Version: 5.0.44) [mysqld(API)] 2 node(s) id=4 @193.40.0.187 (Version: 5.0.44) id=5 @193.40.0.183 (Version: 5.0.45) ndb_mgm>