pgxl

first, what is POSTGRES-XLXL means: Extensible Lattice, can be extended lattice, will be the PostgreSQL application on multi-machine distributed database visualization expression.POSTGRES-XL is a full-acid, open-source, scalable, multi-tenant secure, PostgreSQL-based database solution.The POSTGRES-XL is flexible enough to handle a wide range of loads, such as: OLAP (parallelization via MPP) Oltp OLAP OLTP Operational Data storage Key-value storage, including JSON format

POSTGRES-XL Cluster construction and testing CentOS6.5 192.168.0.101 CentOS6.5 192.168.0.102 CentOS6.5 192.168.0.103 CentOS6.5 192.168.0.104 First, host planning Cnode1 (GTM) cnode2 (Gtm_proxy,coordinator,datanode) cnode3 (Gtm_proxy,coordinator,datanode) cnode4 ( Gtm_proxy,coordinator,datanode) Cnode5 (Gtm_proxy,coordinator,datanode) Second, configure host hosts on each node #vim/etc/hosts 192.168.0.101 cnode1 192.168.0.102 cnode2 192.168.0.103 cnode3 Third, installation POSTGRES

/sestatus-v # If The SELinux status parameter is enabled, it is enabled.SELinux status: enabled Temporarily shut down (no need to restart the machine ): Setenforce 0 # Set SELinux to permissive Mode# Setenforce 1 Set SELinux to enforcing Mode Permanently close: Modify the/etc/selinux/config fileChange SELINUX = enforcing to SELINUX = disabled 8. Execute the following software installation steps on each node. During this process, note that if an error is reported in the middle, you must solve the

PGXL Cluster ConstructionA preparation1 Download Install decompression source/opt/Curl-o http://files.postgres-xl.org/postgres-xl95r1beta1.tar.gzTAR-ZXVF postgres-xl95r1beta1.tar.gzMV Postgres-xl95r1beta1.tar.gz POSTGRES-XL2 compiling$ yum-y gcc$ CD POSTGRES-XL$ pwd/opt/postgres-xl$./configureError: Configure:error:readline Library not foundFIX: $ RPM-QA | grep ReadLineReadline-6.2-9.el7.x86_64$ yum Search ReadLine$ yum install-y readline-devel$./conf

/local/pgxl-9.2--installation directory, can not carry. # make# make installin the GTM host, i.e. 192.168.1.201 executes the installation tool Pgxc_ctl# CD Contrib/pgxc_ctl# make# make installCreate user# useradd Postgres# passwd PostgresConfiguring Environment variablesExport Pguser=postgresExport pghome=/usr/local/pgxl-9.2Export ld_library_path= $PGHOME/lib: $LD _library_pathExport path= $HOME/bin: $PGHOM