Failover and synchronization management for databases
AssigneeDell Products L.P.
InventorsPratheek Veluswamy, Bijan Kumar Mohanty, Hung Dinh, Vasanth K. Ramu
Life of this patent
Estimating the term…
Abstract
A method comprises analyzing metrics corresponding to operation of a first node in a first data center using at least one machine learning algorithm, predicting, based at least in part on the analyzing of the metrics, whether the operation of the first node is anomalous, designating the first node as being in an anomalous state responsive to predicting that the operation of the first node is anomalous, and causing routing of one or more database transactions to a second node in a second data center instead of the first node in response to the anomalous state designation.
Claims21
A method, comprising:
- distributing data of a database system over a first cluster of nodes of a first data center and a second cluster of nodes of a second data center;
- analyzing metrics corresponding to operation of a first node in the first cluster of nodes of the first data center using at least one machine learning algorithm;
- predicting, based at least in part on the analyzing of the metrics, whether the operation of the first node is anomalous with a potential of the first node to fail;
- designating the first node as being in an anomalous state responsive to predicting that the operation of the first node is anomalous with the potential of the first node to fail;
- and
- prior to a failure of the first node, and in response to the anomalous state designation of the first node:
- assigning one or more second nodes of the second cluster of nodes of the second data center to be utilized in place of the first node to perform database transactions;
- and
- causing a routing of one or more database transactions to the one or more second nodes in the second data center instead of the first node;
- wherein the steps of the method are executed by a processing device operatively coupled to a memory.
(canceled)
An apparatus comprising:
- at least one processing device that is operatively coupled to a memory, wherein the memory stores program instructions that are executed by the at least one processing device to instantiate a database management platform which operates to:
- distribute data of a database system over a first cluster of nodes of a first data center and a second cluster of nodes of a second data center;
- analyze metrics corresponding to operation of a first node in the first cluster of nodes of the first data center using at least one machine learning algorithm;
- predict, based at least in part on the analyzing of the metrics, whether the operation of the first node is anomalous with a potential of the first node to fail;
- designate the first node as being in an anomalous state responsive to predicting that the operation of the first node is anomalous with the potential of the first node to fail;
- and
- prior to a failure of the first node, and in response to the anomalous state designation of the first node:
- assign one or more second nodes of the second cluster of nodes of the second data center to be utilized in place of the first node to perform database transactions;
- and
- cause a routing of one or more database transactions to the one or more second nodes in the second data center instead of the first node.
An article of manufacture comprising a non-transitory processor-readable storage medium having stored therein program code of one or more software programs, wherein the program code when executed by at least one processing device causes said at least one processing device to instantiate a database management platform which operates to perform the steps of:
- distributing data of a database system over a first cluster of nodes of a first data center and a second cluster of nodes of a second data center;
- analyzing metrics corresponding to operation of a first node in the first cluster of nodes of the first data center using at least one machine learning algorithm;
- predicting, based at least in part on the analyzing of the metrics, whether the operation of the first node is anomalous with a potential of the first node to fail;
- designating the first node as being in an anomalous state responsive to predicting that the operation of the first node is anomalous with the potential of the first node to fail;
- and
- prior to a failure of the first node, and in response to the anomalous state designation of the first node:
- assigning one or more second nodes of the second cluster of nodes of the second data center to be utilized in place of the first node to perform database transactions;
- and
- causing a routing of one or more database transactions to the one or more second nodes in the second data center instead of the first node.
Dependencies are inferred from the claim text.