Browse Prior Art Database

Near Continuous Availability of Network Attached Relational Database Systems

IP.com Disclosure Number: IPCOM000014554D
Original Publication Date: 2002-Oct-29
Included in the Prior Art Database: 2003-Jun-19
Document File: 2 page(s) / 46K

Publishing Venue

IBM

Abstract

Near Continuous Availability Relational Database System

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 53% of the total text.

Page 1 of 2

Near Continuous Availability of Network Attached Relational Database Systems

Near Continuous Availability Relational Database System

Disclosed is a system configuration providing for near continuous availability of a relational database to provide high volume, 24 hour per day, 7 day per week operations support of critical applications such as sales over the Internet. The system utilizes multiple Intel processor-based or UNIX servers with commercially available software to achieve the Near Continuous Availability of the system. This is difficult to obtain because typically relational databases require periodic maintenance for backups and other system activities which frequently result in some hours of down time per week. Complicating the problem is the fact that high availability platforms address recovery, during failure scenarios, to the operating system level and do not aid relational database recoveries, which generally last at least 20 minutes or more. For critical applications that use relational databases, such downtimes may have a severe impact (such as lost sales).

The configuration uses one or more "front end" dispatcher computers to route requests for Relational Database Management System (RDBMS) service to either the primary or secondary RDBMS server as appropriate. When in normal operations, the primary and secondary RDBMS servers maintain duplicate databases and transmit updates between the two on a near continuous basis. For normal RDBMS maintenance, the secondary server can be worked on independently while the primary server continues to support operations. Upon completion of the maintenance activities, the secondary server will update the primary server...