使用Docker部署openGauss國(guó)產(chǎn)數(shù)據(jù)庫(kù)的操作方法
一、openGauss介紹
1.openGauss簡(jiǎn)介
openGauss是一款支持SQL2003標(biāo)準(zhǔn)語(yǔ)法,支持主備部署的高可用關(guān)系型數(shù)據(jù)庫(kù)。
2.openGauss產(chǎn)品定位
- 多種存儲(chǔ)模式支持復(fù)合業(yè)務(wù)場(chǎng)景,新引入提供原地更新存儲(chǔ)引擎。
- NUMA化數(shù)據(jù)結(jié)構(gòu)支持高性能。
- Paxos一致性日志復(fù)制協(xié)議,主備模式,CRC校驗(yàn)支持高可用。
- 支持全密態(tài)計(jì)算、賬本數(shù)據(jù)庫(kù)等安全特性,提供全方位端到端的數(shù)據(jù)安全保護(hù)。
- 通過(guò)Table Access Method接口層支持多存儲(chǔ)引擎。
3.支持的架構(gòu)和操作系統(tǒng)版本
x86-64 CentOS 7.6
ARM64 openEuler 20.03 LTS
二、檢查宿主機(jī)環(huán)境
1.檢查系統(tǒng)版本
[root@node ~]# cat /etc/centos-release CentOS Linux release 7.6.1810 (Core)
2.檢查Docker狀態(tài)
[root@node ~]# cat /etc/centos-release
CentOS Linux release 7.6.1810 (Core)
[root@node ~]# systemctl status docker
● docker.service - Docker Application Container Engine
Loaded: loaded (/usr/lib/systemd/system/docker.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2022-10-04 16:38:46 CST; 6min ago
Docs: https://docs.docker.com
Main PID: 10737 (dockerd)
Tasks: 175
Memory: 288.8M
CGroup: /system.slice/docker.service
├─10737 /usr/bin/dockerd -H fd:// --containerd=/run/containerd/containerd.sock
├─21641 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 9000 -container-ip 172.17.0.2 -container-port 9000
├─21647 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 9000 -container-ip 172.17.0.2 -container-port 9000
├─21712 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 6888 -container-ip 172.28.0.2 -container-port 6888
├─21718 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 6888 -container-ip 172.28.0.2 -container-port 6888
├─21727 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 3396 -container-ip 172.27.0.2 -container-port 3306
├─21733 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 3396 -container-ip 172.27.0.2 -container-port 3306
├─21747 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 8012 -container-ip 172.17.0.3 -container-port 80
├─21753 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 8012 -container-ip 172.17.0.3 -container-port 80
├─21781 /usr/bin/docker-proxy -proto udp -host-ip 0.0.0.0 -host-port 6888 -container-ip 172.28.0.2 -container-port 6888
├─21787 /usr/bin/docker-proxy -proto udp -host-ip :: -host-port 6888 -container-ip 172.28.0.2 -container-port 6888
├─21794 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 8129 -container-ip 172.27.0.3 -container-port 80
├─21799 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 8129 -container-ip 172.27.0.3 -container-port 80
├─21848 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 6800 -container-ip 172.28.0.2 -container-port 6800
├─21868 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 9080 -container-ip 172.17.0.4 -container-port 80
├─21874 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 6800 -container-ip 172.28.0.2 -container-port 6800
├─21881 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 9080 -container-ip 172.17.0.4 -container-port 80
├─21885 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 3306 -container-ip 192.168.224.3 -container-port 3306
├─21897 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 3306 -container-ip 192.168.224.3 -container-port 3306
├─21910 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 3544 -container-ip 172.17.0.5 -container-port 3306
├─21920 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 3544 -container-ip 172.17.0.5 -container-port 3306
├─21945 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 8712 -container-ip 172.17.0.6 -container-port 80
├─21951 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 8712 -container-ip 172.17.0.6 -container-port 80
├─23999 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 8987 -container-ip 192.168.224.2 -container-port 8181
└─24005 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 8987 -container-ip 192.168.224.2 -container-port 8181
Oct 04 16:38:53 node dockerd[10737]: time="2022-10-04T16:38:53.566667153+08:00" level=info msg="ignoring event" container=b2b3518e620d51474c9679c...askDelete"
Oct 04 16:38:54 node dockerd[10737]: time="2022-10-04T16:38:54+08:00" level=info msg="Firewalld: docker zone already exists, returning"
Oct 04 16:38:54 node dockerd[10737]: time="2022-10-04T16:38:54.414988302+08:00" level=info msg="ignoring event" container=b2b3518e620d51474c9679c...askDelete"
Oct 04 16:38:55 node dockerd[10737]: time="2022-10-04T16:38:55+08:00" level=info msg="Firewalld: docker zone already exists, returning"
Oct 04 16:38:55 node dockerd[10737]: time="2022-10-04T16:38:55.726427597+08:00" level=info msg="ignoring event" container=b2b3518e620d51474c9679c...askDelete"
Oct 04 16:38:56 node dockerd[10737]: time="2022-10-04T16:38:56+08:00" level=info msg="Firewalld: docker zone already exists, returning"
Oct 04 16:38:57 node dockerd[10737]: time="2022-10-04T16:38:57.225224508+08:00" level=info msg="ignoring event" container=b2b3518e620d51474c9679c...askDelete"
Oct 04 16:38:58 node dockerd[10737]: time="2022-10-04T16:38:58+08:00" level=info msg="Firewalld: docker zone already exists, returning"
Oct 04 16:38:58 node dockerd[10737]: time="2022-10-04T16:38:58.973644718+08:00" level=info msg="ignoring event" container=b2b3518e620d51474c9679c...askDelete"
Oct 04 16:39:01 node dockerd[10737]: time="2022-10-04T16:39:01+08:00" level=info msg="Firewalld: docker zone already exists, returning"
Hint: Some lines were ellipsized, use -l to show in full.
三、下載openGauss鏡像
1.進(jìn)入docker官方鏡像倉(cāng)庫(kù)

2.openGauss鏡像介紹
1.從3.0版本開(kāi)始(包括3.0版本)
2.容器采用openGauss數(shù)據(jù)庫(kù)Lite版本
3.默認(rèn)啟動(dòng)后空載內(nèi)存小于200M
4.添加vi,ps,等基礎(chǔ)命令
3.下載openGauss鏡像
[root@node openguass]# docker pull enmotech/opengauss:3.0.0 3.0.0: Pulling from enmotech/opengauss 22c5ef60a68e: Pull complete 28692a7bf40a: Pull complete 53d8b65999fe: Pull complete 2feb7fb751a7: Pull complete 21970696c490: Pull complete Digest: sha256:b8a21dfa15d57476528051f1b8b138dac45cfbad3ef97cba2b340433476147f8 Status: Downloaded newer image for enmotech/opengauss:3.0.0 docker.io/enmotech/opengauss:3.0.0
四、創(chuàng)建openGauss單節(jié)點(diǎn)容器
1.創(chuàng)建數(shù)據(jù)目錄
mkdir -p /data/openguass/
2.創(chuàng)建openGauss容器
docker run --name opengauss -d --restart always --privileged=true -e GS_PASSWORD=Admin@123456 \
-v /data/opengauss/mysql:/var/lib/opengauss -u root -p 15432:5432 \
enmotech/opengauss:3.0.0
GS_PASSWORD:設(shè)置openGauss數(shù)據(jù)庫(kù)的超級(jí)用戶omm以及測(cè)試用戶gaussdb的密碼
GS_NODENAME:數(shù)據(jù)庫(kù)節(jié)點(diǎn)名稱,默認(rèn)為gaussdb。
GS_USERNAME:數(shù)據(jù)庫(kù)連接用戶名,默認(rèn)為gaussdb。
GS_PORT:數(shù)據(jù)庫(kù)端口,默認(rèn)為5432。
3.查看openGauss容器狀態(tài)
[root@node openguass]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES b5abda90d924 enmotech/opengauss:3.0.0 "entrypoint.sh gauss…" 25 seconds ago Up 24 seconds 0.0.0.0:15432->5432/tcp, :::15432->5432/tcp
4.連接測(cè)試openGauss
[root@node openguass]# docker exec -it 360296c286c9 /bin/bash root@360296c286c9:/# su - omm omm@360296c286c9:~$ gsql gsql ((openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:34 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. omm=#
5.外部遠(yuǎn)程連接
[admin@master ~]$ gsql -d postgres -U gaussdb -W'Admin@123456' -h 192.168.3.167 -p15432 gsql ((openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:24 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. openGauss=>
五、創(chuàng)建主從復(fù)制的openGauss容器
1.下載運(yùn)行腳本
wget https://raw.githubusercontent.com/enmotech/enmotech-docker-opengauss/master/create_master_slave.sh
2.腳本中自定義參數(shù)解釋
OG_SUBNET (容器所在網(wǎng)段) [172.11.0.0/24] GS_PASSWORD (定義數(shù)據(jù)庫(kù)密碼)[Enmo@123] MASTER_IP (主庫(kù)IP)[172.11.0.101] SLAVE_1_IP (備庫(kù)IP)[172.11.0.102] MASTER_HOST_PORT (主庫(kù)數(shù)據(jù)庫(kù)服務(wù)端口)[5432] MASTER_LOCAL_PORT (主庫(kù)通信端口)[5434] SLAVE_1_HOST_PORT (備庫(kù)數(shù)據(jù)庫(kù)服務(wù)端口)[6432] SLAVE_1_LOCAL_PORT (備庫(kù)通信端口)[6434] MASTER_NODENAME (主節(jié)點(diǎn)名稱)[opengauss_master] SLAVE_NODENAME (備節(jié)點(diǎn)名稱)[opengauss_slave1]
3.查看創(chuàng)建腳本
[root@node openguass]# cat create_master_slave.sh
#!/bin/bash -e
# Parameters
#!/bin/bash
#set OG_SUBNET,GS_PASSWORD,MASTER_IP,SLAVE_1_IP,MASTER_HOST_PORT,MASTER_LOCAL_PORT,SLAVE_1_HOST_PORT,SLAVE_1_LOCAL_PORT,MASTER_NODENAME,SLAVE_NODENAME
read -p "Please input OG_SUBNET (容器所在網(wǎng)段) [172.11.0.0/24]: " OG_SUBNET
OG_SUBNET=${OG_SUBNET:-172.11.0.0/24}
echo "OG_SUBNET set $OG_SUBNET"
read -p "Please input GS_PASSWORD (定義數(shù)據(jù)庫(kù)密碼)[Enmo@123]: " GS_PASSWORD
GS_PASSWORD=${GS_PASSWORD:-Enmo@123}
echo "GS_PASSWORD set $GS_PASSWORD"
read -p "Please input MASTER_IP (主庫(kù)IP)[172.11.0.101]: " MASTER_IP
MASTER_IP=${MASTER_IP:-172.11.0.101}
echo "MASTER_IP set $MASTER_IP"
read -p "Please input SLAVE_1_IP (備庫(kù)IP)[172.11.0.102]: " SLAVE_1_IP
SLAVE_1_IP=${SLAVE_1_IP:-172.11.0.102}
echo "SLAVE_1_IP set $SLAVE_1_IP"
read -p "Please input MASTER_HOST_PORT (主庫(kù)數(shù)據(jù)庫(kù)服務(wù)端口)[5432]: " MASTER_HOST_PORT
MASTER_HOST_PORT=${MASTER_HOST_PORT:-5432}
echo "MASTER_HOST_PORT set $MASTER_HOST_PORT"
read -p "Please input MASTER_LOCAL_PORT (主庫(kù)通信端口)[5434]: " MASTER_LOCAL_PORT
MASTER_LOCAL_PORT=${MASTER_LOCAL_PORT:-5434}
echo "MASTER_LOCAL_PORT set $MASTER_LOCAL_PORT"
read -p "Please input SLAVE_1_HOST_PORT (備庫(kù)數(shù)據(jù)庫(kù)服務(wù)端口)[6432]: " SLAVE_1_HOST_PORT
SLAVE_1_HOST_PORT=${SLAVE_1_HOST_PORT:-6432}
echo "SLAVE_1_HOST_PORT set $SLAVE_1_HOST_PORT"
read -p "Please input SLAVE_1_LOCAL_PORT (備庫(kù)通信端口)[6434]: " SLAVE_1_LOCAL_PORT
SLAVE_1_LOCAL_PORT=${SLAVE_1_LOCAL_PORT:-6434}
echo "SLAVE_1_LOCAL_PORT set $SLAVE_1_LOCAL_PORT"
read -p "Please input MASTER_NODENAME [opengauss_master]: " MASTER_NODENAME
MASTER_NODENAME=${MASTER_NODENAME:-opengauss_master}
echo "MASTER_NODENAME set $MASTER_NODENAME"
read -p "Please input SLAVE_NODENAME [opengauss_slave1]: " SLAVE_NODENAME
SLAVE_NODENAME=${SLAVE_NODENAME:-opengauss_slave1}
echo "SLAVE_NODENAME set $SLAVE_NODENAME"
read -p "Please input openGauss VERSION [3.0.0]: " VERSION
VERSION=${VERSION:-3.0.0}
echo "openGauss VERSION set $VERSION"
echo "starting "
docker network create --subnet=$OG_SUBNET opengaussnetwork \
|| {
echo ""
echo "ERROR: OpenGauss Database Network was NOT successfully created."
echo "HINT: opengaussnetwork Maybe Already Exsist Please Execute 'docker network rm opengaussnetwork' "
exit 1
}
echo "OpenGauss Database Network Created."
docker run --network opengaussnetwork --ip $MASTER_IP --privileged=true \
--name $MASTER_NODENAME -h $MASTER_NODENAME -p $MASTER_HOST_PORT:$MASTER_HOST_PORT -d \
-e GS_PORT=$MASTER_HOST_PORT \
-e OG_SUBNET=$OG_SUBNET \
-e GS_PASSWORD=$GS_PASSWORD \
-e NODE_NAME=$MASTER_NODENAME \
-e REPL_CONN_INFO="replconninfo1 = 'localhost=$MASTER_IP localport=$MASTER_LOCAL_PORT localservice=$MASTER_HOST_PORT remotehost=$SLAVE_1_IP remoteport=$SLAVE_1_LOCAL_PORT remoteservice=$SLAVE_1_HOST_PORT'\n" \
enmotech/opengauss:$VERSION -M primary \
|| {
echo ""
echo "ERROR: OpenGauss Database Master Docker Container was NOT successfully created."
exit 1
}
echo "OpenGauss Database Master Docker Container created."
sleep 30s
docker run --network opengaussnetwork --ip $SLAVE_1_IP --privileged=true \
--name $SLAVE_NODENAME -h $SLAVE_NODENAME -p $SLAVE_1_HOST_PORT:$SLAVE_1_HOST_PORT -d \
-e GS_PORT=$SLAVE_1_HOST_PORT \
-e OG_SUBNET=$OG_SUBNET \
-e GS_PASSWORD=$GS_PASSWORD \
-e NODE_NAME=$SLAVE_NODENAME \
-e REPL_CONN_INFO="replconninfo1 = 'localhost=$SLAVE_1_IP localport=$SLAVE_1_LOCAL_PORT localservice=$SLAVE_1_HOST_PORT remotehost=$MASTER_IP remoteport=$MASTER_LOCAL_PORT remoteservice=$MASTER_HOST_PORT'\n" \
enmotech/opengauss:$VERSION -M standby \
|| {
echo ""
echo "ERROR: OpenGauss Database Slave1 Docker Container was NOT successfully created."
exit 1
}
echo "OpenGauss Database Slave1 Docker Container created."
4.運(yùn)行創(chuàng)建腳本
[root@node openguass]# sh create_master_slave.sh Please input OG_SUBNET (容器所在網(wǎng)段) [172.11.0.0/24]: OG_SUBNET set 172.11.0.0/24 Please input GS_PASSWORD (定義數(shù)據(jù)庫(kù)密碼)[Enmo@123]: GS_PASSWORD set Enmo@123 Please input MASTER_IP (主庫(kù)IP)[172.11.0.101]: MASTER_IP set 172.11.0.101 Please input SLAVE_1_IP (備庫(kù)IP)[172.11.0.102]: SLAVE_1_IP set 172.11.0.102 Please input MASTER_HOST_PORT (主庫(kù)數(shù)據(jù)庫(kù)服務(wù)端口)[5432]: MASTER_HOST_PORT set 5432 Please input MASTER_LOCAL_PORT (主庫(kù)通信端口)[5434]: MASTER_LOCAL_PORT set 5434 Please input SLAVE_1_HOST_PORT (備庫(kù)數(shù)據(jù)庫(kù)服務(wù)端口)[6432]: SLAVE_1_HOST_PORT set 6432 Please input SLAVE_1_LOCAL_PORT (備庫(kù)通信端口)[6434]: SLAVE_1_LOCAL_PORT set 6434 Please input MASTER_NODENAME [opengauss_master]: MASTER_NODENAME set opengauss_master Please input SLAVE_NODENAME [opengauss_slave1]: SLAVE_NODENAME set opengauss_slave1 Please input openGauss VERSION [3.0.0]: openGauss VERSION set 3.0.0 starting 97d6c3667b72511c0f09eea31b54b6c5d315af06252db1a7961b0861069f2b5a OpenGauss Database Network Created. 24c3c7ba6b162fabbe9ac4e21f4b188ebd49acbbba91e7458d287ad6731ce48f OpenGauss Database Master Docker Container created. 0376996ac00d91173e24ebea274d0750be9093269dcfdf479722c68952aa93a1 OpenGauss Database Slave1 Docker Container created.
5.查看容器狀態(tài)
[root@node openguass]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 0376996ac00d enmotech/opengauss:3.0.0 "entrypoint.sh -M st…" About a minute ago Up About a minute 5432/tcp, 0.0.0.0:6432->6432/tcp, :::6432->6432/tcp opengauss_slave1 24c3c7ba6b16 enmotech/opengauss:3.0.0 "entrypoint.sh -M pr…" 2 minutes ago Up 2 minutes 0.0.0.0:5432->5432/tcp, :::5432->5432/tcp opengauss_master
6.驗(yàn)證主從狀態(tài)
[root@node openguass]# docker exec -it 24c3c7ba6b16 /bin/bash root@opengauss_master:/# su - omm omm@opengauss_master:~$ gs_ctl query -D /var/lib/opengauss/data/ [2022-10-04 10:13:45.084][346][][gs_ctl]: gs_ctl query ,datadir is /var/lib/opengauss/data HA state: local_role : Primary static_connections : 1 db_state : Normal detail_information : Normal Senders info: sender_pid : 319 local_role : Primary peer_role : Standby peer_state : Normal state : Streaming sender_sent_location : 0/40002E8 sender_write_location : 0/40002E8 sender_flush_location : 0/40002E8 sender_replay_location : 0/40002E8 receiver_received_location : 0/40002E8 receiver_write_location : 0/40002E8 receiver_flush_location : 0/40002E8 receiver_replay_location : 0/40002E8 sync_percent : 100% sync_state : Sync sync_priority : 1 sync_most_available : On channel : 172.11.0.101:5434-->172.11.0.102:35454 Receiver info: No information
六、檢查容器運(yùn)行日志

到此這篇關(guān)于使用Docker部署openGauss國(guó)產(chǎn)數(shù)據(jù)庫(kù)的文章就介紹到這了,更多相關(guān)Docker部署openGauss數(shù)據(jù)庫(kù)內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
相關(guān)文章
docker?build與Dockerfile問(wèn)題
這篇文章主要介紹了docker?build與Dockerfile問(wèn)題,具有很好的參考價(jià)值,希望對(duì)大家有所幫助。如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2023-03-03
Docker容器實(shí)現(xiàn)SSH遠(yuǎn)程直連
在某些特殊需求下,我們想ssh直接遠(yuǎn)程連接docker 容器,本文主要介紹了Docker容器實(shí)現(xiàn)SSH遠(yuǎn)程直連,具有一定的參考價(jià)值,感興趣的可以了解一下2023-08-08
Docker部署MongoDb的詳細(xì)過(guò)程記錄
這篇文章主要介紹了如何使用Docker?Compose啟動(dòng)MongoDB副本集,包括配置文件編寫、容器啟動(dòng)命令、副本集初始化、角色和用戶創(chuàng)建等步驟,需要的朋友可以參考下2024-12-12
docker國(guó)內(nèi)鏡像源配置及走代理設(shè)置小結(jié)
本文主要介紹了配置Docker國(guó)內(nèi)鏡像源及代理設(shè)置,以加快鏡像拉取速度,文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2025-01-01
docker overlay實(shí)現(xiàn)跨主機(jī)的容器互通的方法
這篇文章主要介紹了docker overlay實(shí)現(xiàn)跨主機(jī)的容器互通,本文給大家介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值,需要的朋友可以參考下2021-11-11
使用Docker部署 spring-boot maven應(yīng)用的方法
本篇文章主要介紹了使用Docker部署 spring-boot maven應(yīng)用的方法,具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2017-08-08
docker內(nèi)的容器如何與宿主機(jī)共享IP的方法
本文主要介紹了docker內(nèi)的容器如何與宿主機(jī)共享IP的方法,文中根據(jù)實(shí)例編碼詳細(xì)介紹的十分詳盡,具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2022-03-03

