www.infinidb.org

.... ...........

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.

How to Get Started with InfiniDB

E-mail Print PDF

Getting Started with InfiniDB

Welcome to InfiniDB! In an attempt to help get you up and running with InfiniDB as quickly as possible, below are step-by-step instructions and tips that will help guide you through installing and using InfiniDB. Please don’t hesitate to contact us if you experience any issues – we’ll do everything possible to make sure your experience with InfiniDB is a good one.

What prerequisites do I need to get started?

Before you download or try to install InfiniDB, you should first be sure that you have: (1) a machine meeting the minimum hardware requirements; (2) a supported operating system; (3) the necessary software prerequisites installed on your operating system.

Minimum hardware specifications are:

- Intel or AMD x86 architecture

- 2GB of RAM

- 200MB of disk space

InfiniDB currently runs on the following operating systems:

- 64-bit Red Hat Enterprise Linux v 5

- 64-bit CentOS Linux v5

- 64-bit Debian ‘lenny’ Linux v5

- 32-bit Fedora Core Linux v6 and higher

- Ubuntu when built from source code

- 32 and 64-bit Windows Server 2008, Vista, Windows 7, and Windows XP

Software prerequisites that must be installed on your Linux operating system include:

- Boost, versions 1.33-1.40

If your environment does not meet the criteria above, you should locate another machine that meets the required specifications, or do a build from source for your particular system.

 

How do I check if boost is installed on my Linux OS?

For Red Hat Enterprise Linux, CentOS, and Fedora, enter the following command:

rpm -qa | grep boost

For Debian, enter the following command:

$ dpkg -s boost

For Ubuntu, enter the following command:

$ dpkg -s boost

 

How do I install boost if it is not already installed?

You can install boost by entering the following Linux command, which should install the correct version of boost for your operating system:

For Red Hat, CentOS, or Fedora:

yum install boost

For Ubuntu:

ap-get boost

Note you can also install boost from your OS installation media.

 

What other checks should I make prior to installation?

If you have previous versions of MySQL installed on your machine, you will want to stop any running instance of MySQL and/or change the port that MySQL is using (default is 3306, which is what InfiniDB will use by default).

 

What download do I need?

Download either the RPM or TAR file binary download file for your operating system (see above for supported operating systems). You can find all binary downloads at: http://www.infinidb.org/downloads/cat_view/40-binary-release .

Ensure that you have the right binary for the right operating system and architecture (32 or 64-bit).

 

How do I install InfiniDB using an RPM binary on Linux?

Follow these instructions to install InfiniDB using an RPM binary:

  • Log in to your operating system as the ‘root’ user.
  • Unpack the RPM file using the following command
tar –zxf
  • Install the three RPM’s that are extracted from the download file using the following command:
rpm –ivh calpont*.rpm
  • Run the post-install script:
. /usr/local/Calpont/bin/install-infinidb.sh
  • Configure InfiniDB aliases and environment variables for your user account by running the following script:
. /usr/local/Calpont/bin/calpontAlias

 

How do I install InfiniDB using a TAR file binary on Linux?

Follow these instructions to install InfiniDB using a TAR binary:

  • Log in to your operating system as the ‘root’ user.
  • Unpack the TAR file into the /usr/local directory using the following command:
tar –zxf
  • Run the post-install script:
. /usr/local/Calpont/bin/install-infinidb.sh
  • Configure InfiniDB aliases and environment variables for your user account by running the following script:
. /usr/local/Calpont/bin/calpontAlias

 

How do I start and stop InfiniDB on Linux?

To start the InfiniDB service, enter the command:

service infinidb start

To stop the InfiniDB service, enter the command:

service infinidb stop

You can also path directly to the commands:

/etc/init.d/infinidb start
/etc/init.d/infinidb stop

How do I issue SQL Commands to InfiniDB on Linux?

First run the InfiniDB alias and environment script (you can also put these variables in your user account startup shell script):

. /usr/local/Calpont/bin/calpontAlias

Then invoke the InfiniDB client interface, idbmysql:

[root@rtyhgu8 bin]# idbmysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.1.39-commercial InfiniDB Enterprise Edition 0.9.5.1-0-alpha (Commercial)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

How do install and use InfiniDB on Windows?

Installing and using InfiniDB on Windows is very easy. See the Windows FAQ for a quick tutorial on installing/using InfiniDB on Windows.

 

How do load data into InfiniDB?

First create the database and tables you want to load data into.  For example:

mysql> create database testdb;
Query OK, 1 row affected (0.00 sec)
mysql> create table mytable (c1 int) engine=infinidb;
Query OK, 0 rows affected (1.59 sec)

Then you can load data into one or more tables either using the InfiniDB fast bulk loader or the MySQL LOAD DATA INFILE utility (which is much slower than InfiniDB's bulk loader). For an example of how to use InfiniDB's bulk loader, click here. For an example of how to use MySQL's LOAD DATA INFILE, click here.

 

How do I uninstall InfiniDB on Linux?

First, shut down any running instances of InfiniDB:

service infinidb stop.

If you installed InfiniDB using RPM’s, enter:

rpm -e calpont calpont-mysql calpont-mysqld

If you installed InfiniDB with a TAR file, then remove the directories in which you unpacked the TAR file and remove the infinidb service from the /etc/init.d directory.

 

How can I do a source build of InfiniDB?

 

tar –zxf

  • Change directories to the create directory (e.g. calpont-infinidb-0.9.5.1)
  • Follow the instructions in the INSTALL file that is provided

 

Where do I go for more information?

For more detailed install and upgrade instructions, please see the most recent copy of the InfiniDB Jumpstart Guide available at: http://www.infinidb.org/downloads/cat_view/39-documentation .

You will find other documentation at the above link including the InfiniDB Concepts, Administration, and SQL Syntax Guides.

To get help with installation or other questions, please visit the InfiniDB forums at: http://www.infinidb.org/forums .