Efficient handling of mostly read data in a computer server

Abstract

An apparatus and method is described for improving access to mostly read data on network servers. The preferred embodiments more efficiently utilize replicated data servers to minimize server response time for improved performance of data access to network servers by workload managing client requests across the primary server and all replicated servers when it is possible to do so. In preferred embodiments, a load balancer supplies the most current data for mostly read data transactions while maximizing server usage by workload managing client requests across the primary server and all replicated servers. Client requests are managed by a load balancer in the workload manager. Client requests are sent by the load balancer to replicated servers when a routing table (stale data marker list) indicates that the data is in a safe period. Clients are directed exclusively to the primary server only during data update times.

Description

CROSS-REFERENCE TO PARENT APPLICATION[0001]This patent application is a continuation of “U.S. Ser. No. 11 / 422,687 filed on 06 / 07 / 2006, which is incorporated herein by reference.BACKGROUND OF THE INVENTION[0002]1. Technical Field[0003]This invention generally relates to computer servers and more specifically relates to an apparatus and method for efficiently handling mostly read in a computer server environment that maintains data integrity while maximizing server utilization through workload management.[0004]2. Background Art[0005]Essential to computer performance is the timely availability of data. Computer systems often employ servers that are connected over a network to provide data files and software application files to a number of client machines. The same data is replicated onto multiple servers to achieve high availability, scalability of the systems and higher performance. High availability means availability despite planned outages for upgrades or unplanned outages caused ...

AI Technical Summary

Benefits of technology

[0009]According to the preferred embodiments, an apparatus and method is described for efficient utilization of replicated data servers to minimize server response time and to enable larger scalability to support many concurrent clients. In preferred embodiments, a load balancer supplies the most current data for mostly read data transactions while maximizing server usage by workload managing client requests across the primary server and all replicated servers. Client requests are managed by a load balancer in the workload manager. Client requests are sent by the load balancer to replicated servers when a routing table (stale data marker list) indicates that the data is in a safe period. Clients are directed exclusively to the primary server only during data update times.

Problems solved by technology

These replicated servers are wasted in terms of client access usage.

The replicated servers are used only when primary servers fail, but since it is very rare for the primary servers to fail, the servers are not well utilized.

Since up to 80% of a typical database contains mostly read data with very few updates and a large number of reads, large amounts of server resources are wasted, and scalability and performance are greatly diminished.

Without a way to more efficiently utilize servers for mostly read data, the computer industry will continue to suffer from slower response and less efficient utilization of network servers.

Images