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