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
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:
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
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)
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.