A DB2 Performance Tuning Roadmap--Q-BASED A/A IMPLEMENATION
Why Active/Active ? - Business RequirementsSENARIO OF TWO NODE QREPObjects needed in WebSphere MQOBJECTS IN QPREPARE ACTIONQ CONTROL TABLES -PARMTABLESCreate Q MapsCreate Q subscriptionsQ HOUSE-KEEPINT WORK ACTIONCHANLE ACTION:MQ QUEUE ACTIONQAPPLYLatency analysisLATENCY OUTLOOKCAPTURE LATENCY ANALYSISQ Apply latencyQREP RECOVERY
现在IDC大行其道，同城/异地双活甚至多活的概念已经日益普及。12年的时候，写过一篇mysql中关于MASTER/SLAVE的实现mysql replication---master/salve IN ONE PC。针对不同的DBMS，双活具体的实现不同，但都基于相同的理论或是基于SQL REPLICATION,或是基于LOG REPLICATION。这里介绍一下IBM中关于A/A的实现，关于Ｑ的架构以及实现后面专门抽出一章来进行介绍，这里是实践贴，使你对Ｑ有一个感性认识。关于本文最后的Q latency部分，也是每一个系统运维人员都必须要掌握的，因为它对于RPO/RTO的重要性不言而喻。
Why Active/Active ? - Business Requirements
Replication Technologies for Business Continuity
Requirements and trade-offs to consider in selecting technologies:
What needs to be recovered?: Application Data vs. DBMS vs. Entire SystemsHow long does it take? Recovery Time Objective (RTO): One hours or more vs. few secondsHow much data could you lose? Recovery Point Objective (RPO): No data loss vs. seconds of dataDistance required between sites?: 10s of kilometers vs. 100s of kilometersHardware Utilization: Standby vs. ActiveImpact on applications: Direct overhead (synchronous technologies) vs. no impact (async technologies)CPU Overhead: Negligible (hardware e.g., PPRC) vs. Proportional to the workload (transaction replaytechnology)
SENARIO OF TWO NODE QREP
Objects needed in WebSphere MQ
OBJECTS IN Q
OBJECT DEFINE DESCRIPTION