Executive summary
Keeping up with today’s increasingly global and competitive marketplace requires a data processing architecture that provides the flexibility to grow with future strategic requirements and ensures business continuity throughout component outages, maintenance activities, and catastrophic events.
For some enterprises, a single hour of downtime can translate to millions of dollars of lost revenue, not to mention the damage to the company’s reputation and the potential loss of customers. Global enterprises operate across time zones and offer business services around the clock. Reserved offline windows for system maintenance and upgrades no longer exist. Distributed enterprises need the ability to provide proximity of service in each geographic location, coupled with the ability to circumvent network failures or transmission times.
This paper outlines an architecture that addresses these availability requirements.
In December 2009, IBM introduced the DB2 pureScale Feature for Enterprise Server Edition. The DB2 pureScale Feature builds on proven design features from the IBM DB2 for z/OS database software. The DB2 pureScale Feature is intended to meet the needs of many customers by providing:
-
- Virtually unlimited capacity: the ability to scale out your system by adding additional machines to your cluster with ease.
-
- Application transparency: the ability to leverage your existing applications without changes.
-
- Single site continuous availability: by providing an “all active” architecture with inherent redundancy.
-
- Reduced total cost of ownership (TCO): reducing the total cost of ownership by allowing for a simplified deployment and management of advanced technology.
Since its first release in 2004, the Q Replication technology has provided low-latency, high-volume replication for DB2. Q Replication complements the capabilities of pureScale by providing:
- Protection from disk and site failure by replicating the database to a remote site.
- Continuous availability during upgrades and full site maintenance by allowing the transfer of applications to another site until maintenance is completed, and the re- synchronization of these sites afterward
- Workload off-loading and live reporting by offloading reporting applications to another database, thereby eliminating any possible contention with business critical workloads, and allowing analytics and reporting on live data.
- Protection from data corruptions by maintaining a secondary copy of the database where changes are delayed in relation to the primary, allowing for a quick recovery from user or application errors.
By extending the DB2 pureScale Feature with Q Replication, you get scaling, reliability and transparency along with the protection and continuous availability of off-site replication. This paper discusses the considerations for this solution and describes how to deploy Q Replication with the DB2 pureScale Feature.
Introduction
The DB2 pureScale Feature leverages a shared-disk database implementation based on the DB2 for z/OS data-sharing architecture. It brings proven technology from the DB2 database software on the mainframe to open systems. Using the DB2 pureScale Feature offers the following key benefits:
-
Virtually unlimited capacity –The DB2 pureScale Feature provides practically unlimited capacity by allowing for the addition and removal of DB2 members on demand. The DB2 pureScale Feature can scale to 128 members and has a highly efficient centralized management facility that allows for very efficient scale out capabilities. The DB2 pureScale Feature also leverages a technology called Remote Direct Memory Access (RDMA) which provides a highly efficient inter- node communication mechanism that also facilitates its scaling capabilities.
-
Application transparency – An application that utilizes a DB2 pureScale database does not need to have any knowledge of the different members in the cluster or to be concerned about partitioning data. The DB2 pureScale Feature will automatically route applications to the members deemed most appropriate. The DB2 pureScale Feature also provides native support for a great deal of syntax used by other database vendors, allowing those applications to run in a DB2 pureScale environment with minimal or no changes. The benefits of the DB2 pureScale Feature can be leveraged in many cases without modifying the application.
-
Single site continuous availability – The DB2 pureScale Feature provides an “active-active” configuration such that if one member goes down, processing can continue at the remaining active members. During a member failure, in-process transaction data on the failing member is temporarily unavailable until database recovery completes, which typically is in the multiple seconds range.
-
Reduced TCO – The DB2 pureScale Feature can help reduce TCO through its integrated and simplified deployment and maintenance capabilities. The DB2 pureScale interfaces handle the deployment and maintenance of components integrated within the DB2 pureScale Feature.
Download the report to get started!