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

• US 20030177206A1
• Filed: 03/13/2002
• Published: 09/18/2003
• Est. Priority Date: 03/13/2002
• Status: Active Grant

• Current Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Whitlow, Troy Charles
• Granted Patent: US 7,228,344 B2
• Time in Patent Office: Days
• 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 (SQL), the method comprising:

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.

2. The method of claim 1, further comprising:

performing post installation testing.

3. The method of claim 1, further comprising:

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

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 of 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 an 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. A server implemented in a network in accordance with the method of claim 1.

14. 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, 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.

15. The apparatus of claim 14, 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.

16. The apparatus of claim 14, wherein an 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.

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

18. The apparatus of claim 14, wherein the first server is the primary owner of an eRoom virtual server, while the second server is the primary owner of an SQL virtual server.

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

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

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

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

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

24. An article of manufacture, comprising:

a machine-readable medium having stored thereon instructions to;

install hardware for cluster configuration;

install an operating system, SQL application, and eRoom application in a first server;

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;

perform 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

perform an SQL cluster configuration procedure to install the SQL application in the shared storage.

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

means for installing hardware for cluster configuration;

means for installing an operating system, SQL application, and eRoom application in a first server;

means for duplicating a disk image of the first server to a 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;

means for 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

means for performing an SQL cluster configuration procedure to install the SQL application in the shared storage.