Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to install GreenPlum4.3.5.2 under centos6.6, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Foreword:

The installation of GP goes something like this, selecting one host as the Master machine and the other as the setting machine. Since there are not so many machines, three centos6.6 are opened on the virtual machine, using 1-to-2 mode.

When installing, remember that GP can be installed on the Master machine first, and then similar remote installation can be carried out by establishing mutual trust (gpssh-exkeys) between the Maser machine and the setup machine, and you can log in to all machines through gpssh to carry out a series of operations, including building users, copying the installed GP, and so on. Of course, before installation, some people will configure kernel parameters, restrictions, and so on, depending on what you need. Because of my virtual machine, the hardware basically can not meet the requirements of the official website, so I gave up this step.

Pre-installation preparation (optional)

1. Add to the / etc/sysctl.conf of Master machine

[html] view plaincopy

Kernel.shmmax = 500000000 kernel.shmmni = 4096 kernel.shmall = 4000000000 kernel.sem = 512000 100 2048 kernel.sysrq = 1 kernel.core_uses_pid = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.msgmni = 2048 net.ipv4.tcp_syncookies = 1 net.ipv4.ip_forward = 0 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 = 1025 65535 net.core.netdev_max_backlog = 10000 net.core.rmem_max = 2097152 net.core.wmem_max = 2097152 vm.overcommit_memory = 2

Restart the machine or sysctl-p will take effect.

2. Add in Master / etc/security/limits.conf

[html] view plaincopy

* soft nofile 65536 * hard nofile 65536 * soft nproc 131072 * hard nproc 131072

!!! Note that for RedHat 6.x and Centos6.x machines, the parameters in / etc/security/limits.d/90-nproc.conf override the above file parameters. If both files set parameters, make sure the parameters are set in 90-nproc.conf.

3. Turn off the firewall

Chkconfig iptables off; / / permanently shut down and do not start after restart

Service iptables stop; / / will start after reboot, and check the status with service iptables status.

Start GP installation

1. Install GP,root permissions on Master

Put the downloaded greenplum-db-4.3.5.2-build-1-RHEL5-x86_64.zip in a directory, unzip (unzip), and get a ReadMe and .bin file. By default, GP is installed under / usr/local/greenplum, but it can be installed anywhere. Here, we install it under / opt/greenplum/.

Execute the bin file and extract the directory. / greenplum-db-4.3.5.2-build-1-RHEL5-x86_64.bin

Press the spacebar all the way until you are told to enter yes | no, hit yes

Select the installation directory and enter the directory you want to install, here / opt/greenplum/greenplum-db-4.3.5.2

Yes all the way down and it will be installed soon.

2. It is customary to create a user gpadmin responsible for the GP database on the Master machine, and then add the user gpadmin of the subsequent segmentation machine through gpssh.

Generally speaking, there are no gpadmin users at the beginning, so create a new one directly.

Groupadd-g 530 gpadmin

Useradd-g 530u 530m-d / home/gpadmin-s / bin/bash gpadmin

Passwd gpadmin; add password

Modify permissions on the GP installation folder

Chown-R gpadmin:gpadmin / home/gpadmin

Chown-R gpadmin:gpadmin / opt/greenplum

Add an environment variable file under the GP installation directory to the user.

Source / opt/greenplum/greenplum-db/greenplum_path.sh; / opt/greenplum/greenplum-db is a link to / opt/greenplum/greenplum-db-4.3.5.2, not a ln-s / opt/greenplum/greenplum-db-4.3.5.2 / opt/greenplum/greenplum-db on your own

3. Establish mutual trust between hosts

First, on the Master machine, edit the / etc/hosts file

Input the Ip and hostname of Master machine and segment machine.

Such as

# / etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.127.136 mdw # Mastercomputer

192.168.127.137 sdw1 # segmentation machine

192.168.127.138 sdw2 # segmentation machine

Second, create a file hostlists (by any name) that protects all host hostname and a seg_hosts with segmentation machine hostname in a directory such as / var.

/ var/hostlists:

Mdw

Sdw1

Sdw2

/ var/seg_hosts

Sdw1

Sdw2

Begin to build mutual trust

Gpssh-exkeys-f / var/hostlists

[root@localhost] $gpssh-exkeys-f / var/hostlists

[STEP 1 of 5] create local ID and authorize on local host

... / home/root/.ssh/id_rsa file exists... Key generation skipped

[STEP 2 of 5] keyscan all hosts and update known_hosts file

[STEP 3 of 5] authorize current user on remote hosts

... Send to mdw

... Send to sdw1

***

* Enter password for sdw1:

[STEP 4 of 5] determine common authentication file content

[STEP 5 of 5] copy authentication files to all remote hosts

... Finished key exchange with mdw

... Finished key exchange with sdw1

[INFO] completed successfully

Note: ssh-keygen-t rsa; ssh-add / root/.ssh/id_rsa if prompted that there is no secret key. You can get the secret key. If the execution ssd-add appears, Could not open a connection to your authentication agent, then execute ssh-agent bash. That's it.

Once mutual trust is established, all machines can be accessed through gpssh-f / var/seg_hosts.

Thank you for reading this article carefully. I hope the article "how to install GreenPlum4.3.5.2 under centos6.6" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.