Method for avoiding conflicts in database cluster
AssigneeCodership Oy
InventorsAlexey Yurchenko, Seppo Jaakola, Teemu Ollakka
Life of this patent
Estimating the term…
Abstract
A method for avoiding conflicts in a multi-master database cluster is provided. A set of hot spots is identified in the database cluster. When a given node receives a given transaction, the given node selects one or more hot-spot servicing nodes for one or more hot-spot sub-transactions, namely one or more sub-transactions of the given transaction that correspond to one or more hot spots of the set of hot spots. Subsequently, the given node redirects the hot-spot sub-transactions to their respective hot-spot servicing nodes. The hot-spot sub-transactions are then executed at their respective hot-spot servicing nodes.
Claims20
A method for avoiding conflicts in a multi-master database cluster, wherein the multi-master database cluster comprises a plurality of nodes, the method comprising:
- identifying a set of hot spots in the database cluster, the set of hot spots comprising one or more database objects that satisfy one or more criteria defined in a collection of hot-spot policies;
- receiving, at a given node of the database cluster, a given transaction;
- selecting, from the plurality of nodes, one or more hot-spot servicing nodes for one or more hot-spot sub-transactions of the given transaction, wherein the one or more hot-spot sub-transactions correspond to one or more hot spots of the set of hot spots;
- redirecting the one or more hot-spot sub-transactions to their respective hot-spot servicing nodes;
- and
- executing the one or more hot-spot sub-transactions at their respective hot-spot servicing nodes.
A computing apparatus comprising:
- a processor;
- a memory coupled to the processor;
- and
- a network interface coupled to the processor,
- wherein the processor is configured to:
- identify a set of hot spots in a database cluster, the set of hot spots comprising one or more database objects that satisfy one or more criteria defined in a collection of hot-spot policies;
- receive, at a given node of the database cluster, a given transaction;
- select, from a plurality of nodes of the database cluster, one or more hot-spot servicing nodes for one or more hot-spot sub-transactions of the given transaction, wherein the one or more hot-spot sub-transactions correspond to one or more hot spots of the set of hot spots;
- and
- redirect the one or more hot-spot sub-transactions to their respective hot-spot servicing nodes.
A computer program product comprising a non-transitory machine-readable data storage medium having stored thereon program instructions that, when accessed by a processing device, cause the processing device to:
- identify a set of hot spots in a database cluster, the set of hot spots comprising one or more database objects that satisfy one or more criteria defined in a collection of hot-spot policies;
- receive, at a given node of the database cluster, a given transaction;
- select, from a plurality of nodes of the database cluster, one or more hot-spot servicing nodes for one or more hot-spot sub-transactions of the given transaction, wherein the one or more hot-spot sub-transactions correspond to one or more hot spots of the set of hot spots;
- and
- redirect the one or more hot-spot sub-transactions to their respective hot-spot servicing nodes.
Dependencies are inferred from the claim text.