【我和 openGauss 的故事】体验 openGauss 5.0 极简版一主一备部署，延时回放和主备切换功能

# mount -o loop /mnt/OS/Linux/CentOS/CentOS-7-x86_64-Everything-1810.iso /media/# vi /etc/yum.repos.d/iso.repo---添加如下内容：[iso]name=isobaseurl=file:///mediaenable=1gpgcheck=0
# yum makecache
# yum install -y libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb-core readline-devel

---关闭防火墙# systemctl stop firewalld# systemctl disable firewalld
---永久关闭SELinux# sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/sysconfig/selinux
---配置文件系统描述符# echo "* soft nofile 1000000" >>/etc/security/limits.conf# echo "* hard nofile 1000000" >>/etc/security/limits.conf
---重启生效# reboot 

# groupadd dbgroup# useradd -g dbgroup omm# passwd omm

# cd /opt# mkdir openGaussSimp# chown -R omm:dbgroup openGauss$ tar -jxf /stage/openGauss-5.0.0-CentOS-64bit.tar.bz2 -C /opt/openGaussSimp/$ ll /opt/openGaussSimp/总用量 16drwxr-xr-x. 2 omm dbgroup 4096 3月 29 03:20 bindrwxr-xr-x. 3 omm dbgroup 22 3月 29 03:20 etcdrwxr-xr-x. 3 omm dbgroup 24 3月 29 03:20 includedrwxr-xr-x. 4 omm dbgroup 95 3月 29 03:20 jredrwxr-xr-x. 5 omm dbgroup 4096 3月 29 03:20 libdrwxr-xr-x. 5 omm dbgroup 53 3月 29 03:20 sharedrwxr-xr-x. 2 omm dbgroup 78 3月 29 03:20 simpleInstall-rw-r--r--. 1 omm dbgroup 32 3月 29 03:20 version.cfg

$ cd /opt/openGauss/simpleInstall/$ ll  总用量 56  -rw-r--r--. 1 omm dbgroup 10827 3月 29 03:20 finance.sql  -rw-r--r--. 1 omm dbgroup 13009 3月 29 03:20 install.sh  -rw-r--r--. 1 omm dbgroup 5056 3月 29 03:20 README.md  -rw-r--r--. 1 omm dbgroup 19713 3月 29 03:20 school.sql

$ sh install.sh -w password --multinode[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 /opt/openGauss/data/master ... okcreating subdirectories ... in ordinary occasionokcreating configuration files ... okselecting default max_connections ... 100selecting default shared_buffers ... 1024MBBegin init undo subsystem meta.[INIT UNDO] Init undo subsystem meta successfully.creating template1 database in /opt/openGauss/data/master/base/1 ... The core dump path is an invalid directory2023-07-20 16:55:31.270 [unknown] [unknown] localhost 139958306611456 0[0:0#0] [BACKEND] WARNING: macAddr is 55880/310234098, sysidentifier is 3662156413/3421696841, randomNum is 3743216457okinitializing pg_authid ... oksetting password ... okinitializing dependencies ... okloading PL/pgSQL server-side language ... okcreating system views ... okcreating performance views ... okloading system objects' descriptions ... okcreating collations ... okcreating conversions ... okcreating dictionaries ... oksetting privileges on built-in objects ... okinitialize global configure for bucketmap length ... okcreating information schema ... okloading foreign-data wrapper for distfs access ... okloading foreign-data wrapper for log access ... okloading hstore extension ... okloading foreign-data wrapper for MOT access ... okloading security plugin ... okupdate system tables ... okcreating snapshots catalog ... okvacuuming database template1 ... okcopying template1 to template0 ... okcopying template1 to postgres ... okfreezing database template0 ... okfreezing database template1 ... okfreezing database postgres ... ok
WARNING: enabling "trust" authentication for local connectionsYou 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:

or gs_ctl start -D /opt/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 /opt/openGauss/data/slave ... okcreating subdirectories ... in ordinary occasionokcreating configuration files ... okselecting default max_connections ... 100selecting default shared_buffers ... 1024MBBegin init undo subsystem meta.[INIT UNDO] Init undo subsystem meta successfully.creating template1 database in /opt/openGauss/data/slave/base/1 ... The core dump path is an invalid directory2023-07-20 16:55:54.473 [unknown] [unknown] localhost 139719775543552 0[0:0#0] [BACKEND] WARNING: macAddr is 55880/310234098, sysidentifier is 3662156413/3421692616, randomNum is 2853364424okinitializing pg_authid ... oksetting password ... okinitializing dependencies ... okloading PL/pgSQL server-side language ... okcreating system views ... okcreating performance views ... okloading system objects' descriptions ... okcreating collations ... okcreating conversions ... okcreating dictionaries ... oksetting privileges on built-in objects ... okinitialize global configure for bucketmap length ... okcreating information schema ... okloading foreign-data wrapper for distfs access ... okloading foreign-data wrapper for log access ... okloading hstore extension ... okloading foreign-data wrapper for MOT access ... okloading security plugin ... okupdate system tables ... okcreating snapshots catalog ... okvacuuming database template1 ... okcopying template1 to template0 ... okcopying template1 to postgres ... okfreezing database template0 ... okfreezing database template1 ... okfreezing database postgres ... ok
WARNING: enabling "trust" authentication for local connectionsYou 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:

or gs_ctl start -D /opt/openGauss/data/slave -Z single_node -l logfile
[config datanode.]remote_read_mode = non_authenticationhost all all 192.168.9.191/32 trust[start primary datanode.][2023-07-20 16:56:17.641][15074][][gs_ctl]: gs_ctl started,datadir is /opt/openGauss/data/master [2023-07-20 16:56:17.676][15074][][gs_ctl]: waiting for server to start....0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: L7DBMerge.base.online
0 LOG: [Alarm Module]Host IP: L7DBMerge.base.online. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>
0 LOG: [Alarm Module]Cluster Name: dbCluster
0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57
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 directory2023-07-20 16:56:17.745 [unknown] [unknown] localhost 139830592221440 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.2023-07-20 16:56:17.750 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2023-07-20 16:56:17.750 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: L7DBMerge.base.online
2023-07-20 16:56:17.750 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: L7DBMerge.base.online. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>
2023-07-20 16:56:17.750 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster
2023-07-20 16:56:17.750 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57
2023-07-20 16:56:17.765 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin"2023-07-20 16:56:17.775 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets2023-07-20 16:56:17.799 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.2023-07-20 16:56:17.799 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB2023-07-20 16:56:17.799 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB2023-07-20 16:56:17.799 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 8143 MB2023-07-20 16:56:17.799 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: shared memory 3284 Mbytes, memory context 8491 Mbytes, max process memory 12288 Mbytes2023-07-20 16:56:17.799 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: shared memory that key is 5432001 is owned by pid 17862023-07-20 16:56:17.849 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184)2023-07-20 16:56:17.873 [unknown] [unknown] localhost 139830592221440 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: 5122023-07-20 16:56:17.889 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/opt/openGauss/data/master/gaussdb.state.temp" success2023-07-20 16:56:17.890 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Primary), connection index(1)2023-07-20 16:56:17.912 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 974, usable_fds = 1000, already_open = 16The core dump path is an invalid directory2023-07-20 16:56:17.914 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created.2023-07-20 16:56:17.918 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: the configure file /opt/openGauss/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!2023-07-20 16:56:17.918 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file.2023-07-20 16:56:17.926 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!2023-07-20 16:56:17.926 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A2023-07-20 16:56:17.926 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.2023-07-20 16:56:17.926 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details.2023-07-20 16:56:17.927 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!2023-07-20 16:56:17.927 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A2023-07-20 16:56:17.927 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.2023-07-20 16:56:17.927 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details.2023-07-20 16:56:17.927 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!2023-07-20 16:56:17.927 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A2023-07-20 16:56:17.927 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.2023-07-20 16:56:17.927 [unknown] [unknown] localhost 139830592221440 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details.
[2023-07-20 16:56:18.681][15074][][gs_ctl]: done[2023-07-20 16:56:18.681][15074][][gs_ctl]: server started (/opt/openGauss/data/master)[build and start slave datanode.][2023-07-20 16:56:18.691][15146][][gs_ctl]: gs_ctl full build ,datadir is /opt/openGauss/data/slave[2023-07-20 16:56:18.691][15146][][gs_ctl]: fopen build pid file "/opt/openGauss/data/slave/gs_build.pid" success[2023-07-20 16:56:18.691][15146][][gs_ctl]: fprintf build pid file "/opt/openGauss/data/slave/gs_build.pid" success[2023-07-20 16:56:18.694][15146][][gs_ctl]: fsync build pid file "/opt/openGauss/data/slave/gs_build.pid" success[2023-07-20 16:56:18.694][15146][][gs_ctl]: stop failed, killing gaussdb by force ...[2023-07-20 16:56:18.694][15146][][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=="/opt/openGauss/data/slave") print $(NF-2)}' | awk -F/ '{print $3 }' | xargs kill -9 >/dev/null 2>&1 ] path: [/opt/openGauss/data/slave] [2023-07-20 16:56:18.712][15146][][gs_ctl]: server stopped[2023-07-20 16:56:18.712][15146][][gs_ctl]: current workdir is (/opt/openGauss/simpleInstall).[2023-07-20 16:56:18.713][15146][][gs_ctl]: set gaussdb state file when full build build:db state(BUILDING_STATE), server mode(STANDBY_MODE), build mode(FULL_BUILD).[2023-07-20 16:56:18.713][15146][datanode2][gs_ctl]: Get repl_auth_mode is and repl_uuid is [2023-07-20 16:56:18.717][15146][datanode2][gs_ctl]: build try host(192.168.9.191) port(5433) success[2023-07-20 16:56:18.717][15146][datanode2][gs_ctl]: connected to server success, build started.[2023-07-20 16:56:18.752][15146][datanode2][gs_ctl]: clear old target dir success[2023-07-20 16:56:18.752][15146][datanode2][gs_ctl]: create build tag file success[2023-07-20 16:56:18.752][15146][datanode2][gs_ctl]: create build tag file again success[2023-07-20 16:56:18.752][15146][datanode2][gs_ctl]: get system identifier success[2023-07-20 16:56:18.771][15146][datanode2][gs_ctl]: receiving and unpacking files...[2023-07-20 16:56:18.771][15146][datanode2][gs_ctl]: create backup label successINFO: The starting position of the xlog copy of the full build is: 0/2434A60. The slot minimum LSN is: 0/0. The disaster slot minimum LSN is: 0/0. The logical slot minimum LSN is: 0/0.[2023-07-20 16:56:18.969][15146][datanode2][gs_ctl]: xlog start point: 0/2434A60[2023-07-20 16:56:18.969][15146][datanode2][gs_ctl]: begin build tablespace list[2023-07-20 16:56:18.969][15146][datanode2][gs_ctl]: finish build tablespace list[2023-07-20 16:56:18.969][15146][datanode2][gs_ctl]: begin get xlog by xlogstream[2023-07-20 16:56:18.969][15146][datanode2][gs_ctl]: starting background WAL receiver[2023-07-20 16:56:18.969][15146][datanode2][gs_ctl]: starting walreceiver[2023-07-20 16:56:18.970][15146][datanode2][gs_ctl]: begin receive tar files[2023-07-20 16:56:18.970][15146][datanode2][gs_ctl]: receiving and unpacking files...[2023-07-20 16:56:18.975][15146][datanode2][gs_ctl]: build try host(192.168.9.191) port(5433) success[2023-07-20 16:56:18.975][15146][datanode2][gs_ctl]: check identify system success[2023-07-20 16:56:18.983][15146][datanode2][gs_ctl]: send START_REPLICATION 0/2000000 success[2023-07-20 16:56:19.645][15146][datanode2][gs_ctl]: finish receive tar files[2023-07-20 16:56:19.645][15146][datanode2][gs_ctl]: xlog end point: 0/3000058[2023-07-20 16:56:19.646][15146][datanode2][gs_ctl]: fetching MOT checkpointgs_ctl: no mot checkpoint exists[2023-07-20 16:56:19.646][15146][datanode2][gs_ctl]: waiting for background process to finish streaming...[2023-07-20 16:56:24.005][15146][datanode2][gs_ctl]: starting fsync all files come from source.[2023-07-20 16:56:37.583][15146][datanode2][gs_ctl]: finish fsync all files.[2023-07-20 16:56:37.594][15146][datanode2][gs_ctl]: build dummy dw file success[2023-07-20 16:56:37.594][15146][datanode2][gs_ctl]: rename build status file success[2023-07-20 16:56:37.596][15146][datanode2][gs_ctl]: full build build completed(/opt/openGauss/data/slave).[2023-07-20 16:56:37.629][15146][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: L7DBMerge.base.online
0 LOG: [Alarm Module]Host IP: L7DBMerge.base.online. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>
0 LOG: [Alarm Module]Cluster Name: dbCluster
0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57
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 directory2023-07-20 16:56:37.699 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton.2023-07-20 16:56:37.706 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2023-07-20 16:56:37.706 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: L7DBMerge.base.online
2023-07-20 16:56:37.706 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: L7DBMerge.base.online. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>
2023-07-20 16:56:37.706 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster
2023-07-20 16:56:37.706 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57
2023-07-20 16:56:37.722 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin"2023-07-20 16:56:37.731 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets2023-07-20 16:56:37.766 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.2023-07-20 16:56:37.766 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB2023-07-20 16:56:37.766 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB2023-07-20 16:56:37.766 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 8143 MB2023-07-20 16:56:37.766 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: shared memory 3284 Mbytes, memory context 8491 Mbytes, max process memory 12288 Mbytes2023-07-20 16:56:37.766 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: shared memory that key is 5632001 is owned by pid 18942023-07-20 16:56:37.822 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184)2023-07-20 16:56:37.848 [unknown] [unknown] localhost 140210215690496 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: 5122023-07-20 16:56:37.874 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/opt/openGauss/data/slave/gaussdb.state.temp" success2023-07-20 16:56:37.874 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Standby), connection index(1)2023-07-20 16:56:37.897 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 972, usable_fds = 1000, already_open = 18The core dump path is an invalid directory2023-07-20 16:56:37.899 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: the configure file /opt/openGauss/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!2023-07-20 16:56:37.899 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file.2023-07-20 16:56:37.912 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!2023-07-20 16:56:37.912 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A2023-07-20 16:56:37.912 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.2023-07-20 16:56:37.912 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details.2023-07-20 16:56:37.913 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!2023-07-20 16:56:37.913 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A2023-07-20 16:56:37.913 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.2023-07-20 16:56:37.913 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details.2023-07-20 16:56:37.913 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!2023-07-20 16:56:37.913 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A2023-07-20 16:56:37.913 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.2023-07-20 16:56:37.913 [unknown] [unknown] localhost 140210215690496 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details..................[2023-07-20 16:56:55.660][15146][datanode2][gs_ctl]: done[2023-07-20 16:56:55.660][15146][datanode2][gs_ctl]: server started (/opt/openGauss/data/slave)[2023-07-20 16:56:55.660][15146][datanode2][gs_ctl]: fopen build pid file "/opt/openGauss/data/slave/gs_build.pid" success[2023-07-20 16:56:55.660][15146][datanode2][gs_ctl]: fprintf build pid file "/opt/openGauss/data/slave/gs_build.pid" success[2023-07-20 16:56:55.727][15146][datanode2][gs_ctl]: fsync build pid file "/opt/openGauss/data/slave/gs_build.pid" successimport sql fileWould you like to create a demo database (yes/no)? yesLoad 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

$ ps ux | grep gaussdbomm      15077  1.7  8.2 6124380 675456 ?      Ssl  16:56   0:02 /opt/openGauss/bin/gaussdb -D /opt/openGauss/data/master -M primaryomm      15173  2.0  5.4 6345480 444352 ?      Ssl  16:56   0:02 /opt/openGauss/bin/gaussdb -D /opt/openGauss/data/slave -M standby$ gs_ctl query -D /opt/openGaussSimp/data/master/[2023-07-24 17:31:43.810][17978][][gs_ctl]: gs_ctl query ,datadir is /opt/openGauss/data/master  HA state:               local_role                     : Primary    static_connections             : 1    db_state                       : Normal    detail_information             : Normal
 Senders info:           sender_pid                     : 15236    local_role                     : Primary    peer_role                      : Standby    peer_state                     : Normal    state                          : Streaming    sender_sent_location           : 0/403E448    sender_write_location          : 0/403E448    sender_flush_location          : 0/403E448    sender_replay_location         : 0/403E448    receiver_received_location     : 0/403E448    receiver_write_location        : 0/403E448    receiver_flush_location        : 0/403E448    receiver_replay_location       : 0/403E448    sync_percent                   : 100%    sync_state                     : Sync    sync_priority                  : 1    sync_most_available            : Off    channel                        : 192.168.9.191:5433-->192.168.9.191:43042
 Receiver info:      No information 

[omm@L7DBMerge ~]$ gs_ctl query -D /opt/openGaussSimp/data/slave/[2023-07-24 17:33:08.807][18087][][gs_ctl]: gs_ctl query ,datadir is /opt/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                   : 15235    local_role                     : Standby    peer_role                      : Primary    peer_state                     : Normal    state                          : Normal    sender_sent_location           : 0/403E568    sender_write_location          : 0/403E568    sender_flush_location          : 0/403E568    sender_replay_location         : 0/403E568    receiver_received_location     : 0/403E568    receiver_write_location        : 0/403E568    receiver_flush_location        : 0/403E568    receiver_replay_location       : 0/403E568    sync_percent                   : 100%    channel                        : 192.168.9.191:43042<--192.168.9.191:5433

---连接主节点：$ gsql -d postgres -p 5432gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr  )Non-SSL connection (SSL connection is recommended when requiring high-security)Type "help" for help.
openGauss=#

---连接备节点：$ gsql -d postgres -p 5632gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr  )Non-SSL connection (SSL connection is recommended when requiring high-security)Type "help" for help.
openGauss=#

主节点: gs_ctl start|stop|restart -D /opt/openGaussSimp/data/master -M primary
备节点: gs_ctl start|stop|restart -D /opt/openGaussSimp/data/slave -M standby

---主节点：openGauss=# show synchronous_commit; synchronous_commit -------------------- on(1 row)
openGauss=# show recovery_min_apply_delay; recovery_min_apply_delay -------------------------- 0(1 row)
---备节点：openGauss=# show synchronous_commit; synchronous_commit -------------------- on(1 row)
openGauss=# show recovery_min_apply_delay; recovery_min_apply_delay -------------------------- 0(1 row)

---主节点创建表并插入记录openGauss=# \d+No relations found.
openGauss=# create table t_delay (id int,instime date);CREATE TABLE

openGauss=# \d+                                      List of relations Schema |  Name   | Type  | Owner |  Size   |             Storage              | Description --------+---------+-------+-------+---------+----------------------------------+------------- public | t_rapid | table | omm   | 0 bytes | {orientation=row,compression=no} | (1 row)


openGauss=# insert into t_rapid values(1,localtimestamp);INSERT 0 1openGauss=# select now();select * from t_rapid;              now              ------------------------------- 2023-07-25 10:14:19.756149+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:14:18(1 row)
openGauss=# insert into t_rapid values(2,localtimestamp);INSERT 0 1openGauss=# select now();select * from t_rapid;              now              ------------------------------- 2023-07-25 10:15:00.765355+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:14:18  2 | 2023-07-25 10:14:59(2 rows)






---备节点：
openGauss=# \d+                                      List of relations Schema |  Name   | Type  | Owner |  Size   |             Storage              | Description --------+---------+-------+-------+---------+----------------------------------+------------- public | t_rapid | table | omm   | 0 bytes | {orientation=row,compression=no} | (1 row)
openGauss=# select now();select * from t_rapid;              now              ------------------------------- 2023-07-25 10:14:22.040042+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:14:18(1 row)
openGauss=# select now();select * from t_rapid;              now              ------------------------------- 2023-07-25 10:15:02.369679+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:14:18  2 | 2023-07-25 10:14:59(2 rows)

---延时回放时间设置为60秒$ gs_guc reload -D /opt/openGaussSimp/data/master/ -c "recovery_min_apply_delay = 60000"The gs_guc run with the following arguments: [gs_guc -D /opt/openGaussSimp/data/master/ -c recovery_min_apply_delay = 60000 reload ].expected instance path: [/opt/openGaussSimp/data/master/postgresql.conf]gs_guc reload: recovery_min_apply_delay=60000: [/opt/openGaussSimp/data/master/postgresql.conf]server signaled
Total instances: 1. Failed instances: 0.Success to perform gs_guc!

---主节点：openGauss=# show recovery_min_apply_delay; recovery_min_apply_delay -------------------------- 0(1 row)

---备节点：openGauss=# show recovery_min_apply_delay; recovery_min_apply_delay -------------------------- 1min(1 row)

---主节点：openGauss=# select now();create table t_delay (id int,instime date);              now              ------------------------------- 2023-07-25 10:19:15.213658+08(1 row)
CREATE TABLEopenGauss=# \d+                                       List of relations Schema |  Name   | Type  | Owner |    Size    |             Storage              | Description --------+---------+-------+-------+------------+----------------------------------+------------- public | t_delay | table | omm   | 0 bytes    | {orientation=row,compression=no} |  public | t_rapid | table | omm   | 8192 bytes | {orientation=row,compression=no} | (2 rows)
openGauss=# insert into t_delay values(1,localtimestamp);INSERT 0 1openGauss=# select now();select * from t_delay;              now              ------------------------------- 2023-07-25 10:21:33.585342+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:21:28(1 row)
openGauss=# insert into t_delay values(2,localtimestamp);INSERT 0 1openGauss=# select now();select * from t_delay;              now              ------------------------------- 2023-07-25 10:22:42.892056+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:21:28  2 | 2023-07-25 10:22:42(2 rows)


---备节点：openGauss=# select now();select * from t_delay;              now              ------------------------------- 2023-07-25 10:22:22.012958+08(1 row)
 id | instime ----+---------(0 rows)---1分钟内没有数据复制过来
openGauss=# select now();select * from t_delay;             now              ------------------------------ 2023-07-25 10:22:31.88414+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:21:28(1 row)---1分钟后第一条数据复制过来
openGauss=# select now();select * from t_delay;             now              ------------------------------ 2023-07-25 10:23:38.93457+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:21:28(1 row)---第2条数据在1分钟内也没有复制过来
openGauss=# select now();select * from t_delay;              now              ------------------------------- 2023-07-25 10:23:43.511753+08(1 row)
 id |       instime       ----+---------------------  1 | 2023-07-25 10:21:28  1 | 2023-07-25 10:22:42(2 rows)---主节点插入第2条记录1分钟后，复制到备节点可以查询到

openGauss=# drop table t_delay;DROP TABLE
openGauss=# \d+                                       List of relations Schema |  Name   | Type  | Owner |    Size    |             Storage              | Description --------+---------+-------+-------+------------+----------------------------------+------------- public | t_rapid | table | omm   | 8192 bytes | {orientation=row,compression=no} | (1 row)

---延时时间段内在备节点查询该表会挂起会话，备节点回放后才会返回openGauss-# select now();select * from t_delay;ERROR:  syntax error at or near "time"LINE 1: time        ^ERROR:  relation "t_delay" does not exist on datanode1LINE 1: select * from t_delay;                      ^openGauss=# \d+                                       List of relations Schema |  Name   | Type  | Owner |    Size    |             Storage              | Description --------+---------+-------+-------+------------+----------------------------------+------------- public | t_rapid | table | omm   | 8192 bytes | {orientation=row,compression=no} | (1 row)

---切换现备节点为主节点$ gs_ctl switchover -D /opt/openGaussSimp/data/slave/[2023-07-25 10:26:55.538][13012][][gs_ctl]: gs_ctl switchover ,datadir is /opt/openGaussSimp/data/slave [2023-07-25 10:26:55.538][13012][][gs_ctl]: switchover term (1)[2023-07-25 10:26:55.542][13012][][gs_ctl]: waiting for server to switchover........[2023-07-25 10:27:00.566][13012][][gs_ctl]: done[2023-07-25 10:27:00.566][13012][][gs_ctl]: switchover completed (/opt/openGaussSimp/data/slave)
$ gs_ctl query -D /opt/openGaussSimp/data/slave/[2023-07-25 10:27:23.456][13084][][gs_ctl]: gs_ctl query ,datadir is /opt/openGaussSimp/data/slave  HA state:               local_role                     : Primary    static_connections             : 1    db_state                       : Normal    detail_information             : Normal
 Senders info:           sender_pid                     : 13050    local_role                     : Primary    peer_role                      : Standby    peer_state                     : Normal    state                          : Streaming    sender_sent_location           : 0/5F15DC8    sender_write_location          : 0/5F15DC8    sender_flush_location          : 0/5F15DC8    sender_replay_location         : 0/5F15DC8    receiver_received_location     : 0/5F15DC8    receiver_write_location        : 0/5F15DC8    receiver_flush_location        : 0/5F15DC8    receiver_replay_location       : 0/5F15DC8    sync_percent                   : 100%    sync_state                     : Sync    sync_priority                  : 1    sync_most_available            : Off    channel                        : 192.168.9.191:5633-->192.168.9.191:39950
 Receiver info:      No information ---查看原备节点已成为主节点
$ gs_ctl query -D /opt/openGaussSimp/data/master/[2023-07-25 10:27:09.177][13064][][gs_ctl]: gs_ctl query ,datadir is /opt/openGaussSimp/data/master  HA state:               local_role                     : Standby    static_connections             : 1    db_state                       : Normal    detail_information             : Normal
 Senders info:       No information  Receiver info:          receiver_pid                   : 13049    local_role                     : Standby    peer_role                      : Primary    peer_state                     : Normal    state                          : Normal    sender_sent_location           : 0/5F15DC8    sender_write_location          : 0/5F15DC8    sender_flush_location          : 0/5F15DC8    sender_replay_location         : 0/5F15DC8    receiver_received_location     : 0/5F15DC8    receiver_write_location        : 0/5F15DC8    receiver_flush_location        : 0/5F15DC8    receiver_replay_location       : 0/5F15DC8    sync_percent                   : 100%    channel                        : 192.168.9.191:39950<--192.168.9.191:5633---查看原主节点已自动切换为备节点
---切换后的主备节点的原有会话执行操作，会自动重连数据库：openGauss=# show recovery_min_apply_delay;WARNING:  Session unused timeout.FATAL:  terminating connection due to administrator commandcould not send data to server: Broken pipeThe connection to the server was lost. Attempting reset: Succeeded.

openGauss=# \d+FATAL:  terminating connection due to administrator commandcould not send data to server: Broken pipeThe connection to the server was lost. Attempting reset: Succeeded.

---切换后的备节点：openGauss=# create table t_delay (id int,instime date);ERROR:  cannot execute CREATE TABLE in a read-only transactionopenGauss=# select now();create table t_delay (id int,instime date);              now              ------------------------------- 2023-07-25 10:29:01.915622+08(1 row)
ERROR:  cannot execute CREATE TABLE in a read-only transaction---不能进行写入操作

---切换后的主节点：openGauss=# show recovery_min_apply_delay; recovery_min_apply_delay -------------------------- 1min(1 row)
openGauss=# select now();create table t_delay (id int,instime date);              now              ------------------------------- 2023-07-25 10:29:19.473593+08(1 row)
CREATE TABLEopenGauss=# \d+                                       List of relations Schema |  Name   | Type  | Owner |    Size    |             Storage              | Description --------+---------+-------+-------+------------+----------------------------------+------------- public | t_delay | table | omm   | 0 bytes    | {orientation=row,compression=no} |  public | t_rapid | table | omm   | 8192 bytes | {orientation=row,compression=no} | (2 rows)



openGauss=# insert into t_delay values(3,localtimestamp);INSERT 0 1openGauss=# select now();select * from t_delay;              now              ------------------------------- 2023-07-25 10:30:13.892301+08(1 row)
 id |       instime       ----+---------------------  3 | 2023-07-25 10:30:13(1 row)

---切换后的备节点：openGauss=# select now();select * from t_delay;              now              ------------------------------- 2023-07-25 10:30:13.327388+08(1 row)
 id |       instime       ----+---------------------  3 | 2023-07-25 10:30:13(1 row)
openGauss=# show recovery_min_apply_delay; recovery_min_apply_delay -------------------------- 0(1 row)
---立刻就能查到切换后主节点复制过来的数据，切换后的备节点参数recovery_min_apply_delay为默认的0

---在切换后的备节点中需要再配置参数$ gs_guc reload -D /opt/openGaussSimp/data/master/ -c "recovery_min_apply_delay = 60000"The gs_guc run with the following arguments: [gs_guc -D /opt/openGaussSimp/data/master/ -c recovery_min_apply_delay = 60000 reload ].expected instance path: [/opt/openGaussSimp/data/master/postgresql.conf]gs_guc reload: recovery_min_apply_delay=60000: [/opt/openGaussSimp/data/master/postgresql.conf]server signaled
Total instances: 1. Failed instances: 0.Success to perform gs_guc!

---再次验证延时回放，备节点插入记录openGauss=# insert into t_delay values(4,localtimestamp);INSERT 0 1openGauss=# select now();select * from t_delay;             now              ------------------------------ 2023-07-25 10:31:31.95094+08(1 row)
 id |       instime       ----+---------------------  3 | 2023-07-25 10:30:13  4 | 2023-07-25 10:31:29(2 rows)

openGauss=# select now();select * from t_delay;              now              ------------------------------- 2023-07-25 10:31:29.230721+08(1 row)
 id |       instime       ----+---------------------  3 | 2023-07-25 10:30:13(1 row)
openGauss=# select now();select * from t_delay;              now              ------------------------------- 2023-07-25 10:32:35.092483+08(1 row)
 id |       instime       ----+---------------------  3 | 2023-07-25 10:30:13  4 | 2023-07-25 10:31:29(2 rows)---延时时间到1分钟后，第4条记录已复制过来

$ gs_ctl switchover -D /opt/openGaussSimp/data/master/[2023-07-25 10:33:02.040][13524][][gs_ctl]: gs_ctl switchover ,datadir is /opt/openGaussSimp/data/master [2023-07-25 10:33:02.040][13524][][gs_ctl]: switchover term (1)[2023-07-25 10:33:02.044][13524][][gs_ctl]: waiting for server to switchover........[2023-07-25 10:33:07.070][13524][][gs_ctl]: done[2023-07-25 10:33:07.070][13524][][gs_ctl]: switchover completed (/opt/openGaussSimp/data/master)---还原后的主备节点关系$ gs_ctl query -D /opt/openGaussSimp/data/master/[2023-07-25 10:33:11.096][13571][][gs_ctl]: gs_ctl query ,datadir is /opt/openGaussSimp/data/master  HA state:               local_role                     : Primary    static_connections             : 1    db_state                       : Normal    detail_information             : Normal
 Senders info:           sender_pid                     : 13561    local_role                     : Primary    peer_role                      : Standby    peer_state                     : Normal    state                          : Streaming    sender_sent_location           : 0/5F18120    sender_write_location          : 0/5F18120    sender_flush_location          : 0/5F18120    sender_replay_location         : 0/5F18120    receiver_received_location     : 0/5F18120    receiver_write_location        : 0/5F18120    receiver_flush_location        : 0/5F18120    receiver_replay_location       : 0/5F18120    sync_percent                   : 100%    sync_state                     : Sync    sync_priority                  : 1    sync_most_available            : Off    channel                        : 192.168.9.191:5433-->192.168.9.191:50220
 Receiver info:      No information 

$ gs_ctl query -D /opt/openGaussSimp/data/slave/[2023-07-25 10:33:13.628][13580][][gs_ctl]: gs_ctl query ,datadir is /opt/openGaussSimp/data/slave  HA state:               local_role                     : Standby    static_connections             : 1    db_state                       : Normal    detail_information             : Normal
 Senders info:       No information  Receiver info:          receiver_pid                   : 13560    local_role                     : Standby    peer_role                      : Primary    peer_state                     : Normal    state                          : Normal    sender_sent_location           : 0/5F18120    sender_write_location          : 0/5F18120    sender_flush_location          : 0/5F18120    sender_replay_location         : 0/5F18120    receiver_received_location     : 0/5F18120    receiver_write_location        : 0/5F18120    receiver_flush_location        : 0/5F18120    receiver_replay_location       : 0/5F18120    sync_percent                   : 100%    channel                        : 192.168.9.191:50220<--192.168.9.191:5433

---主备节点会话openGauss=# select now();select * from t_delay;WARNING:  Session unused timeout.FATAL:  terminating connection due to administrator commandcould not send data to server: Broken pipeThe connection to the server was lost. Attempting reset: Succeeded. id |       instime       ----+---------------------  3 | 2023-07-25 10:30:13  4 | 2023-07-25 10:31:29(2 rows)

openGauss=# select now();select * from t_delay;FATAL:  terminating connection due to administrator commandcould not send data to server: Broken pipeThe connection to the server was lost. Attempting reset: Succeeded. id |       instime       ----+---------------------  3 | 2023-07-25 10:30:13  4 | 2023-07-25 10:31:29(2 rows)