Systems and methods for server management

• US 9,886,508 B2
• Filed: 05/20/2014
• Issued: 02/06/2018
• Est. Priority Date: 02/15/2006
• Status: Active Grant

• Current Assignee: Sony Interactive Entertainment LLC (Sony Group Corp.)
• Original Assignee: Sony Interactive Entertainment America LLC (Sony Group Corp.)
• Inventors: Harris, Adam Pierce
• Primary Examiner(s): Pham, Khanh
• Application Number:
  US14/283,114
• Publication Number:
  US 20140310309A1
• Time in Patent Office: 1,358 Days
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: H04L 12/18 for broadcast or conference , e.g. multicast
• 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/1029 using data related to the state of servers by a load balancer
• CPC Class Codes: H04L 67/1034 Reaction to server failures by a load balancer
• CPC Class Codes: Y10S 707/966 Distributed
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

Exemplary systems and methods for server management are provided. An exemplary system comprises a plurality of servers, with each server having the ability to access a database or, in some embodiments, be configured to perform a calculation, computation or make a determination of a particular value, values or other information. A communications network delivers queries to each server whereby a look-up table directs query processing by the servers. Further embodiments of the system feature a program logic controller for rebalancing the workload of the network servers. Exemplary methods of processing queries on the system comprise submitting a query to the network, communicating the query to each server in the network and each server looking-up on a look-up table the processing responsibilities of the servers in the network. The query is processed by the server having primary responsibility for processing the query while other the servers monitor query processing. Transmission of a query result to a user typically completes the process.

Claims

1. A method for processing user-generated queries in a network, comprising:

assigning to a first computing device from a plurality of computing devices a primary responsibility for processing a data segment stored in memory of the first computing device, wherein the primary responsibility is assigned automatically in response to a characteristic of the data segment;

assigning to a second computing device from the plurality of computing devices a secondary responsibility for processing the data segment, wherein a copy of the data segment is stored in memory of the second computing device, and wherein the data segment is one of a plurality of data segments that form a portion of a collective database distributed across the plurality of computing devices communicatively coupled by a network;

granting to the first and second computing devices access to a look-up table stored in memory following receipt of a user-generated query for the data segment by any one of the first and second computing devices, wherein the look-up table allocates a pre-determined period of time for completing the query before the query is re-assigned to another computing device;

directing the first computing device to begin processing the query for the data segment according to the assigned primary responsibility;

identifying that the first computing device has not completed processing the query for the data segment within the pre-determined period of time; and

directing the second computing device to begin processing the query for the data segment according to the assigned secondary responsibility and the pre-determined period of time allocated by the stored look-up table following the identification that the first computing device had not completed processing the query within the pre-determined period of time.

2. The method of claim 1, wherein the characteristic of the data segment is a level of processing required to process a user-generated query for the data segment.

3. The method of claim 1, wherein the characteristic of the data segment is an estimated query frequency for the data segment.

4. The method of claim 1, wherein the characteristic of the data segment is represented by a weighted value.

5. The method of claim 1, wherein the second computing device monitors the processing of the query by the first computing device.

6. The method of claim 1, wherein the communications network further includes a third computing device having a master database stored in memory, the master database including the entire collective database and being accessible by any computing device in the communications network.

7. The method of claim 6, further comprising directing the third computing device to process the query for the data segment according when both the first computing device and the second computing device fail to process the query within a predetermined time period.

8. The method of claim 1, further comprising storing a pre-determined initiation time in the look-up table, wherein directing the second computing device to begin processing the query is further based on the pre-determined initiation time.

9. A server management system, comprising:

a network interface communicatively coupled to a communications network, the communications network including a first computing device and a second computing device; and

memory that stores a look-up table that allocates a pre-determined period of time for completing a query before the query is reassigned to another computing device; and

a processor that executes instructions, wherein execution of the instructions by the processor;

assigns to the first computing device from a plurality of computing devices a primary responsibility for processing a data segment stored in memory of the first computing device, wherein the primary responsibility is assigned automatically in response to a characteristic of the data segment;

assigns to the second computing device from the plurality of computing devices a secondary responsibility for processing the data segment, wherein a copy of the data segment is stored in memory of the second computing device, and wherein the data segment is one of a plurality of data segments that form a portion of a collective database distributed across the plurality of computing devices communicatively coupled by a network;

grants to the first and second computing devices access to the look-up table following receipt of a user-generated query for the data segment by any one of the first and second computing devices;

directs the first computing device to begin processing the query for the data segment according to the assigned primary responsibility;

identifying that the first computing device has not completed processing the query for the data segment within the pre-determined period of time; and

directs the second computing device to begin processing the query for the data segment according to the assigned secondary responsibility and the pre-determined period of time allocated by the stored look-up table following the identification that the first computing device had not completed processing the query within the pre-determined period of time.

10. The system of claim 9, wherein the characteristic of the data segment is a level of processing required to process a user-generated query for the data segment.

11. The system of claim 9, wherein the characteristic of the data segment is an estimated query frequency for the data segment.

12. The system of claim 9, wherein the characteristic of the data segment is represented by a weighted value.

13. The system of claim 9, wherein the second computing device monitors the processing of the query by the first computing device.

14. The system of claim 9, wherein the communications network further includes a third computing device having a master database stored in memory, the master database including the entire collective database and being accessible by any computing device in the communications network.

15. The system of claim 9, further comprising directing the third computing device to process the query for the data segment according when both the first computing device and the second computing device fail to process the query within a predetermined time period.

16. A non-transitory computer-readable storage medium having embodied thereon a program, the program being executable by a processor to perform a method for processing user-generated queries in a network, comprising:

assigning to a first computing device from a plurality of computing devices a primary responsibility for processing a data segment stored in memory of the first computing device, wherein the primary responsibility is assigned automatically in response to a characteristic of the data segment;

assigning to a second computing device from the plurality of computing devices a secondary responsibility for processing the data segment, wherein a copy of the data segment is stored in memory of the second computing device, and wherein the data segment is one of a plurality of data segments that form a portion of a collective database distributed across the plurality of computing devices communicatively coupled by a network;

granting to the first and second computing devices access to a look-up table stored in memory following receipt of a user-generated query for the data segment by any one of the first and second computing devices, wherein the look-up table allocates a pre-determined period of time for completing the query before the query is re-assigned to another computing device;

directing the first computing device to begin processing the query for the data segment according to the assigned primary responsibility;

identifying that the first computing device has not completed processing the query for the data segment within the pre-determined period of time; and

directing the second computing device to begin processing the query for the data segment according to the assigned secondary responsibility and the pre-determined period of time allocated by the stored look-up table based on the identification that the first computing device had not completed processing the query within the pre-determined period of time.

17. The non-transitory computer-readable storage medium of claim 16, wherein the characteristic of the data segment is a level of processing required to process a user-generated query for the data segment.

18. The non-transitory computer-readable storage medium of claim 16, wherein the characteristic of the data segment is an estimated query frequency for the data segment.

19. The non-transitory computer-readable storage medium of claim 16, wherein the characteristic of the data segment is represented by a weighted value.

20. The non-transitory computer-readable storage medium of claim 16, wherein the second computing device monitors the processing of the query by the first computing device.