红帽全球峰会第 4 章 可选设置
4.1. 为 Active/Active (Read-Enabled)设置添加辅助虚拟 IP 地址资源
复制链接链接已复制到粘贴板!
从 SAP HANA 2.0 SPS1 开始，SAP 允许 SAP HANA System Replication 的"主动/主动(Read Enabled) "设置。这可让您：
- 启用 SAP HANA 系统复制，以支持辅助系统上的读取访问权限。
- 对辅助系统执行读取性报告，以从主系统中删除此工作负载。
- 降低持续操作中带宽的需求。
如需更多信息，请参阅 SAP HANA System Replication。
需要第二个虚拟 IP 地址来允许客户端访问辅助 SAP HANA 数据库。在失败的情况下，如果辅助站点无法访问，则第二个 IP 将切换到主站点，以避免出现只读访问的停机时间。
operationMode 应设置为 logreplay_readaccess。第二个虚拟 IP 和额外的必要的限制可以使用以下命令配置：
root# pcs resource create rsc_ip2_SAPHana_RH1_HDB10 ocf:heartbeat:IPaddr2 ip=10.0.0.251 op monitor interval="10s" timeout="20s
root# pcs resource create rsc_ip2_SAPHana_RH1_HDB10 ocf:heartbeat:IPaddr2 ip=10.0.0.251 op monitor interval="10s" timeout="20s4.1.1. 配置额外限制
复制链接链接已复制到粘贴板!
以上列出的约束严格推荐。要调整您的环境的行为，需要额外的限制。这些示例包括：
root# pcs constraint location rsc_ip_SAPHana_RH1_HDB10 rule score=500 role=master hana_rh1_roles eq "master1:master:worker:master" and hana_rh1_clone_state eq PROMOTED
root# pcs constraint location rsc_ip_SAPHana_RH1_HDB10 rule score=500 role=master hana_rh1_roles eq "master1:master:worker:master" and hana_rh1_clone_state eq PROMOTED
当次要站点停机时，将 IP2 移到主站点中：
root# pcs constraint location rsc_ip2_SAPHana_RH1_HDB10 rule score=50 id=vip_slave_master_constraint hana_rh1_roles eq 'master1:master:worker:master'
root# pcs constraint location rsc_ip2_SAPHana_RH1_HDB10 rule score=50 id=vip_slave_master_constraint hana_rh1_roles eq 'master1:master:worker:master'root# pcs constraint order promote rsc_SAPHana_RH1_HDB10-clone then start rsc_ip_SAPHana_RH1_HDB10
root# pcs constraint order promote rsc_SAPHana_RH1_HDB10-clone then start rsc_ip_SAPHana_RH1_HDB10root# pcs constraint order start rsc_ip_SAPHana_RH1_HDB10 then start rsc_ip2_SAPHana_RH1_HDB10
root# pcs constraint order start rsc_ip_SAPHana_RH1_HDB10 then start rsc_ip2_SAPHana_RH1_HDB10root# pcs constraint colocation add rsc_ip_SAPHana_RH1_HDB10 with Master rsc_SAPHana_RH1_HDB10-clone 2000
root# pcs constraint colocation add rsc_ip_SAPHana_RH1_HDB10 with Master rsc_SAPHana_RH1_HDB10-clone 2000root# pcs constraint colocation add rsc_ip2_SAPHana_RH1_HDB10 with Slave rsc_SAPHana_RH1_HDB10-clone 5
root# pcs constraint colocation add rsc_ip2_SAPHana_RH1_HDB10 with Slave rsc_SAPHana_RH1_HDB10-clone 5流程
如果集群正在运行，测试集群是否能够运行的行为
root# watch pcs status
root# watch pcs statusCopy to Clipboard Copied! Toggle word wrap Toggle overflow 使用以下命令手动停止 secondary HANA 实例：
sidadm% sapcontrol -nr ${TINSTANCE} -function StopSystem HDBsidadm% sapcontrol -nr ${TINSTANCE} -function StopSystem HDBCopy to Clipboard Copied! Toggle word wrap Toggle overflow 几秒钟后，第二台 IP 地址将移到主主机上。然后您可以使用以下内容再次手动启动数据库：
sidadm% sapcontrol -nr ${TINSTANCE} -function StartSystem HDBsidadm% sapcontrol -nr ${TINSTANCE} -function StartSystem HDBCopy to Clipboard Copied! Toggle word wrap Toggle overflow - 重启集群以进一步使用。
'%20d='M201.5%20305.5c-13.8%200-24.9-11.1-24.9-24.6%200-13.8%2011.1-24.9%2024.9-24.9%2013.6%200%2024.6%2011.1%2024.6%2024.9%200%2013.6-11.1%2024.6-24.6%2024.6zM504%20256c0%20137-111%20248-248%20248S8%20393%208%20256%20119%208%20256%208s248%20111%20248%20248zm-132.3-41.2c-9.4%200-17.7%203.9-23.8%2010-22.4-15.5-52.6-25.5-86.1-26.6l17.4-78.3%2055.4%2012.5c0%2013.6%2011.1%2024.6%2024.6%2024.6%2013.8%200%2024.9-11.3%2024.9-24.9s-11.1-24.9-24.9-24.9c-9.7%200-18%205.8-22.1%2013.8l-61.2-13.6c-3-.8-6.1%201.4-6.9%204.4l-19.1%2086.4c-33.2%201.4-63.1%2011.3-85.5%2026.8-6.1-6.4-14.7-10.2-24.1-10.2-34.9%200-46.3%2046.9-14.4%2062.8-1.1%205-1.7%2010.2-1.7%2015.5%200%2052.6%2059.2%2095.2%20132%2095.2%2073.1%200%20132.3-42.6%20132.3-95.2%200-5.3-.6-10.8-1.9-15.8%2031.3-16%2019.8-62.5-14.9-62.5zM302.8%20331c-18.2%2018.2-76.1%2017.9-93.6%200-2.2-2.2-6.1-2.2-8.3%200-2.5%202.5-2.5%206.4%200%208.6%2022.8%2022.8%2087.3%2022.8%20110.2%200%202.5-2.2%202.5-6.1%200-8.6-2.2-2.2-6.1-2.2-8.3%200zm7.7-75c-13.6%200-24.6%2011.1-24.6%2024.9%200%2013.6%2011.1%2024.6%2024.6%2024.6%2013.8%200%2024.9-11.1%2024.9-24.6%200-13.8-11-24.9-24.9-24.9z'/%3e%3c/svg%3e){kind=small}