Introduction to Azure Database for MySQL - Online Course

Azure Database for MySQL Server Management Components

by

Hi there! In a previous article, we have discussed about the available MySQL deployment options in Azure. In this new article, we will be discussing about the available Azure Database for MySQL server management components.

 

Available Server Management Components for MySQL on the Azure Cloud Platform

The server management components for MySQL server on the Azure platform, is a rich set of components, that enables you to efficiently manage your Azure Database for MySQL, mainly focusing on performance and monitoring aspects.

Note that, if you are using the PaaS MySQL deployment options on Azure, that means that other database administration tasks, are handled by the Azure Platform, such as: patching, backups, high availability, security, etc.

In the below list, you can see the categories of server management components and features for Azure Database for MySQL:

  • Overview, Activity Log and IAM
  • Settings
  • Intelligent Performance
  • Monitoring
  • Automation
  • Support + troubleshooting

Let’s discuss more about these categories of features.

 

Overview, Activity Log and IAM

Under this server management category, you have access to the server overview, activity log and identity and access management (IAM).

Moreover, you can manage tags, as well as, use the “diagnose and solve problems” feature.

 

Settings

Under the “Settings” management category, you can use the following features:

  • Connection security
  • Connection strings
  • Server parameters
  • Active Directory admin
  • Pricing tier
  • Properties
  • Locks

 

Intelligent Performance

Under the “Intelligent Performance” category, you can use the below features:

  • Query Performance Insight
  • Performance recommendations

 

Monitoring

Under the “Monitoring” category, you can manage your MySQL Server on Azure, using the below set of features:

  • Alerts
  • Metrics
  • Diagnostic settings
  • Logs
  • Server logs

 

Automation

Under the “Automation” category, you can use the below 2 features:

  • Tasks
  • Export template

 

Support + Troubleshooting

Under the “Support + troubleshooting” category, you can use the below 2 features:

  • Resource health
  • New support request

 

 

Learn all about MySQL on Azure – Enroll to our course!

You can learn more about MySQL on the Azure platform, by enrolling to our official course on Udemy titled “Introduction to Azure Database for MySQL“.

Introduction to Azure Database for MySQL - Online Course
(Lifetime Access, live guides, certificate of completion, downloadable resources and more!)

Enroll with Discount

Via our course, among other, you will learn about the different MySQL deployment options in Azure and how to create an Azure Database for MySQL server, using the Platform as a Service (PaaS) deployment option. Moreover, you will learn how to access Azure Database for MySQL from on-premises, using MySQL Workbench and the mysql command line tool, as well as, how to efficiently manage your Azure Database for MySQL server, using the available tools and features in Azure Portal.

 

 

Watch our video lecture the MySQL server management components in Azure

The below video lecture, is part of our online course on Udemy, titled “Introduction to Azure Database for MySQL“.

Enroll to the Course!

 

 

Featured Online Courses:

 

Read Also:

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Easily generate snippets with Snippets Generator!

Secure your databases using DBA Security Advisor!

Generate dynamic T-SQL scripts with Dynamic SQL Generator!

Check our latest software releases!

Check our eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub

Views: 1,418