Installing infiniDB community edition on Linux

Posted: June 3, 2011 | Author: survivalguides | Filed under: infinidb | Leave a comment »

I am in the realms of infiniDb today and it appears easy to install the only problem is it doesn’t work without a bit of effort

I am installing on Centos 5.6 but other distros also work, adapt the install part to your OS

OK the easy bits to start with

Download form here You have to register but thats OK

Please NOTE if you have mysql running then you need to stop this as infinidb uses port 3306, this can be changed see later on in the post

The basics are taken from here

You need to install boost to start with

yum install boost

Once downloaded unzip and untar the rpm file

tar -zxf

This creates 3 rpm files. To install

rpm -i calpont*.rpm

You need to run the post installation script now

./usr/localCalpony/bin/install-infinidb.sh

To start infinidb the instructions are a little wrong to start the database

./usr/local/Calpont/bin/infinidb start

This will start mysql and the infinidb engine

To get a mysql command

./usr/local/Calpont/bin/calpontAlias

You can then run

idbmysql  and you will get the traditional promprt you now have a working system.

To test

idbmysql

create database testdatabase;

create table testtable(test varchar(10)) engine=infinidb;

Now the fun bits

I have mysql running on my server and also as I want to make this scalable so I want to move the database files to a different location.

Changing the port is simple.

vi /usr/local/Calpont/mysql/my.cnf

Find 3306 and change to what ever port number you want I used 3307 it may be reservered for another function, but this server is only going to run mysql and is never going to be presented to the outside world.

You can then restart the server to see if all is well.

Moving the database is a littl more fun. Make sure the database is stopped

Create a directory in the location that you want oto store the files

e.g /u10/mysql-infinidb therefore

mkdir /u10/mysql-infinidb

cp -r /usr/local/Calpont/mysql/db  /u10/mysql-infinidb/

chown -R mysql:mysql /u10/mysql-infinidb

You then ned to change the my.cnf file and the mysql-Calpont file

vi /usr/local/Calpont/mysql/my.cnf

Find and alter the following line.  I commented out as can be seen just for easier dugugging

There is another way of doing this here

#datadir         = /usr/local/Calpont/mysql/db
datadir         = /u10/mysql-infinidb/db

vi /etc/init.d/mysql-Calpont

Find the following lines

# @bug 2104. remove all left over vtables. Look for @0024vtable ($vtable).
# “@0024vtable” is a reserved word of InfiniDB and can not be used in regular user table name.
cd db
find . -name ‘@0024vtable*’ | xargs /bin/rm -f
cd ..
and change to

# @bug 2104. remove all left over vtables. Look for @0024vtable ($vtable).
# “@0024vtable” is a reserved word of InfiniDB and can not be used in regular user table name.
#cd db
cd /u10/mysql-infinidb/db This is the location that you created in the previous step
find . -name ‘@0024vtable*’ | xargs /bin/rm -f
#cd ..
    cd /usr/local/Calpont/mysql

You should then be able to start the database

I use Webmin for looking after mysql and it can be configured to look after inifindb as well

---