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

Posted on 2011-10-18
Last Modified: 2012-06-21

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 -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.


Open in new window

Question by:khsoft
    1 Comment
    LVL 142

    Accepted Solution

    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)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
    Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now