Greenplum db Configuration

Greenplum db configuration 1. adjust the kernel Parameter kernel. sysrq = 1fs. file-max = 101365kernel. shmmax = 5001000000kernel. shmall = 4000000000kernel. msgmni = 2048kernel. sem = 250 512000 100 2048kernel. shmmni = 4096net. core. netdev_max_backlog = javasnet. core. rmem_default = 1048576net. core. rmem_max = 1048576net. core. wmem_default = 262144net. core. wmem_max = 262144net. ipv4.conf. all. arp_filter = 1net. ipv4.ip _ local_port_range = 1025 65535net. ipv4.tcp _ fin_timeout = 30net. ipv4.tcp _ max_syn_backlog = 4096net. ipv4.tcp _ tw_recycle = 1net. ipv4.tcp _ tw_reuse = 1vm. overcommit_memory = 2 run sysctl-p to make it take effect. 2. adjust the system limit and edit/etc/security/limits. conf * soft nofile 65536 * hard nofile 65536 * soft nproc 131072 * hard nproc 131072 log on to the root again to make the change take effect. 3. install, specify the path, the installation package is under root, execute the binfile accept protocol yes specify the installation path press ENTER whether installation exists gp press ENTER 4. create a gpadmin user. The password is also gpadmin useradd gpadminpasswd gpadmin 5. configure ssh trust under root/* Add gp environment variable */# cd/usr/local/greenplum-db # cat greenplum_path.sh>/etc/profile/* execute change */#. /etc/profile/* create text, including all gp node names */# edit/home/gpadmin/all_hosts, add yd1701/* Create ssh Trust for the root node */edit/root /. in the ssh/config file, add the ssh port number Host yd1701Port 22022/* to build trust and test */# gpssh-exkeys-f all_hosts # ssh yd1701-p 22022 date 6. modify the permissions of the gp db installation directory # chown-R gpadmin: gpadmin/usr/local/greenplum-db # chown-R gpadmin: gpadmin/usr/local/greenplim-db-4.2.2.0 7. create a master data directory and a segment data directory # mkdir/u02/gpdata/gpmaster # mkdir/u02/gpdata/gpdata0 # mkdir/u02/gpdata/gpdata1, generate 16 segment directories and change the permission to gpadmin: gpadmin 8. configure ssh trust edit/home/gpadmin/Under the gpadmin user /. in the ssh/config file, add the ssh port number Host yd1701Port 22022/* Create an ssh trust under the gpadmin user and test */# gpssh-exkeys-f all_hosts # ssh yd1701-p 22022 date 9. check the environment # gpcheck-f all_hosts-m yd1701-s yd1701, adjust according to the log, and then run 10. edit the Initialization Configuration File # cp/usr/local/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config/home/gpadmin/adjust the following ARRAY_NAME = "EMC Greenplum DW" SEG_PREFIX = gpsegPORT_BASE = 40000/* The path is too long, see File 1701 with the same name */declare-a DATA_DIRECTORY = (/u02/gpdata/gpdata0/u02/gpdata/gpdata1 ...) MASTER_HOSTNAME = yd1701MASTER_DIRECTORY =/u02/gpdata/gpmasterMASTER_PORT = 5432TRUSTED_SHELL = bytes = 8 ENCODING = UNICODEMACHINE_LIST_FILE =/home/gpadmin/all_hosts 11. initialize and view the gpinitsystem-c gpinitsystem_config under the gpadmin user to compile/etc/profile, add export MASTER_DATA_DIRECTORY =/u02/gpdata/gpmaster/gpseg-1 to switch back to the gpadmin user, make the environment variable effective/* view the running status */gpstate-s under the gpadmin user, and check whether all nodes are up 12. start and Stop gpstart 13 under gpstopgpadmin. start nohup gpfdist-d under the gpfdist gpadmin user <Load file path>-p <port number> & 14. configure instance parameter 14.1 adjust master node access control, edit/u02/gpdata/gpmaster/gpseg-1/pg_assist.conf add host all gpadmin 0.0.0.0/0 trust 14.2 configure parameters for each ipvs instance, for example, edit/u02/gpdata/gpdata0/gpseg0/postgresql. conf. Adjust the cache, connections, and execution plan according to the actual situation.