Welcome!

SOA & WOA Authors: Elizabeth White, Pat Romanski, Leonard Johnson, Mark van Rijmenam, Liz McMillan

Related Topics: Java, SOA & WOA, Open Source, Cloud Expo

Java: Article

Installing Vertica

Vertica is state-of-the-art, blazingly fast RDBMS built for Big Data

Vertica is high-performing, advanced RDBMS that is very simple to install and administer, thanks to the its modern design and purpose built architecture.

Once we execute all preparatory steps on database servers and download Vertica software as per Installation Guide, we are starting installation process on a two node cluster (host01, host02):

/opt/vertica/sbin/install_vertica -s host01,host02 -r vertica-ce-5.1.1-0.x86_64.RHEL5.rpm

We initiate database creation process using dbadmin tool:

$ /opt/vertica/bin/adminTools

We will pick option 6 ( Configuration Menu ), then option 1 to Create Database:

The database name is vmartdb:

Here we are selecting hosts for our database:

We are accepting default directories for catalog and database files:

Database creation progress screen is presented to us - ending up with database successfully created and running on our two node cluster:

You should note ease and simplicity of installation and database creation process. There are no extensive cluster and shared storage preparations on special hardware ( in sharp contrast with Oracle RAC installation, for example ). This is all happening on commodity hardware, yet we end up with extremely powerful cluster. Vertica is up to 100 times faster than classic RDBMSs like Oracle. It is truly horizontally scalable database ( scale out ) i.e., you simply scale processing power and storage capacity by adding new nodes.

More Stories By Ranko Mosic

Ranko Mosic, B. Eng, OCP, is specializing in data management systems. He has more than 20 years of North American IT consulting industry experience. His texts about Oracle database were published in various industry publications and his profile was published in Oracle Magazine. He can be reached at ranko.mosic@gmail.com