Contributed by Calpont, InfiniDB Community Edition is an open source, scale-up analytics database engine for your data warehousing, business intelligence and read-intensive application needs. Enabled via MySQLTM and purpose-built for an analytical workload with column-oriented technology at its core, the multi-threaded capabilities of InfiniDB Community Edition fully encompass query, transactional support and bulk load operations.  So come on in, grab a download and get started.

             | 

Can I use other MySQL storage engines with InfiniDB?

E-mail Print PDF

Yes! InfiniDB ships with the MyISAM, Memory, Merge, and CSV engines as built in engines that are installed by default. InfiniDB also ships with the InnoDB plugin, but it is not installed by default. If you want to use InnoDB, you simply install the plugin with the following command:

INSTALL PLUGIN INNODB SONAME 'ha_innodb.so';

At that point, you are able to use InnoDB as normal within your installation.

You can create InnoDB and all other storage engine tables and InfiniDB tables in the same database if you wish, however you cannot join the non-InfiniDB tables together in a SQL query as InfiniDB uses its own optimization techniques to satisfy queries. But, for example, you can work with your transactional databases/objects as normal with InnoDB and also have your data warehouse/mart/analytic tables ready for use with InfiniDB.

You can also download updated version of the InnoDB plugin and install it instead of the version that ships with the InfiniDB bundle.

For more information on installing the InnoDB plugin, see: http://www.innodb.com/doc/innodb_plugin-1.0/innodb-plugin-installation.html.