Cloud optimizations are critical to ensuring that you get the most out of your Azure investments, especially in complex environments with many Azure resources spread across multiple subscriptions and resource groups. Azure Advisor helps you optimize your Azure resources for high availability, security, performance, and cost, by providing free, personalized recommendations based on your Azure usage and configurations.
One of the core value propositions for running your MySQL servers on Azure Database for MySQL service is Intelligent Performance insights. Azure Database for MySQL leverages Azure Advisor to bring users these intelligent insights to ensure that they get the most out of their MySQL databases. Azure Advisor uses database server configuration details and usage metrics to provide targeted recommendations based on your workload pattern. Over the last year, we have seen increased Advisor recommendation adoption and overwhelmingly positive response from customers who have implemented the recommendations and seen visible improvements in the performance of their servers.
The team started off surfacing recommendations by programmatically analyzing server metrics telemetry continuously to determine whether workload performance can be improved by configuring one or more of resource settings. Spanning four different areas, the initial set of recommendations includes:
Read more about the initial recommendation set in this blog post.
We aim to continuously make it easier for you to manage your MySQL servers, and we’ve added three new recommendations to the Azure platform. These recommendations are focused on cost and performance optimizations for your Azure resources.
To improve connection management, we recommend that you reduce the number of short-lived connections and eliminate unnecessary idle connections. To do this, configure a server-side connection-pooler, such as ProxySQL.
You can also postpone or dismiss these recommendations. For example, if you do not want to receive recommendations for a specific subscription or resource group, you can use the portal or the CLI to configure Azure Advisor to limit the resources on which recommendation are provided. For more information about using Azure Advisor, see the article Get started with Azure Advisors.
If you identify any problems or want to make a feature suggestion, please reach out to the Ask Azure DB for MySQL alias. You can also engage with us on the Azure feedback forums for Azure Database for MySQL feedback forum.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.