PostgresX2MPP部署试验

MPP结构&＃xff1a;

129 GTM节点&＃xff0c; 130 coordinator、gtm_proxy、datanode&＃xff08;1、2、3&＃xff09;节点&＃xff0c;131 coordinator、gtm_proxy、datanode&＃xff08;4、5、6&＃xff09;

配置文件&＃xff1a;

#parse mode MPP.
#129 gtm, 130 coord1, gtmproxy1 and 3 datanodes, 131 coord2, gtmproxy2, 3 datanodes
#user and path
pgxcOwner&＃61;postgres
pgxcUser&＃61;$pgxcOwner
pgxcInstallDir&＃61;/opt/pgx2#gtm and gtmproxy
gtmMasterDir&＃61;$HOME/pgxc2/nodes/gtm
gtmMasterPort&＃61;6666
gtmMasterServer&＃61;192.168.238.129
gtmSlave&＃61;n#gtmproxy
gtmProxy&＃61;y
gtmProxyDir&＃61;$HOME/pgxc2/nodes/gtmproxy
gtmProxyNames&＃61;(gtm_pxy1 gtm_pxy2)
gtmProxyServers&＃61;(192.168.238.130 192.168.238.131)
gtmProxyPorts&＃61;(20001 20001)
gtmProxyDirs&＃61;($gtmProxyDir/gtm_pxy1 $gtmProxyDir/gtm_pxy2)
gtmPxyExtraConfig&＃61;(none none)
gtmPxySpecificExtraConfig&＃61;(none none)#coordinator
coordMasterDir&＃61;$HOME/pgxc2/nodes/coord
coordNames&＃61;(coord1 coord2)
coordPorts&＃61;(5432 5432)
poolerPorts&＃61;(6668 6668)
coordPgHbaEntries&＃61;(192.168.238.0/24)
coordMasterServers&＃61;(192.168.238.130 192.168.238.131)
coordMasterDirs&＃61;($coordMasterDir/coord1 $coordMasterDir/coord2)
coordMaxWALsernder&＃61;0
coordMaxWALSenders&＃61;($coordMaxWALsernder $coordMaxWALsernder)
coordSlave&＃61;n
coordSpecificExtraConfig&＃61;(none none)
coordSpecificExtraPgHba&＃61;(none none)#datanode
datanodeNames&＃61;(datanode1 datanode2 datanode3 datanode4 datanode5 datanode6)
datanodePorts&＃61;(15432 15433 15434 15432 15433 15434)
datanodePoolerPorts&＃61;(6669 6670 6671 6669 6670 6671)
datanodePgHbaEntries&＃61;(192.168.238.0/24)
datanodeMasterServers&＃61;(192.168.238.130 192.168.238.130 192.168.238.130 192.168.238.131 192.168.238.131 192.168.238.131)
datanodeMasterDir&＃61;$HOME/pgxc2/nodes/dn_master
datanodeMasterDirs&＃61;($datanodeMasterDir/datanode1 $datanodeMasterDir/datanode2 $datanodeMasterDir/datanode3 $datanodeMasterDir/datanode4 $datanodeMasterDir/datanode5 $datanodeMasterDir/datanode6)
datanodeMaxWALsernder&＃61;0
datanodeMaxWALSenders&＃61;($datanodeMaxWALsernder $datanodeMaxWALsernder $datanodeMaxWALsernder $datanodeMaxWALsernder $datanodeMaxWALsernder $datanodeMaxWALsernder)
datanodeSlave&＃61;n
primaryDatanode&＃61;datanode1
datanodeSpecificExtraConfig&＃61;(none none none none none none)
datanodeSpecificExtraPgHba&＃61;(none none none none none none)

pgxc_ctl -c /home/postgres/pgxc_ctl/pgxc_ctl2.conf init all

psql连接130的coordinator时进行建表没问题&＃xff0c;但是第一次插入会将131节点的datanode节点的进程干掉。
但是再多次测试后&＃xff0c;正常。