| By Ranko Mosic | Article Rating: |
|
| March 27, 2012 08:15 AM EDT | Reads: |
4,358 |
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,358
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, 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
- Cloud People: A Who's Who of Cloud Computing
- Cloud Expo New York Speaker Profile: Dave Linthicum – Cloud Technology Partners
- Cloud Expo New York: Cloud Is Changing the Economics of Business
- Best CIO Practices Shared from SHI’s Customers
- Cloud Expo New York: Deploying Hybrid Cloud for Performance and Uptime
- Cloud Expo New York: Delivering Digital Marketing on the Cloud
- Big Data Isn’t About the Database, It’s About the Application
- Cloud Expo New York: Rethink IT and Reinvent Business with IBM SmartCloud
- Cloudant to Exhibit at Cloud Expo & Big Data Expo New York
- BEA Updates WebLogic SOA Portal for Web 2.0 Era
- The Accessibility of the Cloud
- How to Move Your Oracle Databases to Amazon EC2 Cloud
- Cloud People: A Who's Who of Cloud Computing
- Cloud Expo New York: Best CIO Practices Shared from SHI’s Customers
- Cloud Expo New York Speaker Profile: Dave Linthicum – Cloud Technology Partners
- Cloud Expo New York: Cloud Is Changing the Economics of Business
- Cloud Expo New York: How to Use Google Apps Script
- Cloud Computing Bootcamp at Cloud Expo New York
- Rackspace Hosting Named “Platinum Plus Sponsor” of Cloud Expo New York
- Best CIO Practices Shared from SHI’s Customers
- Cloud Expo New York: Why Big Data Is Really About Small Data
- Cloud Expo New York: Deploying Hybrid Cloud for Performance and Uptime
- Small Cancers, Big Data, and a Life Examined
- Cloud Expo New York: Delivering Digital Marketing on the Cloud
- The i-Technology Right Stuff
- The Top 150 Players in Cloud Computing
- Who Are The All-Time Heroes of i-Technology?
- Where Are RIA Technologies Headed in 2008?
- Get the Message
- i-Technology Viewpoint: Is Web 2.0 the Global SOA?
- ESB Myth Busters: 10 Enterprise Service Bus Myths Debunked
- i-Technology Viewpoint: Thinking Outside the VC Box
- i-Technology Viewpoint: When to Leave Your First IT Job
- SOA Web Services Edge Conference Coverage on SYS-CON.TV
- SYS-CON.TV's "SOA Web Services" and "Enterprise Open Source" Programs To Air in December
- Five Reasons Why Web 2.0 Matters

























