Link to home
Start Free TrialLog in
Avatar of khsoft
khsoft

asked on

Running mysqld does not return the interface prompt, but stops with "MySQL Cluster Server (GPL)" text

Hello,

I run mySQL Cluster on remote CentOS server by executing a set of commands from Linux prompt in Putty on Windows. Then, I finally run
[khsoft@vmi1772 root]$ /home/khsoft/mysqlc/bin/mysqld --defaults-file=/home/khsoft/my_cluster/conf/my.cnf --user=khsoft

Open in new window

mysql cluster responds with the following:
111018 14:36:20 [Note] Plugin 'FEDERATED' is disabled.
111018 14:36:20  InnoDB: Started; log sequence number 0 441997
111018 14:36:21 [Note] NDB: NodeID is 50, management server 'localhost:1186'
111018 14:36:21 [Note] NDB[0]: NodeID: 50, all storage nodes connected
111018 14:36:21 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
111018 14:36:21 [Note] Starting Cluster Binlog Thread
111018 14:36:22 [Note] Event Scheduler: Loaded 0 events
111018 14:36:22 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$mysql/ndb_schema
111018 14:36:22 [Note] NDB Binlog: logging ./mysql/ndb_schema (UPDATED,USE_WRITE)
111018 14:36:22 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$mysql/ndb_apply_status
111018 14:36:22 [Note] NDB Binlog: logging ./mysql/ndb_apply_status (UPDATED,USE_WRITE)
111018 14:36:22 [Note] NDB: Discovered reamining database 'test'
2011-10-18 14:36:23 [NdbApi] INFO     -- Flushing incomplete GCI:s < 8977088/16
2011-10-18 14:36:23 [NdbApi] INFO     -- Flushing incomplete GCI:s < 8977088/16
111018 14:36:23 [Note] NDB Binlog: starting log at epoch 8977088/16
111018 14:36:23 [Note] NDB Binlog: ndb tables writable
111018 14:36:23 [Note] /home/khsoft/mysqlc/bin/mysqld: ready for connections.
Version: '5.1.51-ndb-7.1.9a-cluster-gpl'  socket: '/tmp/mysql.sock'  port: 5000  MySQL Cluster Server (GPL)

Open in new window


The major problem is that finally I cannot see "[khsoft@vmi1772 root]$ " prompt - looks like the deamon has not finished starting. However, mysqld is running, as I can access it by running "HOME/mysqlc/bin/mysql -h 127.0.0.1 -P 5000 -u khsoft" from anohter Putty window. I also can access the database from Workbench CE!

Could you tell me what is wrong with mysql Cluster? As I remember, previously the mysqld did not respond with the text above.

my.cnf:
[mysqld]
ndbcluster
datadir=/home/khsoft/my_cluster/mysqld_data
basedir=/home/khsoft/mysqlc
port=5000

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial