Matrixdb添加mirror
查看系统配置表
[mxadmin@mdw ~]$ psql
psql (12)
Type "help" for help.
postgres=# SELECT * from gp_segment_configuration order by 1;
dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir
------+---------+------+----------------+------+--------+------+----------+---------+---------------------------------------
1 | -1 | p | p | n | u | 5432 | mdw | mdw | /mxdata_20220401161459/master/mxseg-1
2 | 0 | p | p | n | u | 6000 | sdw1 | sdw1 | /mxdata_20220401161459/primary/mxseg0
3 | 1 | p | p | n | u | 6000 | sdw2 | sdw2 | /mxdata_20220401161459/primary/mxseg1
4 | 2 | p | p | n | u | 6000 | sdw3 | sdw3 | /mxdata_20220401161459/primary/mxseg2
5 | 3 | p | p | n | u | 6000 | sdw4 | sdw4 | /mxdata_20220401161459/primary/mxseg3
(5 rows)
postgres=#
创建数据目录
在所有需要添加mirror的主机,创建存放mirror的数据目录
可以使用gpssh命令
[mxadmin@mdw ~]$ cat conf/seg_hosts
sdw1
sdw2
sdw3
sdw4
[mxadmin@mdw ~]$ gpssh -f conf/seg_hosts -e 'mkdir -p /mxdata_20220401161459/mirror'
[sdw1] mkdir -p /mxdata_20220401161459/mirror
[sdw4] mkdir -p /mxdata_20220401161459/mirror
[sdw2] mkdir -p /mxdata_20220401161459/mirror
[sdw3] mkdir -p /mxdata_20220401161459/mirror
[mxadmin@mdw ~]$
生成addmirror文件
[mxadmin@mdw ~]$ gpaddmirrors -o ./addmirror
20220401:16:16:55:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-Starting gpaddmirrors with args: -o ./addmirror
20220401:16:16:55:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-local Greenplum Version: 'postgres (MatrixDB) 4.4.2-enterprise (Greenplum Database) 7.0.0+dev.17321.gcec99aeb59 build commit:cec99aeb598f5cc510ea6f2e8ebf828e71dc97d0'
20220401:16:16:55:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 12 (MatrixDB 4.4.2-enterprise) (Greenplum Database 7.0.0+dev.17321.gcec99aeb59 build commit:cec99aeb598f5cc510ea6f2e8ebf828e71dc97d0) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180303 (Red Hat 7.3.1-5), 64-bit compiled on Mar 21 2022 09:09:55'
20220401:16:16:55:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-Obtaining Segment details from master...
20220401:16:16:56:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-Heap checksum setting consistent across cluster
Enter mirror segment data directory location 1 of 1 >
/mxdata_20220401161459/mirror
20220401:16:17:08:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-Configuration file output to ./addmirror successfully.
查看文件内容如下
contentid | host | port | data_dir #contentid递增,但是primary=mirror
[mxadmin@mdw ~]$ cat addmirror
0|sdw2|7000|/mxdata_20220401161459/mirror/mxseg0
1|sdw3|7000|/mxdata_20220401161459/mirror/mxseg1
2|sdw4|7000|/mxdata_20220401161459/mirror/mxseg2
3|sdw1|7000|/mxdata_20220401161459/mirror/mxseg
执行添加命令
[mxadmin@mdw ~]$ gpaddmirrors -i addmirror
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Starting gpaddmirrors with args: -i addmirror
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-local Greenplum Version: 'postgres (MatrixDB) 4.4.2-enterprise (Greenplum Database) 7.0.0+dev.17321.gcec99aeb59 build commit:cec99aeb598f5cc510ea6f2e8ebf828e71dc97d0'
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 12 (MatrixDB 4.4.2-enterprise) (Greenplum Database 7.0.0+dev.17321.gcec99aeb59 build commit:cec99aeb598f5cc510ea6f2e8ebf828e71dc97d0) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180303 (Red Hat 7.3.1-5), 64-bit compiled on Mar 21 2022 09:09:55'
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Obtaining Segment details from master...
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Heap checksum setting consistent across cluster
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Greenplum Add Mirrors Parameters
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Greenplum master data directory = /mxdata_20220401161459/master/mxseg-1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Greenplum master port = 5432
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Parallel batch limit = 16
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror 1 of 4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance host = sdw1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance address = sdw1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance directory = /mxdata_20220401161459/primary/mxseg0
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance port = 6000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance host = sdw2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance address = sdw2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance directory = /mxdata_20220401161459/mirror/mxseg0
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance port = 7000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror 2 of 4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance host = sdw2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance address = sdw2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance directory = /mxdata_20220401161459/primary/mxseg1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance port = 6000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance host = sdw3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance address = sdw3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance directory = /mxdata_20220401161459/mirror/mxseg1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance port = 7000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror 3 of 4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance host = sdw3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance address = sdw3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance directory = /mxdata_20220401161459/primary/mxseg2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance port = 6000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance host = sdw4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance address = sdw4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance directory = /mxdata_20220401161459/mirror/mxseg2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance port = 7000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror 4 of 4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance host = sdw4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance address = sdw4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance directory = /mxdata_20220401161459/primary/mxseg3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Primary instance port = 6000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance host = sdw1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance address = sdw1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance directory = /mxdata_20220401161459/mirror/mxseg3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:- Mirror instance port = 7000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
Continue with add mirrors procedure Yy|Nn (default=N):
> y
20220401:16:17:42:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Starting to modify pg_hba.conf on primary segments to allow replication connections
20220401:16:17:45:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Successfully modified pg_hba.conf on primary segments to allow replication connections
20220401:16:17:45:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-4 segment(s) to add
20220401:16:17:45:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Validating remote directories
20220401:16:17:45:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Configuring new segments
sdw2 (dbid 6): pg_basebackup: base backup completed
sdw3 (dbid 7): pg_basebackup: base backup completed
sdw4 (dbid 8): pg_basebackup: base backup completed
sdw1 (dbid 9): pg_basebackup: base backup completed
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Updating configuration with new mirrors
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Updating mirrors
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Starting mirrors
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-era is 801aaccd18b22093_220401161509
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Process results...
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-******************************************************************
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror segments have been added; data synchronization is in progress.
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Data synchronization will continue in the background.
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Use gpstate -s to check the resynchronization progress.
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-******************************************************************
查看节点状态
[mxadmin@mdw ~]$ psql
psql (12)
Type "help" for help.
postgres=# SELECT * from gp_segment_configuration order by 1;
dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir
------+---------+------+----------------+------+--------+------+----------+---------+---------------------------------------
1 | -1 | p | p | n | u | 5432 | mdw | mdw | /mxdata_20220401161459/master/mxseg-1
2 | 0 | p | p | s | u | 6000 | sdw1 | sdw1 | /mxdata_20220401161459/primary/mxseg0
3 | 1 | p | p | s | u | 6000 | sdw2 | sdw2 | /mxdata_20220401161459/primary/mxseg1
4 | 2 | p | p | s | u | 6000 | sdw3 | sdw3 | /mxdata_20220401161459/primary/mxseg2
5 | 3 | p | p | s | u | 6000 | sdw4 | sdw4 | /mxdata_20220401161459/primary/mxseg3
6 | 0 | m | m | s | u | 7000 | sdw2 | sdw2 | /mxdata_20220401161459/mirror/mxseg0
7 | 1 | m | m | s | u | 7000 | sdw3 | sdw3 | /mxdata_20220401161459/mirror/mxseg1
8 | 2 | m | m | s | u | 7000 | sdw4 | sdw4 | /mxdata_20220401161459/mirror/mxseg2
9 | 3 | m | m | s | u | 7000 | sdw1 | sdw1 | /mxdata_20220401161459/mirror/mxseg3
(9 rows)
postgres=#