Pivotal Knowledge Base

Follow

Pivotal VRP Prerequisite document - GPDB

PivotalVRP for GPDB

Pre-Installation Checklist (Document Version 37.0)

Please make sure the machine you have intended for the PivotalVRP deployment meets the following criteria.

 

Item

Requirement

Done

Requirements for the MoreVRP Server (Engine)

Console Operating System

·       Windows 64 bit OS

CPU

Up to 1 Rack : 8 Cores or better*

2 racks : 16 cores or better

3 racks : 22 cores or better

4 racks : 26 cores or better

5 racks : 32 cores or better

* based on moderate traffic

For VM environments make sure the actual resources match requirements.

 

Memory

½ Rack 8GB, 1 Rack 12GB, 2 Rack 24GB, 3 Rack 36GB, 4 Rack 48GB

5 Rack 60GB

HDD

200GB for ~1 months of repository. (per DCA)

Add more according to your requirements

(HD estimated space is based on average workload on 1 DCA, actual usage may vary)

Networking

2 x 100Mb/1GB NIC installed

  • One on the public network
  • One on the DCA/cluster interconnect network

OS Localization

·       OS installation language and Local must be English.

·       Regional Settings configured must be also set for English (United States).

Note: if the Regional Settings was changed from a different language to English (US) – Please restart the Server otherwise the changes will not take effect.  

Necessary OS features

·       .Net must be activated on the host server

Security permissions

·       Installation must be done with administrator user or with a user who is a member of the administrators group.

·       For windows 2008/Vista/7 : Disabling Windows User Account Control (UAC)

See this link for more info. http://www.howtogeek.com/howto/windows-vista/disable-user-account-control-uac-the-easy-way-on-windows-vista/

Reboot after changing.

·       Disable the windows password complexity policy

Requirements for the Web Clients

Browsers

  • Firefox 3.11 onwards
  • Google Chrome 2.0.172.37 onwards
  • Internet Explorer 7,8, 9

Java JDK

Version 6 update 16 onwards

Flash

Version 10 onwards

Requirements for the Database Server

User Privileges and network configuration the Database nodes and segments :

** Steps 3 & 4 can be achieved by running script included with the installer

 

 

1.     “postgres” user access rights or any other user with superuser permissions. To create a dedicated user :

 

CREATE ROLE morevrp WITH SUPERUSER

ALTER ROLE morevrp WITH PASSWORD 'XXXX';

ALTER ROLE morevrp LOGIN;

 

2.     Linux/Unix root user access rights on all segment hosts (required for the agent installation phase only)

 

3.     Open up all segments to allow direct connection from the MoreVRP server :

 

Locate all pg_hba.conf files of all segments and add the following line at the end. X.X.X.X should be the MoreVRP server IP address (the IP that is on the interconnect network)

 

host all all X.X.X.X/32 trust

 

4.     Reload postgres configuration (doesn't require a downtime) by running this command on the master node.

 

gpstop -u

Necessary feature during installation

·       SSH communication should be on between segments for root user

 

Network Firewall rules

From More Server to the managed segment hosts (including the master)

  • Greenplum master DB port (default 5432)
  • Greenplum Segment instance ports (default 40001 and above)
  • SSL – Port 25427

From the world to the VRP Server

(Used for WEB UI)

  • Port 9090
  • Port 9191
  • Port 9898

From the More Server to the SMTP server (For automatic emails and alerts)

  • SMTP – usually Port 25

 

OPTIONAL:

Item

Info required

Send information about the target DB environment to the support team (Through Zendesk)

·    Operating system name (segment hosts)

·    Operating system version (segment hosts)

·    Operating system bit level (32/64)

·    CPU type (X86, Itanium, Power4 etc)

Send more details about the PivotalVRP server environment to the support team (Through Zendesk)

·    OS version

·    OS service-pack level

The output of this query from the master server  

select * from gp_segment_configuration

Names and IP address of all Nodes

 

 

Comments

Powered by Zendesk