HP Big Data Getting Started Guide

HP ConvergedSystem 300 for Vertica Getting Started Guide

Abstract
This document provides an overview of the HP ConvergedSystem 300 for Vertica appliance. It is intended to be used by system administrators and technical professionals involved with planning, operations, and administration of the appliance or database.
HP Part Number: 5900-3765 Published: March 2014 Edition: 1
Notices
The information contained herein is subject to change without notice. The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein.
Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license.
Microsoft®, Windows®, and Windows Server® are U.S. registered trademarks of the Microsoft group of companies.
Red Hat® Enterprise Linux and Red Hat® are trademarks of Red Hat, Inc. in the United States and other countries.

Contents

1 Overview..................................................................................................4
Who should use this guide.........................................................................................................4
2 The HP CS300 Vertica appliance.................................................................5
Appliance overview..................................................................................................................6
Installation..........................................................................................................................7
Management software..............................................................................................................9
HP Insight Cluster Management Utility....................................................................................9
HP Insight Remote Support..................................................................................................11
3 Using HP Vertica......................................................................................12
Overview..............................................................................................................................12
Learning about HP Vertica.......................................................................................................12
Accessing HP Vertica..............................................................................................................12
Database superuser (dbadmin)............................................................................................12
HP Vertica interfaces..........................................................................................................12
Connecting to HP Vertica....................................................................................................13
Running the HP Vertica Getting Started Tutorial...........................................................................16
Creating the example database...........................................................................................16
Querying tables in the example database.............................................................................17
Using Database Designer to optimize a design......................................................................17
Dropping the example database..........................................................................................17
Performing common database administrator tasks.......................................................................18
Creating a database..........................................................................................................18
Rules for database and password names...............................................................................18
Starting and stopping the database......................................................................................18
Reconnecting to the database..............................................................................................18
Implementing security.........................................................................................................18
Creating new database users..............................................................................................18
Creating tables..................................................................................................................19
Loading data into the database...........................................................................................19
Monitoring the database.....................................................................................................19
Using HP Vertica Management Console................................................................................19
Performing advanced database administrator tasks.....................................................................20
Installing HP Vertica software for third-party tool integration.....................................................20
Managing load balancing for client connections....................................................................20
Managing database resources............................................................................................20
Changing the dbadmin password........................................................................................21
Installing or upgrading an HP Vertica license key...................................................................21
More information for using HP Vertica..................................................................................21
4 Support and other resources......................................................................23
Information to collect before contacting HP.................................................................................23
How to contact HP..................................................................................................................23
Typographic conventions.........................................................................................................23
5 Documentation feedback ..........................................................................24
Contents 3

1 Overview

The HP ConvergedSystem 300 for Vertica is a purpose-built solution developed through collaborative engineering efforts between the HP ConvergedSystems Engineering Team and HP Vertica. Designed to simplify the implementation and management of real time analytic applications, HP CS300 Vertica provides excellent performance through Massively Parallel Processing (MPP) technology.
The HP CS300 Vertica architecture enables distributed query execution, where each query executes on all HP Vertica clusters in parallel. This architecture gives the HP CS300 Vertica application system the speed to provide user queries with significantly higher levels of I/O throughput than is available on a scale-up symmetric multiprocessing (SMP) system.
Table 1 Related documentation
LocationTopic
HP ProLiant DL380p Gen8 Server User GuideHP ProLiant Gen8 Server HP ProLiant DL360p Gen8 Server User Guide
HP Insight Cluster Management Utility

Who should use this guide

This document is intended for system administrators and database administrators. Knowledge of Linux and SQL commands is required.
http://h20628.www2.hp.com/km-ext/kmcsdirect/ emr_na-c04015665-2.pdf
http://www.hp.com/go/insightmanagement/docsHP Insight Management
http://www.hp.com/go/ilo/docsHP iLO
http://www.hp.com/go/insightremotesupport/docsHP Insight Remote Support
http://www.hp.com/go/convergedsystem/cs300vertica/docsHP Vertica documentation
Management Console DemoHP Vertica Webinars Semi structured data
4 Overview

2 The HP CS300 Vertica appliance

This section provides information about your servers and will help you to locate components in your HP CS300 Vertica appliance.
The appliance arrives at your location in a default configuration with pre-loaded software as shown in Table 2: “Appliance configuration”.
Table 2 Appliance configuration
Configuration
HP Vertica server
2 Management servers
HP ProLiant DL380p Gen8 server
2U Rack form factor
Two Intel Xeon E5–2690v2 (CPU)
Ethernet 10Gb 2P 561FLR-T FIO adapter
Two 300GB 6G SAS 10K 2.5in SC ENT HDD
Twenty-three 600GB 6G SAS 10K 2.5in SC ENT HDD
Two 750W CS Plat PL hot plug power supply kit
128 GB (eight 16GB 2Rx4 PC3–14900R-13 kit)
HP Insight Cluster Management Utility – 3 year 24x7 Flex license
HP ProLiant DL360p Gen8 server
1U Rack form factor
One Intel Xeon E5–2660 v2 (CPU)
64 GB (four 16GB 2Rx4 PC3–14900R-13 kit) memory
Four 600 GB 6G SAS 10K 2.5in SC ENT HDD
Ethernet 10 Gb 2P 51FLR-T FIO adapter
Two 460W CS Plat PL hot plug power supply kit
HP Insight Control HP Vertica Analytics Platform HP Insight Control Flex license RHEL Server 2 Skt 1 Guest 24x7 3 year license HP Insight Cluster Management Utility – 3 year 24x7 Flex license HP Insight Remote Support Advanced Operating System — Red Hat Enterprise Linux 6.4 Operating System — Windows server 2012
HP 5900AF-48XGT 4QSFP+ switchNetworking
Forty-eight RJ-45 1/10GbE ports
Four QSFP+ 40–GbE ports
One RJ-45 serial console port
One RJ-45 out-of-band management port
One USB 2.0
3 year — 4 hour 24x7 Proactive CareSupport
TIP: Serial numbers are listed on the Linux management server in the /opt/hp/CS300/
CS300SN.log file and on each physical device.
5

Appliance overview

The appliance is scalable from 3 to 16 servers per rack as shown in “Hardware configuration”
(page 6). There are two management servers running Red Hat Enterprise Linux (RHEL) and Microsoft
Windows Server, respectively. The Linux server supports HP Vertica and cluster management. The Windows server manages HP Insight Control and HP Insight Remote Support Advanced.
TIP: HP recommends configuring in multiples of 4 per rack.
Figure 1 Hardware configuration
The appliance uses a simple naming convention to distinguish servers. Each server is represented using the rack number, server type, and server number as shown below.
rxxx — rack number
dd — indicates type
vn — Vertica server
mn — Management server
sw — Ethernet switch
pd — Power distribution unit
yyy — number in the rack
The example in Figure 2: “Appliance naming convention” (page 7) shows the management servers using the naming conventions.
r001mn002 — Windows management server r001mn001 — Linux management server
6 The HP CS300 Vertica appliance
Figure 2 Appliance naming convention

Installation

During the HP CS300 Vertica Installation & Startup Service, your appliance was connected using either 10Gb or 1Gb Ethernet and configured for your corporate network. Your organization supplied passwords and IP addresses to HP Technical Services. For a high-level overview of your configuration, including IP addresses, see the file at /opt/hp/CS300/HPCS300.xml on the Linux management server (r001mn001), as shown in “IP addresses” (page 8).
IMPORTANT: Do not edit or change the /opt/hp/CS300/HPCS300.xml file.
Appliance overview 7
Figure 3 IP addresses
NOTE: There are two HP 40GbE QSFP+ ports per switch. Each 40 GbE QSFP+ port is convertible
to 10GbE SFP+ with an adapter. Two adapters are provided with each rack. In addition, there are thirty 1GbE/10GbE RJ45 ports per switch.
There are two Ethernet switches, each switch with fourteen available ports, for a total of fifty-six available 10Gb/1Gb ports on both switches. There are also two 40Gb ports on each switch.
TIP: HP recommends assigning Ethernet ports beginning at port 44 and working backward,
ending at port 17.
Available ports are shown in “Ethernet ports” (page 8).
Figure 4 Ethernet ports
8 The HP CS300 Vertica appliance
Loading...
+ 16 hidden pages