合 在docker中快速体验GBase 8c集群环境

发布日期 2023年3月20日 · 已更新 2023年3月20日  

0    199    2

Tags： DockerGBase快速体验GBase 8c

👉 本文共约814个字，系统预计阅读时间或需4分钟。

显示/隐藏全文目录

目录

• 环境准备
• 数据库启停
• 启动数据库服务
• 停止数据库服务
• 状态检查
• 连接和 SQL 测试
• 远程登录
• 备注
• 巡检脚本
• 参考

环境准备

docker rm -f gbase8c docker run -itd --name gbase8c -h gbase8c \ -p 5432:5432 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true \ lhrbest/gbase8c:8cV5_S3.0.0B76_1.0 \ /usr/sbin/init docker exec -it gbase8c bash

1 2 3 4 5 6 7 8 9

docker rm -f gbase8c docker run -itd --name gbase8c -h gbase8c \   -p 5432:5432 \   -v /sys/fs/cgroup:/sys/fs/cgroup \   --privileged=true \   lhrbest/gbase8c:8cV5_S3.0.0B76_1.0 \   /usr/sbin/init   docker exec -it gbase8c bash

数据库启停

启动数据库服务

systemctl start etcd.service su - gbase /home/gbase/gbase_package/script/gha_ctl start all -l http://127.0.0.1:2379

1 2 3 4

systemctl start etcd.service   su - gbase /home/gbase/gbase_package/script/gha_ctl start all -l http://127.0.0.1:2379

停止数据库服务

su - gbase /home/gbase/gbase_package/script/gha_ctl stop all -l http://127.0.0.1:2379 -- 或 systemctl stop coordinator_gbase_cn1.service systemctl stop datanode_gbase_dn1_1.service systemctl stop gtm_gbase_gtm1.service systemctl stop server_gbase_gha_server1.service systemctl stop etcd.service

1 2 3 4 5 6 7 8 9

su - gbase /home/gbase/gbase_package/script/gha_ctl stop all -l http://127.0.0.1:2379   -- 或 systemctl stop coordinator_gbase_cn1.service systemctl stop datanode_gbase_dn1_1.service systemctl stop gtm_gbase_gtm1.service systemctl stop server_gbase_gha_server1.service systemctl stop etcd.service

状态检查

执行

/home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 /home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 -H

1 2	/home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 /home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 -H

结果如下，说明集群安装正常，数据服务启动中

[root@gbase8c /]# /home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 -H +----+-------------+-----------+-------+---------+--------+ | No | name | host | port | state | leader | +----+-------------+-----------+-------+---------+--------+ | 0 | gha_server1 | 127.0.0.1 | 20001 | running | True | +----+-------------+-----------+-------+---------+--------+ +----+------+-----------+------+---------------------------+---------+---------+ | No | name | host | port | work_dir | state | role | +----+------+-----------+------+---------------------------+---------+---------+ | 0 | gtm1 | 127.0.0.1 | 6666 | /home/gbase/data/gtm/gtm1 | running | primary | +----+------+-----------+------+---------------------------+---------+---------+ +----+------+-----------+------+----------------------------+---------+---------+ | No | name | host | port | work_dir | state | role | +----+------+-----------+------+----------------------------+---------+---------+ | 0 | cn1 | 127.0.0.1 | 5432 | /home/gbase/data/coord/cn1 | running | primary | +----+------+-----------+------+----------------------------+---------+---------+ +----+-------+-------+-----------+-------+----------------------------+---------+---------+ | No | group | name | host | port | work_dir | state | role | +----+-------+-------+-----------+-------+----------------------------+---------+---------+ | 0 | dn1 | dn1_1 | 127.0.0.1 | 15432 | /home/gbase/data/dn1/dn1_1 | running | primary | | 1 | dn2 | dn2_1 | 127.0.0.1 | 20010 | /home/gbase/data/dn2/dn2_1 | running | primary | +----+-------+-------+-----------+-------+----------------------------+---------+---------+ +----+-----------------------+--------+---------+----------+ | No | url | name | state | isLeader | +----+-----------------------+--------+---------+----------+ | 0 | http://127.0.0.1:2379 | node_0 | healthy | True | +----+-----------------------+--------+---------+----------+ [root@gbase8c /]# [root@gbase8c /]# /home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 { "cluster": "gbase", "version": "V5_S3.0.0B76", "server": [ { "name": "gha_server1", "host": "127.0.0.1", "port": "20001", "state": "running", "isLeader": true } ], "gtm": [ { "name": "gtm1", "host": "127.0.0.1", "port": "6666", "workDir": "/home/gbase/data/gtm/gtm1", "agentPort": "8001", "state": "running", "role": "primary", "agentHost": "127.0.0.1" } ], "coordinator": [ { "name": "cn1", "host": "127.0.0.1", "port": "5432", "workDir": "/home/gbase/data/coord/cn1", "agentPort": "8003", "state": "running", "role": "primary", "agentHost": "127.0.0.1", "central": true } ], "datanode": { "dn1": [ { "name": "dn1_1", "host": "127.0.0.1", "port": "15432", "workDir": "/home/gbase/data/dn1/dn1_1", "agentPort": "8005", "state": "running", "role": "primary", "agentHost": "127.0.0.1" } ], "dn2": [ { "name": "dn2_1", "host": "127.0.0.1", "port": "20010", "workDir": "/home/gbase/data/dn2/dn2_1", "agentPort": "8007", "state": "running", "role": "primary", "agentHost": "127.0.0.1" } ] }, "dcs": { "clusterState": "healthy", "members": [ { "url": "http://127.0.0.1:2379", "id": "b71f75320dc06a6c", "name": "node_0", "isLeader": true, "state": "healthy" } ] } }

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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106

[root@gbase8c /]# /home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 -H +----+-------------+-----------+-------+---------+--------+ | No |     name    |    host   |  port |  state  | leader | +----+-------------+-----------+-------+---------+--------+ | 0  | gha_server1 | 127.0.0.1 | 20001 | running |  True  | +----+-------------+-----------+-------+---------+--------+ +----+------+-----------+------+---------------------------+---------+---------+ | No | name |    host   | port |          work_dir         |  state  |   role  | +----+------+-----------+------+---------------------------+---------+---------+ | 0  | gtm1 | 127.0.0.1 | 6666 | /home/gbase/data/gtm/gtm1 | running | primary | +----+------+-----------+------+---------------------------+---------+---------+ +----+------+-----------+------+----------------------------+---------+---------+ | No | name |    host   | port |          work_dir          |  state  |   role  | +----+------+-----------+------+----------------------------+---------+---------+ | 0  | cn1  | 127.0.0.1 | 5432 | /home/gbase/data/coord/cn1 | running | primary | +----+------+-----------+------+----------------------------+---------+---------+ +----+-------+-------+-----------+-------+----------------------------+---------+---------+ | No | group |  name |    host   |  port |          work_dir          |  state  |   role  | +----+-------+-------+-----------+-------+----------------------------+---------+---------+ | 0  |  dn1  | dn1_1 | 127.0.0.1 | 15432 | /home/gbase/data/dn1/dn1_1 | running | primary | | 1  |  dn2  | dn2_1 | 127.0.0.1 | 20010 | /home/gbase/data/dn2/dn2_1 | running | primary | +----+-------+-------+-----------+-------+----------------------------+---------+---------+ +----+-----------------------+--------+---------+----------+ | No |          url          |  name  |  state  | isLeader | +----+-----------------------+--------+---------+----------+ | 0  | http://127.0.0.1:2379 | node_0 | healthy |   True   | +----+-----------------------+--------+---------+----------+ [root@gbase8c /]# [root@gbase8c /]# /home/gbase/gbase_package/script/gha_ctl monitor -l http://127.0.0.1:2379 {     "cluster": "gbase",     "version": "V5_S3.0.0B76",     "server": [         {             "name": "gha_server1",             "host": "127.0.0.1",             "port": "20001",             "state": "running",             "isLeader": true         }     ],     "gtm": [         {             "name": "gtm1",             "host": "127.0.0.1",             "port": "6666",             "workDir": "/home/gbase/data/gtm/gtm1",             "agentPort": "8001",             "state": "running",             "role": "primary",             "agentHost": "127.0.0.1"         }     ],     "coordinator": [         {             "name": "cn1",             "host": "127.0.0.1",             "port": "5432",             "workDir": "/home/gbase/data/coord/cn1",             "agentPort": "8003",             "state": "running",             "role": "primary",             "agentHost": "127.0.0.1",             "central": true         }     ],     "datanode": {         "dn1": [             {                 "name": "dn1_1",                 "host": "127.0.0.1",                 "port": "15432",                 "workDir": "/home/gbase/data/dn1/dn1_1",                 "agentPort": "8005",                 "state": "running",                 "role": "primary",                 "agentHost": "127.0.0.1"             }         ],         "dn2": [             {                 "name": "dn2_1",                 "host": "127.0.0.1",                 "port": "20010",                 "workDir": "/home/gbase/data/dn2/dn2_1",                 "agentPort": "8007",                 "state": "running",                 "role": "primary",                 "agentHost": "127.0.0.1"             }         ]     },     "dcs": {         "clusterState": "healthy",         "members": [             {                 "url": "http://127.0.0.1:2379",                 "id": "b71f75320dc06a6c",                 "name": "node_0",                 "isLeader": true,                 "state": "healthy"             }         ]     } }

连接和 SQL 测试

在主节点 gbase8c 执行 $ gsql -d postgres -p 5432，出现 postgres=# 操作符说明客户端工具 gsql 成功连接 GBase 8c 数据库。

[gbase@gbase8c script]$ gsql -d postgres -p 5432 gsql ((multiple_nodes GBase8cV5 3.0.0B76 build 47948f99) compiled at 2023-02-27 16:04:20 commit 0 last mr 1232 ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. testdb=# select version(); version --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 (1 row) testdb=# postgres=# create database testdb; CREATE DATABASE postgres=# \c testdb Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "testdb" as user "gbase". testdb=# create table student(ID int, Name varchar(10)); CREATE TABLE testdb=# insert into student values(1, 'Mike'),(2,'John'); INSERT 0 2 testdb=# select * from student; id | name ----+------ 1 | Mike 2 | John (2 rows) testdb=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+---------+-------+------------------- postgres | gbase | UTF8 | C | C | template0 | gbase | UTF8 | C | C | =c/gbase + | | | | | gbase=CTc/gbase template1 | gbase | UTF8 | C | C | =c/gbase + | | | | | gbase=CTc/gbase testdb | gbase | UTF8 | C | C | (4 rows) testdb=# \d student Table "public.student" Column | Type | Modifiers --------+-----------------------+----------- id | integer | name | character varying(10) | testdb=# testdb=# create database lhrdb; CREATE DATABASE postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+---------+-------+------------------- lhrdb | gbase | UTF8 | C | C | postgres | gbase | UTF8 | C | C | template0 | gbase | UTF8 | C | C | =c/gbase + | | | | | gbase=CTc/gbase template1 | gbase | UTF8 | C | C | =c/gbase + | | | | | gbase=CTc/gbase testdb | gbase | UTF8 | C | C | (5 rows) postgres=#

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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64

[gbase@gbase8c script]$ gsql -d postgres -p 5432 gsql ((multiple_nodes GBase8cV5 3.0.0B76 build 47948f99) compiled at 2023-02-27 16:04:20 commit 0 last mr 1232 ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help.   testdb=# select version();                                                                                            version                                                                                           --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 (1 row)   testdb=# postgres=# create database testdb; CREATE DATABASE postgres=# \c testdb Non-SSL connection (SSL connection is recommended when requiring high-security) You are now connected to database "testdb" as user "gbase". testdb=# create table student(ID int, Name varchar(10)); CREATE TABLE testdb=# insert into student values(1, 'Mike'),(2,'John'); INSERT 0 2 testdb=# select * from student; id | name ----+------   1 | Mike   2 | John (2 rows)   testdb=# \l                          List of databases    Name    | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+---------+-------+------------------- postgres  | gbase | UTF8     | C       | C     | template0 | gbase | UTF8     | C       | C     | =c/gbase         +            |       |          |         |       | gbase=CTc/gbase template1 | gbase | UTF8     | C       | C     | =c/gbase         +            |       |          |         |       | gbase=CTc/gbase testdb    | gbase | UTF8     | C       | C     | (4 rows)   testdb=#  \d student            Table "public.student" Column |         Type          | Modifiers --------+-----------------------+----------- id     | integer               | name   | character varying(10) |   testdb=# testdb=# create database lhrdb; CREATE DATABASE postgres=# \l                          List of databases    Name    | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+---------+-------+------------------- lhrdb     | gbase | UTF8     | C       | C     | postgres  | gbase | UTF8     | C       | C     | template0 | gbase | UTF8     | C       | C     | =c/gbase         +            |       |          |         |       | gbase=CTc/gbase template1 | gbase | UTF8     | C       | C     | =c/gbase         +            |       |          |         |       | gbase=CTc/gbase testdb    | gbase | UTF8     | C       | C     | (5 rows)   postgres=#

远程登录

C:\Users\lhr>psql -U gha -h 192.168.59.220 -p 5432 -d postgres Password for user gha: psql (14.0, server 9.2.4) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off) Type "help" for help. postgres=> \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+---------+-------+------------------- lhrdb | gbase | UTF8 | C | C | postgres | gbase | UTF8 | C | C | template0 | gbase | UTF8 | C | C | =c/gbase + | | | | | gbase=CTc/gbase template1 | gbase | UTF8 | C | C | =c/gbase + | | | | | gbase=CTc/gbase testdb | gbase | UTF8 | C | C | (5 rows) postgres=>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

C:\Users\lhr>psql -U gha -h 192.168.59.220 -p 5432 -d postgres Password for user gha: psql (14.0, server 9.2.4) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off) Type "help" for help.   postgres=> \l                          List of databases    Name    | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+---------+-------+------------------- lhrdb     | gbase | UTF8     | C       | C     | postgres  | gbase | UTF8     | C       | C     | template0 | gbase | UTF8     | C       | C     | =c/gbase         +            |       |          |         |       | gbase=CTc/gbase template1 | gbase | UTF8     | C       | C     | =c/gbase         +            |       |          |         |       | gbase=CTc/gbase testdb    | gbase | UTF8     | C       | C     | (5 rows)   postgres=>

备注

所有用户的密码均为lhr

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。

相关文章

• 在docker中模拟不同主机快速搭建GBase 8a V95集群环境
• 密码保护GBase 8c GDCA练习题
• 在同一台主机快速搭建GBase 8c集群环境
• 在docker中模拟不同主机快速搭建GBase 8cV5集群环境
• GBase 8s的docker版安装使用
• GBase 8a V8.6.2的docker版安装使用
• 在Docker中快速体验CBDB数据库
• 在Docker中快速体验崖山YashanDB数据库
• 在Docker中快速使用各个版本的GreenPlum数据库
• 在Docker中快速体验GreenPlum 7.0.0和gpcc 7.0.0
• GBase 8s的安装与卸载
• GBase 8s学习连接
• 在Docker中快速体验Oracle 23c免费开发者版
• 在Docker环境中快速体验YMatrix数据库
• 密码保护GBase 8s GDCA练习题
• 密码保护GBase 8a GDCA练习题
• GBase 8a常用运维SQL
• 南大通用GBase产品系列介绍
• 南大通用GBase数据库巡检脚本
• GBase8a V8.6.2单机版安装使用

打赏赞(2)分享

标签： DockerGBase快速体验GBase 8c

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

• 下一篇 含有Docker的环境agetty进程导致cpu占用率100%
• 上一篇 在同一台主机快速搭建GBase 8c集群环境

您可能还喜欢...

• 0

  Docker中使用systemctl命令时报Too many open files错误

  2022年1月7日

   由 小麦苗 · Published 2022年1月7日

   

  0    656    3
• 0

  在Docker中快速体验StarRocks 3.0.0环境

  2023年6月14日

   由 小麦苗 · Published 2023年6月14日

  · 已更新 2023年6月14日  

  0    314    2
• 0

  在Docker环境中快速体验YMatrix数据库

  2023年4月6日

   由 小麦苗 · Published 2023年4月6日 · Last modified 2023年12月12日

  · 已更新 2023年12月12日  

  0    148    1