| By Ranko Mosic | Article Rating: |
|
| March 27, 2012 08:15 AM EDT | Reads: |
4,308 |
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.
Published March 27, 2012 Reads 4,308
Copyright © 2012 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
- Tableau Software and Vertica Join Forces to Deliver Data Visualization and Analytics on Super-Sized Databases in Cloud Architectures and in Internal Datacenters
- Vertica Systems Launches Vertica Analytic Database for the Cloud - Industry's First On-Demand Analytic Database Service Hosted in the Amazon Elastic Compute Cloud (Amazon EC2)
- BlueCrest Standardizes on Vertica for Firm-Wide Market Data Analytics Requirements
More Stories By Ranko Mosic
Ranko Mosic ( OCP ) is specializing in Oracle Database Administration work. He has more than 20 years of North American IT 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
- Cloud People: A Who's Who of Cloud Computing
- New Relic Q1 2013 Blazes Past Growth Targets and Reaches 40,000 Active Customer Accounts
- Cloud Expo New York: Delivering Digital Marketing on the Cloud
- Cloudant to Exhibit at Cloud Expo & Big Data Expo New York
- Cloud Expo New York: Rethink IT and Reinvent Business with IBM SmartCloud
- The Accessibility of the Cloud
- Learn How To Use Google Apps Script
- Cloud Expo New York: Basics of SSD Technology and Its Use in Cloud
- Cloud Expo New York: Real-Time Analytics Using an In-Memory Data Grid
- Cloud Expo NY: Best Practices for Delivering Oracle Database as a Service
- Cloud Expo New York: The Big Challenge of Big Data & Hadoop Integration
- Measuring the Business Value of Cloud Computing
- Cloud People: A Who's Who of Cloud Computing
- Cloud Expo New York: Best CIO Practices Shared from SHI’s Customers
- Examining the True Cost of Big Data
- Cloud Expo New York: How to Use Google Apps Script
- Software Defined Networking – A Paradigm Shift
- New Relic Q1 2013 Blazes Past Growth Targets and Reaches 40,000 Active Customer Accounts
- Cloud Expo New York: Why Big Data Is Really About Small Data
- Cloud Expo New York: Delivering Digital Marketing on the Cloud
- Small Cancers, Big Data, and a Life Examined
- Cloud Expo New York: Requirements of a Cloud Database
- Cloud Expo NY: Calculating the True Value of Industry-Specific Clouds
- Cloudant to Exhibit at Cloud Expo & Big Data Expo New York
- A Cup of AJAX? Nay, Just Regular Java Please
- Java Developer's Journal Exclusive: 2006 "JDJ Editors' Choice" Awards
- JavaServer Faces (JSF) vs Struts
- The i-Technology Right Stuff
- Rich Internet Applications with Adobe Flex 2 and Java
- Java vs C++ "Shootout" Revisited
- Bean-Managed Persistence Using a Proxy List
- Reporting Made Easy with JasperReports and Hibernate
- Creating a Pet Store Application with JavaServer Faces, Spring, and Hibernate
- Why Do 'Cool Kids' Choose Ruby or PHP to Build Websites Instead of Java?
- What's New in Eclipse?
- Where Are RIA Technologies Headed in 2008?

























