Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to implement gaussdb stand-alone deployment

2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

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!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report