Self-service administration of a database

• US 8,713,061 B1
• Filed: 09/15/2012
• Issued: 04/29/2014
• Est. Priority Date: 04/03/2009
• Status: Active Grant

• Current Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Original Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Inventors: Sheth, Rajesh Sudhakar, Warman, Leon Robert, Gangadhar, Narayan
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Waldron, Scott A.
• Application Number:
  US13/620,999
• Time in Patent Office: 591 Days
• Field of Search: 707/790, 707/792, 719/328
• US Class Current: 707/792
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking

Abstract

Administrative aspects of a data environment, such as the creation, deletion, and management of databases, are managed using a set of self-service Web services of a separate control environment. A user can submit a Web services call into an externally-facing interface of the control environment. The control environment can receive the call, extract information from the call, and determine appropriate actions to be performed in the data environment. A workflow can be instantiated that includes tasks used to perform the action in the data environment. Such an approach allows administrative aspects of the data environment to be managed through Web service calls to the control environment. Native access to databases in the data environment is provided using at least one externally-facing interface of the data environment, without accessing the control environment.

Claims

1. A computer-implemented method of enabling self-service administration of a relational database, comprising:

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

providing a plurality of application programming interfaces (APIs) each enabling a user to submit a Web service request to a control environment and corresponding to a specified action to be performed with respect to configuration of the relational database for the user in a data environment, the data environment being separate from the control environment; and

in response to receiving the Web service request through one of the plurality of APIs, causing at least one task to be performed in the data environment corresponding to the specified action,

wherein the configuration of the relational database by the user is performed via the control environment and data of the relational database can be accessed using a data interface of the data environment that is configured to operate independent of the control environment.

2. The computer-implemented method of claim 1, wherein the plurality of APIs enable at least one of creating, upgrading, downgrading, scaling, replicating, backing up, failing over, restoring, rebooting, hibernating, resuming from hibernation, or deleting the relational database in the data environment.

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

the specified action comprises creating the relational database; and

the at least one task includes at least one of instantiating the relational database, setting a storage volume for the relational database, downloading binaries for one of a plurality of database engines, assigning a domain name system (DNS) name or network address information to the relational database, and assigning hardware to support the relational database.

4. A computer-implemented method of enabling self-service administration of a database, comprising:

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

providing a plurality of externally-facing interfaces each enabling a user to submit a Web service request to a control environment, each of the plurality of externally-facing interfaces corresponding to an action to be performed with respect to configuration of the database in a data environment, the data environment being separate from the control environment; and

in response to receiving the Web service request to the control environment through one of the plurality of externally-facing interfaces, causing at least one task to be performed in the data environment corresponding to the action,

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

5. The computer-implemented method of claim 4, wherein the database can be accessed using a data interface of the data environment that is configured to operate independent of the control environment.

6. The computer-implemented method of claim 5, further comprising:

providing the user with a DNS name or network address information enabling the user to access the database using a data interface.

7. The computer-implemented method of claim 4, wherein causing the at least one task to be performed in the data environment comprises:

determining a workflow to be executed in the control environment to perform the action in the data environment; and

executing the workflow in the control environment, the workflow including one or more tasks to be performed in the data environment corresponding to the action.

8. The computer-implemented method of claim 4, wherein causing the at least one task to be performed in the data environment comprises sending, a request corresponding to the Web service request to a host manager for a host machine in the data environment, the host manager being operable to perform one or more tasks in the data environment and further operable to collect and monitor health information for at least one-aspect of the data environment.

9. The computer-implemented method of claim 4, wherein the plurality of externally-facing interfaces enable at least one of creating, upgrading, downgrading, scaling, replicating, backing up, failing over, restoring, rebooting, hibernating, resuming from hibernation, or deleting the database in the data environment.

10. A system for enabling self-service administration of a database, comprising:

at least one processor; and

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

provide a plurality of externally-facing interfaces each enabling a user to submit a Web service request to a control environment and corresponding to an action to be performed with respect to configuration of the database in a data environment, the data environment being separate from the control environment; and

in response to receiving the Web service request to the control environment through one of the plurality of externally-facing interfaces, cause at least one task to be performed in the data environment corresponding to the action,

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

11. The system of claim 10, wherein the database can be accessed using a data interface of the data environment that is configured to operate independent of the control environment.

12. The system of claim 11, wherein the instructions, when executed by the at least one processor, further cause the system to:

provide the user with a DNS name or network address information enabling the user to access the database using the data interface.

13. The system of claim 10, wherein the instructions to cause the at least one task to be performed in the data environment comprise instructions, when executed by the least one processor, cause the system to:

determine a workflow to be executed in the control environment to perform the action in the data environment; and

execute the workflow in the control environment, the workflow including one or more tasks to be performed in the data environment corresponding to the action.

14. The system of claim 13, wherein the workflow is based upon a workflow template.

15. The system of claim 13, wherein the workflow is based at least in part upon an engine of the database.

16. The system of claim 10, wherein the plurality of externally-facing interfaces enable at least one of creating, upgrading, downgrading, scaling, replicating, backing up, failing over, restoring, rebooting, hibernating, resuming from hibernation, or deleting the database in the data environment.

17. A non-transitory computer readable storage medium storing instructions for enabling self-service administration of a database, the instructions when executed by a processor causing the processor to:

provide a plurality of externally-facing interfaces each enabling a user to submit a Web service request to a control environment and corresponding to an action to be performed with respect to configuration of the database in a data environment, the data environment being separate from the control environment; and

in response to receiving the Web service request to the control environment through one of the plurality of externally-facing interfaces, cause at least one task to be performed in the data environment corresponding to the action,

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

18. The non-transitory computer readable storage medium of claim 17, wherein the database can be accessed using a data interface of the data environment that is configured to operate independent of the control environment.

19. The non-transitory computer readable storage medium of claim 18, wherein the instructions when executed by the processor further cause the processor to:

provide the user with a DNS name or network address information enabling the user to access the database using the data interface.

20. The non-transitory computer readable storage medium of claim 17, wherein the instructions to cause the at least one task to be performed in the data environment comprise instructions, when executed by the processor, to cause the processor to:

determine a workflow to be executed in the control environment to perform the action in the data environment; and

execute the workflow in the control environment, the workflow including the at least one task to be performed in the data environment corresponding to the action.

21. The non-transitory computer readable storage medium of claim 20, wherein the workflow is based upon a workflow template.

22. The non-transitory computer readable storage medium of claim 20, wherein the workflow is based at least in part upon an engine of the database.

23. The non-transitory computer readable storage medium of claim 17, wherein the plurality of externally-facing interfaces enable at least one of creating, upgrading, downgrading, scaling, replicating, backing up, failing over, restoring, rebooting, hibernating, resuming from hibernation, or deleting the database in the data environment.