请问一下:
1.HADR的典型最佳实践案例?
2.切换方式与案例?同步时延,基础环境条件(网络带宽、数据量、交易并发量)?
3.如果故障交易从主机切至备机,那同步机制如何变化?以及如何切换后回切?
db2haicu -disable
db2pd -db xxx -hadr
Shutdown the HADR operation
A: Deactivate the primary database
db2 deactivate database sample
B: Stop DB2 on the primary database
db2stop force
C: Deactivate the standby database
db2 deactivate database sample
D: Stop DB2 on the standby database
db2stop
Start the HADR operation
A: db2 activate database sample ----standby database
or
db2 start hadr on database sample as standby
B: db2 activate database sample ----primary database
or
db2 start hadr on database sample as primary
or
db2 connect to sample
db2haic带有HADR环境的升级
Primary server:
先把HADR切换到secondary server(在secondary server, TAKEOVER HADR ON DATABASE)
deactivate database
db2stop
install fixpack/upgrade
db2start
db2 activate database <db_name> u -enable
1、相关实践案例可以参考:http://www.talkwithtrend.com/Article/243929,这个方案
2、HADR切换方式分为正常切换及强制切换,正常切换适用于主备库均正常情况下进行的主备切换,强制切换适用于主库已经宕库情况下执行强制切换。
3、主库切换至备库后,同步机制不变,后续可以根据需求进行正常主备库切换。