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 run InfiniDB on Amazon Web Services?

E-mail Print PDF

Yes, we recently setup and ran InfiniDB on an EC-2 Extra Large Instance using the bundled ephemeral disk and 4 cores.

 

Example syntax to start the instance after setting up the access keys, group, and environment variables:

 

ec2-run-instances ami-86db39ef -k gsg-keypair -g calpont2 -t m1.xlarge -b "sdb=ephemeral0" -b "sdc=ephemeral1" -b "sdd=ephemeral2" -b "sde=ephemeral3"

 

Syntax to initialize and mount one disk, 4 are available by default with an extra-large instance:

 

 mkfs /dev/sdb

 

  fdisk /dev/sdb

 

 mke2fs /dev/sdb1

 

 mount /dev/sdb1 /mnt/data1 -t ext2 -o rw

 

After intallation of InfiniDB create an alias to idbmysql:

 

. /usr/local/Calpont/bin/calpontAlias

 

Run Infinidb:

 

idbmysql ssb100 -vvv ssb_complete.log

 

 

  

For a more detailed example set of instructions and a look at installing and running InfiniDB on an Amazon EC2, please visit our blog.

 

InfiniDB in the Cloud at Amazon Web Services (EC2)