当前位置:Gxlcms > mysql > greenplum激活standby和恢复master原有角色

greenplum激活standby和恢复master原有角色

时间:2021-07-01 10:21:17 帮助过:21人阅读

定义:server1=(master) server2=(standby) Active standby server when master down. gpactivatestandby -d /data/master/gpseg-1 -f (on server2) Change server1 as standby . gpinitstandby -s server1 (on server2) gpactivatestandby -d /data/master/g

定义:server1=(master) server2=(standby)
    Active standby server when master down.
    gpactivatestandby -d /data/master/gpseg-1 -f (on server2)
  1. Change server1 as standby .
    gpinitstandby -s server1 (on server2)
    gpactivatestandby -d /data/master/gpseg-1 -f (on server1)
  2. restore server1 as master
    gpstop -m (on server2)
    gpactivatestandby -d /data/master/gpseg-1 -f (on server1)
  3. restore server2 as standby
    gpinitstandby -s server2 (on server1)


    MARK: pay attention to store or remove /data/master/gpseg-1 when do gpactivatestandby operation.

人气教程排行