New White Paper on HADR Read on Standby
svisser1 2700018UK9 Visits (5057)
There is a new white paper that I recently learned about that I thought I would pass on to you:
Continuous access to Read on Standby databases using Virtual IP addresses
The DB2® High Availability and Disaster Recover (HADR) feature is a database replication method that provides a high availability solution for both partial and complete site failures. HADR protects against data loss by replicating data changes from a source database, called the Primary, to a target database, called the Standby.
The HADR reads on standby (HADR ROS) feature, allows applications to access the current Standby databases for reads. With the HADR ROS feature, read/write applications can access the HADR Primary database, and read-only applications can access either the HADR Primary or the HADR Standby database. This enables you to offload some of the read-only workloads running on the Primary to the Standby.
This paper shows how you can use the HADR ROS feature in conjunction with Virtual IP addresses to ensure continued, automatic connectivity for read-only clients.
For the full paper, see: Continuous access to Read on Standby databases using Virtual IP addresses
PS… Thanks to Louise McNicoll and Steve Raspudic for passing this information to me.