azure-database-mysql

name	azure-database-mysql
description	Expert knowledge for Azure Database for MySQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when using MySQL Flexible Server, HA/DR, backups/geo-restore, Private Link/TLS, or AKS/app integrations, and other Azure Database for MySQL related development tasks. Not for Azure Database for MariaDB (use azure-database-mariadb), Azure Database for PostgreSQL (use azure-database-postgresql), Azure SQL Database (use azure-sql-database), Azure SQL Managed Instance (use azure-sql-managed-instance).
compatibility	Requires network access. Uses mcp_microsoftdocs:microsoft_docs_fetch or fetch_webpage to retrieve documentation.
metadata	{"generated_at":"2026-07-19","generator":"docs2skills/1.0.0"}

Azure Database for MySQL Skill

This skill provides expert guidance for Azure Database for MySQL. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.

How to Use This Skill

IMPORTANT for Agent: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., L35-L120), use read_file with the specified lines. For categories with file links (e.g., [security.md](security.md)), use read_file on the linked reference file

IMPORTANT for Agent: If metadata.generated_at is more than 3 months old, suggest the user pull the latest version from the repository. If mcp_microsoftdocs tools are not available, suggest the user install it: Installation Guide

This skill requires network access to fetch documentation content:

• Preferred: Use mcp_microsoftdocs:microsoft_docs_fetch with query string from=learn-agent-skill. Returns Markdown.
• Fallback: Use fetch_webpage with query string from=learn-agent-skill&accept=text/markdown. Returns Markdown.

Category Index

Category	Lines	Description
Troubleshooting	L37-L53	Diagnosing and fixing MySQL Flexible Server issues: connectivity, performance (CPU/memory/queries), capacity, corruption, replication latency, CLI errors, and using logs/self-heal tools.
Best Practices	L54-L71	Best practices for monitoring, performance tuning, troubleshooting, safe operations, BCDR, and end-to-end migration/optimization for Azure Database for MySQL Flexible Server
Decision Making	L72-L88	Planning MySQL on Azure: version lifecycle, HA/DR and business continuity, sizing tiers/storage, performance baselines, and choosing/migrating/ upgrading to Flexible Server.
Architecture & Design Patterns	L89-L96	Patterns for connecting AKS to MySQL Flexible Server, designing backup/restore, data-in/out replication, high availability (zone-redundant), and read-replica-based scaling.
Limits & Quotas	L97-L105	Limits, quotas, and performance caps for MySQL Flexible Server: max connections/cores/IOPS, storage IOPS behavior, quota increase requests, restart/stop limits, and delete/restore time limits.
Security	L106-L130	Network, auth, and encryption security for Azure MySQL: Private Link, public/private access, firewall rules, TLS and cert rotation, audit logging, migration security, and Microsoft Entra-based access.
Configuration	L131-L161	Configuring Azure Database for MySQL Flexible Server: parameters, HA, networking, logging, monitoring, alerts, maintenance windows, replication, scaling, backups, and read replicas.
Integrations & Coding Patterns	L162-L173	Connecting apps and tools to MySQL Flexible Server (CLI, JDBC, Power BI), managing connection strings, and migrating MySQL data from RDS, on-prem/VM, or large databases using various tools.
Deployment	L174-L183	Automating MySQL Flexible Server deployments and changes (Azure Pipelines, GitHub Actions, Automation), handling backups, geo-restore, version upgrades, and scheduled maintenance.

Troubleshooting

Topic	URL
Use MySQL Flexible Server error logs for troubleshooting	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-error-logs
Resolve database corruption in Azure MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-fix-corrupt-database
Use self-heal to automatically repair MySQL flexible server issues	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-self-heal
Troubleshoot Azure CLI issues for MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-cli-errors
Diagnose and fix MySQL flexible server connection issues	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-connection-issues
Troubleshoot common migration and usage errors in MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-errors
Troubleshoot connectivity issues and connection handling in MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-connectivity-issues
Troubleshoot high CPU utilization in MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-high-cpu-utilization
Troubleshoot low memory issues in MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-low-memory-issues
Troubleshoot query performance issues in MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-query-performance-new

Best Practices

Topic	URL
Implement monitoring best practices for MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-monitor-best-practices
Apply operational best practices for Azure Database for MySQL	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-operation-excellence-best-practices
Run performance benchmarks on Azure MySQL flexible server effectively	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-perf-benchmark-best-practices
Optimize performance of Azure MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-performance-best-practices
Use Azure Monitor and Advisor for MySQL business continuity	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity-advisor-monitor
Apply troubleshooting best practices for MySQL flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-troubleshooting-best-practices
Prevent and recover accidental deletion of MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-prevent-recover-accidental-delete
Restart Azure MySQL Flexible Server safely via portal	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restart-server-portal
Profile and optimize MySQL flexible server queries using EXPLAIN	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-query-performance
Use sys_schema to diagnose performance issues in MySQL flexible server

Decision Making

Topic	URL
Plan Azure Database for MySQL version lifecycle	https://learn.microsoft.com/en-us/azure/mysql/concepts-version-policy
Choose and purchase MySQL Flexible Server reserved capacity	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-reserved-pricing
Plan business continuity for MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity
High availability FAQ and choices for MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-high-availability-faq
Select MySQL Flexible Server service tiers and storage	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-service-tiers-storage
Perform minimal-downtime MySQL migration to Azure flexible server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-migrate-online
Plan and execute Azure MySQL major version upgrades	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade
Plan Azure Database for MySQL major version upgrades	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade-faq
Plan and execute MySQL migration to Azure Database	https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/01-mysql-migration-guide-intro
Assess on-premises MySQL for migration to Azure	https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/03-assessment

Architecture & Design Patterns

Topic	URL
Connect Azure Kubernetes Service to MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-aks
Design data-in replication into MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-data-in-replication
Design data-out replication from MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-data-out-replication
Use read replicas to scale MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-read-replicas

Limits & Quotas

Topic	URL
Service limitations for Azure MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations
Storage IOPS performance characteristics for MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-storage-iops
Request quota increases for Azure MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-request-quota-increase
Restore deleted Azure MySQL flexible servers within retention limits	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-dropped-server
Restart, stop, and start MySQL flexible server with stop-duration limits	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-restart-stop-start

Security

Topic	URL
Use Private Link with Azure MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-private-link
Configure public network access for MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-public
Configure private network access for MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-vnet
Configure Azure MySQL Private Link using Azure CLI	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-azure-cli
Deny public network access for Azure MySQL via portal	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-deny-public-access
Secure Azure MySQL with Private Link using portal	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-portal
Create and connect to MySQL Flexible Server with private access	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-connect-server-vnet
Configure audit logging for MySQL flexible server via CLI	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-audit-logs
Configure and analyze audit logs for Azure MySQL	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-configure-audit
Secure Azure Database for MySQL during and after migration	https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/13-security

Configuration

Topic	URL
Use built-in stored procedures in MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-built-in-store-procedure
Configure monitoring and alerts for MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-monitor-mysql
Reference monitoring metrics for Azure Database for MySQL	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-monitor-mysql-reference
Configure server parameters for Azure MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-server-parameters
Set up metric-based alerts for Azure MySQL	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-alert-on-metric
Enable or disable zone redundant high availability via portal	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-high-availability
Configure zone redundant high availability for Azure MySQL via CLI	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-high-availability-cli
Configure MySQL flexible server parameters via Azure CLI	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-server-parameters-cli
Configure MySQL Flexible Server parameters in Azure portal	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-server-parameters-portal
Configure data-in replication into Azure MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-data-in-replication

Integrations & Coding Patterns

Topic	URL
Use Azure CLI commands to connect to MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-azure-cli
Connect Java applications to MySQL Flexible Server with JDBC	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-java
Connect Azure MySQL Flexible Server to Power BI Desktop	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-with-powerbi-desktop
Migrate Amazon RDS MySQL to Azure flexible server using data-in replication	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-migrate-rds-mysql-data-in-replication
Store MySQL Flexible Server connection strings in Azure Key Vault	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-add-mysql-connection-in-key-vault
Migrate large MySQL databases with mydumper/myloader	https://learn.microsoft.com/en-us/azure/mysql/migrate/concepts-migrate-mydumper-myloader
Migrate on-premises or VM MySQL to Azure flexible server using Import CLI	https://learn.microsoft.com/en-us/azure/mysql/migrate/migrate-external-mysql-import-cli
Migrate MySQL data to Azure using MySQL Workbench	https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/09-data-migration-with-mysql-workbench

Deployment

Topic	URL
Configure Azure Pipelines task for Azure MySQL deployments	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/azure-pipelines-deploy-database-task
Plan for scheduled maintenance on MySQL Flexible Server	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-maintenance
Create Azure Automation tasks for MySQL Flexible Server management	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/create-automation-tasks
Move Azure MySQL Flexible Server between regions using geo-restore	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-move-regions
Restore Azure MySQL Flexible Server from backup using CLI	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-cli
Restore Azure MySQL Flexible Server from backup via portal	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-portal
Use GitHub Actions to deploy changes to Azure MySQL	https://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-mysql-github-actions