3-Master节点Standby同步与切换.pdf

布衣

207

9页

1次

2024-01-05

10墨值下载

一、Master 节点移除，Standby 节点切Master

1.1 移除掉Master节点

1 [gpadmin@master ~]$ pg_ctl stop -D /u05/master/gpseg-1/

2 waiting for server to shut down.........................................................

3 pg_ctl: server does not shut down

4 HINT: The "-m fast" option immediately disconnects sessions rather than

5 waiting for session-initiated disconnection.

6 [gpadmin@master ~]$ pg_ctl stop -m fast -D /u05/master/gpseg-1/

7 waiting for server to shut down.... done

8 server stopped

或直接关闭服务器

1 [root@master ~]# poweroff

1.2 查看移除后的集群状态

1 [gpadmin@master ~]$ gpstate -f

2 20220512:17:56:20:004126 gpstate:bjdx005sin091:gpadmin-[INFO]:-Starting gpstate with args

3 20220512:17:56:20:004126 gpstate:bjdx005sin091:gpadmin-[INFO]:-local Greenplum Version:

4 20220512:17:56:20:004126 gpstate:bjdx005sin091:gpadmin-[CRITICAL]:-gpstate failed. (Reaso

5 Is the server running on host "localhost" (127.0.0.1) and accepting

6 TCP/IP connections on port 5432?

7 ') exiting...

1.3 把Standby 节点升级为Master

1 [gpadmin@standby ~]$ vim .bash_profile

2 # .bash_profile

4 # Get the aliases and functions

5 if [ -f ~/.bashrc ]; then

6 . ~/.bashrc

7 fi

9 # User specific environment and startup programs

11 PATH=$PATH:$HOME/.local/bin:$HOME/bin:/sbin:/usr/bin:/usr/sbin

13 export PATH

14 source /usr/local/greenplum-db/greenplum_path.sh

15 export GPHOME=/usr/local/greenplum-db-6.20.5

16 export MASTER_DATA_DIRECTORY=/u05/data/master/gpseg-1

17 export PGPORT=5432

18 export PGUSER=gpadmin

19 export PGDATABASE=postgres

20 [gpadmin@standby ~]$ source .bash_profile

21 [gpadmin@standby ~]$ gpactivatestandby -d /u05/data/master/gpseg-1/

22 20231213:02:57:20:014420 gpactivatestandby:standby:gpadmin-[DEBUG]:-Running Command: echo

23 20231213:02:57:20:014420 gpactivatestandby:standby:gpadmin-[INFO]:----------------------

24 20231213:02:57:20:014420 gpactivatestandby:standby:gpadmin-[INFO]:-Standby data directory

25 20231213:02:57:20:014420 gpactivatestandby:standby:gpadmin-[INFO]:-Standby port

26 20231213:02:57:20:014420 gpactivatestandby:standby:gpadmin-[INFO]:-Standby running

27 20231213:02:57:20:014420 gpactivatestandby:standby:gpadmin-[INFO]:-Force standby activati

28 20231213:02:57:20:014420 gpactivatestandby:standby:gpadmin-[INFO]:----------------------

29 20231213:02:57:20:014420 gpactivatestandby:standby:gpadmin-[DEBUG]:-Running Command: cat

30 Do you want to continue with standby master activation? Yy|Nn (default=N):

31 > y

32 20231213:02:57:25:014420 gpactivatestandby:standby:gpadmin-[DEBUG]:-Running Command: ps

33 20231213:02:57:25:014420 gpactivatestandby:standby:gpadmin-[INFO]:-found standby postmast

34 20231213:02:57:25:014420 gpactivatestandby:standby:gpadmin-[INFO]:-Promoting standby...

35 20231213:02:57:25:014420 gpactivatestandby:standby:gpadmin-[DEBUG]:-Running Command: pg_c

36 20231213:02:57:25:014420 gpactivatestandby:standby:gpadmin-[DEBUG]:-Waiting for connectio

37 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-Standby master is prom

38 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-Reading current config

39 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[DEBUG]:-Connecting to dbname=

40 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:----------------------

41 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-The activation of the

42 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-standby is now the new

43 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-You will need to updat

44 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-the change of master h

45 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-Do not re-start the fa

46 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-operational, this coul

47 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-MASTER_DATA_DIRECTORY

48 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-this has changed as a

49 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-to change this in any

50 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-to set this value.

51 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-MASTER_PORT is now 543

52 20231213:02:57:26:014420 gpactivatestandby:standby:gpadmin-[INFO]:-may need to make addit