暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
4-Failed segment恢复.pdf
231
9页
3次
2024-01-06
10墨值下载
注:
FTS(Fault Tolerance Server)进程负责故障检测。该进程是master上的一个子进程,可以快速检测
到primary或者mirror是否宕机,并及时让primary/mirror进行故障切换。如果fts挂掉了,master还
会再重新fork出一个。
一、模拟segment异常
1segment
1 [gpadmin@segment1 data]$ pwd
2 /u05/data
3 [gpadmin@segment1 data]$ ls
4 mirror mirror1 mirror2 mirror3 mirror4 primary primary1 primary2 primary3 primar
5 [gpadmin@segment1 data]$ rm -rf *
2segment
1 [gpadmin@master ~]$ gpstate -m
2 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:-Starting gpstate with args: -m
3 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:-local Greenplum Version: 'postgre
4 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:-master Greenplum Version: 'Postgr
5 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:-Obtaining Segment details from ma
6 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:---------------------------------
7 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:--Current GPDB mirror list and sta
8 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:--Type = Group
9 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:---------------------------------
10 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- Mirror Datadir
11 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment1 /u05/data/mirror1/g
12 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment1 /u05/data/mirror2/g
13 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment1 /u05/data/mirror3/g
14 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment1 /u05/data/mirror4/g
15 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment2 /u05/data/mirror1/g
16 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment2 /u05/data/mirror2/g
17 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment2 /u05/data/mirror3/g
18 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment2 /u05/data/mirror4/g
19 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- standby /u05/data/mirror1/g
20 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- standby /u05/data/mirror2/g
21 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- standby /u05/data/mirror3/g
22 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- standby /u05/data/mirror4/g
23 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- master /u05/data/mirror1/g
24 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- master /u05/data/mirror2/g
25 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- master /u05/data/mirror3/g
26 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- master /u05/data/mirror4/g
27 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:---------------------------------
28 20231217:03:10:12:007919 gpstate:master:gpadmin-[WARNING]:-4 segment(s) configured as mir
29 20231217:03:10:12:007919 gpstate:master:gpadmin-[WARNING]:-4 mirror segment(s) acting as
3gpcc
4
segment1 的实例status 均为 "d"
1 postgres=# select * from gp_segment_configuration order by role,dbid;
2 dbid | content | role | preferred_role | mode | status | port | hostname | address |
3 ------+---------+------+----------------+------+--------+------+----------+----------+--
4 6 | 4 | m | p | n | d | 6000 | segment1 | segment1 | /u
5 7 | 5 | m | p | n | d | 6001 | segment1 | segment1 | /u
6 8 | 6 | m | p | n | d | 6002 | segment1 | segment1 | /u
7 9 | 7 | m | p | n | d | 6003 | segment1 | segment1 | /u
8 18 | 0 | m | m | n | d | 7000 | segment1 | segment1 | /u
9 19 | 1 | m | m | n | d | 7001 | segment1 | segment1 | /u
of 9
10墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

文档被以下合辑收录

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜