KingbaseES V8R6集群运维案例之---repmgr standby promote应用案例

admin管理员组

文章数量:1130349

案例说明：
在容灾环境中，跨区域部署的异地备节点不会自主提升为主节点，在主节点发生故障或者人为需要切换时需要手动执行切换操作。若主节点已经失效，希望将异地备机提升为主节点。$bin/repmgr standby promote

适用版本： KingbaseES V8R6

集群节点信息：

ID | Name    | Role    | Status    | Upstream | repmgrd | PID   | Paused? | Upstream last seen
----+---------+---------+-----------+----------+---------+-------+---------+--------------------
 1  | node101 | standby |   running | node102  | running | 19312 | no      | 1 second(s) ago
 2  | node102 | primary | * running |          | running | 20658 | no      | n/a

主备流复制状态信息：

test=# select * from sys_stat_replication;
  pid  | usesysid | usename | application_name |  client_addr  | client_hostname | client_port |         backend_start         | backend_xmin |   state   |  sent_lsn  | write_lsn  | flush_lsn  | replay_lsn | write_lag | flush_lag | replay_lag | sync_priority | sync_state |          reply_time
-------+----------+---------+------------------+---------------+-----------------+-------------+-------------------------------+--
 20165 |       10 | system  | node101          | 192.168.1.101 |                 |       10747 | 2022-09-08 11:12:59.798843+08 |            | streaming | 4/4C0018A0 | 4/4C0018A0 | 4/4C0018A0 | 4/4C0018A0 |           |           |            |             1 | sync       | 2022-09-08 11:16:45.423742+08
(1 row)

关闭failover自动切换：

[kingbase@node102 bin]$ cat ../etc/repmgr.conf|grep failover
#failover='automatic'
failover='manual'

一、模拟主库数据库服务宕机

[kingbase@node102 bin]$ ./sy

案例说明：
在容灾环境中，跨区域部署的异地备节点不会自主提升为主节点，在主节点发生故障或者人为需要切换时需要手动执行切换操作。若主节点已经失效，希望将异地备机提升为主节点。$bin/repmgr standby promote

适用版本： KingbaseES V8R6

集群节点信息：

ID | Name    | Role    | Status    | Upstream | repmgrd | PID   | Paused? | Upstream last seen
----+---------+---------+-----------+----------+---------+-------+---------+--------------------
 1  | node101 | standby |   running | node102  | running | 19312 | no      | 1 second(s) ago
 2  | node102 | primary | * running |          | running | 20658 | no      | n/a

主备流复制状态信息：

test=# select * from sys_stat_replication;
  pid  | usesysid | usename | application_name |  client_addr  | client_hostname | client_port |         backend_start         | backend_xmin |   state   |  sent_lsn  | write_lsn  | flush_lsn  | replay_lsn | write_lag | flush_lag | replay_lag | sync_priority | sync_state |          reply_time
-------+----------+---------+------------------+---------------+-----------------+-------------+-------------------------------+--
 20165 |       10 | system  | node101          | 192.168.1.101 |                 |       10747 | 2022-09-08 11:12:59.798843+08 |            | streaming | 4/4C0018A0 | 4/4C0018A0 | 4/4C0018A0 | 4/4C0018A0 |           |           |            |             1 | sync       | 2022-09-08 11:16:45.423742+08
(1 row)

关闭failover自动切换：

[kingbase@node102 bin]$ cat ../etc/repmgr.conf|grep failover
#failover='automatic'
failover='manual'

一、模拟主库数据库服务宕机

[kingbase@node102 bin]$ ./sy

本文标签： 案例集群KingbaseESstandbyrepmgr