当前位置：首页 -> AI编程基础 -> 数据库编程

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

2014-11-24 17:09:19 · 作者: · 浏览: 0
标签: greenplum 激活 standby 恢复 master 原有 角色
定义：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.