High availability enhancement for servers using structured query language (SQL)

• US 7,228,344 B2
• Filed: 03/13/2002
• Issued: 06/05/2007
• Est. Priority Date: 03/13/2002
• Status: Expired due to Fees

• Current Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Whitlow, Troy Charles
• Primary Examiner(s): Vaughn, Jr.; William C.
• Assistant Examiner(s): GAYESKI, MICHAEL R
• Application Number:
  US10/097,989
• Publication Number:
  US 20030177206A1
• Time in Patent Office: 1,910 Days
• Field of Search: 709/220, 709/221, 709/222, 707/3, 714/13, 714/6, 714/7, 714/11
• US Class Current: 709/220
• CPC Class Codes: G06F 9/5072 Grid computing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A method of providing high availability enhancement for servers using structured query language (SQL), includes: installing hardware for cluster configuration; installing an operating system, SQL application, and eRoom application in a first server; duplicating a disk image of the first server to a second server; performing an initial cluster configuration procedure for eventually permitting the first server and second server to function in a clustered configuration; performing an eRoom cluster configuration procedure to permit one of the first server and second server to run the eRoom application that is installed in a shared storage in the cluster configuration; and performing an SQL cluster configuration procedure to install the SQL application in the shared storage. An apparatus for providing high availability enhancement for servers using structured query language (SQL), includes: a cluster configuration including a first server, a second server, and a shared storage, where an eRoom application is configured to run on one of the first server and second server, with the eRoom application installed in a shared disk in the shared storage, and where the shared disk is configured to move to the other one of the first server and second server as part of the cluster configuration on fail-over.

Claims

1. A method of providing high availability enhancement for servers using structured query language comprising:

installing hardware for cluster configuration, where the hardware is used for clustering operations;

installing an operating system, SQL application, and eRoom application in a first server, wherein the eRoom application provides a web collaboration solution, and the SQL application provides database protection;

duplicating a disk image of the first server to a second server;

performing an initial cluster configuration procedure for eventually permitting the first server and second server to function in a clustered configuration, including installing a shared storage coupled to the first server and to the second server and creating a first shared logical disk, a second shared logical disk, and a third shared logical disk in the shared storage;

performing an eRoom cluster configuration procedure to permit one of the first server and second server to run the eRoom application with cluster resources installed in the shared storage in the cluster configuration, including storing disk resources for the cluster configuration in the first shared logical disk and copying program files and server data of the eRoom application from the first server to the second shared logical disk;

performing a SQL cluster configuration procedure to install the SQL application in the shared storage, including uninstalling the SQL application from the first server and the second server and installing the SQL application to the third shared logical disk;

running the eRoom application on one of the first server and second server, where the eRoom application is installed in a shared disk in the shared storage; and

resetting all Open Database Connectivity Format connections for databases for eRoom applications to point the first server and the second server to the shared storage.

2. The method of claim 1, further comprising:

performing post installation testing.

3. The method of claim 1, further comprising:

moving the shared disk to the other one of the first server and second server as part of the cluster configuration on fail-over.

4. The method of claim 1, wherein the performing the initial cluster configuration procedure includes changing a first set of drive letters of disks in the first server and in the second server.

5. The method of claim 1, wherein the performing the SQL cluster configuration procedure includes changing a second set of drive letters of disks in the first server and in the second server.

6. The method of claim 1, wherein each the first server and the second server includes similar hardware components.

7. The method of claim 1, wherein the first server is the primary owner of an eRoom virtual server, while the second server is the primary owner of a SQL virtual server.

8. The method of claim 1, wherein the duplicating the disk image is performed by use of a backup software.

9. The method of claim 1, wherein the duplicating the disk image is performed by use of a disk imaging product.

10. The method of claim 1, wherein the shared storage includes a foundation eRoom resource for the cluster dependencies.

11. The method of claim 1, wherein the shared storage includes a foundation SQL resource for the cluster dependencies.

12. The method of claim 1, wherein the shared storage includes a Quorum disk to provide essential disk resource for the cluster.

13. The method of claim 1, wherein installing the operating system, SQL application, and eRoom application in the first server comprises:

installing script files and setup files of the eRoom application in a first logical disk in the first server, the first logical disk having a first drive name;

installing program files of the eRoom application and server data of the eRoom application in a second logical disk in the first server, the second logical disk having a second drive name;

installing the operating system and program files of the SQL application in the first logical disk; and

installing data files of the SQL application in a third logical disk in the first server, the third logical disk having a third drive name.

17. The method of claim 1, further comprising:

copying user databases in the first server and the second server to the third shared logical disk.

18. The method of claim 1, wherein the eRopm application will run on the first server if the first server owns the second shared logical disk, and wherein the eRoom application run on the second server if the second server owns the second shared logical disk.

14. The method of 13, wherein duplicating the disk image of the first server to the second server comprises:

duplicating a disk image of the first logical disk to a fourth logical disk in the second server;

duplicating a disk image of the second logical disk to a fifth logical disk in the second server; and

duplicating a disk image of the third logical disk to a sixth logical disk in the second server.

15. The method of claim 14, wherein prior to storing disk resources for the cluster configuration in the first shared logical disk and copying program files and server data of the eRoom application from the first server to the second shared logical disk, changing the second drive name in the first server to a fourth drive name, and setting the second shared logical disk to the second drive name.

16. The method of claim 15, wherein prior to installing the SQL application to the third shared logical disk, changing the third drive name in the first server to a fifth drive name, and setting the third shared logical disk to the third drive name.

19. An apparatus for providing high availability enhancement for servers using structured query language (SQL), the apparatus comprising:

a cluster configuration including a first server, a second server, and a shared storage coupled to the first server and to the second server, where an eRoom application is configured to run on one of the first server and second server, with cluster resources of the eRoom application installed in a shared disk in the shared storage,

where the shared storage includes a first shared logical disk, a second shared logical disk, and a third shared logical disk,

where the first shared logical disk stores disk resources for the cluster configuration, where program files and server data of the eRoom application are copied from the first server to the second shared logical disk, and where the SQL application is uninstalled from the first server and the second server and is installed to the third shared logical disk,

where resources of the eRoom application and SQL application in the shared disk are configured to move to the other one of the first server and second server as part of the cluster configuration on fail-over, and

where all Open Database Connectivity Format connections for databases for eRoom applications are reset in order to point the first server and the second server to the shared storage.

20. The apparatus of claim 19, wherein an initial cluster configuration procedure is performed including changing a first set of drive letters of disks in the first server and in the second server.

21. The apparatus of claim 19, wherein a SQL cluster configuration procedure is performed including changing a second set of drive letters of disks in the first server and in the second server.

22. The apparatus of claim 19, wherein each of the first server and the second server includes similar hardware components.

23. The apparatus of claim 19, wherein the first server is the primary owner of an eRoom virtual server, while the second server is the primary owner of a SQL virtual server.

24. The apparatus of claim 19, wherein a disk image in the first server is duplicated to the second server by use of a backup software.

25. The apparatus of claim 19, wherein a disk image in the first server is duplicated to the second server by use of a disk imaging product.

26. The apparatus of claim 19, wherein the shared storage includes a foundation eRoom resource for the cluster dependencies.

27. The apparatus of claim 19, wherein the shared storage includes a foundation SQL resource for the cluster dependencies.

28. The apparatus of claim 19, wherein the shared storage includes a Quorum disk to provide essential disk resource for the cluster.

29. The apparatus of claim 19, wherein script files and setup files of the eRoom application are installed in a first logical disk in the first server, where the first logical disk has a first drive name;

wherein program files of the eRoom application and server data of the eRoom application are installed in a second logical disk in the first server, where the second logical disk has a second drive name;

wherein the operating system and program files of the SQL application are installed in the first logical disk; and

wherein data files of the SQL application are installed in a third logical disk in the first server, where the third logical disk has a third drive name.

33. The apparatus of claim 19, wherein user databases in the first server and the second server is copied to the third shared logical disk.

34. The apparatus of claim 19, wherein the eRoom application will run on the first server if the first server owns the second shared logical disk, and wherein the eRoom application will run on the second server if the second server owns the second shared logical disk.

30. The apparatus of 29, wherein a disk image of the first logical disk is duplicated to a fourth logical disk in the second server;

wherein a disk image of the second logical disk is duplicated to a fifth logical disk in the second server; and

wherein a disk image of the third logical disk is duplicated to a sixth logical disk in the second server.

31. The apparatus of claim 30, wherein prior to storing disk resources for the cluster configuration in the first shared logical disk and copying program files and server data of the eRoom application from the first server to the second shared logical disk, the second drive name in the first server is changed to a fourth drive name, and the second shared logical disk set to the second drive name.

32. The apparatus of claim 31, wherein prior to installing the SQL application to the third shared logical disk, the third drive name in the first server is changed to a fifth drive name, and the third shared logical disk is set to the third drive name.

35. An article of manufacture, comprising:

a machine-readable medium having stored thereon instructions to;

install hardware for cluster configuration, where the hardware is used for clustering operations;

install an operating system, SQL application, and eRoom application in a first server, wherein the eRoom application provides a web collaboration solution, and the SQL application provides database protection;

duplicate a disk image of the first server to a second server;

perform an initial cluster configuration procedure for eventually permitting the first server and second server to function in a clustered configuration, including installing a shared storage coupled to the first server and to the second server and creating a first shared logical disk, a second shared logical disk, and a third shared logical disk in the shared storage;

perform an eRoom cluster configuration procedure to permit one of the first server and second server to run the eRoom application with cluster resources installed in the shared storage in the cluster configuration, including storing disk resources for the cluster configuration in the first shared logical disk and copying program files and server data of the eRoom application from the first server the second shared logical disk;

perform a SQL cluster configuration procedure to install the SQL application in the shared storage, including uninstalling the SQL application from the first server and the second server and installing the SQL application to the third shared logical disk; and

reset all Open Database Connectivity Format connections for databases for eRoom applications to point the first server and the second server to the shared storage.

36. An apparatus for providing high availability enhancement for servers using structured query language (SQL), the apparatus comprising:

means for installing hardware for cluster configuration, where the hardware is used for clustering operations;

means for installing an operating system, SQL application, and eRoom application in a first server, wherein the eRoom application provides a web collaboration solution, and the SQL application provides database protection;

means for duplicating a disk image the first server second server;

means for performing an initial cluster configuration procedure for eventually permitting the first server and second server to function in a clustered configuration, including means for installing a shared storage coupled to the first server and to the second server and for creating a first shared logical disk, a second shared logical disk, and a third shared logical disk in the shared storage;

means for performing an eRoom cluster configuration procedure to permit one of the first server and second server to run the eRoom application with cluster resources installed in the shared storage in the cluster configuration, including means for storing disk resources for the cluster configuration in the first shared logical disk and for copying program files and server data of the eRoom application from the first server to the second shared logical disk;

means for performing a SQL cluster configuration procedure to install the SQL application in the shared storage, including means for uninstalling the SQL application from the first server and the second server and for installing the SQL application to the third shared logical disk; and

means for resetting all Open Database Connectivity Format connections for databases for eRoom applications to point the first server and the second server to the shared storage.