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

    公开(公告)号:CA2288016C

    公开(公告)日:2004-11-16

    申请号:CA2288016

    申请日:1998-05-27

    Applicant: IBM

    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 instanc e running thereon which accesses a first data partition on the storage device prior to the failure. Upon detection of the failure, access t o 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.

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

    公开(公告)号:CA2288016A1

    公开(公告)日:1998-12-03

    申请号:CA2288016

    申请日:1998-05-27

    Applicant: IBM

    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.

Patent Agency Ranking