将数据库节点备实例切换为主实例。
1、查询数据库状态。
gs_om -t status --detail [ Cluster State ]
cluster_state : Normal redistributing : No current_az : AZ_ALL
[ Datanode State ]
node
node_ip
port
instance
state
--------------------------------------------------------------------------------------------------
1 pekpopgsci00235 10.244.62.204 5432
6001 /home/wuqw/cluster/dn1/ P Primary
Normal
2 pekpopgsci00238 10.244.61.81 5432
6002 /home/wuqw/cluster/dn1/ S Standby
Normal
2、登录备节点,进行主备切换。另外,switchover 级联备机后,级联备机成为备机,
备机降为级联备。
gs_ctl switchover -D /home/wuqw/cluster/dn1/
[2020-06-17 14:28:01.730][24438][][gs_ctl]: gs_ctl switchover ,datadir is -D
"/home/wuqw/cluster/dn1" [2020-06-17 14:28:01.730][24438][][gs_ctl]: switchover term (1)
[2020-06-17 14:28:01.768][24438][][gs_ctl]: waiting for server to switchover............
[2020-06-17 14:28:11.175][24438][][gs_ctl]: done
[2020-06-17 14:28:11.175][24438][][gs_ctl]: switchover completed
(/home/wuqw/cluster/dn1)
3、保存数据库主备机器信息。
gs_om -t refreshconf
Generating dynamic configuration file for all nodes. Successfully generated dynamic
configuration file




