Home >Database >Mysql Tutorial >greenplum激活standby和恢复master原有角色

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 15:22:341702browse

定义: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.
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:dba_enabled_aggregationsNext article:数据库中的关系运算