Database instance clustering
Database instances can be clustered using various attributes, such as attributes reflecting resources assigned to a database instance, attributes reflecting configuration or software version information, or attributes that reflect users or usage of a database instance. As it can be resource intensive to capture database workloads, one or more database instances can be selected from one or more of the clusters and workloads can be captured from such instances. In a similar manner, various attributes can be used to cluster database instances, and one or more instances can be selected from one or more of the clusters, and a captured workload can be replayed on such instances.
1. A computing system comprising:
at least one hardware processor;
at least one memory coupled to the at least one hardware processor; and
one or more computer-readable storage media comprising computer-executable instructions that, when executed, cause the computing system to perform operations comprising:
for respective database instances of a plurality of database instances, receiving a respective set of attribute values for a defined set of attributes describing database instances of the plurality of database instances, wherein the defined set of attributes comprises values reflecting characteristics of database instances that are used to group the database instances into clusters for selecting representative instances to support workload capture and replay;
clustering the plurality of database instances into a plurality of clusters using the respective set of attribute values for the defined set of attributes for database instances of the plurality of database instances;
selecting at least one representative database instance from at least one cluster of the plurality of clusters using cluster definitions resulting from the clustering; and
capturing a workload executed on the at least one representative database instance, and fewer than database instances of the at least one cluster, to provide a captured workload, wherein capturing the workload comprises recording information describing database operations executed as part of the workload, the recorded information being sufficient to enable replay of the workload at another database instance of the plurality of database instances.
2. The computing system of claim 1 , the operations further comprising:
replaying the captured workload on a database instance.
3. The computing system of claim 2 , the operations further comprising:
capturing database performance metrics while replaying the captured workload on the database instance;
comparing the database performance metrics from replaying the captured workload with database performance metrics generated during capture of the workload; and
rendering for display on a user interface a report comparing database performance metrics from replaying the captured workload with the database performance metrics generated during capture of the workload.
4. The computing system of claim 2 , the operations further comprising:
capturing database query results while replaying the captured workload on the database instance;
comparing the database query results from replaying the captured workload with database query results generated during capture of the workload; and
rendering for display on a user interface a report comparing query results from replaying the captured workload with the query results generated during capture of the workload.
5. The computing system of claim 2 , the operations further comprising:
selecting the database instance, for replaying the captured workload, from the at least one cluster.
6. The computing system of claim 5 , wherein the selecting the database instance from the at least one cluster is based at least part on a set of defined criteria.
7. The computing system of claim 1 , the operations further comprising:
receiving values of the respective set of attribute values from multiple components of a cloud database system.
8. The computing system of claim 1 , wherein the defined set of attributes comprises at least one attribute reflecting an amount of a computer resource assigned to a database instance.
9. The computing system of claim 1 , wherein the defined set of attributes comprises at least one attribute representing a throughput metric of workload of a database instance.
10. The computing system of claim 1 , wherein the defined set of attributes comprises at least one attribute representing a number of times a feature of a database instance is used over a time period.
11. The computing system of claim 1 , wherein the defined set of attributes comprises at least one attribute representing activation of a feature of a database instance.
12. The computing system of claim 1 , wherein the defined set of attributes comprises crash information for a database instance.
13. The computing system of claim 1 , wherein the defined set of attributes comprises at least one attribute measuring query performance for queries executed on a database instance.
14. The computing system of claim 1 , wherein the defined set of attributes comprises an identifier of a software application with which a database instance is used.
15. A method, implemented in a computing system comprising at least one memory and at least one hardware processor coupled to the at least one memory, the method comprising:
for respective database instances of a plurality of database instances, receiving a respective set of attribute values for a defined set of attributes describing database instances of the plurality of database instances, wherein the defined set of attributes comprises values reflecting characteristics of database instances that are used to group the database instances into clusters for selecting representative instances to support workload capture and replay;
clustering the plurality of database instances into a plurality of clusters using the respective set of attribute values for the defined set of attributes for database instances of the plurality of database instances;
selecting at least one representative database instance from at least one cluster of the plurality of clusters using cluster definitions resulting from the clustering; and
replaying a captured workload on the at least one representative database instance, and fewer than all database instances of the at least one cluster, wherein the captured workload comprises information describing database operations executed as part of the captured workload at another database instance of the plurality of database instances, the information being sufficient to enable replay of the captured workload at the at least one representative database instances.
16. The method of claim 15 , further comprising:
capturing database performance metrics while replaying the captured workload on the at least one representative database instance;
comparing the database performance metrics from replaying the captured workload with database performance metrics generated during capture of the captured workload at another database instance of the plurality of database instances; and
rendering for display on a user interface a report comparing database performance metrics from replaying the captured workload with the database performance metrics generated during capture of the captured workload at the another database instance.
17. The method of claim 15 , the operations further comprising:
capturing database query results while replaying the captured workload on the database instance;
comparing the database query results from replaying the captured workload with database query results generated during capture of the captured workload at another database instance of the plurality of database instances; and
rendering for display on a user interface a report comparing query results from replaying the captured workload with the query results generated during capture of the captured workload at the another database instance.
18. One or more computer-readable storage media comprising:
computer-executable instructions that, when executed by a computing system comprising at least one hardware processor and at least one memory coupled to the at least one hardware processor, cause the computing system to, for respective database instances of a plurality of database instances, receive a respective set of attribute values for a defined set of attributes describing database instances of the plurality of database instances, wherein the defined set of attributes comprises values reflecting characteristics of database instances that are used to group the database instances into clusters for selecting representative instances to support workload capture and replay;
computer-executable instructions that, when executed by the computing system, cause the computing system to cluster the plurality of database instances into a plurality of clusters using the respective set of attribute values for the defined set of attributes for database instances of the plurality of database instances;
computer-executable instructions that, when executed by the computing system, cause the computing system to select at least one representative database instance from at least one cluster of the plurality of clusters using cluster definitions resulting from the clustering; and
computer-executable instructions that, when executed by the computing system, cause the computing system to capture a workload executed on the at least one representative database instance, and fewer than database instances of the at least one cluster, to provide a captured workload, wherein capturing the workload comprises recording information describing database operations executed as part of the workload, the recorded information being sufficient to enable replay of the workload at another database instance of the plurality of database instances.
19. The one or more computer-readable storage media of claim 18 , further comprising:
computer-executable instructions that, when executed by the computing system, cause the computing system to replay the captured workload on a database instance of the plurality of database instances other than the at least one representative database instance.
20. The one or more computer-readable storage media of claim 19 , further comprising:
computer-executable instructions that, when executed by the computing system, cause the computing system to capture database performance metrics or query execution results while replaying the captured workload on the database instance;
computer-executable instructions that, when executed by the computing system, cause the computing system to compare the database performance metrics or query execution results from replaying the captured workload with, respectively, database performance metrics or query execution results generated during capture of the workload; and
computer-executable instructions that, when executed by the computing system, cause the computing system to render for display on a user interface a report comparing database performance metrics or query execution results from replaying the captured workload with, respectively, the database performance metrics or query execution results generated during capture of the workload.