Hi again, this time I’m showing how to install and configure Greenplum CE in a single node. Also you will be available to download the .ova file, in order to import the appliance and have it installed in a Centos 6.5 64 bits.<\/p>\n
First of all, a little bit of about Greenplum \ud83d\ude42<\/p>\n
* Greenplum Database is a massively parallel processing (MPP) database server based on PostgreSQL open-source technology. MPP (also known as a shared nothing architecture) refers to systems with two or more processors which cooperate to carry out an operation – each processor with its own memory, operating system and disks.
\n* Greenplum Database is an array of individual databases based upon PostgreSQL 8.2 working together to present a single database image.
\n* Greenplum Database stores and processes large amounts of data by distributing the data and processing workload across several servers or hosts.
\n* The master is the entry point to the Greenplum Database system. and coordinates its work with the other database instances in the system, called segments. It is the segments where data is stored and the majority of query processing takes place.<\/p>\n
— Learn more here: — IMPORTANT: If you are a lazy DBA and you don’t want to do the installation, download the the virtual box appliance we made for you \ud83d\ude42 with Greenplum ready to use. Pass for root is qwe123 \ud83d\ude09 Now we are in the same page, lets install Greenplum CE in our Virtual box machine.<\/p>\n Right now, i’m using Virtual Box 4.3.6 and I have installed Centos 6.5 64 bits. This part is not included in the how to \ud83d\ude42<\/p>\n 1) Once we have the OS ready, we need to install the YUM packages for XFS support:<\/p>\n 2) We need another disk for the data storage. Add a new disk to the virtual machine and the create the xfs partition:<\/p>\n 3) Add a line to the \/etc\/fstab to mount the partition onboot:<\/p>\n \/dev\/sdb \/greenplum xfs noatime 0 0<\/p>\n 4) Now we create the Greenplum data store and mount the partition on the \/greenplum mount point.<\/p>\n 5) Before running the installation we need to tweak some system parameters in \/etc\/sysctl.conf :<\/p>\n xfs_mount_options = rw,noatime,inode64,allocsize=16m 6) And also in \/etc\/security\/limits.conf<\/p>\n * soft nofile 65536 7) We set the disk access policy for the linux disk I\/O scheduler:<\/p>\n 8) Finally we set the disk device file value for read-ahead (blockdev) to 16384 and we are done with SO tweaking!<\/p>\n 9) You can get the installation file from the Pivotal site (http:\/\/www.gopivotal.com\/products\/pivotal-greenplum-database). You will get a zip file. Unzippit and then run the binary. After the installation is done, you will find the DB installed on \/usr\/local\/greenplum-db<\/p>\n 10) Now we need to create the OS user to admin the Greenplum DB, and of course, chown the master and segments directories to the user.<\/p>\n 11) From now on, all the you have to do will be with gpadmin user, so, sudo su – gpadmin \ud83d\ude42<\/p>\n 12) We set the environment for gpadmin by copying the following to the .bashrc file:<\/p>\n ##########################################################################<\/p>\n GPHOME=\/usr\/local\/greenplum-db-4.2.2.4<\/p>\n # Replace with symlink path if it is present and correct ##########################################################################<\/p>\n 13) We need to edit the single_host_file and add the localhost entry, in order to crate the keys:<\/p>\n localhost<\/p>\n 14) We need to create a configuration file to be used by the init process:<\/p>\n #####################################################################<\/p>\n ARRAY_NAME=”Greenplum” #####################################################################<\/p>\n 15) That’s all! Now start the database up!<\/p>\n 16) Is it working? test it!<\/p>\n — Sources and help:
\nhttp:\/\/www.technology-mania.com\/2011\/04\/understanding-greenplum.html<\/a>
\nhttp:\/\/www.greenplumdba.com\/greenplum-database<\/a><\/p>\n
\nLink: Greenplum Virtual Box appliance<\/a><\/p>\n yum install xfsprogs xfsdump <\/pre>\n
mkfs -t xfs \/dev\/sdb <\/pre>\n
\u00a0vi \/etc\/fstab <\/pre>\n
\u00a0mkdir \/greenplum\r\n mount \/greenplum <\/pre>\n
vi \/etc\/sysctl.conf <\/pre>\n
\nkernel.shmmax = 500000000
\nkernel.shmmni = 4096
\nkernel.shmall = 4000000000
\nkernel.sem = 250 512000 100 2048
\nkernel.sysrq = 1
\nkernel.core_uses_pid = 1
\nkernel.msgmnb = 65536
\nkernel.msgmax = 65536
\nkernel.msgmni = 2048
\nnet.ipv4.tcp_syncookies = 1
\nnet.ipv4.ip_forward = 0
\nnet.ipv4.conf.default.accept_source_route = 0
\nnet.ipv4.tcp_tw_recycle = 1
\nnet.ipv4.tcp_max_syn_backlog = 4096
\nnet.ipv4.conf.all.arp_filter = 1
\nnet.ipv4.ip_local_port_range = 1025 65535
\nnet.core.netdev_max_backlog = 10000
\nvm.overcommit_memory = 2<\/p>\n vi \/etc\/security\/limits.conf <\/pre>\n
\n* hard nofile 65536
\n* soft nproc 131072
\n* hard nproc 131072<\/p>\n\u00a0echo deadline > \/sys\/block\/sdb\/queue\/scheduler <\/pre>\n
\/sbin\/blockdev --setra 16385 \/dev\/sdb <\/pre>\n
unzip \/root\/greenplum-db-4.2.2.4-build-1-CE-RHEL5-x86_64.zip\r\n \/bin\/bash greenplum-db-4.2.2.4-build-1-CE-RHEL5-x86_64.bin <\/pre>\n
useradd gpadmin\r\n passwd gpadmin<\r\n mkdir -p \/greenplum\/master\r\n mkdir -p \/greenplum\/segment1\r\n mkdir -p \/greenplum\/segment2\r\n chown -R gpadmin:gpadmin \/greenplum <\/pre>\n
vi \/home\/gpadmin\/.bashrc <\/pre>\n
\nif [ -h ${GPHOME}\/..\/greenplum-db ]; then
\nGPHOME_BY_SYMLINK=`(cd ${GPHOME}\/..\/greenplum-db\/ && pwd -P)`
\nif [ x”${GPHOME_BY_SYMLINK}” = x”${GPHOME}” ]; then
\nGPHOME=`(cd ${GPHOME}\/..\/greenplum-db\/ && pwd -L)`\/.
\nfi
\nunset GPHOME_BY_SYMLINK
\nfi
\nPATH=$GPHOME\/bin:$GPHOME\/ext\/python\/bin:$PATH
\nLD_LIBRARY_PATH=$GPHOME\/lib:$GPHOME\/ext\/python\/lib:$LD_LIBRARY_PATH
\nPYTHONPATH=$GPHOME\/lib\/python
\nPYTHONHOME=$GPHOME\/ext\/python
\nOPENSSL_CONF=$GPHOME\/etc\/openssl.cnf
\nexport GPHOME
\nexport PATH
\nexport LD_LIBRARY_PATH
\nexport PYTHONPATH
\nexport PYTHONHOME
\nexport OPENSSL_CONF<\/p>\n vi ~\/single_host_file <\/pre>\n
gpssh-exkeys -f ~\/single_host_file <\/pre>\n
vi ~\/gp_init_config <\/pre>\n
\nMACHINE_LIST_FILE=\/home\/gpadmin\/single_host_file
\nSEG_PREFIX=gp
\nPORT_BASE=50000
\ndeclare -a DATA_DIRECTORY=(\/greenplum\/segment1 \/greenplum\/segment2)
\nMASTER_HOSTNAME=localhost
\nMASTER_DIRECTORY=\/greenplum\/master
\nMASTER_PORT=5432
\nENCODING=UNICODE<\/p>\n gpinitsystem -c ~\/gp_init_config <\/pre>\n
psql template1 <\/pre>\n
\nhttp:\/\/www.greenplumdba.com\/installing-the-greenplum-database<\/a>
\nhttp:\/\/blog.2ndquadrant.com\/installing_greenplum_sne_ec2\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"