www.infinidb.org

Contributed by Calpont, InfiniDB Community Edition is a scale-up analytic database for your data warehousing, data discovery and advanced analytics needs. Enabled by MySQL® and with column-oriented technology at its core, InfiniDB Community Edition is purpose-built for analytical workloads, fully encompassing analytic query, transactional support and bulk load operations. Download, install, and enter the world of scalable, high performance analytics.

             | 

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. For complete details of installations and execution of InfiniDB, see the InfiniDB documentation available at: http://www.infinidb.org/downloads/cat_view/39-documentation.  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.

Minimum hardware specifications are:

- Intel or AMD x86 architecture

- 8GB 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

- 64-bit Ubuntu v5

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.

 

What other checks should I make prior to installation?

If you have previous versions of MySQL installed on your machine, you will want to either stop any running instance of MySQL and change the port that MySQL is using or change the InfiniDB default port during install (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 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 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 Community Edition 2.1-2 Final
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

 

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 testdb.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?

As mentioned above, for more detailed install, upgrade instructions and execution of InfiniDB, please see the most recent copy of the documentation available at: http://www.infinidb.org/downloads/cat_view/39-documentation .

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