文档中心MogDBMogDB StackUqbar
v3.1

文档:v3.1

支持的版本:

其他版本:

gs_sdr

背景信息

从MogDB 3.1.0版本开始,MogDB提供了gs_sdr工具,在不借助额外存储介质的情况下实现跨region的异地容灾。提供流式容灾搭建,容灾升主,计划内主备切换,容灾解除、容灾状态监控功能、显示帮助信息和显示版本号信息等功能。

前提条件

需以操作系统用户omm执行gs_sdr命令。

语法

  • 容灾搭建

    gs_sdr -t start -m [primary|disaster_standby] [-U DR_USERNAME] [-W DR_PASSWORD] [-X XMLFILE] [--json JSONFILE] [--time-out=SECS] [-l LOGFILE]
  • 容灾升主

    gs_sdr -t failover [-l LOGFILE]
  • 计划内主备切换

    gs_sdr -t switchover -m [primary|disaster_standby] [--time-out=SECS] [-l LOGFILE]
  • 容灾解除

    gs_sdr -t stop [-X XMLFILE] [--json JSONFILE] [-l LOGFILE]
  • 容灾状态监控

    gs_sdr -t query [-l LOGFILE]

参数说明

gs_sdr参数可以分为如下几类:

  • 通用参数:

    • -t

      gs_sdr命令的类型。

      取值范围:start、failover、switchover、stop、query。

    • -l

      指定日志文件及存放路径。

      默认值:$GAUSSLOG/om/gs_sdr-YYYY-MM-DD_hhmmss.log

    • -?, –help

      显示帮助信息。

    • -V, –version

      显示版本号信息。

  • 搭建容灾参数:

    • -m

      期望该集群在容灾关系中成为的角色

      取值范围:primary(主集群)或disaster_standby(灾备集群)

    • -U

      具有流复制权限的容灾用户名称

    • -W

      容灾用户密码

      img 说明:

      1. 搭建容灾关系前,主集群需创建容灾用户,用于容灾鉴权,主备集群必须使用相同的容灾用户名和密码,一次容灾搭建后,该用户密码不可修改。若需修改容灾用户名与密码,需要解除容灾,使用新的容灾用户重新进行搭建。容灾用户密码中不可包含以下字符“| ;&$<>`'“{}()[]~*?!\n空白”。
      2. -U、-W 参数如果搭建命令行未带,则在搭建过程中支持交互式输入。
    • -X

      集群安装时的xml,xml中也可以配置容灾信息用于容灾搭建,即在安装xml的基础上扩展三个字段(”localStreamIpmap1”、”remoteStreamIpmap1”、”remotedataPortBase”)

      新增字段的配置方式如下,加粗字体内容为示例。每行信息均有注释进行说明。

      <!-- 每台服务器上的节点部署信息 -->
      <DEVICELIST>
      <DEVICE sn="pekpomdev00038">
      <!-- 当前主机上需要部署的主DN个数 -->
      <PARAM name="dataNum" value="1"/>
      <!-- 主DN的基础端口号 -->
      <PARAM name="dataPortBase" value="26000"/>
      <!-- 本集群dn分片各节点用于SSH可信通道的IP与流复制的IP映射关系 -->
      <PARAM name="localStreamIpmap1" value="(10.244.44.216,172.31.12.58),(10.244.45.120,172.31.0.91)"/>
      <!-- 对端集群dn分片各节点用于SSH可信通道的IP与流复制的IP映射关系 -->
      <PARAM name="remoteStreamIpmap1" value="(10.244.45.144,172.31.2.200),(10.244.45.40,172.31.0.38),(10.244.46.138,172.31.11.145),(10.244.48.60,172.31.9.37),(10.244.47.240,172.31.11.125)"/>
      <!-- 对端集群的主dn端口号 -->
      <PARAM name="remotedataPortBase" value="26000"/>
      </DEVICE>
    • –json

      带有容灾信息的json文件。

      json文件的配置方式如下,加粗字体内容为示例。

      {"remoteClusterConf": {"port": 26000, "shards": [[{"ip": "10.244.45.144", "dataIp": "172.31.2.200"}, {"ip": "10.244.45.40", "dataIp": "172.31.0.38"}, {"ip": "10.244.46.138", "dataIp": "172.31.11.145"}, {"ip": "10.244.48.60", "dataIp": "172.31.9.37"}, {"ip": "10.244.47.240", "dataIp": "172.31.11.125"}]]}, "localClusterConf": {"port": 26000, "shards": [[{"ip": "10.244.44.216", "dataIp": "172.31.12.58"}, {"ip": "10.244.45.120", "dataIp": "172.31.0.91"}]]}}
      参数说明:
      # remoteClusterConf:对端集群的dn分片信息。其中port为对端集群主dn的端口,{"ip": "10.244.45.144", "dtaIp": "172.31.2.200"}为对端集群dn分片上各节点用于SSH可信通道的IP与流复制的IP映射关系。
      # localClusterConf:本集群的dn分片信息。其中port为本集群主dn的端口,{"ip": "10.244.44.216", "dtaIp": "172.31.12.58"}为本集群dn分片上各节点用于SSH可信通道的IP与流复制的IP映射关系。

      img 说明: -X与–json参数支持二选一方式进行配置容灾信息,如果命令行中两个参数全部下发,则以json为准。

    • –time-out=SECS

      指定超时时间,主集群会等待备集群连接的超时时间,超时则判定失败,om脚本自动退出。单位:s。

      取值范围:正整数,建议值1200。

      默认值:1200

  • 容灾升主参数:

  • 容灾解除参数:

    • -X

      集群安装时的xml,需要额外配置容灾信息,即扩展三个字段(”localStreamIpmap1”、”remoteStreamIpmap1”、”remotedataPortBase”)

    • –json

      带有本端及对端容灾信息的json文件。

      img 说明: -X、–json的配置方式请参考本节容灾搭建参数配置。

  • 容灾查询参数:

    容灾状态查询结果说明如下:

项目 含义 说明 备注
hadr_cluster_stat 流式容灾中数据库实例状态 normal 标识该数据库实例未参与流式容灾 -
hadr_cluster_stat 流式容灾中数据库实例状态 full_backup 主数据库实例数据全量复制中 流式容灾中仅主数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 archive 主数据库实例日志流式复制中 流式容灾中仅主数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 backup_fail 主数据库实例数据全量复制失败 流式容灾中仅主数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 archive_fail 主数据库实例日志流式复制失败 流式容灾中仅主数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 switchover 计划内主备倒换中 流式容灾中主备数据库实例皆有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 restore 灾备数据库实例数据全量恢复中 流式容灾中仅灾备数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 restore_fail 灾备数据库实例全备恢复失败 流式容灾中仅灾备数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 recovery 灾备数据库实例日志流式复制中 流式容灾中仅灾备数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 recovery_fail 灾备数据库实例日志流式复制失败 流式容灾中仅灾备数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 promote 灾备数据库实例升主中 流式容灾中仅灾备数据库实例有此状态
hadr_cluster_stat 流式容灾中数据库实例状态 promote_fail 灾备数据库实例升主失败 流式容灾中仅灾备数据库实例有此状态
hadr_switchover_stat 流式容灾主备数据库实例计划内倒换进度展示 百分比 倒换进度展示 -
hadr_failover_stat 流式容灾灾备数据库实例升主进度展示 百分比 倒换进度展示 -
RTO 此时发生灾难,数据恢复所需要的时长 数据库实例停机,网络异常等导致流式容灾中断 流式容灾中仅主数据库实例可查
RTO 此时发生灾难,数据恢复所需要的时长 非空 数据恢复所需要的时长,单位s 流式容灾中仅主数据库实例可查
RPO 此时发生灾难,数据库实例丢失的数据时长 数据库实例停机,网络异常等导致流式容灾中断 流式容灾中仅主数据库实例可查
RPO 此时发生灾难,数据库实例丢失的数据时长 非空 数据库实例可能丢失的数据时长,单位s 流式容灾中仅主数据库实例可查

示例

  • 主集群搭建容灾关系。

    gs_sdr -t start -m primary -X /opt/install_streaming_primary_cluster.xml --time-out=1200 -U 'hadr_user' -W 'Enmo@123'
    --------------------------------------------------------------------------------
    Streaming disaster recovery start 2b9bc268d8a111ecb679fa163e2f2d28
    --------------------------------------------------------------------------------
    Start create streaming disaster relationship ...
    Got step:[-1] for action:[start].
    Start first step of streaming start.
    Start common config step of streaming start.
    Start generate hadr key files.
    Streaming key files already exist.
    Finished generate and distribute hadr key files.
    Start encrypt hadr user info.
    Successfully encrypt hadr user info.
    Start save hadr user info into database.
    Successfully save hadr user info into database.
    Start update pg_hba config.
    Successfully update pg_hba config.
    Start second step of streaming start.
    Successfully check cluster status is: Normal
    Successfully check instance status.
    Successfully check cm_ctl is available.
    Successfully check cluster is not under upgrade opts.
    Start checking disaster recovery user.
    Successfully check disaster recovery user.
    Start prepare secure files.
    Start copy hadr user key files.
    Successfully copy secure files.
    Start fourth step of streaming start.
    Starting reload wal_keep_segments value: 16384.
    Successfully reload wal_keep_segments value: 16384.
    Start fifth step of streaming start.
    Successfully set [/omm/CMServer/backup_open][0].
    Start sixth step of streaming start.
    Start seventh step of streaming start.
    Start eighth step of streaming start.
    Waiting main standby connection..
    Main standby already connected.
    Successfully check cluster status is: Normal
    Start ninth step of streaming start.
    Starting reload wal_keep_segments value: {'6001': '128'}.
    Successfully reload wal_keep_segments value: {'6001': '128'}.
    Successfully removed step file.
    Successfully do streaming disaster recovery start.
  • 备集群搭建容灾关系。

    gs_sdr -t start -m disaster_standby -X /opt/install_streaming_standby_cluster.xml --time-out=1200 -U 'hadr_user' -W 'Enmo@123'
    --------------------------------------------------------------------------------
    Streaming disaster recovery start e34ec1e4d8a111ecb617fa163e77e94a
    --------------------------------------------------------------------------------
    Start create streaming disaster relationship ...
    Got step:[-1] for action:[start].
    Start first step of streaming start.
    Start common config step of streaming start.
    Start update pg_hba config.
    Successfully update pg_hba config.
    Start second step of streaming start.
    Successfully check cluster status is: Normal
    Successfully check instance status.
    Successfully check cm_ctl is available.
    Successfully check cluster is not under upgrade opts.
    Start build key files from remote cluster.
    Start copy hadr user key files.
    Successfully build and distribute key files to all nodes.
    Start fourth step of streaming start.
    Start fifth step of streaming start.
    Successfully set [/omm/CMServer/backup_open][2].
    Stopping the cluster by node.
    Successfully stopped the cluster by node for streaming cluster.
    Start sixth step of streaming start.
    Start seventh step of streaming start.
    Start eighth step of streaming start.
    Starting the cluster.
    Successfully started primary instance. Please wait for standby instances.
    Waiting cluster normal...
    Successfully started standby instances.
    Successfully check cluster status is: Normal
    Start ninth step of streaming start.
    Successfully removed step file.
    Successfully do streaming disaster recovery start.
  • 计划内主集群降备。

    gs_sdr -t switchover -m disaster_standby
    --------------------------------------------------------------------------------
    Streaming disaster recovery switchover 6897d15ed8a411ec82acfa163e2f2d28
    --------------------------------------------------------------------------------
    Start streaming disaster switchover ...
    Streaming disaster cluster switchover...
    Successfully check cluster status is: Normal
    Parse cluster conf from file.
    Successfully parse cluster conf from file.
    Successfully check cluster is not under upgrade opts.
    Got step:[-1] for action:[switchover].
    Stopping the cluster.
    Successfully stopped the cluster.
    Starting the cluster.
    Successfully started primary instance. Please wait for standby instances.
    Waiting cluster normal...
    Successfully started standby instances.
    Start checking truncation, please wait...
    Stopping the cluster.
    Successfully stopped the cluster.
    Starting the cluster.
    Successfully started primary instance. Please wait for standby instances.
    Waiting cluster normal...
    Successfully started standby instances.
    .
    The cluster status is Normal.
    Successfully removed step file.
    Successfully do streaming disaster recovery switchover.
  • 计划内备集群升主。

    gs_sdr -t switchover -m primary
    --------------------------------------------------------------------------------
    Streaming disaster recovery switchover 20542bbcd8a511ecbbdbfa163e77e94a
    --------------------------------------------------------------------------------
    Start streaming disaster switchover ...
    Streaming disaster cluster switchover...
    Waiting for cluster and instances normal...
    Successfully check cluster status is: Normal
    Parse cluster conf from file.
    Successfully parse cluster conf from file.
    Successfully check cluster is not under upgrade opts.
    Waiting for switchover barrier...
    Got step:[-1] for action:[switchover].
    Stopping the cluster by node.
    Successfully stopped the cluster by node for streaming cluster.
    Starting the cluster.
    Successfully started primary instance. Please wait for standby instances.
    Waiting cluster normal...
    Successfully started standby instances.
    Successfully check cluster status is: Normal
    Successfully removed step file.
    Successfully do streaming disaster recovery switchover.
  • 灾备集群容灾升主。

    gs_sdr -t failover
    --------------------------------------------------------------------------------
    Streaming disaster recovery failover 65535214d8a611ecb804fa163e2f2d28
    --------------------------------------------------------------------------------
    Start streaming disaster failover ...
    Got step:[-1] for action:[failover].
    Successfully check cluster status is: Normal
    Successfully check cluster is not under upgrade opts.
    Parse cluster conf from file.
    Successfully parse cluster conf from file.
    Got step:[-1] for action:[failover].
    Starting drop all node replication slots
    Finished drop all node replication slots
    Stopping the cluster by node.
    Successfully stopped the cluster by node for streaming cluster.
    Start remove replconninfo for instance:6001
    Start remove replconninfo for instance:6002
    Start remove replconninfo for instance:6003
    Start remove replconninfo for instance:6005
    Start remove replconninfo for instance:6004
    Successfully removed replconninfo for instance:6001
    Successfully removed replconninfo for instance:6004
    Successfully removed replconninfo for instance:6003
    Successfully removed replconninfo for instance:6002
    Successfully removed replconninfo for instance:6005
    Start remove pg_hba config.
    Finished remove pg_hba config.
    Starting the cluster.
    Successfully started primary instance. Please wait for standby instances.
    Waiting cluster normal...
    Successfully started standby instances.
    Successfully check cluster status is: Normal
    Try to clean hadr user info.
    Successfully clean hadr user info from database.
    Successfully removed step file.
    Successfully do streaming disaster recovery failover.
  • 主集群容灾解除。

    gs_sdr -t stop -X /opt/install_streaming_standby_cluster.xml
    --------------------------------------------------------------------------------
    Streaming disaster recovery stop dae8539ed8a611ecade9fa163e77e94a
    --------------------------------------------------------------------------------
    Start remove streaming disaster relationship ...
    Got step:[-1] for action:[stop].
    Start first step of streaming stop.
    Start second step of streaming start.
    Successfully check cluster status is: Normal
    Check cluster type succeed.
    Successfully check cluster is not under upgrade opts.
    Start third step of streaming stop.
    Start remove replconninfo for instance:6001
    Start remove replconninfo for instance:6002
    Successfully removed replconninfo for instance:6001
    Successfully removed replconninfo for instance:6002
    Start remove cluster file.
    Finished remove cluster file.
    Start fourth step of streaming stop.
    Start remove pg_hba config.
    Finished remove pg_hba config.
    Start fifth step of streaming start.
    Starting drop all node replication slots
    Finished drop all node replication slots
    Start sixth step of streaming stop.
    Successfully check cluster status is: Normal
    Try to clean hadr user info.
    Successfully clean hadr user info from database.
    Successfully removed step file.
    Successfully do streaming disaster recovery stop.
  • 查询容灾状态。

    gs_sdr -t query
    --------------------------------------------------------------------------------
    Streaming disaster recovery query 1201b062d8a411eca83efa163e2f2d28
    --------------------------------------------------------------------------------
    Start streaming disaster query ...
    Successfully check cluster is not under upgrade opts.
    Start check archive.
    Start check recovery.
    Start check RPO & RTO.
    Successfully execute streaming disaster recovery query, result:
    {'hadr_cluster_stat': 'archive', 'hadr_failover_stat': '', 'hadr_switchover_stat': '', 'RPO': '0', 'RTO': '0'}
Copyright © 2011-2024 www.enmotech.com All rights reserved.