Systems and methods for provisioning and decoupled maintenance of cloud-based database systems
Methods and systems are described for provisioning cloud-based database systems and performing decoupled maintenance. For example, conventional systems may rely on database management systems to provision and modify databases hosted by a service provider. However, for entities operating complex database systems with the need for highly customized cloud infrastructure, database management systems fail to provide the granular customization and the control necessary to create and service these systems. In contrast, the described solutions provide an improvement over conventional database management system architecture by providing direct communication between an entity and its cloud-based database systems via command line prompts or API calls, decoupling database system maintenance from database system provisioning process to increase the speed and granular customization of the database system. Moreover, the disclosed solution leverages machine learning to predict optimal database system provisioning and maintenance processes and resources.
1. A server system comprising:
one or more processors; and
memory storing computer-readable instructions that, when executed by the one or more processors, perform:
determining, based on a request to modify a first database system, a failover protocol and a set of modification protocols, wherein the request includes one or more modification parameters;
generating, based on initiating the failover protocol, a standby database system;
redirecting live traffic from the first database system to the standby database system;
performing, on the first database system and based at least in part on the set of modification protocols and the one or more modification parameters, a first modification testing process; and
determining, based at least in part on a result of the first modification testing process, whether to:
perform a second modification testing process on the first database system, wherein the second modification testing process corrects one or more errors associated with the first modification testing process; or
redirect the live traffic from the standby database system to the first database system, and modify the first database system in accordance with the request based at least in part on the set of modification protocols and the one or more modification parameters.
2. The server system of claim 1 , wherein the set of modification protocols comprises one or more parameters, settings, guidelines, or combinations thereof.
3. The server system of claim 1 , wherein generating the standby database system comprises:
determining a first geographical region associated with the first database system; and
generating the standby database system in a second geographical region different from the first geographical region.
4. The server system of claim 1 , wherein the request to modify the first database system is in response to detecting a failure event at the first database system.
5. The server system of claim 1 , wherein initiating the failover protocol is based at least in part on:
determining a recovery point threshold indicating a maximum amount of acceptable data loss, as measured by time, after a failure event at the first database system; and
determining a recovery time threshold indicating a duration of time within which the first database system must be restored after the failure event at the first database system.
6. The server system of claim 1 , wherein prior to the request to modify the first database system, the first database system operates as a primary database system, and
wherein redirecting the live traffic from the first database system comprises converting and labeling the standby database system as the primary database system.
7. The server system of claim 1 , wherein redirecting the live traffic comprises modifying a domain name system (DNS) associated with the first database system, the standby database system, or a combination thereof.
8. The server system of claim 1 , wherein the instructions, when executed by the one or more processors, further perform:
in response to the request to modify the first database system, generating a single command line prompt command or a single API call to a service provider to initiate a modification process of the first database system, wherein the first database system is hosted by the service provider.
9. The server system of claim 8 , wherein the single command line prompt command or the single API call causes a database management system associated with the service provider to be bypassed.
10. A method comprising:
determining, based on a request to modify a first database system, a failover protocol and a set of modification protocols, wherein the request includes one or more modification parameters;
generating, based on initiating the failover protocol, a standby database system;
redirecting live traffic from the first database system to the standby database system;
performing, on the first database system and based at least in part on the set of modification protocols and the one or more modification parameters, a first modification testing process; and
determining, based at least in part on a result of the first modification testing process, whether to:
perform a second modification testing process on the first database system, wherein the second modification testing process corrects one or more errors associated with the first modification testing process; or
redirect the live traffic from the standby database system to the first database system, and modify the first database system in accordance with the request based at least in part on the set of modification protocols and the one or more modification parameters.
11. The method of claim 10 , wherein generating the standby database system comprises:
determining a first geographical region associated with the first database system; and
generating the standby database system in a second geographical region different from the first geographical region.
12. The method of claim 10 , wherein the request to modify the first database system is in response to detecting a failure event at the first database system, and
wherein initiating the failover protocol is based at least in part on:
determining a recovery point threshold indicating a maximum amount of acceptable data loss, as measured by time, after the failure event at the first database system; and
determining a recovery time threshold indicating a duration of time within which the first database system must be restored after the failure event at the first database system.
13. The method of claim 10 , wherein prior to the request to modify the first database system, the first database system operates as a primary database system, and
wherein redirecting the live traffic from the first database system comprises converting and labeling the standby database system as the primary database system.
14. The method of claim 10 , wherein redirecting the live traffic comprises modifying a domain name system (DNS) associated with the first database system, the standby database system, or a combination thereof.
15. The method of claim 10 , further comprising:
in response to the request to modify the first database system, generating a single command line prompt command or a single API call to a service provider to initiate a modification process of the first database system, wherein the first database system is hosted by the service provider,
wherein the single command line prompt command or the single API call causes a database management system associated with the service provider to be bypassed.
16. A non-transitory, computer-readable medium storing computer-readable instructions that, when executed by one or more processors, cause a server system to perform:
determining, based on a request to modify a first database system, a failover protocol and a set of modification protocols, wherein the request includes one or more modification parameters;
generating, based on initiating the failover protocol, a standby database system;
redirecting live traffic from the first database system to the standby database system;
performing, on the first database system and based at least in part on the set of modification protocols and the one or more modification parameters, a first modification testing process; and
determining, based at least in part on a result of the first modification testing process, whether to:
perform a second modification testing process on the first database system, wherein the second modification testing process corrects one or more errors associated with the first modification testing process; or
redirect the live traffic from the standby database system to the first database system, and modify the first database system in accordance with the request based at least in part on the set of modification protocols and the one or more modification parameters.
17. The non-transitory, computer-readable medium of claim 16 , wherein generating the standby database system comprises:
determining a first geographical region associated with the first database system; and
generating the standby database system in a second geographical region different from the first geographical region.
18. The non-transitory, computer-readable medium of claim 16 , wherein the request to modify the first database system is in response to detecting a failure event at the first database system, and
wherein initiating the failover protocol is based at least in part on:
determining a recovery point threshold indicating a maximum amount of acceptable data loss, as measured by time, after the failure event at the first database system; and
determining a recovery time threshold indicating a duration of time within which the first database system must be restored after the failure event at the first database system.
19. The non-transitory, computer-readable medium of claim 16 , wherein prior to the request to modify the first database system, the first database system operates as a primary database system, and
wherein redirecting the live traffic from the first database system comprises:
converting and labeling the standby database system as the primary database system;
modifying a domain name system (DNS) associated with the first database system, the standby database system, or a combination thereof; or
a combination thereof.
20. The non-transitory, computer-readable medium of claim 16 , wherein the instructions that, executed by the one or more processors, cause the server system to perform:
in response to receiving the request to modify the first database system, generating a single command line prompt command or a single API call to a service provider to initiate a modification process of the first database system, wherein the first database system is hosted by the service provider,
wherein the single command line prompt command or the single API call causes a database management system associated with the service provider to be bypassed.