环境准备
1docker rm -f gbase8c
2docker run -itd --name gbase8c -h gbase8c \
3 -p 5432:5432 \
4 -v /sys/fs/cgroup:/sys/fs/cgroup \
5 --privileged=true \
6 lhrbest/gbase8c:8cV5_S3.0.0B76_1.0 \
7 /usr/sbin/init
8
9docker exec -it gbase8c bash
数据库启停
启动数据库服务
1systemctl start etcd.service
2
3su - gbase
4/home/gbase/gbase_package/script/gha_ctl start all -l http://127.0.0.1:2379
停止数据库服务
1su - gbase
2/home/gbase/gbase_package/script/gha_ctl stop all -l http://127.0.0.1:2379
3
4
5-- 或
6systemctl stop coordinator_gbase_cn1.service
7systemctl stop datanode_gbase_dn1_1.service
8systemctl stop gtm_gbase_gtm1.service
9systemctl stop server_gbase_gha_server1.service
10systemctl stop etcd.service
状态检查
执行
1/home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379
2/home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 -H
结果如下，说明集群安装正常，数据服务启动中
1[root@gbase8c /]# /home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 -H
2+----+-------------+-----------+-------+---------+--------+
3| No | name | host | port | state | leader |
4+----+-------------+-----------+-------+---------+--------+
5| 0 | gha_server1 | 127.0.0.1 | 20001 | running | True |
6+----+-------------+-----------+-------+---------+--------+
7+----+------+-----------+------+---------------------------+---------+---------+
8| No | name | host | port | work_dir | state | role |
9+----+------+-----------+------+---------------------------+---------+---------+
10| 0 | gtm1 | 127.0.0.1 | 6666 | /home/gbase/data/gtm/gtm1 | running | primary |
11+----+------+-----------+------+---------------------------+---------+---------+
12+----+------+-----------+------+----------------------------+---------+---------+
13| No | name | host | port | work_dir | state | role |
14+----+------+-----------+------+----------------------------+---------+---------+
15| 0 | cn1 | 127.0.0.1 | 5432 | /home/gbase/data/coord/cn1 | running | primary |
16+----+------+-----------+------+----------------------------+---------+---------+
17+----+-------+-------+-----------+-------+----------------------------+---------+---------+
18| No | group | name | host | port | work_dir | state | role |
19+----+-------+-------+-----------+-------+----------------------------+---------+---------+
20| 0 | dn1 | dn1_1 | 127.0.0.1 | 15432 | /home/gbase/data/dn1/dn1_1 | running | primary |
21| 1 | dn2 | dn2_1 | 127.0.0.1 | 20010 | /home/gbase/data/dn2/dn2_1 | running | primary |
22+----+-------+-------+-----------+-------+----------------------------+---------+---------+
23+----+-----------------------+--------+---------+----------+
24| No | url | name | state | isLeader |
25+----+-----------------------+--------+---------+----------+
26| 0 | http://127.0.0.1:2379 | node_0 | healthy | True |
27+----+-----------------------+--------+---------+----------+
28[root@gbase8c /]#
29[root@gbase8c /]# /home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379
30{
31 "cluster": "gbase",
32 "version": "V5_S3.0.0B76",
33 "server": [
34 {
35 "name": "gha_server1",
36 "host": "127.0.0.1",
37 "port": "20001",
38 "state": "running",
39 "isLeader": true
40 }
41 ],
42 "gtm": [
43 {
44 "name": "gtm1",
45 "host": "127.0.0.1",
46 "port": "6666",
47 "workDir": "/home/gbase/data/gtm/gtm1",
48 "agentPort": "8001",
49 "state": "running",
50 "role": "primary",
51 "agentHost": "127.0.0.1"
52 }
53 ],
54 "coordinator": [
55 {
56 "name": "cn1",
57 "host": "127.0.0.1",
58 "port": "5432",
59 "workDir": "/home/gbase/data/coord/cn1",
60 "agentPort": "8003",
61 "state": "running",
62 "role": "primary",
63 "agentHost": "127.0.0.1",
64 "central": true
65 }
66 ],
67 "datanode": {
68 "dn1": [
69 {
70 "name": "dn1_1",
71 "host": "127.0.0.1",
72 "port": "15432",
73 "workDir": "/home/gbase/data/dn1/dn1_1",
74 "agentPort": "8005",
75 "state": "running",
76 "role": "primary",
77 "agentHost": "127.0.0.1"
78 }
79 ],
80 "dn2": [
81 {
82 "name": "dn2_1",
83 "host": "127.0.0.1",
84 "port": "20010",
85 "workDir": "/home/gbase/data/dn2/dn2_1",
86 "agentPort": "8007",
87 "state": "running",
88 "role": "primary",
89 "agentHost": "127.0.0.1"
90 }
91 ]
92 },
93 "dcs": {
94 "clusterState": "healthy",
95 "members": [
96 {
97 "url": "http://127.0.0.1:2379",
98 "id": "b71f75320dc06a6c",
99 "name": "node_0",
100 "isLeader": true,
101 "state": "healthy"
102 }
103 ]
104 }
105}
连接和 SQL 测试
在主节点 gbase8c
执行 $ gsql -d postgres -p 5432
，出现 postgres=#
操作符说明客户端工具 gsql 成功连接 GBase 8c 数据库。
1[gbase@gbase8c script]$ gsql -d postgres -p 5432
2gsql ((multiple_nodes GBase8cV5 3.0.0B76 build 47948f99) compiled at 2023-02-27 16:04:20 commit 0 last mr 1232 )
3Non-SSL connection (SSL connection is recommended when requiring high-security)
4Type "help" for help.
5
6testdb=# select version();
7 version
8---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
9 PostgreSQL 9.2.4 (multiple_nodes GBase8cV5 3.0.0B76 build 47948f99) compiled at 2023-02-27 16:04:20 commit 0 last mr 1232 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
10(1 row)
11
12testdb=#
13postgres=# create database testdb;
14CREATE DATABASE
15postgres=# \c testdb
16Non-SSL connection (SSL connection is recommended when requiring high-security)
17You are now connected to database "testdb" as user "gbase".
18testdb=# create table student(ID int, Name varchar(10));
19CREATE TABLE
20testdb=# insert into student values(1, 'Mike'),(2,'John');
21INSERT 0 2
22testdb=# select * from student;
23 id | name
24----+------
25 1 | Mike
26 2 | John
27(2 rows)
28
29testdb=# \l
30 List of databases
31 Name | Owner | Encoding | Collate | Ctype | Access privileges
32-----------+-------+----------+---------+-------+-------------------
33 postgres | gbase | UTF8 | C | C |
34 template0 | gbase | UTF8 | C | C | =c/gbase +
35 | | | | | gbase=CTc/gbase
36 template1 | gbase | UTF8 | C | C | =c/gbase +
37 | | | | | gbase=CTc/gbase
38 testdb | gbase | UTF8 | C | C |
39(4 rows)
40
41testdb=# \d student
42 Table "public.student"
43 Column | Type | Modifiers
44--------+-----------------------+-----------
45 id | integer |
46 name | character varying(10) |
47
48testdb=#
49testdb=# create database lhrdb;
50CREATE DATABASE
51postgres=# \l
52 List of databases
53 Name | Owner | Encoding | Collate | Ctype | Access privileges
54-----------+-------+----------+---------+-------+-------------------
55 lhrdb | gbase | UTF8 | C | C |
56 postgres | gbase | UTF8 | C | C |
57 template0 | gbase | UTF8 | C | C | =c/gbase +
58 | | | | | gbase=CTc/gbase
59 template1 | gbase | UTF8 | C | C | =c/gbase +
60 | | | | | gbase=CTc/gbase
61 testdb | gbase | UTF8 | C | C |
62(5 rows)
63
64postgres=#
远程登录
1C:\Users\lhr>psql -U gha -h 192.168.59.220 -p 5432 -d postgres
2Password for user gha:
3psql (14.0, server 9.2.4)
4SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
5Type "help" for help.
6
7postgres=> \l
8 List of databases
9 Name | Owner | Encoding | Collate | Ctype | Access privileges
10-----------+-------+----------+---------+-------+-------------------
11 lhrdb | gbase | UTF8 | C | C |
12 postgres | gbase | UTF8 | C | C |
13 template0 | gbase | UTF8 | C | C | =c/gbase +
14 | | | | | gbase=CTc/gbase
15 template1 | gbase | UTF8 | C | C | =c/gbase +
16 | | | | | gbase=CTc/gbase
17 testdb | gbase | UTF8 | C | C |
18(5 rows)
19
20
21postgres=>
22
备注
所有用户的密码均为lhr
巡检脚本
更多请参考：https://www.xmmup.com/nandatongyonggbaseshujukuxunjianjiaoben.html
其它不再截图。
参考
https://www.xmmup.com/zaidockerzhongkuaisudajiangbase-8cjiqunhuanjing.html
https://www.xmmup.com/zaitongyitaizhujikuaisudajiangbase-8cjiqunhuanjing.html
https://blog.csdn.net/wiserhowe/article/details/126419430
https://blog.csdn.net/wiserhowe/article/details/128833346
https://blog.csdn.net/wiserhowe/article/details/126725440
https://mp.weixin.qq.com/s/yT-v0f5raST8pw9Fiu_HLA
文章转载自DB宝，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
