Welcome!

SOA & WOA Authors: Ali Hussain, David Tishgart, Kevin Benedict, Jerry Melnick, Elizabeth White

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, BScEng, is specializing in Big Data/Data Architecture consulting services ( database/data architecture, machine learning ). His clients are in finance, retail, telecommunications industries. Ranko is welcoming inquiries about his availability for consulting engagements and can be reached at 408-757-0053 or ranko.mosic@gmail.com