How to use INNODB in Infobright IEE edition? please reply.

Hi!
Innodb is not available in IEE.

Thanks for your reply.

We understand that MyISAM doesn’t support Transactions. Actually we need to incorporate transactions in our project using Infobright.

we understand that innodb supports transaction.

Can you please advise us how to use Innodb with Infobright to avail transaction facility ? if not can you please recommend other databases that supports Infobright along with Transaction facility.

Hi !

I can think of installing both: standard mysql with innodb and IEE, both servers using their own databases. Transactions are handled by standard mysql with innodb. Data is moved to IEE from standard mysql with export + load.
Anyway, even if innodb is incorporated in IEE, IEE would not be faster than standard mysql with queries involving innodb tables. So you need to keep both engines used in separation to have performance. Therefore two servers seem to be a viable solution.

So if I go with two servers, Can I have the below facility.

1) select * from innodb.table
  union
  select * from brighthouse.table;

2) Joining innodb and brighthouse tables.
3) Insert into brighthouse.table select * from innodb.table

Do I need to do any configuration settings to achieve the above facility ?

Currently I can acheive the above using MyISAM and brighthouse engine.

Hi !

Well, you cannot directly. Yes, you can after export + load innodb tables into IEE.

As I mentioned, queries involving tables other than defined as engine=brighthouse are slow, or very slow. They are executed by mysql optimizer. I am not sure if you really want to have tables from different engines in one query - unless you have small tables or the performance is not an issue.

And 3) “Insert into ... select…” is to be replaced by export + load with the two servers solution.