SELF-SERVICE CONFIGURATION FOR DATA ENVIRONMENT

• US 20110083138A1
• Filed: 10/07/2009
• Published: 04/07/2011
• Est. Priority Date: 10/07/2009
• Status: Active Grant

• Current Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Original Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Inventors: SIVASUBRAMANIAN, Swaminathan, Sheth, Rajesh Sudhakar, McAlister, Grant Alexander MacDonald
• Granted Patent: US 9,135,283 B2
• Time in Patent Office: Days
• US Class Current: 719/328
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

The values of various operating and/or configuration parameters of a data environment are managed using a set of self-service Web services and interfaces of a separate control environment. A customer can submit a Web services call into an externally-facing application programming interface (API) or other such externally-facing interface of the control environment. The API receiving the call, as well as information extracted from the call, can be used to determine appropriate adjustments to be performed in the data environment. A workflow can be instantiated that includes tasks used to validate and/or apply the adjustments to the target resources, such as databases, data instances, data stores, instance classes, etc. Various real-time functions such as monitoring and auto-scaling also can be performed via the control plane.

Claims

1. A computer-implemented method of managing configuration values for a relational database instance using one or more self-service Web services, 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, each API corresponding to a desired action to be performed with respect to a relational database for the user in a separate database environment;

providing a default parameter group for at least one data instance to be provisioned in the database environment, the default parameter group including values for a plurality of database configuration parameters, the default parameter group having a first version number;

in response to receiving a first Web service request to the control environment through a first API of the plurality of APIs, causing at least one task to be performed to specify a first modified parameter group to be applied when provisioning a data instance in the separate database environment, the first modified parameter group having a second version number; and

in response to receiving a second Web service request to the control environment through a second API of the plurality of APIs, causing at least one task to be performed in the separate database environment to apply a second modified parameter group having a third version number for at least one provisioned data instance for the user,

wherein the user is able to specify or modify parameter values of one or more instances of the relational database by submitting a single Web services call to the control environment.

2. The computer-implemented method of claim 1, wherein the default parameter group includes at least one parameter value optimized for the at least one data instance to be provisioned in the database environment.

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

updating information stored in the control environment for a current parameter group version of the at least one data instance and state information representing any changes being applied to the at least one data instance.

4. A computer-implemented method of enabling a user to manage operational parameters of data instances in a database environment using a separate control environment, 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 the control environment, each API corresponding to a desired action to be performed with respect to one or more data instances for the user in a database environment;

providing a default parameter group for one or more one data instances to be provisioned in the database environment, the default parameter group including values for a plurality of database parameters, the default parameter group having a first version number; and

in response to receiving a Web service request to the control environment through one of the plurality of APIs, causing a modified parameter group to be applied for the one or more data instances, the modified parameter group having a second version number,

wherein the user is able to modify parameter values for any of the one or more data instances before creation of at least one of the data instances or while any of the one or more data instances is running in the database environment.

5. The computer-implemented method of claim 4, wherein updated parameter values of the modified parameter group are applied to the running data instances at substantially the time of the request when the parameter values are dynamic values, and

wherein the parameter values are applied to the running data instances upon a reboot of the data instances when the parameter values are static values.

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

in response to receiving a Web service request to the control environment through one of the plurality of APIs, causing one or more of the running data instances to reboot, whereby the static values are applied.

7. The computer-implemented method of claim 4, wherein applying the modified parameter group for at least one data instance further comprises installing a configuration file including the at least one parameter value for each data instance to which the modified parameter group is to be applied.

8. The computer-implemented method of claim 4, wherein the database environment is operable to provide a plurality of data instances in a data instance class, and

wherein the user is further able to specify a modified parameter group for all of the plurality of instances in the data instance class using a single Web service call.

9. The computer-implemented method of claim 4, further comprising:

in response to the Web service request, executing a workflow in the control environment including at least one task to cause the modified parameter group to be applied for the one or more data instances, the workflow further including at least one task to update information for a current parameter group version of the one or more data instances and state information representing any changes being applied to the one or more data instances.

10. The computer-implemented method of claim 9, wherein a monitoring component of the control plane periodically communicates with a host manager for each of the one or more data instances and, in response to the host manager updating a current version of the parameter group for one of the data instances, updates information for the current parameter group version of the data instance and state information representing the modified parameter group having been successfully applied.

11. The computer-implemented method of claim 10, further comprising:

monitoring information for the one or more data instances; and

automatically applying an updated parameter group based at least in part upon the monitored information when at least one parameter value in the update parameter group is to be updated.

12. The computer-implemented method of claim 4, further comprising:

storing parameter values for a current version of the parameter group for a data instance to a data store in the control environment.

13. The computer-implemented method of claim 4, wherein the user is able to specify a relationship between a parameter value and an aspect of the database environment, and

wherein the parameter value is capable of being automatically updated using the relationship and changes in the aspect of the database environment.

14. The computer-implemented method of claim 4, wherein the Web service request is database engine independent.

15. A system for enabling a user to manage operational parameters of data instances in a database environment using a separate control environment, comprising:

a processor; and

a memory device including instructions that, when executed by the processor, cause the processor to;

provide a plurality of application programming interfaces (APIs) each enabling a user to submit a Web service request to the control environment, each API corresponding to a desired action to be performed with respect to one or more data instances for the user in a database environment;

provide a default parameter group for one or more one data instances to be provisioned in the database environment, the default parameter group including values for a plurality of database parameters, the default parameter group having a first version number; and

in response to receiving a Web service request to the control environment through one of the plurality of APIs, cause a modified parameter group to be applied for the one or more data instances, the modified parameter group having a second version number,

wherein the user is able to modify parameter values for any of the one or more data instances before creation of at least one of the data instances or while any of the one or more data instances is running in the database environment.

16. The system of claim 15, wherein updated parameter values of the modified parameter group are applied to the running data instances at substantially the time of the request when the parameter values are dynamic values, and

wherein the parameter values are applied to the running data instances upon a reboot of the data instances when the parameter values are static values.

17. The system of claim 15, wherein the instructions when executed further cause the processor to:

in response to receiving a Web service request to the control environment through one of the plurality of APIs, cause one or more of the running data instances to reboot, whereby the static values are applied.

18. The system of claim 15, wherein applying the modified parameter group for at least one data instance further comprises installing a configuration file including the at least one parameter value for each data instance to which the modified parameter group is to be applied.

19. The system of claim 15, wherein the database environment is operable to provide a plurality of data instances in a data instance class, and

wherein the user is further able to specify a modified parameter group for all of the plurality of instances in the data instance class using a single Web service call.

20. The system of claim 15, wherein the instructions when executed further cause the processor to:

in response to the Web service request, executing a workflow in the control environment including at least one task to cause the modified parameter group to be applied for the one or more data instances, the workflow further including at least one task to update information for a current parameter group version of the one or more data instances and state information representing any changes being applied to the one or more data instances,

wherein a monitoring component of the control plane periodically communicates with a host manager for each of the one or more data instances and, in response to the host manager updating a current version of the parameter group for one of the data instances, updates information for the current parameter group version of the data instance and state information representing the modified parameter group having been successfully applied.

21. A computer readable storage medium storing instructions for manage operational parameters of data instances in a database environment using a separate control environment, the instructions when executed by a processor causing the processor to:

provide a plurality of application programming interfaces (APIs) each enabling a user to submit a Web service request to the control environment, each API corresponding to a desired action to be performed with respect to one or more data instances for the user in a database environment;

provide a default parameter group for one or more one data instances to be provisioned in the database environment, the default parameter group including values for a plurality of database parameters, the default parameter group having a first version number; and

in response to receiving a Web service request to the control environment through one of the plurality of APIs, cause a modified parameter group to be applied for the one or more data instances, the modified parameter group having a second version number,

wherein the user is able to modify parameter values for any of the one or more data instances before creation of at least one of the data instances or while any of the one or more data instances is running in the database environment.

22. The computer readable storage medium of claim 21, wherein updated parameter values of the modified parameter group are applied to the running data instances at substantially the time of the request when the parameter values are dynamic values, and

wherein the parameter values are applied to the running data instances upon a reboot of the data instances when the parameter values are static values.

23. The computer readable storage medium of claim 21, wherein the instructions when executed further cause the processor to:

in response to receiving a Web service request to the control environment through one of the plurality of APIs, cause one or more of the running data instances to reboot, whereby the static values are applied.

24. The computer readable storage medium of claim 21, wherein applying the modified parameter group for at least one data instance further comprises installing a configuration file including the at least one parameter value for each data instance to which the modified parameter group is to be applied.

25. The computer readable storage medium of claim 21, wherein the database environment is operable to provide a plurality of data instances in a data instance class, and

wherein the user is further able to specify a modified parameter group for all of the plurality of instances in the data instance class using a single Web service call.