在同一台主机快速搭建GBase 8c集群环境

环境准备

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

停止数据库服务

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

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

[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=# 

远程登录

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

巡检脚本

更多请参考：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

声明：本文内容由网友自发贡献，本站不承担相应法律责任。对本内容有异议或投诉，请联系2913721942#qq.com核实处理，我们将尽快回复您，谢谢合作！