US 10,884,887 B2 · Workload shifting in a database system using hint-based routing

Abstract

Systems, techniques, and articles are described herein for workload shifting in a database system. A computer system is configured to provide a database system and includes one or more processors, a primary database system implemented by the one or more processors, and a secondary database system implemented by the one or more processors. The secondary database system is configured as a hot-standby system for the primary database system and is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption. The primary database system is configured by programming instructions, executable on the computer system, to cause the one or more processors to determine from a query request from a client application directed to the primary database system that workload from a query may be shifted to the secondary database system and instruct the client application to execute the query.

Claims20

Dependent claims

A computer system comprising:

one or more processors;
a primary database system implemented by the one or more processors;
and
a secondary database system implemented by the one or more processors, the secondary database system configured as a hot-standby system for the primary database system that is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption to the primary database system;
wherein the primary database system is configured by programming instructions, executable on the computer system, to cause the one or more processors to:
determine from a query request from a client application directed to the primary database system that workload from a query may be shifted to the secondary database system;
determine that a routing hint in the query request indicates a preference for the query to be executed at the secondary database system;
and
instruct, based on the routing hint, the client application to direct the secondary database system to execute the query.

6 more elements

A computer-implemented method in a computer system comprising a primary database system and a secondary database system, the secondary database system configured as a backup system for the primary database system that is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption to the primary database system, the method comprising:

receiving by the primary database system a query request from a client application in advance of receiving a query,
determining by the primary database system that a routing hint in the query request indicates a preference for the query to be executed at the secondary database system;
determining that execution of the query does not involve writing data;
determining by the primary database system to instruct the client application to route the query to the secondary database system based on the routing hint;
and
instructing, by the primary database system, the client application to route the query to the secondary database system.

3 more elements

A non-transitory computer readable storage medium embodying programming instruction for performing a method, the method comprising:

receiving by a primary database system comprising a primary database a query request from a client application in advance of receiving a query,
determining by the primary database system that a routing hint in the query request indicates a preference for the query to be executed at a secondary database system comprising a secondary database, the secondary database system configured as a backup system for the primary database system that is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption to the primary database system, wherein the primary database and the secondary database are separate and independent of one another;
determining that execution of the query does not involve writing data;
determining by the primary database system to instruct the client application to route the query to the secondary database system based on the routing hint;
and
instructing, by the primary database system, the client application to route the query to the secondary database system.

3 more elements

Dependencies are inferred from the claim text.

Workload shifting in a database system using hint-based routing

Life of this patent

Workload shifting in a database system using hint-based routing

Life of this patent

Abstract

Claims20