5.2-Segment扩展-纵向扩容.pdf
10墨值下载
1台：master、1台：standby、4台：segment 一共6台服务器，每个服务器8个primary、8个mirror
现在的需求：每个服务器8个primary、8个mirror扩展到每台服务器9个primary、9个mirror。
一、环境介绍
postgres=# select hostname,role,count(*) from gp_segment_configuration group by
hostname,role order by 1,2;
1
hostname | role | count
2
----------+------+-------
3
master | m | 8
4
master | p | 9
5
segment1 | m | 8
6
segment1 | p | 8
7
segment2 | m | 8
8
segment2 | p | 8
9
segment3 | m | 8
10
segment3 | p | 8
11
segment4 | m | 8
12
segment4 | p | 8
13
standby | m | 9
14
standby | p | 8
15
(12 rows)
16
二、创建新的目录
[gpadmin@master gpconfigs]$ cat hostlist
1
master
2
standby
3
segment1
4
segment2
5
segment3
6
segment4
7
[gpadmin@master gpconfigs]$ gpssh -f hostlist -e 'mkdir -p /u05/data/primary5
/u05/data/mirror5'
8
[ master] mkdir -p /u05/data/primary5 /u05/data/mirror5
9
[segment3] mkdir -p /u05/data/primary5 /u05/data/mirror5
10
[segment2] mkdir -p /u05/data/primary5 /u05/data/mirror5
11
[segment1] mkdir -p /u05/data/primary5 /u05/data/mirror5
12
[segment4] mkdir -p /u05/data/primary5 /u05/data/mirror5
13
[ standby] mkdir -p /u05/data/primary5 /u05/data/mirror5
14
三、扩展
[gpadmin@master gpconfigs]$ gpexpand -f hostlist
1
20231231:22:18:49:023337 gpexpand:master:gpadmin-[INFO]:-local Greenplum Version:
'postgres (Greenplum Database) 6.20.5 build
commit:bd00a8103dd57c80bd98192b5b3516fd5179912b'
2
20231231:22:18:49:023337 gpexpand:master:gpadmin-[INFO]:-master Greenplum Version:
'PostgreSQL 9.4.26 (Greenplum Database 6.20.5 build
commit:bd00a8103dd57c80bd98192b5b3516fd5179912b) on x86_64-unknown-linux-gnu, compiled
by gcc (GCC) 6.4.0, 64-bit compiled on Jun 1 2022 22:53:46'
3
20231231:22:18:49:023337 gpexpand:master:gpadmin-[INFO]:-Querying gpexpand schema for
current expansion state
4
5
System Expansion is used to add segments to an existing GPDB array.
6
gpexpand did not detect a System Expansion that is in progress.
7
8
Before initiating a System Expansion, you need to provision and burn-in
9
the new hardware. Please be sure to run gpcheckperf to make sure the
10
new hardware is working properly.
11
12
Please refer to the Admin Guide for more information.
13
14
Would you like to initiate a new System Expansion Yy|Nn (default=N):
15
> y
16
17
You must now specify a mirroring strategy for the new hosts. Spread mirroring places
18
a given hosts mirrored segments each on a separate host. You must be
19
adding more hosts than the number of segments per host to use this.
20
Grouped mirroring places all of a given hosts segments on a single
21
mirrored host. You must be adding at least 2 hosts in order to use this.
22
23
24
25
What type of mirroring strategy would you like?
26
spread|grouped (default=grouped):
27
>
28
of 11
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论