GBase8s 数据库实例化

原创已于 2022-08-26 16:59:10 修改 · 1.5k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#linux #运维 #数据库

于 2022-08-21 19:59:40 首次发布

GBase 8s 同时被 2 个专栏收录

14 篇文章

订阅专栏

GBase8s基础功能

11 篇文章

订阅专栏

本文详细介绍了如何在Linux环境下进行GBase8s数据库实例化，包括切换到gbasedbt用户，执行GBaseInit_gbasedbt.sh脚本，设置实例名称、目录、IP、端口、字符集、表空间路径及大小，以及自定义表空间配置。通过这些步骤，最终成功启动数据库并验证其运行状态。

1.切换到数据库用户gbasedbt

su - gbasedbt

2.切换到目录/opt/gbase/etc, 执行实例化脚本GBaseInit_gbasedbt.sh:

cd /opt/gbase/etc
sh GBaseInit_gbasedbt.sh

3.实例名称使用默认值gbaseserver:

ENTER THE INSTANCE INFORMATION or PRESS <ENTER> TO ACCEPT THE DEFAULT.

ENTER GBASE INSTANCE NAME (GBASEDBTSERVER) [Default:gbaseserver]:

4.目录选择默认值:

SEARCHING FOR GBASE INSTALL FOLDER, PLEASE WAIT FOR SECONDS...
GBASE INSTALL FOLDER LIST:
 1) /opt/gbase
CHOOSE GBASE INSTALL FOLDER(GBASEDBTDIR) [Default:/opt/gbase]:

5.IP和端口号也都使用默认值:

CHOOSE SERVICE IP ADDRESS FROM THE LIST:
 1) 192.168.200.180
 2) 127.0.0.1
ENTER THE NUMBER FOR YOUR CHOICE [Default:192.168.200.180]: 

SPECIFY THE PORT NUMBER FOR GBASE [Default:9088]:

6. INITIALIZE TYPE选择2) CUSTOM , 定制实例参数:

INITIALIZE TYPE:
 1) TYPICAL -- Initialize the instance with all features configured with default values.
 2) CUSTOM  -- Initialize the instance with specific features that you need.
ENTER THE NUMBER FOR YOUR CHOICE [Default:1]: 2

7.字符集选择 2) zh_CN.GB18030-2000:

GBASE CHARACTER SET LIST:
 1) en_US.8859-1
 2) zh_CN.GB18030-2000
 3) zh_CN.utf8
ENTER THE NUMBER FOR YOUR CHOICE [Default:1]: 2

8.表空间路径配置如下,可以自己定义,也可以直接回车使用默认值

ENTER THE DATA SPACE PATH [Default:/opt/gbase/gbaseserver_dbs]:

9.下面可以设置表空间的大小,因为是测试环境参数设置的比默认值小一些:

ENTER THE LOGICAL LOG DBSPACE SIZE(MB) [Default:4910]: 2000

ENTER THE PHYSICAL LOG DBSPACE SIZE(MB) [Default:4910]: 2000

ENTER THE SMART LOB DBSPACE SIZE(MB) [Default:1012]: 500

ENTER THE TEMPORARY DBSPACE SIZE(MB) [Default:1012]: 500

10.选择"Y"自定义设置表空间

ENTER "Y" TO START DATABASE ADVANCED SETTINGS, OR ENTER "N" TO ACCEPT DEFAULT VALUES: [Default:N]: y

11.配置信息如下:

ENTER THE NUMBER OF DATA DBSPACES [Default:1]: 5

ENTER THE NUMBER OF TEMP DBSPACES [Default:1]: 3

Enter "Y" TO ENABLE ENVIRONMENT GL_USEGLU, OR ENTER "N" TO DISABLE: [Default:N]: y

12.最后实例配置信息如下,选择"y"进行实例初始化:

INSTANCE SUMMARY:
  Instance name:               gbaseserver
  GBase install directory:     /opt/gbase
  IP address & port:           192.168.200.180:9088
  Character set:               zh_CN.GB18030-2000
  Logical log space size:      2000 MB
  Physical log space size:     2000 MB
  Smart LOB space size:        500 MB
  Temp DBSpace size:           500 MB
  Data path:                   /opt/gbase/gbaseserver_dbs
  Data path free size:         48653 MB
  The number of data DBSpace:  5
  The number of temp DBSpace:  3
  Environment GL_USEGLU:       1

Enter "Y" to Start database initializing, or Enter "N" to Edit Again: y

13.实例化记录如下, 完成按下回车结束初始化:

Touching Chunks...OK
Create sqlhosts File:  /opt/gbase/etc/sqlhosts.gbaseserver ...OK
Setting Parameters in /opt/gbase/etc/onconfig.gbaseserver :
ROOTPATH.ROOTSIZE.DBSERVERNAME.FULL_DISK_INIT.SBSPACENAME.SYSSBSPACENAME.DBSPACETEMP.LOGFILES.MULTIPROCESSOR.VPCLASS.NETTYPE.CLEANERS.DEF_TABLE_LOCKMODE.DIRECT_IO.LOCKS.TAPEDEV.LTAPEDEV.CKPTINTVL.DS_MAX_QUERIES.DS_TOTAL_MEMORY.DS_NONPDQ_QUERY_MEM.PHYSBUFF.LOGBUFF.AUTO_TUNE.MSGPATH.SERVERNUM.ALLOW_NEWLINE.TEMPTAB_NOLOG.DUMPSHMEM.USEOSTIME.STACKSIZE.ON_RECVRY_THREADS.OFF_RECVRY_THREADS.USELASTCOMMITTED.SHMVIRTSIZE.SHMADD.GBASEDBTCONTIME.BUFFERPOOL2K.BUFFERPOOL16K...AUTO_CKPTS.OK
Initializing Root DBSpace & Share Memory...OK
Creating system database.........OK
Creating logical log Dbspace...OK
Creating physical log Dbspace...OK
Creating smart LOB Dbspace...OK
Creating temp Dbspace.1.2.3...OK
Creating data Dbspace.1.2.3.4.5...OK
Setting dbscheduler...OK
Moving physical log...OK
Adding 40 logical logs: 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40...OK
Setting data chunks extendable...OK
Cleaning logical logs in rootdbs...Your evaluation license will expire on 2023-08-21 00:00:00
.Your evaluation license will expire on 2023-08-21 00:00:00
.Your evaluation license will expire on 2023-08-21 00:00:00
.Your evaluation license will expire on 2023-08-21 00:00:00
...OK
Database restarting.......Your evaluation license will expire on 2023-08-21 00:00:00
OK
Creating database: gbasedb...OK

Now you can use this URL to connect to gbasedb:
jdbc:gbasedbt-sqli://192.168.200.180:9088/gbasedb:GBASEDBTSERVER=gbaseserver;DB_LOCALE=zh_CN.GB18030-2000;CLIENT_LOCALE=zh_CN.GB18030-2000;NEWCODESET=GB18030,GB18030-2000,5488;GL_USEGLU=1

Version:
Your evaluation license will expire on 2023-08-21 00:00:00
On-Line -- Up 00:00:13 -- 674664 Kbytes
Build Number:		3.3.0_N303

GBase Initializing Finished!

Initialize log file : ./InitGBaseDB_202208211933.log 

Press <ENTER> to Exit and Logout...

14.切换到gbasedbt,使用命令ps -ef|grep oninit 查看数据库进程显示已经启动