Joinutility seperatorLogin utility separator Infobright.com
   
 
Include partitioning plug-in?
Posted: 05 April 2010 05:15 PM   Ignore ]  
Newbie
Avatar
Rank
Total Posts:  9
Joined  2010-04-05

I was testing ICE for the past few days and results are better than expected but found 2 downfalls for us. 

1. No InnoDB engine included.
2. No partitioning plug-in.

InnoDB engine is not as much of a factor as I have recently found out that you can install it on an existing DB server.

http://www.innodb.com/products/innodb_plugin/download/

What I was wondering is if there will be a release that will include the partitioning plug-in to be able to utalize MySQL’s new partitioning technology on tables that we need partitioning on.  This would be a great benefit to the ICE package as many people are getting into the MyISAM partitioning but ICE currently does not support this.  Not specifically the Infobright but it is not currently packaged with Infobright.

Another benefit would be is if it was possible to create a plug-in or or shared library of Infobrights engine such as InnoDB has done with theirs, that way no one will need to delete current installed MySQL servers and install Infobright’s enbeded server of MySQL.  This will eliminate so much hasstle of backing up huge tables and databases just to move them around over period of a few days just to get new engine up and running.

Profile
 
Posted: 06 April 2010 03:28 AM   Ignore ]   [ # 1 ]  
Super Duper Member
Avatar
RankRankRankRankRank
Total Posts:  914
Joined  2008-08-18

Hi !

ICE cannot be added as a plugin, because it uses a significantly modified mysql code. Currently this makes it technically impossible to add ICE to a vanilla mysql

About partitioning - it is not foreseen in ICE. What is the purpose of it in your case? Partitioning in MyISAM can be a MyISAM specific technical tool to deal with deficiencies not present in ICE. Not to mention that creation and maintaining of partitioning is a database administration cost.

Profile
 
Posted: 06 April 2010 11:24 AM   Ignore ]   [ # 2 ]  
Newbie
Avatar
Rank
Total Posts:  9
Joined  2010-04-05

I think you have misunderstood me in my first post.  I am not asking for ICE to allow partitioning as it would be out right ridiculous.  I am asking that the MySQL plug-in partitioning be added so that I can still use MyISAM table with partitioning.  Partitioning is a feature added to MySQL as a plug-in from version 5.1.x onwards only available to MyISAM tables.

If you download and install MySQL from their site, partitioning is already packaged and enabled, but when you guys package ICE within MySQL, for some reason you guys took out the partitioning plug-in from 5.1.x.  I am simply asking if you guys could release ICE embedded with the partitioning module that MySQL has provided for MyISAM.

I have also spoken on the phone with a Infobright rep. and they have told me that it might be done in the near future considering it is a standard plug-in for MySQL.

Profile