Description:
ndbcluster support not available in the package version 5.1 of mysqld-server for RHEL4.
How to repeat:
Install the rpm packages available on http://dev.mysql.com/downloads/mysql/5.1.html#linux-rhel4-x86-64bit-rpms :
------------8<------------
# rpm -ivh MySQL-clusterextra-community-5.1.23-0.rhel4.x86_64.rpm MySQL-clustertools-community-5.1.23-0.rhel4.x86_64.rpm MySQL-clustermanagement-community-5.1.23-0.rhel4.x86_64.rpm MySQL-server-community-maria-5.1.23a-0.rhel4.x86_64.rpm MySQL-client-community-maria-5.1.23a-0.rhel4.x86_64.rpm MySQL-clusterstorage-community-5.1.23-0.rhel4.x86_64.rpm
#
------------8<------------
You should then have all the required packaged install :
------------8<------------
# rpm -qa | grep -i mysql
MySQL-clustertools-community-5.1.23-0.rhel4
MySQL-clustermanagement-community-5.1.23-0.rhel4
MySQL-server-community-maria-5.1.23a-0.rhel4
MySQL-clusterextra-community-5.1.23-0.rhel4
MySQL-clusterstorage-community-5.1.23-0.rhel4
MySQL-client-community-maria-5.1.23a-0.rhel4
#
------------8<------------
If mysqld is launch with the --ndb-cluster (or --ndbcluster), it results in an error :
------------8<------------
# su - mysql -c "/usr/sbin/mysqld --ndb-cluster"
080306 11:59:10 InnoDB: Started; log sequence number 0 46409
080306 11:59:10 [ERROR] /usr/sbin/mysqld: unknown option '--ndb-cluster'
080306 11:59:10 [ERROR] Aborting
080306 11:59:10 InnoDB: Starting shutdown...
080306 11:59:13 InnoDB: Shutdown completed; log sequence number 0 46409
080306 11:59:13 [Note] /usr/sbin/mysqld: Shutdown complete
#
# su - mysql -c "/usr/sbin/mysqld --ndbcluster"
080306 11:59:33 InnoDB: Started; log sequence number 0 46409
080306 11:59:33 [ERROR] /usr/sbin/mysqld: unknown option '--ndbcluster'
080306 11:59:33 [ERROR] Aborting
080306 11:59:33 InnoDB: Starting shutdown...
080306 11:59:35 InnoDB: Shutdown completed; log sequence number 0 46409
080306 11:59:35 [Note] /usr/sbin/mysqld: Shutdown complete
#
------------8<------------
If MySQLd is launched without the ndbcluster support, I can check that the ndb engine is not available :
------------8<------------
# mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.23a-maria-alpha-community-maria-log MySQL Community Server [Maria] (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW ENGINES\G;
*************************** 1. row ***************************
Engine: FEDERATED
Support: YES
Comment: Federated MySQL storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 2. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 3. row ***************************
Engine: MyISAM
Support: DEFAULT
Comment: Default engine as of MySQL 3.23 with great performance
Transactions: NO
XA: NO
Savepoints: NO
*************************** 4. row ***************************
Engine: MARIA
Support: YES
Comment: Crash-safe tables with MyISAM heritage
Transactions: YES
XA: NO
Savepoints: NO
*************************** 5. row ***************************
Engine: CSV
Support: YES
Comment: CSV storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 6. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 8. row ***************************
Engine: BLACKHOLE
Support: YES
Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
XA: NO
Savepoints: NO
*************************** 9. row ***************************
Engine: InnoDB
Support: YES
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
9 rows in set (0.00 sec)
ERROR:
No query specified
mysql>
------------8<------------
The version used :
------------8<------------
mysql> SELECT version();
+-----------------------------------------+
| version() |
+-----------------------------------------+
| 5.1.23a-maria-alpha-community-maria-log |
+-----------------------------------------+
1 row in set (0.00 sec)
mysql>
------------8<------------
Suggested fix:
Build the package with the ndbcluster support.
