MySQL Bugs: #38065: not include innodb in mysql5.1.24-ndb6.3.26

Bug #38065	not include innodb in mysql5.1.24-ndb6.3.26
Submitted:	12 Jul 2008 9:51	Modified:	15 Sep 2008 13:21
Reporter:	ws lee	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	mysql5.1.24-ndb6.3.26	OS:	Any
Assigned to:	Jon Stephens	CPU Architecture:	Any

Description:
I have compiled in --with-innodb option.
But, In mysql5.1.24-ndb6.3.26,  I can't use innodb engine.

How to repeat:
./configure --prefix=/usr/local/mysql --with-ndbcluster --with-innodb
make
make install

mysql> select version();
+-----------------------------+
| version()                   |
+-----------------------------+
| 5.1.24-ndb-6.3.16-telco-log | 
+-----------------------------+
1 row in set (0.00 sec)

mysql> show engines;
+------------+---------+-----------------------------------------------------------+--------------+----+------------+
| Engine     | Support | Comment                                                   | Transactions | XA | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+----+------------+
| ndbcluster | DEFAULT | Clustered, fault-tolerant tables                          | YES          | NO | NO         | 
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                     | NO           | NO | NO         | 
| CSV        | YES     | CSV storage engine                                        | NO           | NO | NO         | 
| FEDERATED  | YES     | Federated MySQL storage engine                            | NO           | NO | NO         | 
| MyISAM     | YES     | Default engine as of MySQL 3.23 with great performance    | NO           | NO | NO         | 
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables | NO           | NO | NO         | 
+------------+---------+-----------------------------------------------------------+--------------+----+------------+
6 rows in set (0.00 sec)

mysql> create table biglog(a int, b text) engine=innodb;
Query OK, 0 rows affected, 3 warnings (1.22 sec)

mysql> show warnings;
+---------+------+----------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                              |
+---------+------+----------------------------------------------------------------------------------------------------------------------+
| Warning | 1286 | Unknown table engine 'innodb'                                                                                        | 
| Warning | 1266 | Using storage engine ndbcluster for table 'biglog'                                                                   | 
| Error   | 1478 | Table storage engine 'ndbcluster' does not support the create option 'Binlog of table with BLOB attribute and no PK' | 
+---------+------+----------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.01 sec)

I double check this.

Download: mysql-5.1.24-ndb-6.3.16-telco.tar.gz

This is the community version.

select version();
+-------------------------------+
| version()                     |
+-------------------------------+
| 5.1.24-ndb-6.3.16-telco-debug | 
+-------------------------------+

 show engines\G
*************************** 1. row ***************************
      Engine: MRG_MYISAM
     Support: YES
     Comment: Collection of identical MyISAM tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 2. row ***************************
      Engine: MyISAM
     Support: DEFAULT
     Comment: Default engine as of MySQL 3.23 with great performance
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 3. row ***************************
      Engine: BLACKHOLE
     Support: YES
     Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 4. row ***************************
      Engine: CSV
     Support: YES
     Comment: CSV storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 5. row ***************************
      Engine: MEMORY
     Support: YES
     Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 6. row ***************************
      Engine: FEDERATED
     Support: YES
     Comment: Federated MySQL storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 7. row ***************************
      Engine: ARCHIVE
     Support: YES
     Comment: Archive storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
7 rows in set (0.00 sec)

InnoDB is missing here.

It's worse than that; innobase is completely missing from everything since 6.3.10.  Copying from my post at http://forums.mysql.com/read.php?25,224650,224650#msg-224650

InnoDB *missing* in ndb >= 6.3.10 sources.

The ndb 6.3.9 release notes say that InnoDB support was added back in, and indeed, the sources have storage/innobase/, but I've just checked mysql-5.1.23-ndb-6.3.[NUM]-telco.tar.gz, where num is 10, 13, 14, 15, and 16, and *none* of them have storage/innobase/.

How do I get InnoDB working in the latest version?

Thanks.

-Robin

Hi Robin and Lee,

you need ndb and innodb in parallel within a single mysqld instance? Asking this because it is not the most common request. 

Have you considered using our supported pro binaries which contain both?

I do indeed need both.  I need to migrate a production InnoDB database onto a version of MySQL such that we can later move to clustering.  It needs to be in stages to avoid downtime.

I need NDB 6.3 features, as well, so as far as I know there are no binaries.

Not that any of this matters: this is a *regression bug*.  The 6.3.9 release notes explicitly state that InnoDB was added back in, and indeed, the 6.3.9 sources have it, but none after that do, and the release notes do not say it was taken out on purpose.  It's *supposed* to be there.

-Robin

We have the same request.
To be able to include InnoDB engine along with the ndb cluster engine in this build.

-David

Having the same issue. Have used NDB and Innodb together for long time, and went to upgrade to the latest version (5.1.24-ndb-6.3.16-telco) and no innodb support. Perhaps Sun wants to discourage the free/community use of these engines together? Very skeptical of motives here...

Thank you for your feedback. 

There is no particular reason to not have InnoDB and Cluster bundled in one GPL source release. We updated the 6.3.17 GPL source release to contain both. Please check downloads at

ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.27-ndb-6.3.17

and get the file mysql-5.1.27-ndb-6.3.17-innodb.tar.gz.

Documented bugfix in the 5.1.27-ndb-6.3.17 changelog as follows:

        Support for the InnoDB storage engine was missing
        from the GPL source releases. An updated GPL source tarball
        mysql-5.1.27-ndb-6.3.17-innodb.tar.gz which
        includes code for building InnoDB can be found on
        the MySQL FTP site (ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.27-ndb-6.3.17/).