Install Greenplum Single Node Demo

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;
Back to Top