Improved portal experience to manage Azure Database for MySQL - Flexible Server

Published Nov 29 2021 10:33 AM 1,196 Views
Microsoft

We’re constantly working to improve your user experience in the Azure portal. Our goal is to offer you a productive and easy-to-use experience for provisioning, managing, and monitoring your instances of MySQL - Flexible Server. For example, we’ve added…

 

  • Get started with the new Overview page
  • Diagnose and solve potential problems
  • Improved Backup and restore experience
  • Improve monitoring views with Workbook integration

In this post, I’d like to share highlights of our latest improvements to the Azure portal experience, which are detailed in the following sections.

 

Get started with the new Overview page

 

A new Overview page for Azure Database for MySQL - Flexible Server is designed to help users get information about all server properties, access key monitoring metrics, and take advantage of tutorials designed to kickstart application development using PHP, .NET, or Java.

 

  • Getting started: New customers can use the information on this tab for guidance on configuring network access to the instance and connecting with application drivers to prepare for application development. The tab also provides access to sample database schemas to help new customers get started.

 

mk_sunitha_1-1638075922546.png

 

  • Properties: This tab provides details about key server properties, such as the compute sku, storage, etc. The tab also shows all the features we offer to help users determine whether to configure these features based on specific application requirements.

 

mk_sunitha_2-1638075922583.png

 

  • Monitoring: This tab provides users a peek into key server metrics such as CPU, Memory, Storage, Success/Failed connections, and queries to help monitor a server's health. Customers perform tasks such as creating notification alerts, scaling up compute or storage resources to accommodate high CPU/Memory/DB connections, or enabling workbooks to build a dashboard for viewing server health based on comprehensive monitoring data.

 

mk_sunitha_3-1638075922633.png

 

  • Tutorials: This tab provides uses access to tutorials designed to help them get started with building and developing applications.

 

mk_sunitha_4-1638075922663.png

 

Diagnose and solve potential problems

 

The Diagnose and solve problems page for a server provides detail about how to troubleshoot common issues related to availability, connectivity, migration, scaling, performance, and more. Follow the guidance provided on the page to quickly mitigate any ongoing issues and take action to resolve them.

 

mk_sunitha_8-1638076052507.png

 

Improved Backup and restore experience

 

We’re delighted to announce that the upgraded Backup and Restore experience for Azure Database for MySQL - Flexible Server is lifting the cloak of invisibility from a server’s automated full backups. We’re launching a dedicated Backup and Restore blade in the Azure portal, which allows customers to view backup history within the retention period and to use a full server backup to quickly restore a server. Checkout all the improvements for Backup and restore experience.

 

Improve monitoring views with Workbook integration

 

Azure Database for MySQL - Flexible Server is now integrated with Azure Monitor Workbooks. Workbooks provide a flexible canvas for data analysis and enable the creation of rich visual reports within the Azure portal. There are three default templates available for Azure Database for MySQL - Flexible Server, as shown in the following image:

 

mk_sunitha_6-1638075922738.png

 

  • The Overview template gives the Instance Summary and top-level metrics to you help understand resource utilization on your server. You’ll be able to see the below details for the Azure Database for MySQL – Flexible Server
  • The Auditing template provides a summary and details of the Auditing events collected for the server. The following views are available with this template for the Azure Database for MySQL – Flexible Server
  • The Query Performance Insight template provides a summary and details of query workload on the instance, long running query, slow query analysis and connection metrics.

Learn more about Workbook integration.

 

Share feedback via the portal

 

You will see a Feedback button on page when managing your server in the Azure portal. Please tell us about your experience when you update the server capabilities such networking, server parameters , replicas, high availability  in the portal for your instance of MySQL - Flexible Server.

mk_sunitha_7-1638075922765.png

 

Summary

We hope that these improvements improve your experience to get started and build applications using Azure Database for MySQL. Be sure to check the Azure Database for MySQL - Flexible Server documentation, Try Azure Database for MySQL - Flexible Server for free.! If you have any questions, feel free to reach out to us using Azure DB for MySQL team.

%3CLINGO-SUB%20id%3D%22lingo-sub-2870859%22%20slang%3D%22en-US%22%3EImproved%20portal%20experience%20to%20manage%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2870859%22%20slang%3D%22en-US%22%3E%3CP%3EWe%E2%80%99re%20constantly%20working%20to%20improve%20your%20user%20experience%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fportal.azure.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAzure%20portal%3C%2FA%3E.%20Our%20goal%20is%20to%20offer%20you%20a%20productive%20and%20easy-to-use%20experience%20for%20provisioning%2C%20managing%2C%20and%20monitoring%20your%20instances%20of%20MySQL%20-%20Flexible%20Server.%20For%20example%2C%20we%E2%80%99ve%20added%E2%80%A6%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EGet%20started%20with%20the%20new%20Overview%20page%3C%2FLI%3E%0A%3CLI%3EDiagnose%20and%20solve%20potential%20problems%3C%2FLI%3E%0A%3CLI%3EImproved%20Backup%20and%20restore%20experience%3C%2FLI%3E%0A%3CLI%3EImprove%20monitoring%20views%20with%20Workbook%20integration%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EIn%20this%20post%2C%20I%E2%80%99d%20like%20to%20share%20highlights%20of%20our%20latest%20improvements%20to%20the%20Azure%20portal%20experience%2C%20which%20are%20detailed%20in%20the%20following%20sections.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--322086147%22%20id%3D%22toc-hId-330986291%22%3EGet%20started%20with%20the%20new%20Overview%20page%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA%20new%20%3CSTRONG%3EOverview%3C%2FSTRONG%3E%20page%20for%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server%20is%20designed%20to%20help%20users%20get%20information%20about%20all%20server%20properties%2C%20access%20key%20monitoring%20metrics%2C%20and%20take%20advantage%20of%20tutorials%20designed%20to%20kickstart%20application%20development%20using%20PHP%2C%20.NET%2C%20or%20Java.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EGetting%20started%3C%2FSTRONG%3E%3A%20New%20customers%20can%20use%20the%20information%20on%20this%20tab%20for%20guidance%20on%20configuring%20network%20access%20to%20the%20instance%20and%20connecting%20with%20application%20drivers%20to%20prepare%20for%20application%20development.%20The%20tab%20also%20provides%20access%20to%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FAzure-samples%2Fmysql-database-samples%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Esample%20database%20schemas%3C%2FA%3E%20to%20help%20new%20customers%20get%20started.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mk_sunitha_1-1638075922546.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329826iFA4CE6B17E4734D9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mk_sunitha_1-1638075922546.png%22%20alt%3D%22mk_sunitha_1-1638075922546.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EProperties%3C%2FSTRONG%3E%3A%20This%20tab%20provides%20details%20about%20key%20server%20properties%2C%20such%20as%20the%20compute%20sku%2C%20storage%2C%20etc.%20The%20tab%20also%20shows%20all%20the%20features%20we%20offer%20to%20help%20users%20determine%20whether%20to%20configure%20these%20features%20based%20on%20specific%20application%20requirements.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mk_sunitha_2-1638075922583.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329827iA6953DC82E745094%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mk_sunitha_2-1638075922583.png%22%20alt%3D%22mk_sunitha_2-1638075922583.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EMonitoring%3C%2FSTRONG%3E%3A%20This%20tab%20provides%20users%20a%20peek%20into%20key%20server%20metrics%20such%20as%20CPU%2C%20Memory%2C%20Storage%2C%20Success%2FFailed%20connections%2C%20and%20queries%20to%20help%20monitor%20a%20server's%20health.%20Customers%20perform%20tasks%20such%20as%20creating%20notification%20alerts%2C%20scaling%20up%20compute%20or%20storage%20resources%20to%20accommodate%20high%20CPU%2FMemory%2FDB%20connections%2C%20or%20enabling%20workbooks%20to%20build%20a%20dashboard%20for%20viewing%20server%20health%20based%20on%20comprehensive%20monitoring%20data.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mk_sunitha_3-1638075922633.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329828i56DD7919DF16739D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mk_sunitha_3-1638075922633.png%22%20alt%3D%22mk_sunitha_3-1638075922633.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3ETutorials%3C%2FSTRONG%3E%3A%20This%20tab%20provides%20uses%20access%20to%20tutorials%20designed%20to%20help%20them%20get%20started%20with%20building%20and%20developing%20applications.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mk_sunitha_4-1638075922663.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329829iF54061BA17800B48%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mk_sunitha_4-1638075922663.png%22%20alt%3D%22mk_sunitha_4-1638075922663.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--2129540610%22%20id%3D%22toc-hId--1476468172%22%3EDiagnose%20and%20solve%20potential%20problems%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20%3CSTRONG%3EDiagnose%20and%20solve%20problems%3C%2FSTRONG%3E%20page%20for%20a%20server%20provides%20detail%20about%20how%20to%20troubleshoot%20common%20issues%20related%20to%20availability%2C%20connectivity%2C%20migration%2C%20scaling%2C%20performance%2C%20and%20more.%20Follow%20the%20guidance%20provided%20on%20the%20page%20to%20quickly%20mitigate%20any%20ongoing%20issues%20and%20take%20action%20to%20resolve%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mk_sunitha_8-1638076052507.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329833iE9D27CB193221522%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mk_sunitha_8-1638076052507.png%22%20alt%3D%22mk_sunitha_8-1638076052507.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-357972223%22%20id%3D%22toc-hId-1011044661%22%3EImproved%20Backup%20and%20restore%20experience%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%E2%80%99re%20delighted%20to%20announce%20that%20the%20upgraded%20Backup%20and%20Restore%20experience%20for%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server%20is%20lifting%20the%20cloak%20of%20invisibility%20from%20a%20server%E2%80%99s%20automated%20full%20backups.%20We%E2%80%99re%20launching%20a%20dedicated%20%3CSTRONG%3EBackup%20and%20Restore%3C%2FSTRONG%3E%20blade%20in%20the%20Azure%20portal%2C%20which%20allows%20customers%20to%20view%20backup%20history%20within%20the%20retention%20period%20and%20to%20use%20a%20full%20server%20backup%20to%20quickly%20restore%20a%20server.%20Checkout%20all%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-for-mysql%2Frestore-10x-faster-in-azure-database-for-mysql-flexible-server%2Fba-p%2F2895288%22%20target%3D%22_blank%22%3Eimprovements%20for%20Backup%20and%20restore%20experience.%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1449482240%22%20id%3D%22toc-hId--796409802%22%3EImprove%20monitoring%20views%20with%20Workbook%20integration%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAzure%20Database%20for%20MySQL%20-%20Flexible%20Server%20is%20now%20integrated%20with%20Azure%20Monitor%20Workbooks.%20Workbooks%20provide%20a%20flexible%20canvas%20for%20data%20analysis%20and%20enable%20the%20creation%20of%20rich%20visual%20reports%20within%20the%20Azure%20portal.%20There%20are%20three%20default%20templates%20available%20for%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server%2C%20as%20shown%20in%20the%20following%20image%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mk_sunitha_6-1638075922738.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329830i7C9C3E9E603966A0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mk_sunitha_6-1638075922738.png%22%20alt%3D%22mk_sunitha_6-1638075922738.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EThe%20%3CSTRONG%3EOverview%3C%2FSTRONG%3E%20template%20gives%20the%20Instance%20Summary%20and%20top-level%20metrics%20to%20you%20help%20understand%20resource%20utilization%20on%20your%20server.%20You%E2%80%99ll%20be%20able%20to%20see%20the%20below%20details%20for%20the%20Azure%20Database%20for%20MySQL%20%E2%80%93%20Flexible%20Server%3C%2FLI%3E%0A%3CLI%3EThe%20%3CSTRONG%3EAuditing%3C%2FSTRONG%3E%20template%20provides%20a%20summary%20and%20details%20of%20the%20Auditing%20events%20collected%20for%20the%20server.%20The%20following%20views%20are%20available%20with%20this%20template%20for%20the%20Azure%20Database%20for%20MySQL%20%E2%80%93%20Flexible%20Server%3C%2FLI%3E%0A%3CLI%3EThe%20%3CSTRONG%3EQuery%20Performance%20Insight%3C%2FSTRONG%3E%20template%20provides%20a%20summary%20and%20details%20of%20query%20workload%20on%20the%20instance%2C%20long%20running%20query%2C%20slow%20query%20analysis%20and%20connection%20metrics.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3ELearn%20more%20about%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fmysql%2Fflexible-server%2Fconcepts-workbooks%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWorkbook%20integration%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1038030593%22%20id%3D%22toc-hId-1691103031%22%3EShare%20feedback%20via%20the%20portal%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20will%20see%20a%20%3CSTRONG%3EFeedback%3C%2FSTRONG%3E%20button%20on%20page%20when%20managing%20your%20server%20in%20the%20Azure%20portal.%20Please%20tell%20us%20about%20your%20experience%20when%20you%20update%20the%20server%20capabilities%20such%20networking%2C%20server%20parameters%20%2C%20replicas%2C%20high%20availability%20%26nbsp%3Bin%20the%20portal%20for%20your%20instance%20of%20MySQL%20-%20Flexible%20Server.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mk_sunitha_7-1638075922765.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329832i223323F129CCBF48%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mk_sunitha_7-1638075922765.png%22%20alt%3D%22mk_sunitha_7-1638075922765.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--769423870%22%20id%3D%22toc-hId--116351432%22%3ESummary%3C%2FH2%3E%0A%3CP%3EWe%20hope%20that%20these%20improvements%20improve%20your%20experience%20to%20get%20started%20and%20build%20applications%20using%20Azure%20Database%20for%20MySQL.%20Be%20sure%20to%20check%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fmysql%2Fflexible-server%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Database%20for%20MySQL%20-%20Flexible%20Server%3C%2FA%3E%20documentation%2C%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fmysql%2Fflexible-server%2Fhow-to-deploy-on-azure-free-account%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETry%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server%20for%20free%3C%2FA%3E.!%20If%20you%20have%20any%20questions%2C%20feel%20free%20to%20reach%20out%20to%20us%20using%20%3CA%20href%3D%22mailto%3A%2522Ask%2520Azure%2520DB%2520for%2520MySQL%2522%2520%253cAskAzureDBforMySQL%40service.microsoft.com%253e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAzure%20DB%20for%20MySQL%20team%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2870859%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20out%20out%20the%20improvements%20we've%20made%20to%20the%20portal%20experience%20for%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server.%20Managing%20your%20server%20resources%20in%20the%20Azure%20portal%20is%20easier%20than%20ever%2C%20making%20it%20more%20efficient%20to%20configure%20and%20manage%20database%20server%20operations.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mk_sunitha_0-1638075886292.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329825iCDB9B1261E583CF0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mk_sunitha_0-1638075886292.png%22%20alt%3D%22mk_sunitha_0-1638075886292.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Co-Authors
Version history
Last update:
‎Nov 29 2021 10:45 AM
Updated by: