could no alloc node id (case one)
Posted by:
gdy1039
Date: July 22, 2006 07:09PM
first,use two machine to make mysql5_max cluster
pc01: ndb+mysql+mgm eth0:192.168.3.1/24
pc02: ndb+mysql eth0:192.168.3.2/24
#############my.cnf############
# Options for mysqld process:
[MYSQLD]
ndbcluster # run NDB engine
ndb-connectstring=192.168.3.1 # location of MGM node
# Options for ndbd process:
[MYSQL_CLUSTER]
ndb-connectstring=192.168.3.1 # location of MGM node
############config.ini#######################
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # 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/IP options:
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead
# Management process options:
[NDB_MGMD]
hostname=192.168.3.1 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles
# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
hostname=192.168.3.1 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
# Options for data node "B":
[NDBD]
hostname=192.168.3.2 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
# SQL node options:
[MYSQLD]
hostname=192.168.3.1 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[MYSQLD]
Hostname=192.168.3.2
run this command:
Pc01:/usr/local/bin/ndb_mgmd –f /var/lib/mysq-cluster/config
/usr/local/mysql/bin/ndbd –-initial
/etc/init.d/mysql.server start
Pc02: /usr/local/mysql/bin/ndbd --initial
/etc/init.d/mysql.server start
Pc01: /usr/local/bin/ndb_mgm –e show
everynode is connect,
data can be insert,and sysc automatic
but,,,,,,
when pc01 down,, ndb thread will dead auto.
at this time,if I run this command
********************************
ifconfig eth1:1 192.168.3.1/24
/usr/local/mysql/bin/ndbd
*******************************
then,ndbd will said mgm can't be connect or not found.
Edited 1 time(s). Last edit at 07/22/2006 07:26PM by gdy1039 .