Method and system for workload balancing in a network of computer systems

• US 7,120,704 B2
• Filed: 01/31/2002
• Issued: 10/10/2006
• Est. Priority Date: 01/31/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ganduri, Shivram, Pickel, James
• Primary Examiner(s): Dharia, Rupal
• Assistant Examiner(s): Bayard, Djenane M.
• Application Number:
  US10/066,049
• Publication Number:
  US 20030145113A1
• Time in Patent Office: 1,713 Days
• Field of Search: 709/105, 709/225, 709/226, 709/248, 709/228, 709/229, 707200-203
• US Class Current: 709/248
• CPC Class Codes: H04L 61/00 Network arrangements, protocols or services for addressing or naming
• CPC Class Codes: H04L 61/45 Network directories; Name-to-address mapping
• CPC Class Codes: H04L 67/1001 for accessing one among a plurality of replicated servers
• CPC Class Codes: H04L 67/1008 based on parameters of servers, e.g. available memory or workload monitoring of computer activity G06F11/30
• CPC Class Codes: H04L 67/1038 Load balancing arrangements to avoid a single path through a load balancer
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method and system for connecting a client to a database managed by a network of computer systems having a plurality of database management system (DBMS) members includes providing a shared network address for the plurality of DBMS members, which is used by the client to connect to an active DBMS member of the plurality of DBMS members.

Through the aspects of the present invention, the shared network address allows the client to connect, via a network router, to any one of the plurality of DBMS members so long as one member is active. Once the client is connected to one member, the member sends to the client a list of all active members and their respective workloads. The list also includes member-specific network addresses corresponding to each member so that the client can distribute work evenly across the active members and also perform a resynchronization process with a DBMS member after a first connection with the DBMS member has been interrupted.

Claims

1. A method for connecting a client to a database managed by a network of computer systems, the network of computer systems including a plurality of database management system (DBMS) members, the method comprising the steps of:

(a) providing a shared network address for the plurality of DBMS members;

(b) utilizing the shared network address by the client to connect to an active DBMS member of the plurality of DBMS members;

(c) assigning each DBMS member in the plurality of DBMS members a corresponding member-specific network address, wherein the member-specific network address is associated with the corresponding member regardless of its location; and

(d) utilizing the member-specific network address of a DBMS member to re-establish a connection to the DBMS member for performing a resynchronization process after a first connection to the DBMS member has been interrupted.

2. The method of claim 1, wherein the shared network address is common to each DBMS member of the plurality of DBMS members.

3. The method of claim 1, wherein the utilizing step (b) further includes the steps of:

(b1) submitting a domain name for the database location to a domain name server coupled to the client;

(b2) resolving the domain name to the shared network address; and

(b3) returning the shared network address to the client from the domain name server.

4. The method of claim 1, wherein the utilizing step (b) further includes the step of:

(b1) sending the shared network address by the client to a network router coupled to the network of computer systems.

5. The method of claim 1, wherein the utilizing step (b) further includes the step of:

(b1) determining which ones of the plurality of DBMS members located at the shared network address are active.

6. The method of claim 5, wherein the determining step (b1) further includes:

(b1i) communicating with a work load manager coupled to the plurality of DBMS members, wherein the work load manager monitors the status and workload of each active DBMS member.

7. The method of claim 5, wherein the utilizing step (b) further includes the step of:

(b2) connecting the client to any one of the active DBMS members located at the shared network address.

8. The method of claim 5, further comprising the step of:

(c) transmitting to the client a list of active DBMS members from an active DBMS member.

9. The method of claim 5, further comprising the steps of:

(e) providing a weighted load for each active DBMS member; and

(f) identifying a member-specific network address associated with each active DBMS member.

10. The method of claim 9, further comprising the step of:

(g) balancing a workload across the active DBMS members based on their respective weighted loads.

11. A computer readable medium containing programming instructions for connecting a client to a database managed by a network of computer systems, the network of computer systems including a plurality of database management system (DBMS) members, comprising programming instruction for:

(a) providing a shared network address for the plurality of DBMS members;

(b) utilizing the shared network address by the client to connect to an active DBMS member of the plurality of DBMS members;

(c) assigning each DBMS member in the plurality of DBMS members a corresponding member-specific network address, wherein the member-specific network address is associated with the corresponding member regardless of its location; and

(d) utilizing the member-specific network address of a DBMS member to re-establish a connection to the DBMS member for performing a resynchronization process after a first connection to the DBMS member has been interrupted.

12. The computer readable medium of claim 11, wherein the shared network address is common to each DBMS member of the plurality of DBMS members.

13. The computer readable medium of claim 11, wherein the utilizing instruction (b) further includes the instructions for:

(b1) submitting a domain name for the database location to a domain name server coupled to the client;

(b2) resolving the domain name to the shared network address; and

(b3) returning the shared network address to the client from the domain name server.

14. The computer readable medium of claim 11, wherein the utilizing instruction (b) further includes the instruction for:

(b1) sending the shared network address by the client to a network router coupled to the network of computer systems.

15. The computer readable medium of claim 11, wherein the utilizing instruction (b) further includes the instruction for:

(b1) determining which ones of the plurality of DBMS members located at the shared network address are active.

16. The computer readable medium of claim 15, wherein the determining instruction (b1) further includes:

(b1i) communicating with a work load manager coupled to the plurality of DBMS members, wherein the work load manager monitors the status and workload of each active DBMS member.

17. The computer readable medium of claim 15, wherein the utilizing instruction (b) further includes the instructions for:

(b2) connecting the client to any one of the active DBMS members located at the shared network address.

18. The computer readable medium of claim 15, further comprising the instruction for:

(e) transmitting to the client a list of active DBMS members from an active DBMS member.

19. The computer readable medium of claim 15, further comprising the instructions for:

(e) providing a weighted load for each active DBMS member; and

(f) identifying the member-specific network address associated with each active DBMS member.

20. The computer readable medium of claim 19, further comprising the instruction for:

(g) balancing a workload across the active DBMS members based on their respective weighted loads.

21. A system for connecting a client to a database managed by a network of computer systems, the network of computer systems including a plurality of database management system (DBMS) members, the system comprising:

a shared network address for the plurality of DBMS members; and

a network router coupled to the client for utilizing the shared network address to connect the client to an active DBMS member of the plurality of DBMS members; and

means for assigning a corresponding member-specific network address for each DBMS member, wherein the member-specific network address is associated with the corresponding member regardless of its location,

wherein the client utilizes the member-specific network address to perform a resynchronization process with a DBMS member after a first connection with the DBMS member has been interrupted.

22. The system of claim 21, wherein the shared network address is common to each DBMS member of the plurality of DBMS members.

23. The system of claim 21, further comprising:

a domain name server coupled to the client, wherein the client submits a domain name for the network of computer systems to the domain name server and the domain name server resolves the domain name to the shared network address and returns the shared network address to the client.

24. The system of claim 21, wherein the network router comprises means for determining which ones of the plurality of DBMS members located at the shared network address are active.

25. The system of claim 24, wherein the determining means includes a work load manager coupled to the plurality of DBMS members, wherein the work load manager monitors the status and workload of each active DBMS member and communicates the status to the network router.

26. The system of claim 24, wherein each active DBMS member further includes means for transmitting a list of active DBMS members to the client.

27. The system of claim 24, further comprising:

means for providing a weighted load for each active DBMS member; and

means for identifying a member-specific network address associated with each active DBMS member.

28. The system of claim 27, further comprising:

means for distributing work evenly across the active DBMS members based on their respective weighed loads.