安装openGauss极简版单节点和一主一备节点环境
Tags： openGauss一主一备单机单节点极简版高可用
👉 本文共约776个字，系统预计阅读时间或需3分钟。
在Docker中快速体验openGauss数据库：https://www.xmmup.com/zaidockerzhongkuaisutiyanopengaussshujuku.html
在CentOS7中安装openGauss数据库单机版：https://www.xmmup.com/zaicentos7zhonganzhuangopengaussshujukudanjiban.html
PG12高可用之1主2从流复制环境搭建及切换测试：https://www.xmmup.com/dbbao60pg12gaokeyongzhi1zhu2congliufuzhihuanjingdajianjiqiehuanceshi.html
参考：https://opengauss.org/zh/docs/2.1.0/docs/Quickstart/Quickstart.html
单节点安装
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
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 | docker rm -f lhropengausssimple docker run -d --name lhropengausssimple -h lhropengausssimple \ -p 35432-35439:5432-5439 -p 35632-35639:5632-5639 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/lhrcentos76:8.5 \ /usr/sbin/init docker exec -it lhropengausssimple bash cd /soft #close selinux sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config setenforce 0 #close firewalld systemctl stop firewalld && systemctl disable firewalld echo 'export LANG=en_US.UTF-8' >> /etc/profile cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime sysctl -w kernel.sem="250 85000 250 330" -- 创建用户和组 groupadd dbgrp useradd -g dbgrp -d /home/omm -m -s /bin/bash omm echo "lhr" | passwd --stdin omm ## 创建相关目录 mkdir /opengauss chgrp dbgrp -R /opengauss chmod 775 -R /opengauss ## 解压数据库安装包，85Mb wget https://opengauss.obs.cn-south-1.myhuaweicloud.com/2.1.0/x86/openGauss-2.1.0-CentOS-64bit.tar.bz2 tar -jxf openGauss-2.1.0-CentOS-64bit.tar.bz2 -C /opengauss chown -R omm:dbgrp /opengauss -- 单节点安装 su - omm cd /opengauss/simpleInstall sh install.sh -w lhr@123XXT -- 启动停止 gs_ctl start|stop|restart -D $GAUSSHOME/data/single_node -Z single_node gs_ctl status -D $GAUSSHOME/data/single_node -- 连接，-r表示可以使用上下左右键 gsql -d postgres -r # 环境变量，会自动写入 /home/omm/.bashrc export GAUSSHOME=/opengauss export PATH=$GAUSSHOME/bin:$PATH export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH export GS_CLUSTER_NAME=dbCluster ulimit -n 1000000 # 环境变量 echo "export PGDATA=$GAUSSHOME/data/single_node" >> /home/omm/.bashrc source /home/omm/.bashrc -- 配置远程访问 create database omm; alter system set password_policy=0; alter system set password_encryption_type=1; alter system set listen_addresses = '*'; echo "host all all 0.0.0.0/0 sha256" >> /opengauss/data/single_node/pg_hba.conf -- 重启 gs_ctl restart -- 新建用户 -- 初始化数据库的用户，是不能通过IP远程连接的，所以需要创建另外一个用户才能远程连接 # 创建用户(初始化数据库的用户不能进行远程连接，需要重新创建用户) create user lhr with password 'lhr' sysadmin ; grant all PRIVILEGES to lhr; -- 验证远程登录数据库 gsql -dpostgres -h172.17.0.6 -Ulhr -r -W'lhr' -- 远程连接 gsql -d postgres -U lhr -W'lhr' -h 192.168.66.35 -p35432 -r psql -d postgres -U lhr -h 192.168.66.35 -p35432 -- 解锁用户 alter user lhr account unlock; |
安装过程：
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 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 | [omm@lhropengausssimple bin]$ /opengauss/bin/gaussdb -V gaussdb (openGauss 2.1.0 build 590b0f8e) compiled at 2021-09-30 14:29:04 commit 0 last mr [omm@lhropengausssimple bin]$ [omm@lhropengausssimple bin]$ cd /opengauss/simpleInstall [omm@lhropengausssimple simpleInstall]$ sh install.sh -w lhr@123XXT [step 1]: check parameter [step 2]: check install env and os setting [step 3]: change_gausshome_owner [step 4]: set environment variables [step 6]: init datanode The files belonging to this database system will be owned by user "omm". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". creating directory /opengauss/data/single_node ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 32MB creating configuration files ... ok Begin init undo subsystem meta. [INIT UNDO] Init undo subsystem meta successfully. creating template1 database in /opengauss/data/single_node/base/1 ... The core dump path is an invalid directory 2021-10-24 09:57:56.002 [unknown] [unknown] localhost 140606630728640 0[0:0#0] [BACKEND] WARNING: macAddr is 578/2886795268, sysidentifier is 37923857/327574, randomNum is 1556938646 ok initializing pg_authid ... ok setting password ... ok initializing dependencies ... ok loading PL/pgSQL server-side language ... ok creating system views ... ok creating performance views ... ok loading system objects' descriptions ... ok creating collations ... ok creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok initialize global configure for bucketmap length ... ok creating information schema ... ok loading foreign-data wrapper for distfs access ... ok loading foreign-data wrapper for hdfs access ... ok loading foreign-data wrapper for log access ... ok loading hstore extension ... ok loading foreign-data wrapper for MOT access ... ok loading security plugin ... ok update system tables ... ok creating snapshots catalog ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok freezing database template0 ... ok freezing database template1 ... ok freezing database postgres ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run gs_initdb. Success. You can now start the database server of single node using: gaussdb -D /opengauss/data/single_node --single_node or gs_ctl start -D /opengauss/data/single_node -Z single_node -l logfile [step 7]: start datanode [2021-10-24 09:59:29.904][842][][gs_ctl]: gs_ctl started,datadir is /opengauss/data/single_node [2021-10-24 09:59:30.073][842][][gs_ctl]: waiting for server to start... .0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 0 LOG: [Alarm Module]Host Name: lhropengausssimple 0 LOG: [Alarm Module]Host IP: 172.17.0.4 0 LOG: [Alarm Module]Cluster Name: dbCluster 0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55 0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory. 0 WARNING: failed to parse feature control file: gaussdb.version. 0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version. The core dump path is an invalid directory 2021-10-24 09:59:30.416 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton. gaussdb.state does not exist, and skipt setting since it is optional.2021-10-24 09:59:30.416 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 2021-10-24 09:59:30.416 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: lhropengausssimple 2021-10-24 09:59:30.416 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 172.17.0.4 2021-10-24 09:59:30.416 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster 2021-10-24 09:59:30.416 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55 2021-10-24 09:59:30.452 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin" 2021-10-24 09:59:30.453 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets 2021-10-24 09:59:30.537 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] WARNING: No explicit IP is configured for listen_addresses GUC. 2021-10-24 09:59:30.537 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0. 2021-10-24 09:59:30.538 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB 2021-10-24 09:59:30.538 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB 2021-10-24 09:59:30.538 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 11069 MB 2021-10-24 09:59:30.538 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: shared memory 358 Mbytes, memory context 11417 Mbytes, max process memory 12288 Mbytes 2021-10-24 09:59:30.626 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184) 2021-10-24 09:59:30.664 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728) 2021-10-24 09:59:30.738 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512 2021-10-24 09:59:30.827 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/opengauss/data/single_node/gaussdb.state.temp" success 2021-10-24 09:59:30.827 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal) 2021-10-24 09:59:30.857 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 979, usable_fds = 1000, already_open = 11 The core dump path is an invalid directory 2021-10-24 09:59:30.860 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created. 2021-10-24 09:59:30.871 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: the configure file /opengauss/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user! 2021-10-24 09:59:30.871 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file. 2021-10-24 09:59:30.910 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2021-10-24 09:59:30.910 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2021-10-24 09:59:30.910 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2021-10-24 09:59:30.910 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. 2021-10-24 09:59:30.913 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2021-10-24 09:59:30.913 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2021-10-24 09:59:30.913 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2021-10-24 09:59:30.913 [unknown] [unknown] localhost 140607086257088 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. . [2021-10-24 09:59:32.130][842][][gs_ctl]: done [2021-10-24 09:59:32.130][842][][gs_ctl]: server started (/opengauss/data/single_node) import sql file Would you like to create a demo database (yes/no)? YES Please type 'yes' or 'no': yes Load demoDB [school,finance] success. [complete successfully]: You can start or stop the database server using: gs_ctl start|stop|restart -D $GAUSSHOME/data/single_node -Z single_node [omm@lhropengausssimple simpleInstall]$ gs_ctl status -D $GAUSSHOME/data/single_node [2021-10-25 16:10:28.173][1117][][gs_ctl]: gs_ctl status,datadir is /opengauss/data/single_node gs_ctl: server is running (PID: 706) /opengauss/bin/gaussdb "-D" "/opengauss/data/single_node" [omm@lhropengausssimple simpleInstall]$ pwd /opengauss/simpleInstall [omm@lhropengausssimple simpleInstall]$ ll total 64 -rw-r--r-- 1 omm dbgrp 10883 Sep 30 14:39 finance.sql -rw-r--r-- 1 omm dbgrp 12842 Sep 30 14:39 install.sh -rw-r--r-- 1 omm dbgrp 4491 Oct 24 09:59 load.log -rw-r--r-- 1 omm dbgrp 5167 Sep 30 14:39 README.md -rw-r--r-- 1 omm dbgrp 19926 Sep 30 14:39 school.sql [omm@lhropengausssimple simpleInstall]$ cd .. [omm@lhropengausssimple opengauss]$ ll total 40 drwxr-xr-x 3 omm dbgrp 4096 Sep 30 14:39 bin drwx------ 3 omm dbgrp 4096 Oct 24 09:57 data drwxr-xr-x 3 omm dbgrp 4096 Sep 30 14:39 etc drwxr-xr-x 3 omm dbgrp 4096 Sep 30 14:39 include drwxr-xr-x 4 omm dbgrp 4096 Sep 30 14:39 jre drwxr-xr-x 5 omm dbgrp 4096 Sep 30 14:39 lib drwx------ 2 omm dbgrp 4096 Oct 24 09:59 logs drwxr-xr-x 5 omm dbgrp 4096 Sep 30 14:39 share drwxr-xr-x 2 omm dbgrp 4096 Oct 24 09:59 simpleInstall -rw-r--r-- 1 omm dbgrp 32 Sep 30 14:39 version.cfg [omm@lhropengausssimple opengauss]$ ps -ef|grep omm root 414 19 0 09:55 pts/0 00:00:00 su - omm omm 415 414 0 09:55 pts/0 00:00:00 -bash omm 845 0 4 09:59 pts/0 00:00:02 /opengauss/bin/gaussdb -D /opengauss/data/single_node omm 973 415 0 10:00 pts/0 00:00:00 ps -ef omm 974 415 0 10:00 pts/0 00:00:00 grep --color=auto omm [omm@lhropengausssimple opengauss]$ cd bin [omm@lhropengausssimple bin]$ ./gsql gsql: FATAL: database "omm" does not exist [omm@lhropengausssimple bin]$ ./gsql -d postgres gsql ((openGauss 2.1.0 build 590b0f8e) compiled at 2021-09-30 14:29:04 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. openGauss=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+-------------+-------------+------------------- finance | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | school | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/omm + | | | | | omm=CTc/omm template1 | omm | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/omm + | | | | | omm=CTc/omm (5 rows) openGauss=# C:\Users\lhrxxt>psql -d postgres -U lhr -h 192.168.66.35 -p35432 Password for user lhr: psql (14.0, server 9.2.4) Type "help" for help. postgres=> \du List of roles Role name | Attributes | Member of ------------------------+------------------------------------------------+----------- gs_role_account_lock | Cannot login | {} gs_role_copy_files | Cannot login | {} gs_role_pldebugger | Cannot login | {} gs_role_replication | Cannot login | {} gs_role_signal_backend | Cannot login | {} gs_role_tablespace | Cannot login | {} lhr | | {} omm | Superuser, Create role, Create DB, Replication | {} |
一主一备安装
部署一主一备环境
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 | -- 安装一主一备节点（之前的配置和单节点一样） su - omm cd /opengauss/simpleInstall sh install.sh -w lhr@123XXT --multinode -p 5434 -- 启动停止 primary: gs_ctl start|stop|restart -D $GAUSSHOME/data/master -M primary standby: gs_ctl start|stop|restart -D $GAUSSHOME/data/slave -M standby -- 连接，-r表示可以使用上下左右键 gsql -d postgres -r -- 修改参数文件 -- master alter system set replconninfo1 = 'localhost=127.0.0.1 localport=5435 localheartbeatport=5439 localservice=5438 remotehost=127.0.0.1 remoteport=5635 remoteheartbeatport=5639 remoteservice=5638'; -- slave alter system set replconninfo1 = 'localhost=127.0.0.1 localport=5635 localheartbeatport=5639 localservice=5638 remotehost=127.0.0.1 remoteport=5435 remoteheartbeatport=5439 remoteservice=5438'; # 环境变量 cat >> /home/omm/.bashrc <"EOF" export GAUSSHOME=/opengauss export PATH=$GAUSSHOME/bin:$PATH export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH export GS_CLUSTER_NAME=dbCluster ulimit -n 1000000 EOF source /home/omm/.bashrc -- 配置远程访问 gsql -d postgres -p 5434 gsql -d postgres -p 5634 -- f 为主，t为备 select pg_is_in_recovery(); create database omm; alter system set password_policy=0; alter system set password_encryption_type=1; alter system set listen_addresses = '*'; echo "host all all 0.0.0.0/0 sha256" >> /opengauss/data/master/pg_hba.conf echo "host all all 0.0.0.0/0 sha256" >> /opengauss/data/slave/pg_hba.conf -- 重启（必须带-M参数，否则主备关系破坏） gs_ctl restart -D /opengauss/data/master/ -M primary gs_ctl restart -D /opengauss/data/slave/ -M standby -- 查询主备关系 gs_ctl query -D /opengauss/data/master select * from pg_stat_replication; select pg_is_in_recovery(); -- 新建用户 -- 初始化数据库的用户，是不能通过IP远程连接的，所以需要创建另外一个用户才能远程连接 gsql -p 5434 # 创建用户(初始化数据库的用户不能进行远程连接，需要重新创建用户) create user lhr with password 'lhr' sysadmin ; grant all PRIVILEGES to lhr; -- 验证远程登录数据库 gsql -dpostgres -h172.17.0.7 -Ulhr -r -W'lhr' -- 远程连接 gsql -d postgres -U lhr -W'lhr' -h 192.168.66.35 -p35434 -r psql -d postgres -U lhr -h 192.168.66.35 -p35434 -- 解锁用户 alter user lhr account unlock; -- 重新构建主备关系 gs_ctl build -D /opengauss/data/slave -b full -M standby |
安装过程：
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 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 | [omm@lhropengausssimple simpleInstall]$ sh install.sh -w lhr@123XXT --multinode -h Usage: sh install.sh -w password Arguments: -w login password -p datanode port, default 5432 --multinode if specify, will install master_slave cluster. default install single node. -h, --help Show this help, then exit [omm@lhropengausssimple simpleInstall]$ sh install.sh -w lhr@123XXT --multinode -p 5434 [step 1]: check parameter [step 2]: check install env and os setting [step 3]: change_gausshome_owner [step 4]: set environment variables [init primary datanode.] The files belonging to this database system will be owned by user "omm". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default text search configuration will be set to "english". creating directory /opengauss/data/master ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 32MB creating configuration files ... ok Begin init undo subsystem meta. [INIT UNDO] Init undo subsystem meta successfully. creating template1 database in /opengauss/data/master/base/1 ... The core dump path is an invalid directory 2022-01-07 09:41:45.881 [unknown] [unknown] localhost 139774232949696 0[0:0#0] [BACKEND] WARNING: macAddr is 578/2886795271, sysidentifier is 37923857/519835, randomNum is 3146509979 ok initializing pg_authid ... ok setting password ... ok initializing dependencies ... ok loading PL/pgSQL server-side language ... ok creating system views ... ok creating performance views ... ok loading system objects' descriptions ... ok creating collations ... ok creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok initialize global configure for bucketmap length ... ok creating information schema ... ok loading foreign-data wrapper for distfs access ... ok loading foreign-data wrapper for hdfs access ... ok loading foreign-data wrapper for log access ... ok loading hstore extension ... ok loading foreign-data wrapper for MOT access ... ok loading security plugin ... ok update system tables ... ok creating snapshots catalog ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok freezing database template0 ... ok freezing database template1 ... ok freezing database postgres ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run gs_initdb. Success. You can now start the database server of single node using: gaussdb -D /opengauss/data/master --single_node or gs_ctl start -D /opengauss/data/master -Z single_node -l logfile [init slave datanode.] The files belonging to this database system will be owned by user "omm". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default text search configuration will be set to "english". creating directory /opengauss/data/slave ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 32MB creating configuration files ... ok Begin init undo subsystem meta. [INIT UNDO] Init undo subsystem meta successfully. creating template1 database in /opengauss/data/slave/base/1 ... The core dump path is an invalid directory 2022-01-07 09:43:56.685 [unknown] [unknown] localhost 140253729342400 0[0:0#0] [BACKEND] WARNING: macAddr is 578/2886795271, sysidentifier is 37923857/509740, randomNum is 3351758636 ok initializing pg_authid ... ok setting password ... ok initializing dependencies ... ok loading PL/pgSQL server-side language ... ok creating system views ... ok creating performance views ... ok loading system objects' descriptions ... ok creating collations ... ok creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok initialize global configure for bucketmap length ... ok creating information schema ... ok loading foreign-data wrapper for distfs access ... ok loading foreign-data wrapper for hdfs access ... ok loading foreign-data wrapper for log access ... ok loading hstore extension ... ok loading foreign-data wrapper for MOT access ... ok loading security plugin ... ok update system tables ... ok creating snapshots catalog ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok freezing database template0 ... ok freezing database template1 ... ok freezing database postgres ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run gs_initdb. Success. You can now start the database server of single node using: gaussdb -D /opengauss/data/slave --single_node or gs_ctl start -D /opengauss/data/slave -Z single_node -l logfile [config datanode.] remote_read_mode = non_authentication host all all 172.17.0.7/32 trust [start primary datanode.] [2022-01-07 09:46:01.989][3115][][gs_ctl]: gs_ctl started,datadir is /opengauss/data/master [2022-01-07 09:46:02.172][3115][][gs_ctl]: waiting for server to start... .0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 0 LOG: [Alarm Module]Host Name: lhropengausssimple 0 LOG: [Alarm Module]Host IP: 172.17.0.7 0 LOG: [Alarm Module]Cluster Name: dbCluster 0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55 0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory. 0 WARNING: failed to parse feature control file: gaussdb.version. 0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version. The core dump path is an invalid directory 2022-01-07 09:46:02.543 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton. gaussdb.state does not exist, and skipt setting since it is optional.2022-01-07 09:46:02.543 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 2022-01-07 09:46:02.543 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: lhropengausssimple 2022-01-07 09:46:02.543 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 172.17.0.7 2022-01-07 09:46:02.543 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster 2022-01-07 09:46:02.543 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55 2022-01-07 09:46:02.594 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin" 2022-01-07 09:46:02.739 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0. 2022-01-07 09:46:02.740 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB 2022-01-07 09:46:02.740 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB 2022-01-07 09:46:02.740 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 11069 MB 2022-01-07 09:46:02.740 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: shared memory 358 Mbytes, memory context 11417 Mbytes, max process memory 12288 Mbytes 2022-01-07 09:46:02.992 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184) 2022-01-07 09:46:03.033 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728) 2022-01-07 09:46:03.164 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512 2022-01-07 09:46:03.248 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/opengauss/data/master/gaussdb.state.temp" success 2022-01-07 09:46:03.248 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Primary) 2022-01-07 09:46:03.284 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 977, usable_fds = 1000, already_open = 13 The core dump path is an invalid directory 2022-01-07 09:46:03.288 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created. 2022-01-07 09:46:03.298 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: the configure file /opengauss/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user! 2022-01-07 09:46:03.298 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file. 2022-01-07 09:46:03.350 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2022-01-07 09:46:03.350 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2022-01-07 09:46:03.350 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2022-01-07 09:46:03.350 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. 2022-01-07 09:46:03.353 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2022-01-07 09:46:03.353 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2022-01-07 09:46:03.353 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2022-01-07 09:46:03.353 [unknown] [unknown] localhost 140344290526144 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. . [2022-01-07 09:46:04.375][3115][][gs_ctl]: done [2022-01-07 09:46:04.375][3115][][gs_ctl]: server started (/opengauss/data/master) [build and start slave datanode.] [2022-01-07 09:46:04.396][3182][][gs_ctl]: gs_ctl full build ,datadir is /opengauss/data/slave [2022-01-07 09:46:04.396][3182][][gs_ctl]: stop failed, killing gaussdb by force ... [2022-01-07 09:46:04.396][3182][][gs_ctl]: command [ps c -eo pid,euid,cmd | grep gaussdb | grep -v grep | awk '{if($2 == curuid && $1!="-n") print "/proc/"$1"/cwd"}' curuid=`id -u`| xargs ls -l | awk '{if ($NF=="/opengauss/data/slave") print $(NF-2)}' | awk -F/ '{print $3 }' | xargs kill -9 >/dev/null 2>&1 ] path: [/opengauss/data/slave] [2022-01-07 09:46:04.419][3182][][gs_ctl]: server stopped [2022-01-07 09:46:04.419][3182][][gs_ctl]: current workdir is (/opengauss/simpleInstall). [2022-01-07 09:46:04.420][3182][][gs_ctl]: fopen build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 09:46:04.420][3182][][gs_ctl]: fprintf build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 09:46:04.440][3182][][gs_ctl]: fsync build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 09:46:04.441][3182][][gs_ctl]: set gaussdb state file when full build:db state(BUILDING_STATE), server mode(STANDBY_MODE), build mode(FULL_BUILD). [2022-01-07 09:46:04.452][3182][datanode2][gs_ctl]: connect to server success, build started. [2022-01-07 09:46:04.452][3182][datanode2][gs_ctl]: create build tag file success [2022-01-07 09:46:04.548][3182][datanode2][gs_ctl]: clear old target dir success [2022-01-07 09:46:04.548][3182][datanode2][gs_ctl]: create build tag file again success [2022-01-07 09:46:04.549][3182][datanode2][gs_ctl]: get system identifier success [2022-01-07 09:46:04.549][3182][datanode2][gs_ctl]: receiving and unpacking files... [2022-01-07 09:46:04.549][3182][datanode2][gs_ctl]: create backup label success INFO: The starting position of the xlog copy of the full build is: 0/2149080. The slot minimum LSN is: 0/0. [2022-01-07 09:46:04.825][3182][datanode2][gs_ctl]: xlog start point: 0/2149080 [2022-01-07 09:46:04.826][3182][datanode2][gs_ctl]: begin build tablespace list [2022-01-07 09:46:04.826][3182][datanode2][gs_ctl]: finish build tablespace list [2022-01-07 09:46:04.826][3182][datanode2][gs_ctl]: begin get xlog by xlogstream [2022-01-07 09:46:04.826][3182][datanode2][gs_ctl]: starting background WAL receiver [2022-01-07 09:46:04.826][3182][datanode2][gs_ctl]: starting walreceiver [2022-01-07 09:46:04.826][3182][datanode2][gs_ctl]: begin receive tar files [2022-01-07 09:46:04.827][3182][datanode2][gs_ctl]: receiving and unpacking files... [2022-01-07 09:46:04.834][3182][datanode2][gs_ctl]: check identify system success [2022-01-07 09:46:04.834][3182][datanode2][gs_ctl]: send START_REPLICATION 0/2000000 success [2022-01-07 09:46:08.168][3182][datanode2][gs_ctl]: finish receive tar files [2022-01-07 09:46:08.168][3182][datanode2][gs_ctl]: xlog end point: 0/3000058 [2022-01-07 09:46:08.169][3182][datanode2][gs_ctl]: fetching MOT checkpoint gs_ctl: no mot checkpoint exists [2022-01-07 09:46:08.169][3182][datanode2][gs_ctl]: waiting for background process to finish streaming... [2022-01-07 09:46:09.875][3182][datanode2][gs_ctl]: starting fsync all files come from source. [2022-01-07 09:46:41.906][3182][datanode2][gs_ctl]: finish fsync all files. [2022-01-07 09:46:41.931][3182][datanode2][gs_ctl]: build dummy dw file success [2022-01-07 09:46:41.931][3182][datanode2][gs_ctl]: rename build status file success [2022-01-07 09:46:41.938][3182][datanode2][gs_ctl]: build completed(/opengauss/data/slave). [2022-01-07 09:46:42.128][3182][datanode2][gs_ctl]: waiting for server to start... .0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 0 LOG: [Alarm Module]Host Name: lhropengausssimple 0 LOG: [Alarm Module]Host IP: 172.17.0.7 0 LOG: [Alarm Module]Cluster Name: dbCluster 0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55 0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory. 0 WARNING: failed to parse feature control file: gaussdb.version. 0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version. The core dump path is an invalid directory 2022-01-07 09:46:42.490 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton. 2022-01-07 09:46:42.491 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 2022-01-07 09:46:42.491 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: lhropengausssimple 2022-01-07 09:46:42.491 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 172.17.0.7 2022-01-07 09:46:42.491 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster 2022-01-07 09:46:42.491 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55 2022-01-07 09:46:42.560 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin" 2022-01-07 09:46:42.679 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0. 2022-01-07 09:46:42.679 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB 2022-01-07 09:46:42.679 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB 2022-01-07 09:46:42.679 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 11069 MB 2022-01-07 09:46:42.679 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: shared memory 358 Mbytes, memory context 11417 Mbytes, max process memory 12288 Mbytes 2022-01-07 09:46:42.837 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184) 2022-01-07 09:46:42.877 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728) 2022-01-07 09:46:42.953 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512 2022-01-07 09:46:43.048 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/opengauss/data/slave/gaussdb.state.temp" success 2022-01-07 09:46:43.048 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Standby) 2022-01-07 09:46:43.088 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 975, usable_fds = 1000, already_open = 15 The core dump path is an invalid directory 2022-01-07 09:46:43.096 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: the configure file /opengauss/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user! 2022-01-07 09:46:43.096 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file. 2022-01-07 09:46:43.139 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2022-01-07 09:46:43.139 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2022-01-07 09:46:43.139 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2022-01-07 09:46:43.139 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. 2022-01-07 09:46:43.142 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2022-01-07 09:46:43.142 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2022-01-07 09:46:43.142 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2022-01-07 09:46:43.142 [unknown] [unknown] localhost 140521043760064 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. .......... [2022-01-07 09:46:53.189][3182][datanode2][gs_ctl]: done [2022-01-07 09:46:53.189][3182][datanode2][gs_ctl]: server started (/opengauss/data/slave) [2022-01-07 09:46:53.189][3182][datanode2][gs_ctl]: fopen build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 09:46:53.189][3182][datanode2][gs_ctl]: fprintf build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 09:46:53.259][3182][datanode2][gs_ctl]: fsync build pid file "/opengauss/data/slave/gs_build.pid" success import sql file Would you like to create a demo database (yes/no)? yes Load demoDB [school,finance] success. [complete successfully]: You can start or stop the database server using: primary: gs_ctl start|stop|restart -D $GAUSSHOME/data/master -M primary standby: gs_ctl start|stop|restart -D $GAUSSHOME/data/slave -M standby |
查询主备关系
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 | [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/master [2022-01-07 10:48:22.065][12294][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/master HA state: local_role : Primary static_connections : 1 db_state : Normal detail_information : Normal Senders info: sender_pid : 11825 local_role : Primary peer_role : Standby peer_state : Normal state : Streaming sender_sent_location : 0/6000CF0 sender_write_location : 0/6000CF0 sender_flush_location : 0/6000CF0 sender_replay_location : 0/6000CF0 receiver_received_location : 0/6000CF0 receiver_write_location : 0/6000CF0 receiver_flush_location : 0/6000CF0 receiver_replay_location : 0/6000CF0 sync_percent : 100% sync_state : Sync sync_priority : 1 sync_most_available : Off channel : 127.0.0.1:5435-->127.0.0.1:50000 Receiver info: No information [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/slave [2022-01-07 10:48:26.782][12303][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/slave HA state: local_role : Standby static_connections : 1 db_state : Normal detail_information : Normal Senders info: No information Receiver info: receiver_pid : 11824 local_role : Standby peer_role : Primary peer_state : Normal state : Normal sender_sent_location : 0/6000CF0 sender_write_location : 0/6000CF0 sender_flush_location : 0/6000CF0 sender_replay_location : 0/6000CF0 receiver_received_location : 0/6000CF0 receiver_write_location : 0/6000CF0 receiver_flush_location : 0/6000CF0 receiver_replay_location : 0/6000CF0 sync_percent : 100% channel : 127.0.0.1:50000<--127.0.0.1:5435 [omm@lhropengausssimple ~]$ gsql -p 5434 gsql ((openGauss 2.1.0 build 590b0f8e) compiled at 2021-09-30 14:29:04 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. omm=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- f (1 row) postgres=> \x Expanded display is on. postgres=> select * from pg_stat_replication; -[ RECORD 1 ]------------+---------------------------------- pid | 140431925966592 usesysid | 10 usename | omm application_name | WalSender to Standby[walreceiver] client_addr | 127.0.0.1 client_hostname | client_port | 50000 backend_start | 2022-01-07 10:40:53.514293+08 state | Streaming sender_sent_location | 0/6000268 receiver_write_location | 0/6000268 receiver_flush_location | 0/6000268 receiver_replay_location | 0/6000268 sync_priority | 1 sync_state | Sync [omm@lhropengausssimple slave]$ gsql -p 5634 gsql ((openGauss 2.1.0 build 590b0f8e) compiled at 2021-09-30 14:29:04 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. omm=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row) |
主从切换
主从Switchover切换
在备机做切换：
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 | [omm@lhropengausssimple ~]$ gs_ctl switchover -D /opengauss/data/slave/ [2022-01-07 11:21:22.238][16834][][gs_ctl]: gs_ctl switchover ,datadir is /opengauss/data/slave [2022-01-07 11:21:22.239][16834][][gs_ctl]: switchover term (1) [2022-01-07 11:21:22.252][16834][][gs_ctl]: waiting for server to switchover.............. [2022-01-07 11:21:33.593][16834][][gs_ctl]: done [2022-01-07 11:21:33.593][16834][][gs_ctl]: switchover completed (/opengauss/data/slave) [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/master [2022-01-07 11:22:10.434][16926][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/master HA state: local_role : Standby static_connections : 1 db_state : Normal detail_information : Normal Senders info: No information Receiver info: receiver_pid : 16882 local_role : Standby peer_role : Primary peer_state : Normal state : Normal sender_sent_location : 0/6005408 sender_write_location : 0/6005408 sender_flush_location : 0/6005408 sender_replay_location : 0/6005408 receiver_received_location : 0/6005408 receiver_write_location : 0/6005408 receiver_flush_location : 0/6005408 receiver_replay_location : 0/6005408 sync_percent : 100% channel : 127.0.0.1:50120<--127.0.0.1:5635 [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/slave/ [2022-01-07 11:22:19.877][16940][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/slave HA state: local_role : Primary static_connections : 1 db_state : Normal detail_information : Normal Senders info: sender_pid : 16883 local_role : Primary peer_role : Standby peer_state : Normal state : Streaming sender_sent_location : 0/6005408 sender_write_location : 0/6005408 sender_flush_location : 0/6005408 sender_replay_location : 0/6005408 receiver_received_location : 0/6005408 receiver_write_location : 0/6005408 receiver_flush_location : 0/6005408 receiver_replay_location : 0/6005408 sync_percent : 100% sync_state : Sync sync_priority : 1 sync_most_available : Off channel : 127.0.0.1:5635-->127.0.0.1:50120 Receiver info: No information |
主从Failover切换
在备机操作：
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 | [omm@lhropengausssimple ~]$ gs_ctl failover -D /opengauss/data/master/ [2022-01-07 11:25:04.187][17134][][gs_ctl]: gs_ctl failover ,datadir is /opengauss/data/master [2022-01-07 11:25:04.188][17134][][gs_ctl]: failover term (1) [2022-01-07 11:25:04.200][17134][][gs_ctl]: waiting for server to failover... .[2022-01-07 11:25:05.232][17134][][gs_ctl]: done [2022-01-07 11:25:05.232][17134][][gs_ctl]: failover completed (/opengauss/data/master) [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/slave/ [2022-01-07 11:25:21.319][17169][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/slave HA state: local_role : Primary static_connections : 1 db_state : Normal detail_information : Normal Senders info: No information Receiver info: No information [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/master/ [2022-01-07 11:25:28.813][17180][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/master HA state: local_role : Primary static_connections : 1 db_state : Normal detail_information : Normal Senders info: No information Receiver info: No information -- 由于slave已经为异常库，所以，这里重启slave库 gs_ctl restart -D /opengauss/data/slave/ -M standby [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/slave/ [2022-01-07 11:27:30.297][17740][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/slave HA state: local_role : Standby static_connections : 1 db_state : Need repair detail_information : WAL segment removed Senders info: No information Receiver info: No information |
可见，现在为2个主库，重启“slave”之后，“slave”为standby，对于“slave”应该为备库，所以，这里只能重建：
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 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 | -- 重新构建主备关系 gs_ctl build -D /opengauss/data/slave -b full -M standby [omm@lhropengausssimple ~]$ gs_ctl build -D /opengauss/data/slave -b full -M standby [2022-01-07 11:29:30.081][19353][][gs_ctl]: gs_ctl full build ,datadir is /opengauss/data/slave waiting for server to shut down.... done server stopped [2022-01-07 11:29:31.109][19353][][gs_ctl]: current workdir is (/home/omm). [2022-01-07 11:29:31.109][19353][][gs_ctl]: fopen build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 11:29:31.109][19353][][gs_ctl]: fprintf build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 11:29:31.129][19353][][gs_ctl]: fsync build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 11:29:31.130][19353][][gs_ctl]: set gaussdb state file when full build:db state(BUILDING_STATE), server mode(STANDBY_MODE), build mode(FULL_BUILD). [2022-01-07 11:29:31.140][19353][datanode1][gs_ctl]: connect to server success, build started. [2022-01-07 11:29:31.140][19353][datanode1][gs_ctl]: create build tag file success [2022-01-07 11:29:31.390][19353][datanode1][gs_ctl]: clear old target dir success [2022-01-07 11:29:31.390][19353][datanode1][gs_ctl]: create build tag file again success [2022-01-07 11:29:31.390][19353][datanode1][gs_ctl]: get system identifier success [2022-01-07 11:29:31.391][19353][datanode1][gs_ctl]: receiving and unpacking files... [2022-01-07 11:29:31.391][19353][datanode1][gs_ctl]: create backup label success INFO: The starting position of the xlog copy of the full build is: 0/403BDC8. The slot minimum LSN is: 0/403BDC8. [2022-01-07 11:29:31.652][19353][datanode1][gs_ctl]: xlog start point: 0/403BDC8 [2022-01-07 11:29:31.652][19353][datanode1][gs_ctl]: begin build tablespace list [2022-01-07 11:29:31.652][19353][datanode1][gs_ctl]: finish build tablespace list [2022-01-07 11:29:31.652][19353][datanode1][gs_ctl]: begin get xlog by xlogstream [2022-01-07 11:29:31.652][19353][datanode1][gs_ctl]: starting background WAL receiver [2022-01-07 11:29:31.652][19353][datanode1][gs_ctl]: starting walreceiver [2022-01-07 11:29:31.652][19353][datanode1][gs_ctl]: begin receive tar files [2022-01-07 11:29:31.653][19353][datanode1][gs_ctl]: receiving and unpacking files... [2022-01-07 11:29:31.660][19353][datanode1][gs_ctl]: check identify system success [2022-01-07 11:29:31.661][19353][datanode1][gs_ctl]: send START_REPLICATION 0/4000000 success [2022-01-07 11:29:34.015][19353][datanode1][gs_ctl]: finish receive tar files [2022-01-07 11:29:34.015][19353][datanode1][gs_ctl]: xlog end point: 0/7000058 [2022-01-07 11:29:34.016][19353][datanode1][gs_ctl]: fetching MOT checkpoint gs_ctl: no mot checkpoint exists [2022-01-07 11:29:34.017][19353][datanode1][gs_ctl]: waiting for background process to finish streaming... [2022-01-07 11:29:36.717][19353][datanode1][gs_ctl]: starting fsync all files come from source. [2022-01-07 11:30:06.777][19353][datanode1][gs_ctl]: finish fsync all files. [2022-01-07 11:30:06.847][19353][datanode1][gs_ctl]: build dummy dw file success [2022-01-07 11:30:06.847][19353][datanode1][gs_ctl]: rename build status file success [2022-01-07 11:30:06.869][19353][datanode1][gs_ctl]: build completed(/opengauss/data/slave). [2022-01-07 11:30:07.071][19353][datanode1][gs_ctl]: waiting for server to start... .0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 0 LOG: [Alarm Module]Host Name: lhropengausssimple 0 LOG: [Alarm Module]Host IP: 172.17.0.7 0 LOG: [Alarm Module]Cluster Name: dbCluster 0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55 0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory. 0 WARNING: failed to parse feature control file: gaussdb.version. 0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version. The core dump path is an invalid directory 2022-01-07 11:30:07.396 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton. 2022-01-07 11:30:07.396 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 2022-01-07 11:30:07.396 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: lhropengausssimple 2022-01-07 11:30:07.396 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 172.17.0.7 2022-01-07 11:30:07.396 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster 2022-01-07 11:30:07.397 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55 2022-01-07 11:30:07.464 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin" 2022-01-07 11:30:07.614 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] WARNING: No explicit IP is configured for listen_addresses GUC. 2022-01-07 11:30:07.614 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0. 2022-01-07 11:30:07.614 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB 2022-01-07 11:30:07.614 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB 2022-01-07 11:30:07.614 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 11069 MB 2022-01-07 11:30:07.614 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: shared memory 358 Mbytes, memory context 11417 Mbytes, max process memory 12288 Mbytes 2022-01-07 11:30:07.696 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184) 2022-01-07 11:30:07.727 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728) 2022-01-07 11:30:07.785 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512 2022-01-07 11:30:07.861 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/opengauss/data/slave/gaussdb.state.temp" success 2022-01-07 11:30:07.861 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Standby) 2022-01-07 11:30:07.911 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 975, usable_fds = 1000, already_open = 15 The core dump path is an invalid directory 2022-01-07 11:30:07.917 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: the configure file /opengauss/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user! 2022-01-07 11:30:07.917 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file. 2022-01-07 11:30:07.959 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2022-01-07 11:30:07.959 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2022-01-07 11:30:07.959 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2022-01-07 11:30:07.959 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. 2022-01-07 11:30:07.965 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2022-01-07 11:30:07.965 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2022-01-07 11:30:07.965 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2022-01-07 11:30:07.965 [unknown] [unknown] localhost 140319055131584 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. ........... [2022-01-07 11:30:19.120][19353][datanode1][gs_ctl]: done [2022-01-07 11:30:19.120][19353][datanode1][gs_ctl]: server started (/opengauss/data/slave) [2022-01-07 11:30:19.120][19353][datanode1][gs_ctl]: fopen build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 11:30:19.120][19353][datanode1][gs_ctl]: fprintf build pid file "/opengauss/data/slave/gs_build.pid" success [2022-01-07 11:30:19.145][19353][datanode1][gs_ctl]: fsync build pid file "/opengauss/data/slave/gs_build.pid" success [omm@lhropengausssimple ~]$ [omm@lhropengausssimple ~]$ [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/slave/ [2022-01-07 11:30:34.278][19488][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/slave HA state: local_role : Standby static_connections : 1 db_state : Normal detail_information : Normal Senders info: No information Receiver info: receiver_pid : 19472 local_role : Standby peer_role : Primary peer_state : Normal state : Normal sender_sent_location : 0/8000148 sender_write_location : 0/8000148 sender_flush_location : 0/8000148 sender_replay_location : 0/8000148 receiver_received_location : 0/8000148 receiver_write_location : 0/8000148 receiver_flush_location : 0/8000148 receiver_replay_location : 0/8000148 sync_percent : 100% channel : 127.0.0.1:39592<--127.0.0.1:5435 [omm@lhropengausssimple ~]$ gs_ctl query -D /opengauss/data/master [2022-01-07 11:30:38.960][19497][][gs_ctl]: gs_ctl query ,datadir is /opengauss/data/master HA state: local_role : Primary static_connections : 1 db_state : Normal detail_information : Normal Senders info: sender_pid : 19473 local_role : Primary peer_role : Standby peer_state : Normal state : Streaming sender_sent_location : 0/8000148 sender_write_location : 0/8000148 sender_flush_location : 0/8000148 sender_replay_location : 0/8000148 receiver_received_location : 0/8000148 receiver_write_location : 0/8000148 receiver_flush_location : 0/8000148 receiver_replay_location : 0/8000148 sync_percent : 100% sync_state : Sync sync_priority : 1 sync_most_available : Off channel : 127.0.0.1:5435-->127.0.0.1:39592 Receiver info: No information |
可见，主从已经恢复正常状态！！！
