Control service for relational data management

• US 8,706,764 B2
• Filed: 09/15/2012
• Issued: 04/22/2014
• Est. Priority Date: 03/31/2009
• Status: Active Grant

• Current Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Original Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Inventors: Sivasubramanian, Swaminathan, McAlister, Grant Alexander MacDonald, Franklin, Paul David, Sheth, Rajesh Sudhakar, Horsley, James
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Waldron, Scott A
• Application Number:
  US13/621,073
• Publication Number:
  US 20130066923A1
• Time in Patent Office: 584 Days
• Field of Search: 707/790, 707/792, 719/328
• US Class Current: 707/792
• CPC Class Codes: G06F 11/3006 where the computing system is distributed, e.g. networked systems, clusters, multiprocessor systems multiprogramming arrangements G06F9/46; allocation of resources G06F9/50
• CPC Class Codes: G06F 11/3055 Monitoring arrangements for monitoring the status of the computing system or of the computing system component, e.g. monitoring if the computing system is on, off, available, not available error or fault processing without redundancy G06F11/0703; error detection or correction by redundancy in data representation G06F11/08; error detection or correction by redundancy in operation G06F11/14; error detection or correction by redundancy in hardware G06F11/16
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 12/02 Addressing or allocation; Relocation program address sequencing G06F9/00; arrangements for selecting an address in a digital store G11C8/00
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

Aspects of a data environment, such as the creation, provisioning, and management of data stores and instances, are managed using a separate control environment. A user can call into an interface of the control environment, the call being analyzed to determine actions to be performed in the data environment. A monitoring component of the control plane also can periodically communicate with the data environment to determine any necessary actions to be performed, such as to recover from faults or events in the data environment. A workflow can be instantiated that includes tasks necessary to perform the action. For each task, state information can be passed to a component in the data environment operable to perform the task, until all tasks for an action are completed. Data in the data environment can be accessed directly using a separate interface of the data environment, without accessing the control plane.

Claims

1. A computer-implemented method of managing a provisioned database, comprising:

under control of one or more computer systems configured with executable instructions,

receiving a request at a control interface in a control environment for an action relating to configuration of the provisioned database in a data environment that is separate from the control environment;

determining a workflow for the action based at least in part upon the request, the workflow comprising one or more tasks; and

for each task of the workflow,

sending first state information to the data environment for performing the task;

receiving second state information from the data environment regarding the task having been performed; and

when the task is a final task of the workflow, providing a response from the control environment indicating that the action has been completed,

wherein the configuration of the provisioned database by a user is performed using the control interface in the the control environment.

2. The computer-implemented method of claim 1, wherein the action includes at least one of creating, upgrading, downgrading, scaling, replicating, backing up, failing over, restoring, hibernating, resuming from hibernation, or deleting the provisioned database.

3. The computer-implemented method of claim 1, wherein the control interface comprises one or more web pages capable of being rendered by a browser application and the request comprises a form submission to the control environment.

4. The computer-implemented method of claim 1, wherein the control interface comprises a graphical user interface of a software application and the request comprises a service call to the control environment.

5. The computer-implemented method of claim 1, wherein the control interface comprises an Application Programming Interface (API) and the request comprises a service call to the control environment.

6. The computer-implemented method of claim 1, wherein the control interface comprises a command line interface and the request comprises a service call to the control environment.

7. The computer-implemented method of claim 1, wherein at least one of the one or more tasks of the workflow is based upon a workflow template.

8. The computer-implemented method of claim 1, wherein some of the one or more tasks are specific to a selected database engine for the provisioned database.

9. The computer-implemented method of claim 8, wherein the some of the one more tasks specific to the selected database engine comprise a work flow template.

10. The computer-implemented method of claim 1, wherein:

the action comprises creating the provisioned database; and

the one or more tasks comprise at least one of instantiating the provisioned database, setting a storage volume for the provisioned database, downloading binaries for a selected database engine, assigning a Domain Name System (DNS) name or network address information to the provisioned database, and assigning hardware to support the provisioned database.

11. The computer-implemented method of claim 1, wherein the provisioned database is accessible using a DNS name or network address information corresponding to the provisioned database.

12. A system for managing a provisioned database, comprising:

at least one processor; and

memory including instructions that, when executed by the at least one processor, cause the system to;

receive a request at a control interface in a control environment for an action relating to configuration of the provisioned database in a data environment that is separate from the control environment;

determine a workflow for the action based at east in part upon the request, the workflow comprising one or more tasks; and

for each task of the workflow,

send first state information to the data environment for performing the task;

receive second state information from the data environment regarding the task having been performed; and

when the task is a final task of the workflow, provide a response from the control environment indicating that the action has been completed,

wherein the configuration of the provisioned database by a user is performed via the control environment.

13. The system of claim 12, wherein the action includes at least one of creating, upgrading, downgrading, scaling, replicating, backing up, failing over, restoring, rebooting, hibernating, resuming from hibernation, or deleting the provisioned database.

14. The system of claim 12, wherein the control interface comprises one or more web pages capable of being rendered by a browser application and the request comprises a form submission to the control environment.

15. The system of claim 12, wherein the control interface comprises a graphical user interface of a software application and the request comprises a service call to the control environment.

16. The system of claim 12, wherein the control interface comprises an Application Programming Interface (API) and the request comprises a service call to the control environment.

17. The system of claim 12, wherein the control interface comprises a command line interface and the request comprises a service call to the control environment.

18. The system of claim 12, wherein at least one of the one or ore tasks of the workflow is based upon a workflow template.

19. The system of claim 12, wherein some of the one or more tasks are specific to a selected database engine for the provisioned database.

20. The system of claim 19, wherein the some of the one more tasks specific to the selected database engine comprise a workflow template.

21. The system of claim 12, wherein:

the action comprises creating the provisioned database; and

the one or more tasks comprise at least one of instantiating the provisioned database, setting a storage volume for the provisioned database, downloading binaries for a selected database engine, assigning a DNS name or network address information to the provisioned database, and assigning hardware to support the provisioned database.

22. The system of claim 12, wherein the provisioned database is accessible using a DNS name or network address information corresponding to the provisioned database.

23. A non-transitory computer-readable medium including instructions for enabling management of a provisioned database, the instructions when executed by a processor of a computing device cause the computing device to:

receive a request at a control environment for an action relating to configuration of the provisioned database;

determine a workflow for the action based at least in part upon the request, the workflow comprising one or more tasks; and

for each task of the workflow,

cause the task to be performed for the provisioned database;

receive state information regarding the task having been performed; and

when the task is a final task of the workflow, provide a response indicating that the action has been performed,

wherein the configuration of the provisioned database by a user is performed via the control environment.

24. The non-transitory computer-readable medium of claim 23, wherein the action includes at least one of creating, upgrading, downgrading, scaling, replicating, backing up, failing over, restoring, rebooting, hibernating, resuming from hibernation, or deleting the provisioned database.

25. The non-transitory computer-readable medium of claim 23, wherein the provisioned database is accessible using a DNS name or network address information corresponding to the provisioned database.