Install greenplum cluster on Ubuntu 16.04

Planning: 1 Msater, 2 segments

Environment: Ubuntu 16.04

Greenplum Version: ' Postgres (greenplum Database) 5.3.0 build 2155c5a-oss

1. Installation

sudo add-apt-repository ppa:greenplum/db

sudo apt-get update

sudo apt-get install Greenplum-db-oss

2. Configure/etc/hosts

Edit the/etc/hosts file and make sure this it includes the host names and all interface address names for every machine p Articipating in your Greenplum Database system.

3. Turn off the firewall

Service Iptables Stop

4, modify/etc/sysctl.conf, add

Kernel.shmmax = 500000000

Kernel.shmmni = 4096

Kernel.shmall = 4000000000

Kernel.sem = 250 512000 100 2048

KERNEL.SYSRQ = 1

Kernel.core_uses_pid = 1

KERNEL.MSGMNB = 65536

Kernel.msgmax = 65536

Kernel.msgmni = 2048

Net.ipv4.tcp_syncookies = 1

Net.ipv4.conf.default.accept_source_route = 0

Net.ipv4.tcp_tw_recycle = 1

Net.ipv4.tcp_max_syn_backlog = 4096

Net.ipv4.conf.all.arp_filter = 1

Net.ipv4.ip_forward=0

Net.ipv4.ip_local_port_range = 1025 65535

Net.core.netdev_max_backlog = 10000

Net.core.rmem_max = 2097152

Net.core.wmem_max = 2097152

Vm.overcommit_memory = 2

5, configure/etc/security/limits.conf, add

* Soft nofile 65536* hard nofile 65536* soft nproc 131072* hard Nproc 131072

6. Set the read-ahead block size

/sbin/blockdev--setra 16384 /DEV/SDA

7. Restart the system

8, Installation Greenplum

http://greenplum.org/install-greenplum-oss-on-ubuntu/

https://launchpad.net/~greenplum/+archive/ubuntu/db

Installation into/opt/gpdb

---------------------------

sudo apt-get install-y Software-properties-common

sudo add-apt-repository ppa:greenplum/db

sudo apt-get update

sudo apt-get install-y greenplum-db-oss

9. Initializing Environment variables

$ su Root

$ source/opt/gpdb/greenplum_path.sh

10. Create a host file all_hosts

$ VI all_hosts

IfreBigData1

IfreBigData2

IfreBigData4

11. Run Gpseginstall Tool

$ gpseginstall-f all_hosts-u gpadmin-p gpadmin

It's possible to avoid a secret failure.

20171215:08:55:57:054683 gpseginstall:ifrebigdata1:root-[info]:-exchange ssh keys for user root

20171215:08:55:57:054683 gpseginstall:ifrebigdata1:root-[info]:-cmd ' Gpssh-exkeys-f all_hosts ' failed with error code 1

20171215:08:55:57:054683 Gpseginstall:ifrebigdata1:root-[info]:-gppsh-exkeys failed running from within Pexpect ... Now try outside of Pexpect

Problem getting hostname for ifreBigData1: [Errno 0] Resolver error 0 (no Error)

Traceback (most recent):

File "/opt/gpdb/bin/gpssh-exkeys", line 534, in <module>

(primary, aliases, Ipaddrs) = SOCKET.GETHOSTBYADDR (hostname)

Socket.herror: [Errno 0] Resolver error 0 (no error)

20171215:08:55:58:054683 Gpseginstall:ifrebigdata1:root-[error]:-error on Cmd:gpssh-exkeys-f all_hosts

Workaround

$su Gpadmin

$source/opt/gpdb/greenplum_path.sh

$gpssh-exkeys-f all_hosts

12. Verify installation and password-free login

$ gpssh-f all_hosts-e ls $GPHOME

13. Add source/opt/gpdb/greenplum_path.sh to the. bashrc file at the end (all nodes are to be done)

14. Create a storage area

A) Create a master data storage area

Mkdir-p/data/master

b) Change of directory ownership

Chown Gpadmin/data/master

c) Create a file containing all segment hosts Seg_hosts

d) root user creates master and mirror data directories on the segment host with the Gpssh tool

$ su Root

$ source/opt/gpdb/greenplum_path.sh

$ gpssh-exkeys-f all_hosts

Gpssh-f seg_hosts-e ' mkdir-p/data/primary '

Gpssh-f seg_hosts-e ' mkdir-p/data/mirror '

Gpssh-f seg_hosts-e ' Chown gpadmin/data/primary '

Gpssh-f seg_hosts-e ' Chown gpadmin/data/mirror '

15. Synchronization System Time

Installing NTP on each machine

A.gpssh-f all_hosts-e ' apt install-y ntp '

B. Modifying/etc/ntp.conf additions

Server Masterhostname

C.gpssh-f/data/all_hosts-e ' ntpd '

16. Verify Operating system settings

#gpcheck-F/data/all_hosts-m ifreBigData1

17. Initializing GP Database system

#su-gpadmin

$ cp/opt/gpdb/docs/cli_help/gpconfigs/gpinitsystem_config ~/gpinitsystem_config

$ chmod 775 Gpinitsystem_config

$ VI Gpinitsystem_config

Array_name= "Greenplum Data Platform"

Seg_prefix=ifreseg

port_base=40000

Declare-a data_directory= (/data/primary)

Master_hostname=ifrebigdata1

Master_directory=/data/master

master_port=5432

# # # # OPTIONAL MIRROR PARAMETERS

mirror_port_base=50000

replication_port_base=41000

mirror_replication_port_base=51000

Declare-a mirror_data_directory= (/data/mirror)

A) Run the initialization tool

$ cp/data/seg_hosts ~

$ gpinitsystem-c gpinitsystem_config-h seg_hosts

Check Results

b) Setting environment variables

Add to

Export Master_data_directory=/data/master/ifreseg-1

To Master's ~/.BASHRC

Do the same on the segment machine

18. Start Stop Database

$ gpstart

$gpstop

Verify

$ psql-d template1

Install greenplum cluster on Ubuntu 16.04