Method and system for recovery in a partitioned shared nothing d

Details Method and system for recovery in a partitioned shared nothing d Method and system for recovery in a partitioned shared nothing d

1997-05-29

1999-05-25

Kim, Matthew M.

Data processing: database and file management or data structures

Database design

Data structure types

707201, 707203, 707204, G06F 1700

Patent

active

059078499

ABSTRACT:
A method and system for recovering from a failure of a processing node in a partitioned shared nothing database processing system are provided. The processing system may include a pair of processing nodes having twin-tailed-connected thereto a storage device. A first processing node of the pair of processing nodes has a first database instance running thereon which accesses a first data partition on the storage device prior to the failure. Upon detection of the failure, access to the first data partition on the storage device is provided to a third, spare processing node through the second processing node of the pair of processing nodes. The third processing node runs a replacement database instance for the first database instance which was running on the first processing node prior to the failure thereof. The replacement database instance accesses the first data partition on the storage device through the second processing node, thereby recovering from the failure of the first processing node. Access to the first data partition may include using a virtual shared disk utility having a server portion on the second processing node and a client portion on the third processing node.

REFERENCES:
patent: 3702006 (1972-10-01), Page
patent: 4633387 (1986-12-01), Hartung et al.
patent: 4769772 (1988-09-01), Dwyer
patent: 4819159 (1989-04-01), Shipley et al.
patent: 4843541 (1989-06-01), Bean et al.
patent: 4853843 (1989-08-01), Ecklund
patent: 4920487 (1990-04-01), Baffes
patent: 4925311 (1990-05-01), Neches et al.
patent: 5269013 (1993-12-01), Abramson et al.
patent: 5440727 (1995-08-01), Bhide et al.
patent: 5450584 (1995-09-01), Sekiguchi et al.
patent: 5555404 (1996-09-01), Torbjorsen et al.
patent: 5734896 (1998-03-01), Rizvi et al.
patent: 5764905 (1998-06-01), Catozzi et al.
D.M. Dias, B.R. Iyer and P.S. Yu, "Hybrid Data Sharing--Function Shipping Architecture for Multi-Systems and Control"; IBM Technical Disclosure Bulletin; vol. 30, No. 10; Mar. 1988, pp. 453-454.
Y.H. Lee and P.S. Yu, "FMRT: An Efficient Transaction Routing and Load Sharing Algorithm"; IBM Technical Disclosure Bulletin; vol. 33, No. 10B; Mar. 1991, pp. 355-360.
M. Auslander, A. Chang, S. Morgan, S. Moore, J.C. O'Quin and J.T. O'Quin, "Mirroring of Data on a Partition Basis", Reproduced from Research Disclosure, Jul. 1990, No. 315; Kenneth Mason Publications Ltd., England.
D.W. Cornell, D.M. Dias and P.S. Yu, "On Multisystem Coupling Through Function Request Shipping," IEEE Transactions on Software Engineering, vol. SE-12, No. 10, Oct. 1986, pp. 1006-1017.
P.S. Yu, D. Cornell, D.M. Dias and A. Thomasian, "Performance Comparison of IO Shipping and Database Call Shipping: Schemes in Multisystem Partitioned Databases," North-Holland Performance Evaluation 10 (1989), pp. 15-33.
J.L. Wolf, D.M. Dias, B.R. Iyer and P.S. Yu, "Multisystem Coupling by a Combination of Data Sharing and Data Partitioning," IEEE Transactions on Engineering, vol. 15, No. 7, Jul. 1989, pp. 854-860.

Affiliated with

Also associated with

Rating

Method and system for recovery in a partitioned shared nothing d does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for recovery in a partitioned shared nothing d, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for recovery in a partitioned shared nothing d will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-409139