back to blog
July 10, 2014 | Dipti Joshi

Installing InfiniDB becomes even simpler with Enterprise Manager

This week, we announced our new InifiniDB Enterprise 60-day Trial, featuring InfiniDB Enterprise Manager.  In this post, I would like to show you how I used Enterprise Manager’s very simple user interface to install an InfiniDB cluster.

I have following setup designated for my InfiniDB Cluster:

1 UM, 2 PMs

UM –

PM1 –

PM1 –

I am installing Enterprise Manager on UM that is

These are CentOS 6 servers and I have setup password less SSH among them

First, I downloaded the InfiniDB Enterprise trial from, and followed the install instructions in the Enterprise Manager guide included in the documentation set: ( to install the Enterprise Manager software.

Next, I went to  to view the Enterprise Manager Home Page:


I clicked on the “Provision Cluster” button (that would be my first click), and was presented with this screen:


I entered the name of my InfiniDB Cluster Name, “test_infinidb_cluster”.

For host names, I gave an IP address of “UM” and “PM nodes” for the InfiniDB cluster.

For the user, I chose “root”, as it is passwordless SSH user id for the UM and PM nodes.

For the key, I selected EM_id_rsa.txt file where I had the SSH key stored. 

Then, I clicked continue (that would be my second click) and my Host reports page appeared:



This page was pre-populated with default values for software version, storage type and deployment type.  I changed the deployment type to “Separate UM/PM”, as I am doing a multi-server install.

Primary PM and Secondary PM are the two PM where the primary and secondary OAM modules run for management of the cluster – it is there for information only.  Enterprise Manager automatically assigned the PM1 role to, the PM2 role to, and the UM2 role to

On the same page, there is also a configuration tab with default configuration options - I chose not to make any changes to those options.

Next, I pressed the install button – (that would be my third click) and in few minutes, my cluster was successfully installed!

From there, I could view the details of my newly installed cluster – “test_infinidb_cluster” - on the cluster page:


There, I clicked on the cluster “test_infinidb_cluster" for more details:


At this point, my InfiniDB cluster was ready to be used for database operations.

I was able to SSH to the UM node ( and use idbmysql  to do queries:

root@qavmEMum1:~# idbmysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.1.73 InfiniDB 4.6 Beta

Copyright (c) 2014, InfiniDB, Inc. and/or its affiliates. All rights reserved.

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

InfiniDB is a registered trademark of InfiniDB, Inc. and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


Installing an InfiniDB cluster was just that simple.  Having installed InfiniDB clusters in past manually and without Enterprise Manager, I found this to be the smoothest installation experience I have ever had!  I encourage you to try it for yourself.  Download the Enterprise Trial featuring the new enterprise manager from, and share your experience with us here on this blog or via email at