We are using Infobright that has Brighthouse and MyISAM engines.  Our requirement is to support transactions. As MyISAM engine does not support transactions, we would like to know if we can add INNODB engine that supports transactions as plug-in(instead of MyISAM) to infobright. Does infobright support this and if yes, how to approach?

It would be great if you could let us know the possibility ASAP or if there are any other alternatives.

Hi !

Infobright is ditributed without Innodb because we have no rights to distribute Innodb. I do not know any way a user can add an engine to mysql/Infobright server binaries.

As I wrote in a different thread, mixing brighthouse and innodb tables in a single qurey would lead to low perfromance. You can check it mixing myisam and brighthouse tables in a query. Actually, we have not much practical experience with such settings, so if you do a test, please let us know the conclusions.

Hi

the innodb plugin will not work due to the underlying version of mysql (5.1.14) used by infobright;

in a future release, we may be able
update mysql base version high enough to support the innodb plugin.

of course
if you yourself want to download the source, you could compile with innodb enabled…

tw

Sorry for a beginner’s question. How do I enable innodb support when I compile infobright from source?

I tried to set with_innodb=yes in the environment and compile the ICE source code (3.2GA) according to the instruction. But I got a lot of link error, something looks like this.

../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o): In function `get_one_option(int, my_option const*, char*)’:
mysqld.cc:(.text+0x1993): undefined reference to `innobase_data_file_path’
mysqld.cc:(.text+0x1a01): undefined reference to `innobase_log_archive’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o): In function `_ZL21init_common_variablesPKciPPcPS0_.clone.2’:
mysqld.cc:(.text+0x5d44): undefined reference to `innobase_use_large_pages’
mysqld.cc:(.text+0x5d4c): undefined reference to `innobase_large_page_size’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x1818): undefined reference to `innobase_use_checksums’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x1820): undefined reference to `innobase_use_checksums’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x18f8): undefined reference to `innobase_data_home_dir’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x1900): undefined reference to `innobase_data_home_dir’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x1968): undefined reference to `innobase_use_doublewrite’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x1970): undefined reference to `innobase_use_doublewrite’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x19d8): undefined reference to `innobase_fast_shutdown’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x19e0): undefined reference to `innobase_fast_shutdown’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x1a48): undefined reference to `innobase_file_per_table’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x1a50): undefined reference to `innobase_file_per_table’
../../../../../src/../build/vendor/release/sql/libmysqld.a(mysqld.o):(.data+0x1ab8): undefined reference to `srv_flush_log_at_trx_commit’
...
...

Please help me. I like BH engine for its superior performance, but I need transaction support for other meta data.

Thanks in advance.

Hi !

I am affraid building innodb is not supported.

Well, it is a possibility for the future, but there are licensing issues to include InnoDB in the Infobright product. Who knows, it could happen some day.

In the meantime I recommend that you install a separate instance of plain MySQL (on a different port) to serve your transactional needs with InnoDB.

Geoffrey

What about percona xtraDB? It is an open source innodb replacement. It is under GPLv2.

Here is the link

http://www.percona.com/docs/wiki/Percona-XtraDB:start

> What about percona xtraDB?

We did not try xtraDB or, regarding innodb, did not resolve any issues by adding it in source tree. Best and safe option, as others said, is to go for separate mysql instance.

Thank you all for the fast response. I really appreciate the info. I guess I will just use two instances for now.