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

After viewing online videos and looking for online materials. GP4.3 installed successfully. The following is the directory of the installation process

1. Experimental environment 4

1.1. Hardware environment 4

1.2. Virtual machine configuration 4

two。 System Settings (all master and data nodes) 4

2.1. Base environment settings 4

2.1.1. Close iptables4

2.1.2. Close selinux5

2.1.3. Modify hostname5

2.1.4. Modify hosts5

2.2. Greenplum Environment Settings 6

2.2.1. Modify shared memory and network, vim / etc/sysctl.conf6

2.2.2. User restrictions, vim / etc/security/limits.conf7

2.2.3. Set disk access IO scheduling policy 7

2.2.4. Set the value of the read-ahead block to 163848

3. Install Greenplum software 9 on the Master node

3.1. Prepare Media 9

3.2. Decompression 9

3.3. Installation 10

4. Initialize the configuration of Greenplum12 on all host

4.1. Get environment parameter 12

4.2. Create the hosts file all_hosts13

4.3. Gpssh connection (Centos6.8 must be verified) 13

4.4. Run gpseginstall tool to simplify data transmission and installation between master node and data node 15

4.5. Verify installation 16

4.5.1. Switch to the gpadmin user and get the environment variable 16

4.5.2. Use the gpssh tool to test password-less login to all hosts 16

4.5.3. Add "source / usr/local/greenplum-db/greenplum_path.sh" to the last 17 of the .bashrc file

4.6. Create storage area 18

4.6.1. Create master data storage area 18

4.6.2. Change the ownership of the catalogue 18

4.6.3. Create a file seg_hosts19 that contains all segment hosts

4.6.4. Create master and mirror data catalogs on all segment hosts using the gpssh tool 19

4.7. Synchronize system time 20

4.7.1. Edit / etc/ntp.conf on the master host to set up ntp service 20

4.7.2. Edit / etc/ntp.conf setting time on segment host is the same as master 20

4.7.3. On the master host, synchronize the system clock 21 through the ntp daemon

5. Verify operating system settings 21

5.1. Gpcheck checks whether the operating system settings are correct 21

6. Initialize Greenplum database system 22

6.1. Create Greenplum database profile 22

6.1.1. Copy a gpinitsystem_config file from the template 22

6.1.2. Set all required parameters 22

6.1.3. Set optional parameter 23

6.2. Initialize database 23

6.2.1. Run initialization tool 23

6.2.2. Set environment variable 24

6.3. Start and stop database 25

6.3.1. Shut down database 25

6.3.2. Start database 25

6.3.3. Access to database 26

See the attachment for details.

Attachment: http://down.51cto.com/data/2366637

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.