#yasom自修复配置

# 开启yasom自修复

开启yasom自修复功能,可以在出现yasom多主异常的情况下进行自动修复,即保留1个主yasom并将其余的yasom自动降备,被降备的yasom会将自身的元数据备份至$YASDB_HOME/om/{集群名称}/data/repair/。

如自修复后数据库集群信息不符合预期,可使用yasboot cluster load命令重新加载信息。

# 前提条件

  • 自修复与yasom仲裁(yasboot election)互斥,若已开启yasom仲裁则无法使用自修复。

  • 需开启操作系统认证(遵循标准安装步骤时默认已开启)才能正常使用自修复功能。

# 操作步骤

  1. 以安装用户登录数据库服务器。

  2. 查看yasom进程信息。

    yasboot process yasom status -c yashandb -p sys_password
    +------------------------------------------------------------------------------------------------------------------------------------+
    | hostid   | pid   | ipaddr       | primary           | secondary | local_yasom_addr  | role    | backup_num | max_seq | auto_repair |
    +------------------------------------------------------------------------------------------------------------------------------------+
    | host0001 | 15080 | 192.168.1.2  | 192.168.1.2:1675  | []        | 192.168.1.2:1675 | primary | 2          | 39      | off         |
    +----------+-------+--------------+-------------------+-----------+-------------------+---------+------------+---------+-------------+
    | host0002 | -     | 192.168.1.3  | 192.168.1.2:1675  | []        | -                 | -       | 2          | 39      | -           |
    +----------+-------+--------------+-------------------+-----------+-------------------+---------+------------+---------+-------------+
    
  3. 在任一yasom进程所在服务器,执行如下命令开启自修复功能。

    yasboot process yasom repair on -c yashandb
    enable repair success
    
  4. 查看配置是否生效。

    yasboot process yasom status -c yashandb
    +------------------------------------------------------------------------------------------------------------------------------------+
    | hostid   | pid   | ipaddr       | primary           | secondary | local_yasom_addr  | role    | backup_num | max_seq | auto_repair |
    +------------------------------------------------------------------------------------------------------------------------------------+
    | host0001 | 15080 | 192.168.1.2  | 192.168.1.2:1675  | []        | 192.168.1.2:1675 | primary | 2          | 39      | on          |
    +----------+-------+--------------+-------------------+-----------+-------------------+---------+------------+---------+-------------+
    | host0002 | -     | 192.168.1.3  | 192.168.1.2:1675  | []        | -                 | -       | 2          | 39      | -           |
    +----------+-------+--------------+-------------------+-----------+-------------------+---------+------------+---------+-------------+
    

    auto_repair = on表示开启成功,仅主yasom会显示该状态。

# 关闭yasom自修复

  1. 以安装用户登录数据库服务器。

  2. 查看yasom进程信息。

    yasboot process yasom status -c yashandb
    +------------------------------------------------------------------------------------------------------------------------------------+
    | hostid   | pid   | ipaddr       | primary           | secondary | local_yasom_addr  | role    | backup_num | max_seq | auto_repair |
    +------------------------------------------------------------------------------------------------------------------------------------+
    | host0001 | 15080 | 192.168.1.2  | 192.168.1.2:1675  | []        | 192.168.1.2:1675 | primary | 2          | 39      | on          |
    +----------+-------+--------------+-------------------+-----------+-------------------+---------+------------+---------+-------------+
    | host0002 | -     | 192.168.1.3  | 192.168.1.2:1675  | []        | -                 | -       | 2          | 39      | -           |
    +----------+-------+--------------+-------------------+-----------+-------------------+---------+------------+---------+-------------+
    
  3. 在任一yasom进程所在服务器,执行如下命令开启自修复功能。

    yasboot process yasom repair off -c yashandb
    disable repair success
    
edit-icon
反馈
coperate-icon
coperate
合作
communication-icon
communicate
交流