Re: could no alloc node id (case two)

[gdy1039]

even I add two network adapter in both the machine
and use a cable connect two both the eth1
pc01: ndb+mysql eth0:192.168.3.1/24
mgm eth1:192.168.4.1
pc02: ndb+mysql eth0:192.168.3.2/24
eth1:192.168.4.2

#############my.cnf############
# Options for mysqld process:
[MYSQLD]
ndbcluster # run NDB engine
ndb-connectstring=192.168.4.1 # location of MGM node

# Options for ndbd process:
[MYSQL_CLUSTER]
ndb-connectstring=192.168.4.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.4.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

********************************************************************************

in this case,it's more bad!!!
all ndb node and mysql is disconnect
the network is ok,don't think about that
thanksssssSSSSssssssss!!!!!!
hope andbody help me.



Edited 1 time(s). Last edit at 07/22/2006 07:25PM by gdy1039 .