METHOD AND SYSTEM FOR RECOVERY IN A PARTITIONED SHARED NOTHING DATABASE SYSTEM USING VIRTUAL SHARED DISKS

摘要

A method and system for recovering from a failure of a processing node in apartitioned shared nothing database processing systemare provided. The processing system may include a pair of processing nodeshaving twin-tailed-connected thereto a storage device. A firstprocessing node of the pair of processing nodes has a first database instancerunning thereon which accesses a first data partition on thestorage device prior to the failure. Upon detection of the failure, access tothe first data partition on the storage device is provided to a third,spare processing node through the second processing node of the pair ofprocessing nodes. The third processing node runs a replacementdatabase instance for the first database instance which was running on thefirst processing node prior to the failure thereof. The replacementdatabase instance accesses the first data partition on the storage devicethrough the second processing node, thereby recovering from thefailure of the first processing node. Access to the first data partition mayinclude using a virtual shared disk utility having a server portionon the second processing node and a client portion on the third processingnode.