Database cluster management
AssigneeOracle International Corporation
InventorAllan George Schrum
Life of this patent
Estimating the term…
Abstract
Techniques for managing a database cluster are disclosed. A database cluster stores a database in a distributed manner among multiple nodes. Applications query a node in the database cluster with a database language query to access data in the database. If the node determines it is in a pre-shutdown state, the node returns both query results and a status indicator. Based on receiving the indication of the pre-shutdown status, the application may continue to query the node to obtain data from the database for an ongoing task or operation. The application may then switch over to another node in the database cluster prior to the node changing to an inaccessible or shutdown state.
Claims20
One or more non-transitory computer readable media comprising instructions which, when executed by one or more hardware processors, cause performance of operations comprising:
- detecting a first trigger to change a state of a first node in a database cluster from an operational state to an inaccessible state at a future time, wherein the database cluster stores a database among a plurality of nodes in the database cluster, wherein the plurality of nodes includes the first node;
- based on detecting the first trigger, modifying a status identifier for the first node from an operational status identifier to a pre-shutdown status identifier;
- storing the pre-shutdown status identifier in a data table in the database;
- subsequent to storing the pre-shutdown status identifier:
- receiving, by the first node, a first query in a database language from an application accessing the database stored on the database cluster;
- executing, by the first node, the first query to access a first set of data stored in the first node and specified in the first query;
- and
- in response to the first query, generating a first query response to the application including the pre-shutdown status identifier.
A method comprising:
- detecting a first trigger to change a state of a first node in a database cluster from an operational state to an inaccessible state at a future time, wherein the database cluster stores a database among a plurality of nodes in the database cluster, wherein the plurality of nodes includes the first node;
- based on detecting the first trigger, modifying a status identifier for the first node from an operational status identifier to a pre-shutdown status identifier;
- storing the pre-shutdown status identifier in a data table in the database;
- subsequent to storing the pre-shutdown status identifier:
- receiving, by the first node, a first query in a database language from an application accessing the database stored on the database cluster;
- executing, by the first node, the first query to access a first set of data stored in the first node and specified in the first query;
- and
- in response to the first query, generating a first query response to the application including the pre-shutdown status identifier, wherein the method is performed by at least one device including a hardware processor.
A system comprising:
- at least one device including a hardware processor;
- the system being configured to perform operations comprising:
- detecting a first trigger to change a state of a first node in a database cluster from an operational state to an inaccessible state at a future time, wherein the database cluster stores a database among a plurality of nodes in the database cluster, wherein the plurality of nodes includes the first node;
- based on detecting the first trigger, modifying a status identifier for the first node from an operational status identifier to a pre-shutdown status identifier;
- storing the pre-shutdown status identifier in a data table in the database;
- subsequent to storing the pre-shutdown status identifier:
- receiving, by the first node, a first query in a database language from an application accessing the database stored on the database cluster;
- executing, by the first node, the first query to access a first set of data stored in the first node and specified in the first query;
- and
- in response to the first query, generating a first query response to the application including the pre-shutdown status identifier.
Dependencies are inferred from the claim text.