Greenplum与mysql集群_Greenplum数据库集群

cat /etc/sysctl.conf |grep -v -E "^#|^$"

kernel.shmmax = 500000000

kernel.shmmni = 4096

kernel.shmall = 4000000000

kernel.sem = 500 1024000 200 4096

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_local_port_range = 10000 65535

net.core.netdev_max_backlog = 10000

net.core.rmem_max = 2097152

net.core.wmem_max = 2097152

vm.overcommit_memory = 2

vm.swappiness = 10

vm.dirty_expire_centisecs = 500

vm.dirty_writeback_centisecs = 100

vm.dirty_background_ratio = 0

vm.dirty_ratio=0

vm.dirty_background_bytes = 1610612736

vm.dirty_bytes = 4294967296

cat /home/gpadmin/gpinitsystem_config |grep -v -E "^#|^$"

ARRAY_NAME="Zenlayer Greenplum DW"

SEG_PREFIX=gpseg

PORT_BASE=40000

declare -a DATA_DIRECTORY=(/home/gpdata/primary /home/gpdata/primary)

MASTER_HOSTNAME=gp2-master.sin3

MASTER_DIRECTORY=/home/gpdata/master

MASTER_PORT=5234

TRUSTED_SHELL=ssh

CHECK_POINT_SEGMENTS=8

ENCODING=UNICODE

MIRROR_PORT_BASE=50000

REPLICATION_PORT_BASE=41000

MIRROR_REPLICATION_PORT_BASE=51000

declare -a MIRROR_DATA_DIRECTORY=(/home/gpdata/mirror /home/gpdata/mirror)

DATABASE_NAME=zenlayer_db

[root@gp2-master ~]#

####

cat /home/gpadmin/gpinitsystem_config |grep -v -E "^#|^$"

ARRAY_NAME="Zenlayer Greenplum DW"

SEG_PREFIX=gpseg

PORT_BASE=40000

declare -a DATA_DIRECTORY=(/home/gpdata/primary /home/gpdata/primary)

MASTER_HOSTNAME=gp2-master.sin3

MASTER_DIRECTORY=/home/gpdata/master

MASTER_PORT=5234

TRUSTED_SHELL=ssh

CHECK_POINT_SEGMENTS=8

ENCODING=UNICODE

MIRROR_PORT_BASE=50000

REPLICATION_PORT_BASE=41000

MIRROR_REPLICATION_PORT_BASE=51000

declare -a MIRROR_DATA_DIRECTORY=(/home/gpdata/mirror /home/gpdata/mirror)

DATABASE_NAME=zenlayer_db