/usr/sbin/mysqld: unknown option '--ndbcluster'
Posted by:
Eduardo Juan ()
Date: April 17, 2008 11:23AM
Hi ppl! I'm posting here since I've tried every different solutions on net and couldn't find any useful :_(
I'm using latest MySQL-server-5.1.24-0.glibc23.i386.rpm
Whenever I do /etc/init.d/mysql start, this is the error log from mysql server:
-------------------------------------------------------------------
080417 14:16:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
080417 14:16:07 InnoDB: Started; log sequence number 0 46604
080417 14:16:07 [ERROR] /usr/sbin/mysqld: unknown option '--ndbcluster'
080417 14:16:07 [ERROR] Aborting
080417 14:16:07 InnoDB: Starting shutdown...
080417 14:16:09 InnoDB: Shutdown completed; log sequence number 0 46604
080417 14:16:09 [Note] /usr/sbin/mysqld: Shutdown complete
080417 14:16:09 mysqld_safe mysqld from pid file /var/lib/mysql/app1_tradehub.corp.cma.com.br.pid ended
---------------------------------------------------------------------------------
Also this is output from management console:
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.50.1 (Version: 5.1.23, Nodegroup: 0, Master)
id=3 @192.168.50.2 (Version: 5.1.23, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.50.100 (Version: 5.1.23)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.50.1)
id=5 (not connected, accepting connect from 192.168.50.2)
----------------------------------------------------------------------------
------------------------ Configs I'm using ------------------------------------
<config.ini> = MGM node {192.168.50.100}
[NDB_MGMD DEFAULT]
PortNumber=1186
#LogDestination=CONSOLE;SYSLOG:facility=syslog;FILE:filename=/var/log/mysqlcluster-log
DataDir=/var/lib/mysql-cluster
ArbitrationRank=1
[NDB_MGMD]
Id = 1
HostName= 192.168.50.100
DataDir= /var/lib/mysql-cluster
[NDBD DEFAULT]
DataDir=/var/lib/mysql-cluster
NoOfReplicas=2
DataMemory=1664MB
IndexMemory=256MB
MaxNoOfConcurrentOperations=10000
MaxNoOfOrderedIndexes=512
MaxNoOfUniqueHashIndexes=256
MaxNoOfTables=256
MaxNoOfAttributes=1500
[NDBD]
Id = 2
HostName = 192.168.50.1
[NDBD]
Id = 3
HostName = 192.168.50.2
[MYSQLD]
Id = 4
HostName = 192.168.50.1
[MYSQLD]
Id = 5
HostName = 192.168.50.2
--------------------------------------
</etc/my.cnf> App1 {192.168.50.1}
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysql_cluster]
ndb-connectstring = nodeid=1,192.168.50.100:1186
[mysqld]
log-error
ndbcluster
ndb-connectstring = 192.168.50.100:1186
ndb-nodeid = 4
ndb-mgmd-host = 192.168.50.100
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 16
log-bin=mysql-bin
server-id = 1
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 512M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
--------------------------------------------
</etc/my.cnf> App2 {192.168.50.2}
Same as above.....
****************************************************************************
Please, help...I'm really stuck with this problem and don't find any solution!
I also installed version 5.0.51a and with same configs as above, mysql command 'show engines;' showed that NDB engine was DISABLED!!
Could be a configuration problem?
Thanks a lot for the attention...really appreciate any help to deploy this cluster!
Regards,
Eduardo J.
Sorry, you can't reply to this topic. It has been closed.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.