• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 553
  • Last Modified:

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

0
khsoft
Asked:
khsoft
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you are missing the & and the end, to send the command to the background.
otherwise, the command will indeed continue to run (it's a deamon process, remember)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now