I start the management node, then the ndbd node, followed by mysqld API node. mysqld (api node) starts, and I can log into it (mysql -u root -p), but it is not listed as a "connected" mysqld(API) using ndb_mgm show.
Is there some thing I have to clear? It did connect once, but will not
reconnect now. No config files were changed.
The following are details about my install and start/stop process:
Config Files:
#########################################
# ON Postal1
#########################################
-----------------------------------------
cat /usr/local/mysql/data/Ndb.cfg
-----------------------------------------
nodeid=20;host=postal1:2200
-----------------------------------------
cat /usr/local/mysql/ndb/ndb1/Ndb.cfg
-----------------------------------------
nodeid=1;host=postal1:2200
------------------------------------------
cat /usr/local/mysql/ndb/mgmt/Ndb.cfg
------------------------------------------
nodeid=63;host=postal1:2200
------------------------------------------
cat /usr/local/mysql/ndb/mgmt/config.ini
------------------------------------------
######################################
# First Machine:
# /usr/local/mysql/
# data/
# Ndb.cfg
# log/
# ndb/
# mgmt/
# config.ini
# Ndb.cfg
# ndb1/
# Ndb.cfg
# 550MB indexes, 500MB data
# 2 replicas
######################################
[DB DEFAULT]
NoOfReplicas: 2
DataMemory:500M
IndexMemory:550M
MaxNoOfConcurrentTransactions:75
MaxNoOfConcurrentOperations:120000
TimeBetweenWatchDogCheck:2000
MaxNoOfOrderedIndexes:75000
MaxNoOfTables:9000
MaxNoOfAttributes:40000
[COMPUTER]
Id: 1
HostName: postal1
[COMPUTER]
Id: 2
HostName: postal2
[MGM]
Id: 63
ExecuteOnComputer: 1
PortNumber: 2200
LogDestination:
SYSLOG:facility=local0,;FILE:filename=/usr/local/mysql/ndb/mgmt/mgmd.log
[DB]
Id: 1
ExecuteOnComputer: 1
FileSystemPath: /usr/local/mysql/ndb/mgmt/
[DB]
Id: 2
ExecuteOnComputer: 2
FileSystemPath: /usr/local/mysql/ndb/ndb1/
[API]
Id: 20
ExecuteOnComputer: 1
[API]
Id: 21
ExecuteOnComputer: 2
postal1:/usr/local/mysql# cat /usr/local/mysql/data/Ndb.cfg
nodeid=20;host=postal1:2200
postal1:/usr/local/mysql# cat /usr/local/mysql/ndb/ndb1/Ndb.cfg
nodeid=1
host=postal1:2200
postal1:/usr/local/mysql# cat /usr/local/mysql/ndb/mgmt/Ndb.cfg
nodeid=63
host=postal1:2200
------------------------------------------
------------------------------------------
cat /etc/my.cnf
------------------------------------------
[client]
#password = your_password
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
skip-locking
# NDB Cluster
ndbcluster
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
------------------------------------------
#########################################
# ON Postal2
#########################################
---------------------------------
cat /usr/local/mysql/data/Ndb.cfg
---------------------------------
nodeid=21;host=postal1:2200
---------------------------------
cat /usr/local/mysql/ndb/ndb1/Ndb.cfg
---------------------------------
nodeid=2;postal1:2200
---------------------------------
cat /usr/local/mysql/ndb/mgmt/Ndb.cfg
---------------------------------
nodeid=63;host=postal1:2200
---------------------------------
cat /usr/local/mysql/ndb/mgmt/config.ini
---------------------------------
#
# First Machine:
# /usr/local/mysql/ndb/
# mgmt/
# config.ini
# Ndb.cfg
# log/
# ndb1/
# Ndb.cfg
# 550MB indexes, 500MB data
# 2 replicas
[DB DEFAULT]
NoOfReplicas: 2
DataMemory:500M
IndexMemory:550M
MaxNoOfConcurrentTransactions:75
MaxNoOfConcurrentOperations:120000
TimeBetweenWatchDogCheck:2000
MaxNoOfOrderedIndexes:75000
MaxNoOfTables:9000
MaxNoOfAttributes:40000
#[TCP DEFAULT]
#PortNumber: 28002
[COMPUTER]
Id: 1
HostName: postal1
[COMPUTER]
Id: 2
HostName: postal2
[MGM]
Id: 63
ExecuteOnComputer: 1
PortNumber: 2200
LogDestination:
SYSLOG:facility=local0,;FILE:filename=/usr/local/mysql/ndb/mgmt/mgmd.log
[DB]
Id: 1
ExecuteOnComputer: 1
FileSystemPath: /usr/local/mysql/ndb/mgmt/
[DB]
Id: 2
ExecuteOnComputer: 2
FileSystemPath: /usr/local/mysql/ndb/ndb1/
[API]
Id: 20
ExecuteOnComputer: 1
[API]
Id: 21
ExecuteOnComputer: 2
---------------------------------
---------------------------------
/etc/my.cnf
---------------------------------
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
skip-locking
key_buffer = 32M
max_allowed_packet = 2M
table_cache = 64
sort_buffer_size = 1M
net_buffer_length = 16K
read_buffer_size = 512K
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 16M
datadir=/usr/local/mysql/data
ndbcluster
log-bin
server-id = 2
tmpdir = /tmp/
innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/log
innodb_log_arch_dir = /usr/local/mysql/log
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 35M
sort_buffer_size = 25M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 35M
sort_buffer_size = 25M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
---------------------------------
Start
On postal1:
-----------
shell> cd /usr/local/mysql
shell> rm -rf data/ib* data/postal2-bin.* ndb/ndb_2* ndb/ndb1/ndb_2*
ndb/mgmt/ndb_*
shell> export MYSQL_HOME=/usr/local/mysql
shell> export NDB_HOME=$MYSQL_HOME/ndb
shell> export PATH="$PATH:$MYSQL_HOME/bin"
shell> export LD_LIBRARY_PATH=$MYSQL_HOME/lib
shell> export MANPATH=$MANPATH:$MYSQL_HOME/man
shell> pushd /usr/local/mysql/ndb/mgmt/ && ndb_mgmd -c config.ini -l Ndb.cfg &&
popd
shell> pushd /usr/local/mysql/ndb/ndb1/ && ndbd --nodaemon --nostart --initial
shell> pushd /usr/local/mysql/
shell> ./bin/mysqld_safe
On postal2:
-----------
shell> cd /usr/local/mysql
shell> rm -rf data/ib* data/postal2-bin.* ndb/ndb_2* ndb/ndb1/ndb_2*
ndb/mgmt/ndb_*
shell> export MYSQL_HOME=/usr/local/mysql
shell> export NDB_HOME=$MYSQL_HOME/ndb
shell> export PATH="$PATH:$MYSQL_HOME/bin"
shell> export LD_LIBRARY_PATH=$MYSQL_HOME/lib
shell> export MANPATH=$MANPATH:$MYSQL_HOME/man
shell> pushd /usr/local/mysql/ndb/ndb1/ && ndbd --nodaemon --nostart --initial
shell> pushd /usr/local/mysql/
shell> ./bin/mysqld_safe
Stop
On postal1:
-----------
shell> cd /usr/local/mysql
shell> export MYSQL_HOME=/usr/local/mysql
shell> export NDB_HOME=$MYSQL_HOME/ndb
shell> export PATH="$PATH:$MYSQL_HOME/bin"
shell> export LD_LIBRARY_PATH=$MYSQL_HOME/lib
shell> export MANPATH=$MANPATH:$MYSQL_HOME/man
shell> ndb_mgm
NDB> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @192.168.0.40 (Version: 3.5.2, Nodegroup: 0, Master)
id=2 @192.168.0.41 (Version: 3.5.2, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=63 @192.168.0.40 (Version: 3.5.2)
[mysqld(API)] 2 node(s)
id=20 @192.168.0.40 (Version: 3.5.2)
id=21 @192.168.0.41 (Version: 3.5.2)
NDB> shutdown
2 NDB Cluster storage node(s) have shutdown.
NDB Cluster management server shutdown.
shell> mysqladmin -u root -p shutdown
On postal2:
-----------
shell> cd /usr/local/mysql
shell> export MYSQL_HOME=/usr/local/mysql
shell> export NDB_HOME=$MYSQL_HOME/ndb
shell> export PATH="$PATH:$MYSQL_HOME/bin"
shell> export LD_LIBRARY_PATH=$MYSQL_HOME/lib
shell> mysqladmin -u root -p shutdown
The next time I start mysqld_safe, it does not appear as a connected API.
--
._____________________.
| \0/ John Stile |
| UniX Administration |
| / \ 510-305-3800 |
| [EMAIL PROTECTED] |
.---------------------.
signature.asc
Description: This is a digitally signed message part
