In this tutorial demo Ivan shows how to take a freshly installed OS instance in the cloud or on premise and configure it for and deploy Greenplum Database.
The entire process with explanations takes only about 10 minutes which includes OS configuration, downloading Greenplum Database software, installing Greenplum Database software, Greenplum Database configuration and deployment of a Greenplum Database instance.
Documentation for OS configuration:
Documentation for database installation:
Steps followed in this demo:
yum install vim
yum install wget
vim /etc/selinux/config
set disabled
sestatus
cat /etc/redhat-release
cat /proc/cpuinfo | grep processor
cat /proc/meminfo | grep MemTotal
vim /etc/
= 2
= 95
= 10000 65535
= 250 2048000 200 8192
sysctl —system
vim /etc/security/
* soft nofile 524288
* hard nofile 524288
* soft nproc 131072
* hard nproc 131072
groupadd gpadmin
useradd gpadmin -r -m -g gpadmin
— browse to
wget
yum install ./
vim /home/gpadmin/.bashrc
. /usr/local/greenplum-db/
vim ./hosts
gpssh-exkeys -f hosts
mkdir ./data
cp $GPHOME/docs/cli_help/gpconfigs/gpinitsystem_singlenode .
vim gpinitsystem_singlenode
gpinitsystem -c gpinitsystem_singlenode
vim .bashrc
export MASTER_DATA_DIRECTORY=/home/gpadmin/data/gpsne-1
create table t1 as select generate_series(1,1000000) as colA distributed by (colA);
select count(*) from t1;
select sum(colA) from t1;
20 views
460
125
2 months ago 00:02:24 15
Deploying Arenadata DB on offline bare-metal with ADCM