opengauss 实践总结学习心
openGauss 是一款开源关系型数据库管理系统 , 深度融合华为在数据库领域多年的经验，结合企业级场景需求，持续构建竞争力特性;kubernetes 也是一个开源的，用于管理云平台中多个主机上的容器化的应用，Kubernetes 的目标是让部署容器化的应用简单并且高效,Kubernetes 提供了应用部署，规划，更新，维护的一种机制, 本篇文章将介绍 openGauss 在 kubernetes 集群环境上的部署探索。

1.检查 k8s 运行环境
[root@n-k8s-m ~]# kubectl get node

NAME STATUS ROLES AGE VERSION
n-k8s-m Ready master 349d v1.18.0
2.查看准备好的 openGauss 的 docker 镜像
[root@n-k8s-m ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
nginx latest 4cdc5dd7eaad 36 hours ago 133MB
opengauss 2.0.0 757bf74560e3 5 weeks ago 639MB
3.安装 NFS 服务器存储

安装依赖包

[root@n-k8s-m ~]#yum -y install nfs-utils rpcbind

开机启动

[root@n-k8s-m ~]#systemctl enable rpcbind.service
[root@n-k8s-m ~]#systemctl enable nfs-server.service
[root@n-k8s-m ~]#systemctl start rpcbind.service #端口是111
[root@n-k8s-m ~]#systemctl start nfs-server.service # 端口是 2049

配置NFS

[root@n-k8s-m ~]#mkdir /home/pv1
[root@n-k8s-m ~]#chown nfsnobody:nfsnobody /home/pv1
[root@n-k8s-m ~]#cat /etc/exports

/home/pv1 ***.***.***.***/24(rw,async,all_squash)

[root@n-k8s-m ~]#exportfs -rv

exporting ***.***.***.***/24:/home/pv1

/home/pv1 .../24(rw,async,all_squash)

[root@n-k8s-m ~]#exportfs -rv
exporting .../24:/home/pv1
4.创建 openGauss 所使用的存储 pv

编写yaml文件

[root@n-k8s-m ~]# cat opengauss_pv.yml
apiVersion: v1
kind: PersistentVolume
metadata:
name: opengauss-pv
labels:
type: nfs001
spec:
capacity:
storage: 1Gi
accessModes:
- ReadWriteMany
persistentVolumeReclaimPolicy: Recycle
nfs:
path: "/home/pv1"
server: ... readOnly: false

创建pv

[root@n-k8s-m opengauss]# kubectl create -f opengauss_pv.yml
persistentvolume/opengauss-pv created

查看创建pv

[root@n-k8s-m opengauss]# kubectl get pv
NAME                                       CAPACITY   ACCESS MODES   RECLAIM POLICY   STATUS      CLAIM                            STORAGECLASS          REASON   AGE

opengauss-pv 1Gi RWX Recycle Available
5.创建 openGauss 所使用的存储 pvc

编写yaml文件

[root@n-k8s-m ~]# cat opengauss_pvc.yml
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
name: opengauss-pvc
spec:
accessModes:
- ReadWriteMany
resources:
requests:
storage: 1Gi

创建pvc

[root@n-k8s-m opengauss]# kubectl create -f opengauss_pvc.yml
persistentvolumeclaim/opengauss-pv created

查看创建pvc

[root@n-k8s-m opengauss]# kubectl get pvc
NAME                     STATUS   VOLUME                  CAPACITY   ACCESS MODES   STORAGECLASS          AGE

opengauss-pvc Bound opengauss-pv 1Gi RWX 4s
6.创建 openGauss 的 Deployment

编写yaml文件

apiVersion: apps/v1
kind: Deployment
metadata:
name: opengauss-deployment
spec:
selector:
matchLabels:
app: opengauss
strategy:
type: Recreate
template:
metadata:
labels:
app: opengauss
spec:
containers:
- image: opengauss:2.0.0
name: opengauss-service
imagePullPolicy: IfNotPresent
env:
- name: GS_PASSWORD
value: Gauss@123
ports:
- containerPort: 5432
name: opengauss
volumeMounts: # 挂载Pod上的卷到容器
- name: opengauss-persistent-storage # Pod上卷的名字，与“volumes”名字匹配
mountPath: /var/lib/opengauss # 挂载的Pod的目录
volumes: # 挂载持久卷到Pod
- name: opengauss-persistent-storage # 持久卷名字， 与“volumMounts”名字匹配
persistentVolumeClaim:
claimName: opengauss-pvc # 持久卷申请名字

创建Deployment[root@n-k8s-m opengauss]# kubectl create -f opengauss_deploy.yaml

 deployment.apps/opengauss-deployment create

查看创建Deploymen

 [root@n-k8s-m opengauss]# kubectl get deploy
 NAME                            READY   UP-TO-DATE   AVAILABLE   AGEopengauss-deployment     1/1                 1            1           110s

创建Deployment

[root@n-k8s-m opengauss]# kubectl create -f opengauss_deploy.yaml
deployment.apps/opengauss-deployment created

查看创建Deployment

[root@n-k8s-m opengauss]# kubectl get deploy
NAME READY UP-TO-DATE AVAILABLE AGE
opengauss-deployment 1/1 1 1 110s​
7.创建 openGauss 的 Service 提供集群内部和外部的高可用访问

编写yaml文件

apiVersion: v1
kind: Service
metadata:
name: opengauss-service
labels:
app: opengauss
spec:
type: NodePort
selector:
app: opengauss
ports:

• protocol : TCP
  nodePort: 32222
  port: 5432
  targetPort: 5432

创建openGauss的Service

[root@n-k8s-m opengauss]# kubectl create -f opengauss_svc.yaml
>service/opengauss-service created

查看创建Service

[root@n-k8s-m opengauss]# kubectl get svc
NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
opengauss-service NodePort 10.101.64.232 <none> 5432:32222/TCP 6s
8.连接 openGauss 数据库

使用kubectl内部连接数据库

[root@n-k8s-m opengauss]# kubectl get pod
NAME READY STATUS RESTARTS AGE
opengauss-deployment-6b8b4645f8-bfk4w 1/1 Running 0 15m
[root@n-k8s-m opengauss]# kubectl exec -it opengauss-deployment-6b8b4645f8-bfk4w sh
kubectl exec [POD] [COMMAND] is DEPRECATED and will be removed in a future version. Use kubectl kubectl exec [POD] -- [COMMAND] instead.
sh-4.2# su - omm
[omm@opengauss-deployment-6b8b4645f8-bfk4w ~]$ gsql
gsql ((openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:04:03 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
omm=# \c
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "omm" as user "omm".
omm=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+------------+------------+-------------------
omm | omm | UTF8 | en_US.utf8 | en_US.utf8 |
postgres | omm | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | omm | UTF8 | en_US.utf8 | en_US.utf8 | =c/omm +
| | | | | omm=CTc/omm
template1 | omm | UTF8 | en_US.utf8 | en_US.utf8 | =c/omm +
| | | | | omm=CTc/omm
(4 rows)
使用 pgadmin4 外部连接数据库

image.pngimage.png