#yasom自修复配置
# 开启yasom自修复
开启yasom自修复功能,可以在出现yasom多主异常的情况下进行自动修复,即保留1个主yasom并将其余的yasom自动降备,被降备的yasom会将自身的元数据备份至$YASDB_HOME/om/{集群名称}/data/repair/。
如自修复后数据库集群信息不符合预期,可使用yasboot cluster load命令重新加载信息。
# 前提条件
# 操作步骤
以安装用户登录数据库服务器。
查看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 | - | +----------+-------+--------------+-------------------+-----------+-------------------+---------+------------+---------+-------------+在任一yasom进程所在服务器,执行如下命令开启自修复功能。
yasboot process yasom repair on -c yashandb enable repair success查看配置是否生效。
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自修复
以安装用户登录数据库服务器。
查看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 | - | +----------+-------+--------------+-------------------+-----------+-------------------+---------+------------+---------+-------------+在任一yasom进程所在服务器,执行如下命令开启自修复功能。
yasboot process yasom repair off -c yashandb disable repair success

