1 message in com.mysql.lists.clustermanagement server can't see database ...| From | Sent On | Attachments |
|---|---|---|
| Justin Swanhart | 20 Jul 2004 11:52 |
| Subject: | management server can't see database nodes...![]() |
|---|---|
| From: | Justin Swanhart (sp4m...@yahoo.com) |
| Date: | 07/20/2004 11:52:36 AM |
| List: | com.mysql.lists.cluster |
I have a problem..
My management server appears to be working, but it can't "see" the database nodes. So I can't do an orderly shutdown on them, etc.
When I run the management server it generates the following output:
[root@george mgmt]# ./ndb_mgmd -c config.ini NDB Cluster Management Server. Version 3.5.0 (beta) Command port: 2200, Statistics port: 0 NDB> reportError (2, 32774) reportError (3, 32774) reportError (4, 32774) reportError (5, 32774) reportError (2, 32774) [repeats forever]
I can start the database nodes on all four machines, and they start up properly and create an initial database (ndb -i)
When I connect to the management server with ndb_mgm and do a "SHOW" I get this:
[root@george mgmt]# ndb_mgm -- NDB Cluster -- Management Client -- Connecting to Management Server: localhost:2200 NDB> show Cluster Configuration
--------------------- 4 NDB Node(s) DB node: 2 (not connected) DB node: 3 (not connected) DB node: 4 (not connected) DB node: 5 (not connected)
4 API Node(s) API node: 6 (not connected) API node: 7 (not connected) API node: 8 (not connected) API node: 9 (not connected)
1 MGM Node(s) MGM node: 1 (Version: 3.5.0)
NDB>
---------------------------------
however, as I said, the database nodes are working and my mysql processes can use them. I created the test_ndb_table through the mysql server on ringo
[root@george mgmt]# ndb_show_tables id type state logging database schema name 0 SystemTable Online Yes sys def SYSTAB_0 2 SystemTable Online Yes sys def NDB$EVENTS_0 4 UserTable Online Yes test def test_ndb_table
Here is my config.ini file: [root@george mgmt]# cat config.ini [COMPUTER] Id: 1 ByteOrder: Little HostName: ringo.db.xxxx.com
[COMPUTER] Id: 2 ByteOrder: Little HostName: george.db.xxxx.com
[COMPUTER] Id: 3 ByteOrder: Little HostName: paul.db.xxxx.com
[COMPUTER] Id: 4 ByteOrder: Little HostName: john.db.xxxx.com
[MGM] Id: 1 ExecuteOnComputer: 1 PortNumber: 2200 #PortNumberStats: 2201 ArbitrationRank: 1
[DB DEFAULT] NoOfReplicas: 2 LockPagesInMainMemory: N StopOnError: Y MaxNoOfConcurrentOperations: 16384 MaxNoOfConcurrentTransactions: 1024 IndexMemory: 256M DataMemory: 2G TimeBetweenLocalCheckpoints: 20 TimeBetweenGlobalCheckpoints: 1500 NoOfFragmentLogFiles: 8 BackupMemory: 16M BackupDataBufferSize: 4M BackupLogBufferSize: 4M BackupWriteSize: 32k
[DB] Id: 2 ExecuteOnComputer: 1 FileSystemPath: /usr/local/mysql/ndb_nodes/data
[DB] Id: 3 ExecuteOnComputer: 2 FileSystemPath: /usr/local/mysql/ndb_nodes/data
[DB] Id: 4 ExecuteOnComputer: 3 FileSystemPath: /usr/local/mysql/ndb_nodes/data
[DB] Id: 5 ExecuteOnComputer: 4 FileSystemPath: /usr/local/mysql/ndb_nodes/data
[API] Id: 6 ExecuteOnComputer: 1
[API] Id: 7 ExecuteOnComputer: 2
[API] Id: 8 ExecuteOnComputer: 3
[API] Id: 9 ExecuteOnComputer: 4
[TCP DEFAULT] PortNumber: 10002
-----------------------------
Any ideas?




