GaussDB 100单机版轻量安装

一、创建安装用户和用户组

groupadd dbgrp
useradd -g dbgrp -d /home/omm -m -s /bin/bash omm
passwd omm

说明：设置omm用户密码

二、上传GaussDB 100安装包，并解压

1.创建安装包目录
mkdir -p /gdb/software/gaussdb
2.通过FTP工具上传安装包到此目录
lcd "D:\Open Source DB\GaussDB100"
put GaussDB_100_1.0.0-DATABASE-REDHAT-64bit.tar.gz
3.解压
cd /gdb/software/gaussdb
tar -xvf GaussDB_100_1.0.0-DATABASE-REDHAT-64bit.tar.gz

三、进入安装包解压目录，执行install.py脚本进行安装

cd /gdb/software/gaussdb/GaussDB_100_1.0.0-DATABASE-REDHAT-64bit
python install.py -U omm:dbgrp -R /gdb/gaussdb/app -D /gdb/gaussdb/data -C  LSNR_ADDR=127.0.0.1,192.168.56.16 -C LSNR_PORT=1888

具体安装过程说明，下面日志表示安装成功。

[root@edumysql GaussDB_100_1.0.0-DATABASE-REDHAT-64bit]# python install.py -U omm:dbgrp -R /gdb/gaussdb/app -D /gdb/gaussdb/data -C  LSNR_ADDR=127.0.0.1,192.168.56.16 -C LSNR_PORT=1888
Checking runner.
Checking parameters.
End check parameters.
Checking user.
End check user.
Checking old install.
End check old install.
Checking kernel parameters.
Checking directory.
Checking integrality of run file...
Decompressing run file.
Setting user env.
Checking data dir and config file
Initialize db instance.
Creating database.
Creating database succeed.
Changing file permission due to security audit.
Install successfully, for more detail information see /home/omm/zengineinstall.log.

表1 install安装参数说明

表2 zengine.ini配置表

安装完成后，本虚拟机zengine.ini配置如下：

[omm@edumysql gdb]$ cat /gdb/gaussdb/data/cfg/zengine.ini
TEMP_BUFFER_SIZE = 1G
DATA_BUFFER_SIZE = 2G
SHARED_POOL_SIZE = 1G
LOG_BUFFER_SIZE = 64M
DBWR_PROCESSES = 8
LOG_BUFFER_COUNT = 8
SESSIONS = 1500
INSTANCE_NAME = zenith
LSNR_ADDR = 127.0.0.1,192.168.56.16
LSNR_PORT = 1888
ENABLE_SYSDBA_LOGIN = TRUE
CONTROL_FILES = (/gdb/gaussdb/data/data/cntl1, /gdb/gaussdb/data/data/cntl2, /gdb/gaussdb/data/data/cntl3)

表3 环境变量
在安装完成，会在omm用户配置文件.bashrc添加4个环境变量

安装完成后，本虚拟机.bashrc配置如下：

[omm@edumysql ~]$ cat .bashrc
# User specific aliases and functions
export GSDB_HOME="/gdb/gaussdb/app"
export PATH="/gdb/gaussdb/app/bin":$PATH
export LD_LIBRARY_PATH="/gdb/gaussdb/app/lib":"/gdb/gaussdb/app/add-ons":$LD_LIBRARY_PATH
export GSDB_DATA="/gdb/gaussdb/data"

四、使用omm用户，启动数据库服务

su - omm
cd /gdb/gaussdb/app/bin
python zctl.py -t start

[omm@edumysql ~]$ cd /gdb/gaussdb/app/bin
[omm@edumysql bin]$ python zctl.py -t start
Zengine instance has already started.

五、使用zsql连接数据库

zsql sys/Changeme_123@127.0.0.1:1888
zsql sys/Changeme_123@192.168.56.16:1888

操作如下：
[omm@edumysql bin]$ zsql sys/Changeme_123@127.0.0.1:1888

connected.

SQL> 

六、修改数据库管理员用户sys默认密码

ALTER USER SYS IDENTIFIED BY gdb_2019 REPLACE Changeme_123;

操作如下：
SQL> ALTER USER SYS IDENTIFIED BY gdb_2019 REPLACE Changeme_123;

Succeed.

七、查询数据库、版本和默认用户信息

1.数据库信息

SQL> select dbid,name,status,open_status from dv_database;

DBID         NAME                             STATUS               OPEN_STATUS         
------------ -------------------------------- -------------------- --------------------
837565763    GAUSS                            OPEN                 READ WRITE          

1 rows fetched.

2.数据库版本信息

SQL> select * from dv_version;

VERSION                                                         
----------------------------------------------------------------
GaussDB_100_1.0.0.B019 Release 0b7bb43                          
ZENGINE                                                         
0b7bb43                                                         

3 rows fetched.

3.默认用户信息

SQL> select * from db_users;

USER_ID      USERNAME     CREATED                CRYPTOPERIOD            
------------ ------------ ---------------------- ------------------------
0            SYS          2019-10-16 18:12:05    +0000179 23:51:04.696117
1            PUBLIC       2019-10-16 18:12:05    +0000179 23:35:00.444129

2 rows fetched.

八、创建用户与表

SQL> create user enmogdb identified by "gdb_2019";

Succeed.


SQL> grant create session,create table to enmogdb;

Succeed.

SQL> conn enmogdb/gdb_2019@127.0.0.1:1888
connected.

SQL> create table enmo(id varchar2(50));

Succeed.

SQL> insert into enmo(id) values ('Welcome To GaussDB 100's World!');

1 rows affected.

SQL> select * from enmo;

ID                                                
--------------------------------------------------
Welcome To GaussDB 100!                           

1 rows fetched.

九、关闭数据库

[omm@edumysql bin]$ python zctl.py -t stop
Successfully stopped instance.

十、附录

1、GaussDB 100软件安装目录存储空间不足导致安装失败，存储空间最少要求20GB

[root@edumysql GaussDB_100_1.0.0-DATABASE-REDHAT-64bit]# python install.py -U omm:dbgrp -R /opt/gaussdb/app -D /opt/gaussdb/data -C  LSNR_ADDR=127.0.0.1 -C LSNR_PORT=1888
Checking runner.
Checking parameters.
End check parameters.
Checking user.
End check user.
Checking old install.
End check old install.
Checking kernel parameters.
Checking directory.
Checking integrality of run file...
Decompressing run file.
Setting user env.
Checking data dir and config file
Initialize db instance.
Creating database.
Error: Failed to execute sql file /opt/gaussdb/app/admin/scripts/create_database.sample.sql, output:
connected.

SQL> 
GS-00028, Write size 1011712, expected size 2097152, mostly because file size is larger than disk, please delete the incomplete file
SQL> 

Please refer to install log "/home/omm/zengineinstall.log" for more detailed information.