Self-service configuration for data environment

• US 9,135,283 B2
• Filed: 10/07/2009
• Issued: 09/15/2015
• 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, McAlister, Grant Alexander MacDonald, Sheth, Rajesh Sudhakar
• Primary Examiner(s): Chbouki, Tarek
• Assistant Examiner(s): ELLIS, MATTHEW J
• Application Number:
  US12/575,381
• Publication Number:
  US 20110083138A1
• Time in Patent Office: 2,169 Days
• Field of Search: 707/609
• US Class Current: 1/1
• 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 parameters 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,

exposing a plurality of application programming interfaces (APIs), to a user, for receiving a Web service request associated with the user at a control environment, each API corresponding to a desired action to be performed with respect to at least one database instance for the user in a database environment;

providing a default parameter group for at least one database instance to be provisioned in the database environment for the user, the default parameter group including a first version number and at least two database configuration parameters indicating how the at least one database instance is to operate; and

receiving, at the control environment, a first Web service request associated with the user to apply a modified parameter group to the at least one database instance;

parsing, at the control environment, the first Web service request to select an API of the plurality of APIs corresponding to a desired action to be performed;

assigning a second version number to the modified parameter group in the control environment;

causing at least one task to be performed to apply the modified parameter group when provisioning the at least one database instance in the database environment, the modified parameter group including the second version number and at least one database configuration parameter different from the database configuration parameters of the default parameter group,

wherein the user is able to specify or modify parameter values of one or more database instances by submitting a single Web service request 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 database 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 database instance and state information representing any changes being applied to the at least one database instance.

4. The computer-implemented method of claim 1, wherein the database configuration parameters further include at least one of:

a buffer cache allocation setting, a query timeout setting, an amount of cache to be allocated for query results, or a connection timeout setting.

5. 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,

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

providing a default parameter group for the one or more one data instances to be provisioned in the database environment for the user, the default parameter group including a first version number and at least two database configuration parameters indicating how the one or more data instances are to operate;

receiving, at the control environment, a first Web service request associated with the user to apply a modified parameter group to the at least one database instance;

parsing, at the control environment, the first Web service request to select an API of the plurality of APIs corresponding to a desired action to be performed;

assigning a second version number to the modified parameter group in the control environment;

causing the modified parameter group to be applied for the one or more data instances, the modified parameter group including a second version number and at least one database configuration parameter different from the database configuration parameters of the default parameter group,

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

6. The computer-implemented method of claim 5, wherein updated parameter values of the modified parameter group are applied to the one or more data instances at substantially the time of the Web service request when the updated parameter values are dynamic values, and

wherein the updated parameter values are applied to the one or more data instances upon a reboot of the one or more data instances when the updated parameter values are static values.

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

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

8. The computer-implemented method of claim 5, wherein causing the modified parameter group to be applied for the one or more data instances further comprises installing a configuration file including at least one parameter value for each data instance to which the modified parameter group is to be applied.

9. The computer-implemented method of claim 5, 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 the modified parameter group for all of the plurality of data instances in the data instance class using a single Web service call.

10. The computer-implemented method of claim 5, 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.

11. The computer-implemented method of claim 10, wherein a monitoring component of the control environment periodically communicates with a host manager for each of the one or more data instances and, in response to the host manager updating a version of a parameter group for the one or more data instances, the monitoring component updates the information for the current parameter group version and the state information.

12. The computer-implemented method of claim 5, 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.

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

14. The computer-implemented method of claim 5, wherein the database configuration parameters further include at least one of:

a buffer cache allocation setting, a query timeout setting, an amount of cache to be allocated for query results, or a connection timeout setting.

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;

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

provide a default parameter group for the one or more one data instances to be provisioned in the database environment for the user, the default parameter group including a first version number and at least two database configuration parameters indicating how the one or more data instances are to operate;

receive, at the control environment, a first Web service request associated with the user to apply a modified parameter group to the at least one database instance;

parse, at the control environment, the first Web service request to select an API of the plurality of APIs corresponding to a desired action to be performed;

assign a second version number to the modified parameter group in the control environment;

cause the modified parameter group to be applied for the one or more data instances, the modified parameter group including a second version number and at least one database configuration parameter different from the database configuration parameters of the default parameter group,

wherein the user is able to modify parameter values for any of the one or more data instances before creation of the one or more 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 one or more data instances at substantially the time of the Web service request when the updated parameter values are dynamic values, and

wherein the updated parameter values are applied to the one or more data instances upon a reboot of the one or more data instances when the updated parameter values are static values.

17. The system of claim 16, 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 the one or more data instances to reboot, whereby the static values are applied.

18. The system of claim 15, wherein causing the modified parameter group to he applied for the one or more data instances further comprises installing a configuration file including 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 the 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 environment periodically communicates with a host manager for each of the one or more data instances and, in response to the host manager updating a version of a parameter group for the one or more data instances, the monitoring component updates the information for the current parameter group version and the state information.

21. A non-transitory computer readable storage medium storing instructions for managing 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:

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

provide a default parameter group for the one or more one data instances to be provisioned in the database environment for the user, the default parameter group including a first version number and at least two database configuration parameters indicating how the one or more data instances are to operate;

receive, at the control environment, a first Web service request associated with the user to apply a modified parameter group to the at least one database instance;

parse, at the control environment, the first Web service request to select an API of the plurality of APIs corresponding to a desired action to be performed;

assign a second version number to the modified parameter group in the control environment;

cause the modified parameter group to be applied for the one or more data instances, the modified parameter group including a second version number and at least one database configuration parameter different from the database configuration parameters of the default parameter group,

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

22. The non-transitory computer readable storage medium of claim 21, wherein updated parameter values of the modified parameter group are applied to the one or more data instances at substantially the time of the Web service request when the updated parameter values are dynamic values, and

wherein the updated parameter values are applied to the one or more data instances upon a reboot of the one or more data instances when the updated parameter values are static values.

23. The non-transitory computer readable storage medium of claim 22, 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 the one or more data instances to reboot, whereby the static values are applied.

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

25. The non-transitory 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 the modified parameter group for all of the plurality of instances in the data instance class using a single Web service call.