Matrixdb添加standby

Matrixdb添加standby

配置hosts文件，添加所有主机的信息

在所有节点上，通过root用户执行下列操作。

[root@mdw ~]# vi /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.247.128 mdw
192.168.247.129 sdw1 smdw
192.168.247.130 sdw2
192.168.247.131 sdw3
192.168.247.132 sdw4

执行添加standby

在mdw上mxadmin执行

gpinitstandby -s smdw -S /mxdata_20220401161459/standby/

[mxadmin@mdw ~]$ gpinitstandby -s smdw -S /mxdata_20220401161459/standby/
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Validating environment and parameters for standby initialization...
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Checking for data directory /mxdata_20220401161459/standby/ on smdw
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:------------------------------------------------------
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Greenplum standby master initialization parameters
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:------------------------------------------------------
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Greenplum master hostname               = mdw
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Greenplum master data directory         = /mxdata_20220401161459/master/mxseg-1
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Greenplum master port                   = 5432
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Greenplum standby master hostname       = smdw
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Greenplum standby master port           = 5432
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Greenplum standby master data directory = /mxdata_20220401161459/standby/
20220401:16:33:19:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Greenplum update system catalog         = On
Do you want to continue with standby master initialization? Yy|Nn (default=N):
> y
20220401:16:33:21:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20220401:16:33:22:022375 gpinitstandby:mdw:mxadmin-[INFO]:-The packages on smdw are consistent.
20220401:16:33:22:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Adding standby master to catalog...
20220401:16:33:22:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Database catalog updated successfully.
20220401:16:33:22:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Updating pg_hba.conf file...
20220401:16:33:22:022375 gpinitstandby:mdw:mxadmin-[INFO]:-pg_hba.conf files updated successfully.
20220401:16:33:23:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Starting standby master
20220401:16:33:23:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Checking if standby master is running on host: smdw  in directory: /mxdata_20220401161459/standby/
20220401:16:33:24:022375 gpinitstandby:mdw:mxadmin-[INFO]:-MasterStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /mxdata_20220401161459/standby/ -l /mxdata_20220401161459/standby//log/startup.log -t 600 -o " -p 5432 -c gp_role=dispatch " start
20220401:16:34:51:022375 gpinitstandby:mdw:mxadmin-[WARNING]:-Could not start standby master
20220401:16:34:51:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Cleaning up pg_hba.conf backup files...
20220401:16:34:51:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.
20220401:16:34:51:022375 gpinitstandby:mdw:mxadmin-[INFO]:-Successfully created standby master on smdw