How to implement gaussdb stand-alone deployment

This article mainly introduces how to achieve gaussdb stand-alone deployment, the article is very detailed, has a certain reference value, interested friends must read it!

1. Software environment

Operating system hosts and addresses that currently support gaussdb:

Server hostname server address: 192.168.95.100 Universe 24

[root@lks ~] # ip addr

Port number: 1611

2.2. User name and password

User name: omm is used to run and maintain GaussDB T and belongs to the dbgrp group

User groups: dbgrp group

2.3. Installation directory

Server package directory: / opt/software/gaussdb

GaussDB T Special Catalog: / opt/gaussdb

Installation directory: / opt/gaussdb/app

Data directory: / opt/gaussdb/data

3. Operation steps

Log in to GaussDB T server as root user

3.1 create installation users and groups

[root@lks ~] # grep dbgrp / etc/group [root@lks ~] # groupadd dbgrp [root@lks ~] # grep dbgrp / etc/groupdbgrp:x:1001: [root@lks ~] # grep omm / etc/passwd [root@lks ~] # useradd-g dbgrp-d / home/omm-s / bin/bash omm [root@lks ~] # grep omm / etc/passwdomm:x:1001:1001::/home/omm:/bin/bash [root@lks ~] # echo "gaussdb" | passwd -- stdin omm [root@lks ~] # grep omm / etc/shadow

3.2 create and store installation packages and directories, and extract installation packages

[root@lks ~] # mkdir-p / opt/software/gaussdb [root@lks ~] # ls-ld / opt/software/gaussdb [root@lks ~] # cd / opt/software/gaussdb/ [root@lks gaussdb] # mv / root/GaussDB_100_1.0.1-DATABASE-REDHAT-64bit.tar.gz. [root@lks gaussdb] # lsGaussDB_100_1.0.1-DATABASE-REDHAT-64bit.tar.gz [root@lks gaussdb] # tar-zxvf GaussDB_100_1. 0.1-DATABASE-REDHAT-64bit.tar.gz

3.3 stand-alone installation

[root@lks gaussdb] # cd GaussDB_100_1.0.1-DATABASE-REDHAT-64bit/ [root@lks GaussDB_100_1.0.1-DATABASE-REDHAT-64bit] # ls-ltotal 8176 Murrwxmuri. 1 root root 25342 Oct 17 15:49 funclib.py-rw-r--r--. 1 root root 65 Oct 17 15:49 GaussDB_100_1.0.1-RUN-REDHAT-64bit.sha256-rw-r--r--. 1 root root 8047378 Oct 17 15:49 GaussDB_100_1.0.1-RUN-REDHAT-64bit.tar.gz-rwx-. 1 root root 83188 Oct 17 15:49 install.py-rwx-. 1 root root 7697 Oct 17 15:49 sshexkey.py-rwx-. 1 root root 193192 Oct 17 15:49 upgrade.py [root@lks GaussDB_100_1.0.1-DATABASE-REDHAT-64bit] # python-- version [root@lks GaussDB_100_1.0.1-DATABASE-REDHAT-64bit] # python install.py-U omm:dbgrp-R/opt/gaussdb/app-D / opt/gaussdb/data-CLSNR_ ADDR=127.0.0.1192.168.95.100-CLSNR_PORT=1611

Remarks:

The installation can use the default zengine.ini optimized configuration, and the initial configuration can be replaced by-C modification parameters.

Installation parameters description:

-U specify installation users and groups

-R specifies the installation directory # No need to create it in advance

-D specify data file directory #

-C specifies that the configuration parameter defaults to / opt/gaussdb/data/cfg/zengine.ini

3.4 Test results

Install log path / home/omm/zengineinstall.log file

Switch data worker user login and use zsql to connect to the database omm database administrator

[root@lks GaussDB_100_1.0.1-DATABASE-REDHAT-64bit] # su-omm [omm@lks ~] $zsql sys/Changeme_123@192.168.95.100:1888-qSQL > SELECT database_role,status FROM dv_database DATABASE_ROLE STATUS-- PRIMARY OPEN

GaussDB T defaults to the administrator account sys with a password of Changeme_123.

At this point, the stand-alone deployment of GaussDB T is complete.

The above is all the contents of the article "how to achieve gaussdb stand-alone deployment". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!