Your primary job as a developer is building new value-added services for your customers, and you always expect your database to remain functional and performant. There isn’t time and resources to regularly monitor database performance as it scales; doing so can lead to degraded application performance during peak hours. In the past, the DBA managed resource configurations, but today that responsibility can be shared across many roles which makes it hard to achieve.
You no longer need to be a database expert to optimize your database and can now leverage the intelligent insights available for Azure Database for MySQL workloads through recommendations.
The recommendations feature gives daily insights about your database server to optimize performance. These recommendations are tightly integrated with Azure Advisor to provide you with best practices directly within the Azure portal. Azure Advisor is a personalized cloud consultant that helps you follow guidelines to optimize your Azure deployments.
If you’re running a MySQL application on Azure today and you want to see the recommendations we’ve already made to help you optimize your Azure Database for MySQL resources. Check out the performance recommendations tab in the Azure Advisor.
Azure Database for MySQL recommendation continuously analyses your servers' telemetry to determine if your workload performance can be improved by configuring one or more of the resource settings. Currently, it monitors, analyzes, and makes recommendations for four different areas:
To get started with the recommendation for MySQL, please follow the step below:
Access Azure Database for MySQL Recommendation in the Azure portal
You can access the recommendations feature by default with no additional cost. The recommendations provided are accessible in the Azure Advisor page or the server’s overview page.
Go deeper with the recommendation on Azure portal
Selecting a specific recommendation provides details on the actions needed to address the performance constraints for the server. You can see the recommendation details as you select the recommendation type (Label 1 in Fig 3). To act on a recommendation select recommended actions (Label 2 in Figure 3).
Recommendations can be postponed or dismissed. If you do not want to receive recommendations for a specific subscription or resource group, you can configure Azure Advisor via the portal or by using the CLI to generate recommendations only for those that you specify. For more information about using Azure Advisor, see the article Get started with Azure Advisors.
After implementing any recommendation, be sure to evaluate performance to measure the impact of the changes.
We have had great success for our early users of the recommendations feature in Azure Database for MySQL . Our goal is to simplify the manageability of your database server and make it easier for you to focus on your application development.
So, go ahead and check out the Recommendation for your Azure Database for MySQL. 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.
Manish Kumar
Program Manager, Microsoft
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.