SYSTEMS AND METHODS FOR AUTOMATING MANAGEMENT OF DISTRIBUTED DATABASES
First Claim
1. A system for automatically integrating cloud based resources into a distributed database executing on local hardware, the system comprising:
- at least one processor operatively connected to a memory;
a state component, executed by the at least one processor, configured to determine a current state for a plurality of database nodes, wherein the current state determination identifies a database instance executing on client hardware including at least one replica set having a primary node hosting a primary database instance that accepts database write operations from client systems, and at least two secondary nodes that host copies of the primary database instance that replicate logged write operations from the primary node, a database version executing on the replica set, and configuration data for at least one database instance;
a planning component, executed by the at least one processor, configured to generate an execution plan to provision an additional secondary node mirroring the primary node and the primary database; and
an automation component, executed by the at least one processor, configured to;
provision at least one cloud resource having processor and memory based on the execution plan;
install database binary files including automation agents for a secondary node on the at least one cloud resource;
trigger synchronization between the primary node and the secondary node executing on the at least one cloud resource; and
update configuration metadata for the database instance; and
replicate write operations on the primary node executing on client hardware received after synchronization to the secondary node executing on the at least one cloud resource.
1 Assignment
0 Petitions
Accused Products
Abstract
An automation system is provided to automate any administrative task in a distributed database, such that the end user can input a goal state (e.g., create database with a five node architecture) and the automation system generates and executes a plan to achieve the goal state without further user input. According to another aspect, bringing existing database systems into automated management can be as complex as designing the database itself. According to some embodiments, the automation system is configured to analyze existing database systems, capture and/or install monitoring components within the existing database, and generate execution pathways to integrate existing database systems into automation control systems. Based on the current state information, the automation system is configured to generate an installation pathway of one or more intermediate states to transition the existing system from no automation to a goal state having active automation agents distributed throughout the database.
-
Citations
20 Claims
-
1. A system for automatically integrating cloud based resources into a distributed database executing on local hardware, the system comprising:
-
at least one processor operatively connected to a memory; a state component, executed by the at least one processor, configured to determine a current state for a plurality of database nodes, wherein the current state determination identifies a database instance executing on client hardware including at least one replica set having a primary node hosting a primary database instance that accepts database write operations from client systems, and at least two secondary nodes that host copies of the primary database instance that replicate logged write operations from the primary node, a database version executing on the replica set, and configuration data for at least one database instance; a planning component, executed by the at least one processor, configured to generate an execution plan to provision an additional secondary node mirroring the primary node and the primary database; and an automation component, executed by the at least one processor, configured to; provision at least one cloud resource having processor and memory based on the execution plan; install database binary files including automation agents for a secondary node on the at least one cloud resource; trigger synchronization between the primary node and the secondary node executing on the at least one cloud resource; and update configuration metadata for the database instance; and replicate write operations on the primary node executing on client hardware received after synchronization to the secondary node executing on the at least one cloud resource. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 18)
-
-
13. A computer implemented method for automatically integrating cloud based resources into a distributed database executing on local hardware, the method comprising:
-
determining, by at least one processor, a current state for a plurality of database nodes, wherein determining the current state includes identifying a database instance executing on client hardware including at least one replica set having a primary node hosting a primary database instance that accepts database write operations from client systems, and at least two secondary nodes that host copies of the primary database instance that replicate logged write operations from the primary node, a database version executing on the replica set, and configuration data for at least one database instance; generating, by the at least one processor, an execution plan to provision an additional secondary node mirroring the primary node and the primary database; provisioning, by the at least one processor, at least one cloud resource having processor and memory based on the execution plan; installing, by the at least one processor, database binary files including automation agents for a secondary node on the at least one cloud resource; triggering, by the at least one processor, synchronization between the primary node and the secondary node executing on the at least one cloud resource; updating, by the at least one processor, configuration metadata for the database instance; and replicating, by the at least one processor, any write operations receive on the primary node executing on client hardware after synchronization to the secondary node executing on the at least one cloud resource. - View Dependent Claims (14, 15, 16, 17, 19, 20)
-
Specification