System and method for backing up highly available source databases in a hyperconverged system

Patent metadata

Field	Value
Publication number	US-11640340-B2
Application number	US-202117182511-A
Country	US
Kind code	B2
Filing date	Feb 23, 2021
Priority date	Oct 20, 2020
Publication date	May 2, 2023
Grant date	May 2, 2023

Abstract

A system and method includes a plurality of nodes distributed between a first cluster and a second cluster, each of the plurality of nodes storing a copy of a source database and a processor executing computer-readable instructions stored on a memory to designate a first node of the plurality of nodes as a primary node, designate remaining ones of the plurality of nodes as secondary nodes to take over from the primary node upon failure of the primary node, designate a second node of the plurality of nodes as an initial active node, backup the source database from the initial active node, automatically designate, based on a switch over policy, a third node of the plurality of nodes as a next active node upon the initial active node becoming unavailable, and continue backups of the source database from the next active node upon the initial active node becoming unavailable.

First claim

What is claimed is:

1. A system comprising:
a processor executing computer-readable instructions stored on a memory to:
select one of a plurality of nodes as a primary node capable of storing a source database, the remaining ones of the plurality of nodes being a secondary node, each of the secondary node capable of storing a copy of the source database, wherein updates made to the source database on the primary node are able to be copied to the copy of the source database on the secondary node, and wherein in response to the primary node becoming unavailable, one of the secondary node is designated to become the primary node based on a first policy;
designate a first node from the primary node or the secondary node as an initial active node;
capture one or more snapshots of the source database or the copy of the source database from the first node designated as the initial active node;
determine that the first node has become unavailable;
select, in response to the first node becoming unavailable and based on a user defined switch over policy, a second node from the primary node or the secondary node as a next active node, wherein the switch over policy defines a criteria for selecting the next active node from the plurality of nodes to capture the one or more snapshots from; and
capture the one or more snapshots of the source database or the copy of the source database from the second node in response to selecting the second node as the next active node.

2. The system of claim 1 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the primary node.

3. The system of claim 1 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the secondary node.

4. The system of claim 1 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the secondary node, or upon determining that none of the plurality of nodes are the secondary node, select the next active node from the plurality of nodes that is the primary node.

5. The system of claim 1 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the primary node, or upon determining that none of the plurality of nodes is the primary node, select the next active node from the plurality of nodes that is the secondary node.

6. The system of claim 1 , wherein the switch over policy defines a priority assigned to at least a subset of the plurality of nodes and wherein the processor further executes the computer-readable instructions to select the next active node based upon the priority.

7. A non-transitory computer-readable media comprising computer readable instructions stored thereon that when executed by a processor causes the processor to:
select one of a plurality of nodes as a primary node capable of storing a source database and the remaining ones of the plurality of nodes being a secondary node, each of the secondary node capable of storing a copy of the source database, wherein updates made to the source database on the primary node are able to be copied to the copy of the source database on the secondary node, and wherein in response to the primary node becoming unavailable, one of the secondary node is designated to become the primary node based on a first policy;
designate a first node from the primary node or the secondary node as an initial active node;
capture one or more snapshots of the source database or the copy of the source database from the first node designated as the initial active node;
determine that the first node has become unavailable;
select, in response to the first node becoming unavailable and based on a user defined switch over policy, a second node from the primary node or the secondary node as a next active node, wherein the switch over policy defines a criteria for selecting the next active node from the plurality of nodes to capture the one or more snapshots from; and
capture the one or more snapshots of the source database or the copy of the source database from the second node in response to selecting the second node as the next active node.

8. The non-transitory computer-readable media of claim 7 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the primary node.

9. The non-transitory computer-readable media of claim 7 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the secondary node.

10. The non-transitory computer-readable media of claim 7 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the secondary node, or upon determining that none of the plurality of nodes are the secondary node, select the next active node from the plurality of nodes that is the primary node.

11. The non-transitory computer-readable media of claim 7 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the primary node, or upon determining that none of the plurality of nodes is the primary node, select the next active node from the plurality of nodes that is the secondary node.

12. The non-transitory computer-readable media of claim 7 , wherein the switch over policy defines a priority assigned to at least a subset of the plurality of nodes and wherein the processor further executes the computer-readable instructions to select the next active node based upon the priority.

13. A method comprising:
selecting, by a processor executing computer-readable instructions stored on a memory, one of a plurality of nodes as a primary node capable of storing a source database and the remaining ones of the plurality of nodes being a secondary node, each of the secondary node capable of storing a copy of the source database, wherein updates made to the source database on the primary node are able to be copied to the copy of the source database on the secondary node, and wherein in response to the primary node becoming unavailable, one of the secondary node is designated to become the primary node based on a first policy;
designating, by the processor, a first node from the primary node or the secondary node as an initial active node;
capturing, by the processor, one or more snapshots of the source database or the copy of the source database from the first node designated as the initial active node;
determining, by the processor, that the first node has become unavailable;
selecting, by the processor, in response to the first node becoming unavailable and based on a user defined switch over policy, a second node from the primary node or the secondary node as a next active node, wherein the switch over policy defines a criteria for selecting the next active node from the plurality of nodes to capture the one or more snapshots from; and
capturing, by the processor, one or more snapshots of the source database or the copy of the source database from the second node in response to selecting the second node as the next active node.

14. The method of claim 13 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the primary node.

15. The method of claim 13 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the secondary node.

16. The method of claim 13 , wherein the switch over policy defines selection of the next active node from the plurality of nodes that is the secondary node, o

Assignees

• Nutanix Inc

Inventors

• Sontakke Sagar
• Khanuja Kamaldeep
• Banthia Bakul

Classifications

• G06F11/1464 Primary

  for networked environments · CPC title

• G06F2201/84

  Using snapshots, i.e. a logical point-in-time copy of the data · CPC title

• G06F11/1471

  involving logging of persistent data for recovery · CPC title

• G06F11/1451

  by selection of backup contents · CPC title

• G06F11/2025 Primary

  using centralised failover control functionality · CPC title