【GaussDB】华为云环境下安装Docker管理的GaussDB

最新推荐文章于 2024-05-08 11:56:43 发布
最新推荐文章于 2024-05-08 11:56:43 发布
阅读量356 收藏
点赞数 3
分类专栏： GaussDB数据库运维与管理 文章标签： gaussdb 华为云 docker
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43346403/article/details/137454506
版权

1.购买云环境。

经过安装发下:docker方式部署，只需要一个 / 目录，就可以，不必所有节点都挂载。
当前也可以都挂载。挂很多盘浪费资源，测试环境，可以只挂一个目录。 / 

119.3.233.237 	192.168.0.165  第一台 gaussdb001
119.3.226.231   192.168.0.140  第二台 gaussdb002
114.116.242.223 192.168.0.149  第三台 gaussdb003

2.修改主机名。

 hostnamectl set-hostname gaussdb001
 hostnamectl set-hostname gaussdb002
 hostnamectl set-hostname gaussdb003

vi /etc/hosts 
192.168.0.165 gaussdb001
192.168.0.140 gaussdb002
192.168.0.149 gaussdb003

3.磁盘检查 

[root@ecs-9c2b-0001 ~]# fdisk -l |grep /dev
Disk /dev/vda: 100 GiB, 107374182400 bytes, 209715200 sectors
/dev/vda1     2048   2099199   2097152   1G EFI System
/dev/vda2  2099200 209715166 207615967  99G Linux filesystem
--除了根目录有8个盘。
Disk /dev/vdb: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk /dev/vdc: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk /dev/vdd: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk /dev/vde: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk /dev/vdf: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk /dev/vdg: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk /dev/vdh: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk /dev/vdi: 100 GiB, 107374182400 bytes, 209715200 sectors

不要做格式化。保持裸盘即可。

4.java检查 

[root@ecs-9c2b-0001 soft]# java -version
openjdk version "1.8.0_242"
OpenJDK Runtime Environment (build 1.8.0_242-b08)
OpenJDK 64-Bit Server VM (build 25.242-b08, mixed mode)

5.安装 expect 

yum -y install expect
[root@ecs-9c2b-0001 soft]# expect -v
expect version 5.45.4

6.ssl检查 

[root@ecs-9c2b-0001 soft]# openssl version
OpenSSL 1.1.1d  10 Sep 2019

7.安装dos2unix

yum -y install dos2unix 
[root@ecs-9c2b-0001 soft]# dos2unix -V
dos2unix 7.4.0 (2017-10-10)
With Unicode UTF-16 support.
With native language support.
With support to preserve the user and group ownership of files.
LOCALEDIR: /usr/share/locale
http://waterlan.home.xs4all.nl/dos2unix.html

8.字符集设置 

安装用户需使用locale命令检查操作系统字符集，必须为en_US.UTF-8。若不是， 执行以下命令进行修改或添加。

vi /etc/sysconfig/i18n
修改LANG为en_US.UTF-8，执行source /etc/sysconfig/i18n即可

LANG=en_US.UTF-8
source /etc/sysconfig/i18n

9.libcgroup 检查 

yum -y install libcgroup

10.注意时区 

[root@ecs-9c2b-0002 ~]# timedatectl
               Local time: Mon 2024-04-01 15:04:48 CST
           Universal time: Mon 2024-04-01 07:04:48 UTC
                 RTC time: Mon 2024-04-01 07:04:47
                Time zone: Asia/Shanghai (CST, +0800)
System clock synchronized: yes
              NTP service: active
          RTC in local TZ: no


--时区设置未UTC；
timedatectl set-timezone UTC

11.关闭GSSAPI认证

vi /etc/ssh/sshd_config 

GSSAPIAuthentication no    --这里修改未No;

systemctl restart sshd

12.python3 版本检查 

[root@ecs-9c2b-0002 ~]# python3 --version
Python 3.7.4

13.关闭防火墙:

云环境默认已经关闭防火墙。

systemctl stop firewalld.service 
systemctl disable firewalld.service

14.selinux配置修改  

vi /etc/selinux/config

SELINUX=permissive

15.设置pam规则 

vi /etc/pam.d/system-auth
在行末添加 “min_len=8”
password    requisite     pam_pwquality.so try_first_pass local_users_only   
--修改为:
password    requisite     pam_pwquality.so try_first_pass local_users_only min_len=8

16.开启安装步骤。

将包放在合适的位置。
mkdir /data
tar -xzvf DBS-docker-service*_all.tar.gz -C /data

cp /root/soft/DBS* /data/docker-service/pkgs
cp GaussDB_OS_PATCH_2.23.07.260.20231226095856.zip* /data/docker-service/pkgs/

微服务包(共12个)：

DBS-auth_*_all.tar.gz 
DBS-common-service_*_all.tar.gz 
DBS-GaussDB-backupmanager_*_all.tar.gz 
DBS-gaussdb-console_*_all.tar.gz 
DBS-GaussDB-instancemanager_*_all.tar.gz 
DBS-GaussDB-open-api_*_all.tar.gz 
DBS-luban_*_all.tar.gz 
DBS-monitor-service_*_all.tar.gz 
DBS-ots_*_all.tar.gz 
DBS-rds-ha-admin_*_all.tar.gz 
DBS-resource-manager_*_all.tar.gz 
DBS-workflow_*_all.tar.gz

数据包（共2个）：
DBS-GaussDB-feature-data_*_all.tar.gz 
DBS-platform-data_*_all.tar.gz


GaussDB实例安装包（共6个）： 
GaussDB_OS_PATCH_*.zip 
DBS-GaussDB-agent_*_all.tar.gz 
DBS-GaussDB-Manual_*.tar.gz 
DBS-DBMind-Manual_*.tar.gz 
DBS-tools_*_all.tar.gz 
DBS-OM-Agent-Manual_*.tar.gz

17.修改参数

cd /data/docker-service/config
vi user_edit_file.conf

若user_edit_file.conf配置文件中指定的
gauss_path、main_path、log_path、sftp_path、influx_path、docker_path、backup_path对应的
目录未挂载磁盘，则需执 行以下命令创建指定目录。


vi /data/docker-service/config/user_edit_file.conf
[user_edit]
ssh_port = 22
gauss_path = /opt/gaussdb
node1_ip = 192.168.0.165
node2_ip = 192.168.0.140
node3_ip = 192.168.0.149
influxdb_install_ip1 = 192.168.0.165
influxdb_install_ip2 = 192.168.0.140
sftp_install_ip1 = 192.168.0.165
sftp_install_ip2 = 192.168.0.140
main_path = /opt/cloud
node1_ip2 = 192.168.0.165
node2_ip2 = 192.168.0.140
node3_ip2 = 192.168.0.149
log_path = /opt/cloud/logs
sftp_path = /opt/sftphome
influx_path = /opt/cloud/influxdb
docker_path = /opt/docker
backup_path = /opt/backup
service_group_id = 1010
service_user_id = 1010
uninstall_all = no
use_cgroup = no


--我们目前还没有挂载。
--执行脚本创建目录。
sh /data/docker-service/action/mainAction/create_install_dir.sh 'Root#123'

18.以root用户进入上传软件包节点appctl.sh文件所在目录。
 

cd /data/docker-service
sh appctl.sh install
输入root密码:Root#123
[root@gaussdb001 docker-service]# sh appctl.sh install
请输入root用户密码:
start check host: 192.168.0.165 root password
check host: 192.168.0.165 root password success
start check host: 192.168.0.140 root password
check host: 192.168.0.140 root password success
start check host: 192.168.0.149 root password
check host: 192.168.0.149 root password success
*** BUILD MICRO SERVICE IMAGES ***
 check docker status           |  OK             
 check service origin packages |  OK             
 load docker base image        |  OK             
 build & save zookeeper        |  OK             
 build & save kafka            |  OK             
 build & save common-service   |  OK             
 build & save monitor-service  |  OK             
 build & save rds-ha-admin     |  OK             
 build & save resource-manager |  OK             
 build & save workflow         |  OK             
 build & save auth             |  OK             
 build & save gaussdb-console  |  OK             
 build & save luban            |  OK             
 build & save ots              |  OK             
 build & save GaussDB-open-api |  OK             
 build & save GaussDB-instancemanager |  OK             
 build & save GaussDB-backupmanager |  OK             
 unload docker base image      |  OK             
*** DISTRIBUTE PACKAGES ***
 /data/docker-service left space |  OK             
 check packages                |  OK             
 distribute gaussdb packages   |  OK             
 distribute service packages   |  OK             
 distribute data packages      |  OK             
 distribute sftp packages      |  OK             
 distribute remote ip          |  OK             
*** PREPARE ***
 192.168.0.165                 |  OK             
 192.168.0.140                 |  OK             
 192.168.0.149                 |  OK             
Now doing precheck for 192.168.0.165
Now doing precheck for 192.168.0.140
Now doing precheck for 192.168.0.149
[WARNING]-[check_drs]===>[192.168.0.140: The switch of use_cgroup is no.You are not allow to install drs together on this machine.]
[WARNING]-[check_dir_mount]===>[192.168.0.140: /opt/cloud was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.140: /opt/backup was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.140: /opt/cloud/logs was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.140: /opt/docker was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.140: /opt/gaussdb was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.140: /opt/cloud/influxdb was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.140: /opt/sftphome was not mounted.]
[WARNING]-[check_drs]===>[192.168.0.149: The switch of use_cgroup is no.You are not allow to install drs together on this machine.]
[WARNING]-[check_dir_mount]===>[192.168.0.149: /opt/cloud was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.149: /opt/backup was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.149: /opt/cloud/logs was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.149: /opt/docker was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.149: /opt/gaussdb was not mounted.]
[WARNING]-[check_drs]===>[192.168.0.165: The switch of use_cgroup is no.You are not allow to install drs together on this machine.]
[WARNING]-[check_docker]===>[192.168.0.165: docker has been installed on this machine.The docker data store path is /opt/docker.]
[WARNING]-[check_dir_mount]===>[192.168.0.165: /opt/cloud was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.165: /opt/backup was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.165: /opt/cloud/logs was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.165: /opt/docker was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.165: /opt/gaussdb was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.165: /opt/cloud/influxdb was not mounted.]
[WARNING]-[check_dir_mount]===>[192.168.0.165: /opt/sftphome was not mounted.]
[WARNING]-[check_users]===>[192.168.0.165: [dbadmin service sftpservice] will be used, if the users already exists, we will delete the user before creating it.]
Precheck all completed.
Start to init manifest...
init manifest successful for 192.168.0.165.
init manifest successful for 192.168.0.140.
init manifest successful for 192.168.0.149.
======== 192.168.0.165: patch ========
  patch                   |  complete       
  base_env                |  complete       
======== 192.168.0.140: patch ========
  patch                   |  complete       
  base_env                |  complete       
======== 192.168.0.149: patch ========
  patch                   |  complete       
  base_env                |  complete       

======== 192.168.0.165: base_enviornment ========
  docker                  |  complete       
  InfluxDB                |  complete       
  sftp                    |  complete       
  gaussdb                 |  complete       
======== 192.168.0.140: base_enviornment ========
  docker                  |  complete       
  InfluxDB                |  complete       
  sftp                    |  complete       
  gaussdb                 |  complete       
======== 192.168.0.149: base_enviornment ========
  docker                  |  complete       
  InfluxDB                |  complete       
  sftp                    |  complete       
  gaussdb                 |  complete       

======== 192.168.0.165: CommonbaseData ========
  common-base             |  complete       
======== 192.168.0.140: CommonbaseData ========
  common-base             |  complete       
======== 192.168.0.149: CommonbaseData ========
  common-base             |  complete       

======== 192.168.0.165: PlatformData ========
  platform-data           |  complete       
======== 192.168.0.140: PlatformData ========
  platform-data           |  complete       
======== 192.168.0.149: PlatformData ========
  platform-data           |  complete       

======== 192.168.0.165: Zookeeper ========
  zookeeper               |  complete       
  GaussDB-feature-data    |  complete       
======== 192.168.0.140: Zookeeper ========
  zookeeper               |  complete       
  GaussDB-feature-data    |  complete       
======== 192.168.0.149: Zookeeper ========
  zookeeper               |  complete       
  GaussDB-feature-data    |  complete       

======== 192.168.0.165: Kafka ========
  kafka                   |  complete       
======== 192.168.0.140: Kafka ========
  kafka                   |  complete       
======== 192.168.0.149: Kafka ========
  kafka                   |  complete       

======== 192.168.0.165: docker_service ========
  common-service          |  complete       
  monitor-service         |  complete       
  rds-ha-admin            |  complete       
  resource-manager        |  complete       
  workflow                |  complete       
======== 192.168.0.140: docker_service ========
  common-service          |  complete       
  monitor-service         |  complete       
  rds-ha-admin            |  complete       
  resource-manager        |  complete       
  workflow                |  complete       
======== 192.168.0.149: docker_service ========
  common-service          |  complete       
  monitor-service         |  complete       
  rds-ha-admin            |  complete       
  resource-manager        |  complete       
  workflow                |  complete       

======== 192.168.0.165: gaussdb_service ========
  auth                    |  complete       
  gaussdb-console         |  complete       
  luban                   |  complete       
  ots                     |  complete       
  GaussDB-open-api        |  complete       
  GaussDB-instancemanager |  complete       
  GaussDB-backupmanager   |  complete       
======== 192.168.0.140: gaussdb_service ========
  auth                    |  complete       
  gaussdb-console         |  complete       
  luban                   |  complete       
  ots                     |  complete       
  GaussDB-open-api        |  complete       
  GaussDB-instancemanager |  complete       
  GaussDB-backupmanager   |  complete       
======== 192.168.0.149: gaussdb_service ========
  auth                    |  complete       
  gaussdb-console         |  complete       
  luban                   |  complete       
  ots                     |  complete       
  GaussDB-open-api        |  complete       
  GaussDB-instancemanager |  complete       
  GaussDB-backupmanager   |  complete       

install successful

Upload sftp packages done for 192.168.0.165
请登录「云数据库GaussDB管理平台-任务中心」查看安装包上传任务状态

19.目录查看 

[root@gaussdb001 docker-service]# df -h
Filesystem      Size  Used Avail Use% Mounted on
devtmpfs         32G     0   32G   0% /dev
tmpfs            32G   64K   32G   1% /dev/shm
tmpfs            32G   19M   32G   1% /run
tmpfs            32G     0   32G   0% /sys/fs/cgroup
/dev/vda2        98G   55G   39G  60% /
tmpfs            32G  192K   32G   1% /tmp
/dev/vda1      1022M  5.8M 1017M   1% /boot/efi
tmpfs           6.4G     0  6.4G   0% /run/user/0
tmpfs           6.4G     0  6.4G   0% /run/user/1013
overlay          98G   55G   39G  60% /opt/docker/overlay2/a37b134c212e35a247f005a606d89e11ad5f92331982492e4a86061610bc03e2/merged
shm              64M     0   64M   0% /opt/docker/containers/ddedb8092f9601f20a8b527bf9c3f11d75656bf75606cf622222a8216062ddb7/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/8e17d61160e01f8acf29798adb152e36c22da39bcfa825f68e0b613f8011b62f/merged
shm              64M     0   64M   0% /opt/docker/containers/5151b4dbfa8ef4408dabd521932102cdaf0daf437c4fa8f0c1c0e8b61a8db62f/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/22bfdef20a295045974bc47b91d663a8a9f6aef77e974f310b7df183563f91bc/merged
shm              64M     0   64M   0% /opt/docker/containers/36b4eedc56392a7cf1333f94b009a4dbe3cb345a894d45920e4dd92cf5a7d31f/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/8630f5402552d3da3f0e35b351a3812be80c1516f91a0207ec8df1f109efda55/merged
shm              64M     0   64M   0% /opt/docker/containers/ba8a04f5fa17ff1fa1087a2dadb478786f7e1b38cbd067445b3b81fa17ea0899/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/10d48c0b3ff13c546650f13d6ee63d21dc3f7da7793d1863ffe22477b1f1aba7/merged
overlay          98G   55G   39G  60% /opt/docker/overlay2/a2947937a45b5d7d006f473f2b13b023761ce156ae00f27fdc82d678a872fc2a/merged
shm              64M     0   64M   0% /opt/docker/containers/61f1252b21ad807538c29db2802603781b7192a1f4744f395431a1deebf9d20c/mounts/shm
shm              64M     0   64M   0% /opt/docker/containers/b4336bab83796188f9303b1a6ea26916f489fb3f2ab87be2a016cdaa49281dc2/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/98e58dbc99df739e925fda545dc47462ea2efd7e5999ea362590a7b10c1c34c7/merged
shm              64M     0   64M   0% /opt/docker/containers/b64e0d40381110c1d50c5e0e7e48b07844c6e28ad398830f96226725253c025c/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/fa945f745cdbfc0f1d89e5c1f49f6822ac2e826289bb7a1bf81d9d30e0e9abff/merged
shm              64M     0   64M   0% /opt/docker/containers/2f4e00d797aaca829b3536f8f48bb053b7de33cdbe527023c26a49ddc6169549/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/177bb8714a1c200376294ce16924d2714f212f6f87a20649a9d7d33569e58abe/merged
shm              64M     0   64M   0% /opt/docker/containers/82e50faf9b7819d9ed4f52ce340f16848703ad620f751ad8541cdc31ea63cc8e/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/d5e6039e7f897fb7d627144c56e261900e9fa8b19f4f731f1f57c9405855ea72/merged
shm              64M     0   64M   0% /opt/docker/containers/7ae3af85c383e0eacaae4ee7bdcec47b18b192caa1c1f6b2ab5e780fc9abbd20/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/e77f37e155375dc53fa8771042e2252eb1550d45e7890689b69e89e8f0fbaa75/merged
shm              64M     0   64M   0% /opt/docker/containers/f70fc3c684c06d558b94a0cdbad3bcae75d9091366a69448207e750d34ec55b4/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/a267ff3dd24160533f64c03087a15b2c0548bf5e5549818446b62a8c5baeaf6d/merged
overlay          98G   55G   39G  60% /opt/docker/overlay2/d8b35ef232fa025692f2c09c39cfc2c1a41065e8d3703ec7582a765a4f51f67a/merged
shm              64M     0   64M   0% /opt/docker/containers/09ef1b64ec44297e8bc1c2712f192f1de998fe8bb3f4bf05ac252dbc83375aac/mounts/shm
overlay          98G   55G   39G  60% /opt/docker/overlay2/c40e2be245b8b13aecaaf2a07e8fb00760e0ec2ce65e6ec06fd4e76a567190eb/merged
shm              64M     0   64M   0% /opt/docker/containers/d33bb4e66c9c76749b3f81cf3e61f4cfad88a4576e52b59e3bb37dda264c0555/mounts/shm
shm              64M     0   64M   0% /opt/docker/containers/80f387ffe09b36272c574dd527ad3695f7b8d8183244cc25e54df33f31edd820/mounts/shm

可以看到docker版本的按照，不需要那么多目录。
只需要一个根目录。

20.集群进程查看 

[root@gaussdb001 docker-service]# ps -ef |grep gauss
dbadmin   142884       1  0 08:10 ?        00:00:10 /opt/gaussdb/core/app/bin/om_monitor -L /opt/gaussdb/logs/gaussdb/dbadmin/cm/om_monitor
dbadmin   168664       1  9 08:11 ?        00:02:38 /opt/gaussdb/core/app/bin/etcd -name etcd_7001 --data-dir /opt/gaussdb/data/etcd --client-cert-auth --trusted-ca-file /opt/gaussdb/core/app/share/sslcert/etcd/etcdca.crt --cert-file /opt/gaussdb/data/etcd/etcd.crt --key-file /opt/gaussdb/data/etcd/etcd.key --peer-client-cert-auth --peer-trusted-ca-file /opt/gaussdb/core/app/share/sslcert/etcd/etcdca.crt --peer-cert-file /opt/gaussdb/data/etcd/etcd.crt --peer-key-file /opt/gaussdb/data/etcd/etcd.key -initial-advertise-peer-urls https://192.168.0.165:31320 -listen-peer-urls https://192.168.0.165:31320 -listen-client-urls https://192.168.0.165:31300 -advertise-client-urls https://192.168.0.165:31300 --election-timeout 5000 --heartbeat-interval 1000 --log-outputs stdout --quota-backend-bytes 8589934592 --auto-compaction-mode periodic --auto-compaction-retention 1h -initial-cluster-token etcd-cluster-dbadmin --enable-v2=false -initial-cluster etcd_7001=https://192.168.0.165:31320,etcd_7002=https://192.168.0.140:31320,etcd_7003=https://192.168.0.149:31320 -initial-cluster-state new
dbadmin   169804  142884  9 08:12 ?        00:02:41 /opt/gaussdb/core/app/bin/cm_agent
dbadmin   169853       1  1 08:12 ?        00:00:17 /opt/gaussdb/core/app/bin/cm_server
dbadmin   169891       1  0 08:12 ?        00:00:00 gaussdb fenced UDF master process
dbadmin   178732       1 41 08:12 ?        00:11:40 /opt/gaussdb/core/app/bin/gaussdb -D /opt/gaussdb/data/dn/dn_6001 -M standby
service   433157  419764  1 08:23 ?        00:00:19 /opt/cloud/3rdComponent/jre/bin/java -Dnop -Djava.util.logging.manager=org.apache.logging.log4j.jul.LogManager -DAPP_NAME=gaussdb-console -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCDateStamps -Xloggc:/opt/cloud/gaussdb-console/logs/gc-20240401-162327.log -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/opt/cloud/gaussdb-console/logs/oom-20240401-162327.log -Dorg.quartz.scheduler.skipUpdateCheck=true -Duser.timezone=UTC -XX:-OmitStackTraceInFastThrow -Dorg.terracotta.quartz.skipUpdateCheck=true -Dnet.sf.ehcache.skipUpdateCheck=true -Dorg.apache.catalina.security.SecurityListener.UMASK=0077 -Dfastjson.parser.safeMode=true -Dzookeeper.clientCnxnSocket=org.apache.zookeeper.ClientCnxnSocketNIO -Djdk.tls.ephemeralDHKeySize=4096 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Dorg.apache.catalina.connector.RECYCLE_FACADES=true -Dfile.encoding=UTF-8 -Dorg.apache.catalina.STRICT_SERVLET_COMPLIANCE=false -server -Xss1m -Xms3000m -Xmx3000m -Xmn1500m -XX:SurvivorRatio=10 -XX:MaxTenuringThreshold=15 -XX:NewRatio=2 -XX:+DisableExplicitGC -Dignore.endorsed.dirs= -classpath /opt/cloud/gaussdb-console/bin/bootstrap.jar:/opt/cloud/gaussdb-console/lib/:/opt/cloud/gaussdb-console/server/:/opt/cloud/gaussdb-console/server/*:/opt/cloud/gaussdb-console/server/:/opt/cloud/gaussdb-console/server/*:/opt/cloud/gaussdb-console/bin/tomcat-juli.jar -Dcatalina.base=/opt/cloud/gaussdb-console -Dcatalina.home=/opt/cloud/gaussdb-console -Djava.io.tmpdir=/opt/cloud/gaussdb-console/temp org.apache.catalina.startup.Bootstrap start
*/
[root@gaussdb002 ~]# ps -ef |grep gauss
dbadmin    38760       1  0 08:10 ?        00:00:08 /opt/gaussdb/core/app/bin/om_monitor -L /opt/gaussdb/logs/gaussdb/dbadmin/cm/om_monitor
dbadmin    50204       1  7 08:11 ?        00:02:16 /opt/gaussdb/core/app/bin/etcd -name etcd_7002 --data-dir /opt/gaussdb/data/etcd --client-cert-auth --trusted-ca-file /opt/gaussdb/core/app/share/sslcert/etcd/etcdca.crt --cert-file /opt/gaussdb/data/etcd/etcd.crt --key-file /opt/gaussdb/data/etcd/etcd.key --peer-client-cert-auth --peer-trusted-ca-file /opt/gaussdb/core/app/share/sslcert/etcd/etcdca.crt --peer-cert-file /opt/gaussdb/data/etcd/etcd.crt --peer-key-file /opt/gaussdb/data/etcd/etcd.key -initial-advertise-peer-urls https://192.168.0.140:31320 -listen-peer-urls https://192.168.0.140:31320 -listen-client-urls https://192.168.0.140:31300 -advertise-client-urls https://192.168.0.140:31300 --election-timeout 5000 --heartbeat-interval 1000 --log-outputs stdout --quota-backend-bytes 8589934592 --auto-compaction-mode periodic --auto-compaction-retention 1h -initial-cluster-token etcd-cluster-dbadmin --enable-v2=false -initial-cluster etcd_7001=https://192.168.0.165:31320,etcd_7002=https://192.168.0.140:31320,etcd_7003=https://192.168.0.149:31320 -initial-cluster-state new
dbadmin    51300   38760  8 08:12 ?        00:02:29 /opt/gaussdb/core/app/bin/cm_agent
dbadmin    51348       1  1 08:12 ?        00:00:18 /opt/gaussdb/core/app/bin/cm_server
dbadmin    51384       1  0 08:12 ?        00:00:00 gaussdb fenced UDF master process
dbadmin    54877       1 16 08:12 ?        00:04:41 /opt/gaussdb/core/app/bin/gaussdb -D /opt/gaussdb/data/dn/dn_6002 -M standby
service   113603  103391  1 08:24 ?        00:00:18 /opt/cloud/3rdComponent/jre/bin/java -Dnop -Djava.util.logging.manager=org.apache.logging.log4j.jul.LogManager -DAPP_NAME=gaussdb-console -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCDateStamps -Xloggc:/opt/cloud/gaussdb-console/logs/gc-20240401-162411.log -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/opt/cloud/gaussdb-console/logs/oom-20240401-162411.log -Dorg.quartz.scheduler.skipUpdateCheck=true -Duser.timezone=UTC -XX:-OmitStackTraceInFastThrow -Dorg.terracotta.quartz.skipUpdateCheck=true -Dnet.sf.ehcache.skipUpdateCheck=true -Dorg.apache.catalina.security.SecurityListener.UMASK=0077 -Dfastjson.parser.safeMode=true -Dzookeeper.clientCnxnSocket=org.apache.zookeeper.ClientCnxnSocketNIO -Djdk.tls.ephemeralDHKeySize=4096 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Dorg.apache.catalina.connector.RECYCLE_FACADES=true -Dfile.encoding=UTF-8 -Dorg.apache.catalina.STRICT_SERVLET_COMPLIANCE=false -server -Xss1m -Xms3000m -Xmx3000m -Xmn1500m -XX:SurvivorRatio=10 -XX:MaxTenuringThreshold=15 -XX:NewRatio=2 -XX:+DisableExplicitGC -Dignore.endorsed.dirs= -classpath /opt/cloud/gaussdb-console/bin/bootstrap.jar:/opt/cloud/gaussdb-console/lib/:/opt/cloud/gaussdb-console/server/:/opt/cloud/gaussdb-console/server/*:/opt/cloud/gaussdb-console/server/:/opt/cloud/gaussdb-console/server/*:/opt/cloud/gaussdb-console/bin/tomcat-juli.jar -Dcatalina.base=/opt/cloud/gaussdb-console -Dcatalina.home=/opt/cloud/gaussdb-console -Djava.io.tmpdir=/opt/cloud/gaussdb-console/temp org.apache.catalina.startup.Bootstrap start

*/
[root@gaussdb003 ~]# ps -ef |grep gauss
dbadmin    37666       1  0 08:10 ?        00:00:09 /opt/gaussdb/core/app/bin/om_monitor -L /opt/gaussdb/logs/gaussdb/dbadmin/cm/om_monitor
dbadmin    48727       1  8 08:11 ?        00:02:23 /opt/gaussdb/core/app/bin/etcd -name etcd_7003 --data-dir /opt/gaussdb/data/etcd --client-cert-auth --trusted-ca-file /opt/gaussdb/core/app/share/sslcert/etcd/etcdca.crt --cert-file /opt/gaussdb/data/etcd/etcd.crt --key-file /opt/gaussdb/data/etcd/etcd.key --peer-client-cert-auth --peer-trusted-ca-file /opt/gaussdb/core/app/share/sslcert/etcd/etcdca.crt --peer-cert-file /opt/gaussdb/data/etcd/etcd.crt --peer-key-file /opt/gaussdb/data/etcd/etcd.key -initial-advertise-peer-urls https://192.168.0.149:31320 -listen-peer-urls https://192.168.0.149:31320 -listen-client-urls https://192.168.0.149:31300 -advertise-client-urls https://192.168.0.149:31300 --election-timeout 5000 --heartbeat-interval 1000 --log-outputs stdout --quota-backend-bytes 8589934592 --auto-compaction-mode periodic --auto-compaction-retention 1h -initial-cluster-token etcd-cluster-dbadmin --enable-v2=false -initial-cluster etcd_7001=https://192.168.0.165:31320,etcd_7002=https://192.168.0.140:31320,etcd_7003=https://192.168.0.149:31320 -initial-cluster-state new
dbadmin    50092   37666  9 08:12 ?        00:02:36 /opt/gaussdb/core/app/bin/cm_agent
dbadmin    50140       1  1 08:12 ?        00:00:19 /opt/gaussdb/core/app/bin/cm_server
dbadmin    50169       1 17 08:12 ?        00:05:03 /opt/gaussdb/core/app/bin/gaussdb -D /opt/gaussdb/data/dn/dn_6003 -M pending
dbadmin    50178       1  0 08:12 ?        00:00:00 gaussdb fenced UDF master process
service   107147   99601  1 08:23 ?        00:00:17 /opt/cloud/3rdComponent/jre/bin/java -Dnop -Djava.util.logging.manager=org.apache.logging.log4j.jul.LogManager -DAPP_NAME=gaussdb-console -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCDateStamps -Xloggc:/opt/cloud/gaussdb-console/logs/gc-20240401-162350.log -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/opt/cloud/gaussdb-console/logs/oom-20240401-162350.log -Dorg.quartz.scheduler.skipUpdateCheck=true -Duser.timezone=UTC -XX:-OmitStackTraceInFastThrow -Dorg.terracotta.quartz.skipUpdateCheck=true -Dnet.sf.ehcache.skipUpdateCheck=true -Dorg.apache.catalina.security.SecurityListener.UMASK=0077 -Dfastjson.parser.safeMode=true -Dzookeeper.clientCnxnSocket=org.apache.zookeeper.ClientCnxnSocketNIO -Djdk.tls.ephemeralDHKeySize=4096 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Dorg.apache.catalina.connector.RECYCLE_FACADES=true -Dfile.encoding=UTF-8 -Dorg.apache.catalina.STRICT_SERVLET_COMPLIANCE=false -server -Xss1m -Xms3000m -Xmx3000m -Xmn1500m -XX:SurvivorRatio=10 -XX:MaxTenuringThreshold=15 -XX:NewRatio=2 -XX:+DisableExplicitGC -Dignore.endorsed.dirs= -classpath /opt/cloud/gaussdb-console/bin/bootstrap.jar:/opt/cloud/gaussdb-console/lib/:/opt/cloud/gaussdb-console/server/:/opt/cloud/gaussdb-console/server/*:/opt/cloud/gaussdb-console/server/:/opt/cloud/gaussdb-console/server/*:/opt/cloud/gaussdb-console/bin/tomcat-juli.jar -Dcatalina.base=/opt/cloud/gaussdb-console -Dcatalina.home=/opt/cloud/gaussdb-console -Djava.io.tmpdir=/opt/cloud/gaussdb-console/temp org.apache.catalina.startup.Bootstrap start

*/

21.docker 进程查看 

--三个节点都是一样的。
[root@gaussdb003 ~]# docker ps -a
CONTAINER ID        IMAGE                                                  COMMAND             CREATED             STATUS              PORTS               NAMES
8aa93636c20d        gaussdb-backupmanager:2.23.07.260.20231223170622       "bash start.sh"     21 minutes ago      Up 20 minutes                           gaussdb-backupmanager2.23.07.260.20231223170622
b5adcab0cb82        gaussdb-instancemanager:2.23.07.260.20231226234230     "bash start.sh"     21 minutes ago      Up 21 minutes                           gaussdb-instancemanager2.23.07.260.20231226234230
a5b64fc06612        gaussdb-open-api:2.23.07.260.20231226232138.70780102   "bash start.sh"     21 minutes ago      Up 21 minutes                           gaussdb-open-api2.23.07.260.20231226232138.70780102
69af8b093fcc        ots:2.23.07.260.20231222133123.70415568                "bash start.sh"     21 minutes ago      Up 21 minutes                           ots2.23.07.260.20231222133123.70415568
f438b114984e        luban:2.23.07.260.20231226220440.70776246              "bash start.sh"     21 minutes ago      Up 21 minutes                           luban2.23.07.260.20231226220440.70776246
0ce56731fae6        gaussdb-console:2.23.07.260.70429885                   "bash start.sh"     21 minutes ago      Up 21 minutes                           gaussdb-console2.23.07.260.70429885
b4a671c03d28        auth:2.23.07.260.20231221153212.70313242               "bash start.sh"     21 minutes ago      Up 21 minutes                           auth2.23.07.260.20231221153212.70313242
cb966b1addb0        workflow:2.23.07.200.202309092109.61758876             "bash start.sh"     23 minutes ago      Up 23 minutes                           workflow2.23.07.200.202309092109.61758876
a5bd32566f2d        resource-manager:2.23.07.260.202311271720.68102008     "bash start.sh"     24 minutes ago      Up 23 minutes                           resource-manager2.23.07.260.202311271720.68102008
e9c3b7fd98d8        rds-ha-admin:2.23.07.260.202312112053.69373866         "bash start.sh"     24 minutes ago      Up 23 minutes                           rds-ha-admin2.23.07.260.202312112053.69373866
b4dd7a686670        monitor-service:2.23.07.260.202312211511.70310489      "bash start.sh"     24 minutes ago      Up 23 minutes                           monitor-service2.23.07.260.202312211511.70310489
c1592367b49e        common-service:2.23.07.260.202312261914.70760277       "bash start.sh"     24 minutes ago      Up 24 minutes                           common-service2.23.07.260.202312261914.70760277
b4e3f3e1a7ab        kafka:2.23.07.200.20230826182412                       "bash start.sh"     24 minutes ago      Up 24 minutes                           kafka2.23.07.200.20230826182412
d37530427ad8        zookeeper:2.23.07.200.20230826182412                   "bash start.sh"     25 minutes ago      Up 25 minutes                           zookeeper2.23.07.200.20230826182412


119.3.233.237 	192.168.0.165  第一台 gaussdb001
119.3.226.231   192.168.0.140  第二台 gaussdb002
114.116.242.223 192.168.0.149  第三台 gaussdb003
https://119.3.233.237:8443/gaussdb/#/login
https://119.3.226.231:8443/gaussdb/#/login
https://114.116.242.223:8443/gaussdb/#/login

22.由于是自动安装，无法找到密码，所以无法登录/

gsql -p 8635 -U rdsadmin -W  -d core -h 192.168.0.165


--docker方式安装后，不清楚端口是多少。目前无法登录。
[root@gaussdb001 om]# netstat -anp |grep gauss
tcp        0      0 192.168.0.165:8635      0.0.0.0:*               LISTEN      178732/gaussdb      
tcp        0      0 127.0.0.1:8635          0.0.0.0:*               LISTEN      178732/gaussdb      
tcp        0      0 192.168.0.165:8636      0.0.0.0:*               LISTEN      178732/gaussdb      
tcp        0      0 127.0.0.1:8636          0.0.0.0:*               LISTEN      178732/gaussdb      
tcp        0      0 192.168.0.165:8640      0.0.0.0:*               LISTEN      178732/gaussdb      

unix  2      [ ACC ]     STREAM     LISTENING     300719   169891/gaussdb fenc  /opt/gaussdb/temp/.gaussUDF.socket
unix  2      [ ACC ]     STREAM     LISTENING     322729   178732/gaussdb       /opt/gaussdb/temp/.s.PGSQL.8635
unix  2      [ ACC ]     STREAM     LISTENING     322730   178732/gaussdb       /opt/gaussdb/temp/.s.PGSQL.8636



[root@gaussdb001 dbadmin]# gsql -p 8635 -U rdsadmin -W"Huawei#321"  -d postgres -h 192.168.0.165
gsql: ERROR:  Invalid username/password,login denied.
ERROR:  Invalid username/password,login denied.


gsql -p 30180 -U root -W "Huawei#321" -d postgres -h 192.168.0.165

戒掉贪嗔痴(薛双奇)
关注
  • 3
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Gaussdb高斯数据库安装步骤
刘同学的博客
06-21 9858
1）下载wget https://www.python.org/ftp/python/3.6.6/Python-3.6.6.tgz。4）指定安装目录为/opt/python36./configure --prefix=/opt/python36。zctl.-py -t start -m nomount/mount #指定其他状态。OS版本检测，为了版本兼容性修改-1为-2，也可以直接把572，573直接注释掉。------这里python版本需要3.0至少，末尾附加安装python简易过程。
docker安装华为gaussdb数据库
奋斗的小鸟专栏
05-21 3321
docker镜像：这里我们使用docker hub镜像下载，该镜像下载较慢，可能有时访问不同，可以使用阿里云镜像下载，阿里云镜像配置参考《
Docker部署数据库--高斯DB(opengauss)
kft1314的博客
05-08 877
该参数设置了openGauss数据库的超级用户omm以及测试用户gaussdb的密码。openGauss安装时默认会创建omm超级用户，该用户名暂时无法修改。openGauss镜像配置了本地信任机制，因此在容器内连接数据库无需密码，但是如果要从容器外部（其它主机或者其它容器）连接则必须要输入密码。openGauss的密码有复杂度要求，需要：密码长度8个字符以上，必须同时包含英文字母，数字，以及特殊符号。下面操作，直接使用工具连接数据库，如果无法正常连接，执行下面操作。指定数据库端口，默认为5432。
[docker]快速构建gauss数据库
热门推荐
東₂₀₂₃²⁰²³
11-09 5万+
这里写目录标题镜像地址启动容器使用说明1. jdbc连接命令方式（omm用户） 镜像地址 搜索镜像 如果嫌弃https://hub.docker.com拉取镜像比较慢，可以去阿里或者网易的镜像站拉取 参见 常用docker镜像站 本次选用enmotech/opengauss 及 aff123/opengauss 作为测试 启动容器 启动容器没什么好说的，执行如下命令 docker run --name opengauss --privileged=true -d -e GS_PASSWORD=Gaus
利用docker轻松安装高斯数据库
heouheou的博客
05-21 2283
openGauss是一款开源的关系型数据库管理系统，它具有多核高性能、全链路安全性、智能运维等企业级特性。openGauss内核早期源自开源数据库PostgreSQL，融合了华为在数据库领域多年的内核经验，在架构、事务、存储引擎、优化器及ARM架构上进行了适配与优化。作为一个开源数据库，期望与广泛的开发者共同构建一个多元化技术的开源数据库社区。
使用Docker、navicat部署和连接GaussDB
yueyue763184的博客
03-02 2221
一般使用的连接用户gaussdb，密码是Bls@123456
华为云Docker/Kubernetes(k8s) 21天学习云计算容器 视频版
02-07
华为云Docker/Kubernetes(k8s) 21天学习云计算容器
云服务器 linux docker MongoDB安装文档
04-03
华为云服务器MongoDB安装文档
docker和docker-compose一键安装教程(支持在线和离线)
01-08
echo 检测到 Docker 已安装，跳过安装步骤 docker -v echo 启动 Docker service docker start 2>&1 | tee -a ${CURRENT_DIR}/install.log else if [[ -d $CURRENT_DIR/docker ]]; then echo ...
docker安装.doc
最新发布
05-08
Docker的安装步骤可以因操作系统而异，但一般来说，以下是Docker安装的一般性步骤（以Linux系统为例）： 前置条件 确保您的操作系统为64位版本且内核版本不低于3.10。 确保您拥有sudo权限，这将允许您在系统中安装...
华为云CCE集群升级方案及实施步骤
04-30
华为云CCE（Cloud Container Engine）是华为提供的企业级Kubernetes集群服务，旨在提供高度可扩展、高性能的容器化应用管理平台。当现有的CCE集群版本不再受华为云支持时，为了保持最佳的运行状态和技术支持，就需要...
基于DOCKER安装华为自研数据库高斯（GAUSS）
老码农的心路历程
11-29 4030
华为数据库裸机安装比较困难，我们可以采用docker的安装方式，自己学习和测试使用。 安装环境 1） centos 7.9 2） docker版本 opengauss 注意，我们在安装此镜像并运行的话，要把防火墙打开，无论打开与否，在centos7下可运行如下命令。 # systemctl restart firewalld 启动完毕，我们可以使用以下命令拉取镜像，并运行。运行之后，端口侦听在 5432，用户名为gaussdb,密码为设定的密码，当前为Enmo@123. 外包访问的端口也是54
ubuntu中如何用docker下载华为opengauss数据库(超简单)
haobabiu的博客
09-15 3408
openGauss是一款全面友好开放，携手伙伴共同打造的企业级开源关系型数据库。openGauss采用木兰宽松许可证v2发行，提供面向多核架构的极致性能、全链路的业务、数据安全、基于AI的调优和高效运维的能力。openGauss深度融合华为在数据库领域多年的研发经验，结合企业级场景需求，持续构建竞争力特性。同时，openGauss也是一个开源、免费的数据库平台，鼓励社区贡献、合作。OpenGauss安装可以选择以下二种方式。方式一。
华为openGauss高斯数据库安装--docker方式
jmshl的专栏
11-23 2873
openGauss是一款华为开源的关系型数据库管理系统，它具有多核高性能、全链路安全性、智能运维等企业级特性。openGauss内核早期源自开源数据库PostgreSQL，融合了华为在数据库领域多年的内核经验，在架构、事务、存储引擎、优化器及ARM架构上进行了适配与优化。作为一个开源数据库，期望与广泛的开发者共同构建一个多元化技术的开源数据库社区。
利用华为云服务器部署Docker
不负好时光
12-26 6800
1. 购买云服务器 这个不赘述，直接去官网购买https://www.huaweicloud.com/ 2.环境准备 以我个人经历为例，我买的是弹性云服务器ECS，买的时候是window 2008 server操作系统，用不惯。 第一步：切换centOS7.5 打开控制台，进入ECS详情 进入如下界面，先关机，再切换操作系统，之后按照步骤执行即可。 配置安全组 登录服务器 a）.使用华为...
Linux使用gaussDB数据库,docker配置openGauss数据库的方法详解
weixin_42625070的博客
05-05 1307
For Windows User在docker中使用openGauss拉取openGauss镜像在控制台输入docker pull enmotech/opengauss:latest等待下载中途可能会出现卡住的情况。可以按Ctrl+C之后重新运行拉取镜像的的指令。直到所有都显示Download complete如果实在是下载不了就给docker换个源打开C盘下的用户(或者User)文件夹–>...
docker拉取安装openGauss高斯数据库
u014200244的专栏
12-21 566
##拉取opengauss高斯数据库镜像docker pull enmotech/opengauss:3.0.0##docker运行opengauss高斯数据库docker run --name opengauss --privileged=true -p 17700:5432 -d -e GS_PASSWORD=Enmo@123 enmotech/opengauss:3.0.0##进入opengauss高斯数据库容器docker exec -it 26cebc11ce90 bash##切换到omm用户ro
华为云服务器安装Docker
计科小七的博客
11-07 1714
【代码】华为云服务器安装Docker
华为云centos7安装docker
09-22
华为云CentOS 7安装Docker的步骤如下： 1. 确保你的CentOS 7系统版本符合要求，需要为CentOS 7.0及以上的版本。 2. 首先，更新系统的软件包列表和已安装的软件包，可以使用以下命令： ``` sudo yum update ``` 3. 安装所需的依赖包，使用以下命令： ``` sudo yum install -y yum-utils device-mapper-persistent-data lvm2 ``` 4. 添加Docker的官方软件源，使用以下命令： ``` sudo yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo ``` 5. 安装最新版本的Docker Engine-Community，使用以下命令： ``` sudo yum install -y docker-ce docker-ce-cli containerd.io ``` 6. 启动Docker服务，并将其设置为开机自启，使用以下命令： ``` sudo systemctl start docker sudo systemctl enable docker ``` 7. 验证Docker是否正确安装并运行，可以使用以下命令查看Docker版本： ``` docker version ```

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值