Back to Details

azure-database-mysql

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Azure Database for MySQL Skill

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.
本Skill为Azure Database for MySQL提供专家级指导，涵盖故障排除、最佳实践、决策制定、架构与设计模式、限制与配额、安全、配置、集成与编码模式以及部署。它结合了本地快速参考内容和远程文档获取功能。

How to Use This Skill

如何使用本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.
Agent 重要提示：使用下方的分类索引定位相关章节。对于带有行范围的分类（例如
L35-L120
），使用
read_file
读取指定行内容。对于带有文件链接的分类（例如
[security.md](security.md)
），使用
read_file
读取链接的参考文件
Agent 重要提示：如果
metadata.generated_at
的时间超过3个月，建议用户从仓库拉取最新版本。如果
mcp_microsoftdocs
工具不可用，建议用户安装该工具：安装指南
本Skill需要网络访问权限以获取文档内容：
  • 首选方式：使用
    mcp_microsoftdocs:microsoft_docs_fetch
    ，并携带查询字符串
    from=learn-agent-skill
    ，返回Markdown格式内容。
  • 备选方式：使用
    fetch_webpage
    ，并携带查询字符串
    from=learn-agent-skill&accept=text/markdown
    ，返回Markdown格式内容。

Category Index

分类索引

CategoryLinesDescription
TroubleshootingL37-L53Diagnosing and fixing MySQL Flexible Server issues: connectivity, performance (CPU/memory/queries), errors, corruption, capacity, replication lag, CLI problems, and using logs/self-heal tools
Best PracticesL54-L71Best practices for monitoring, performance tuning, troubleshooting, safe operations, BCDR, and end-to-end migration/optimization for Azure Database for MySQL Flexible Server
Decision MakingL72-L88Guidance on sizing, HA/BCDR, performance features, and planning/choosing methods for migrating and upgrading MySQL workloads to Azure Database for MySQL Flexible Server
Architecture & Design PatternsL89-L97Patterns for connecting AKS to MySQL Flexible Server, designing backup/restore, data-in/out replication, high availability (zone-redundant), and read-replica-based scaling.
Limits & QuotasL98-L106Limits, quotas, and performance caps for MySQL Flexible Server: compute/storage/IOPS limits, quota increase process, restore retention limits, and stop/start duration constraints.
SecurityL107-L133Securing Azure Database for MySQL Flexible Server: network isolation (Private Link, firewalls), TLS and cert rotation, encryption, Entra auth, users, and audit logging before/after migration.
ConfigurationL134-L164Configuring MySQL Flexible Server: parameters, HA, networking (VNet/firewall), replication, logs/slow queries, monitoring/metrics, alerts, scaling, maintenance, backups, and read replicas.
Integrations & Coding PatternsL165-L175Connecting to Azure Database for MySQL Flexible Server via CLI, Java/JDBC, Power BI, managing connection strings with Key Vault, and migrating data from RDS, on-prem, VMs, or Workbench
DeploymentL176-L186Automating MySQL Flexible Server deployments and maintenance: CI/CD with Azure Pipelines/GitHub Actions, backups/geo-restore, major version upgrades, and scheduled/automated management tasks.
分类行范围描述
故障排除L37-L53诊断并修复MySQL Flexible Server问题：连接性、性能（CPU/内存/查询）、错误、损坏、容量、复制延迟、CLI问题，以及使用日志/自修复工具
最佳实践L54-L71Azure Database for MySQL Flexible Server的监控、性能调优、故障排除、安全操作、BCDR以及端到端迁移/优化的最佳实践
决策制定L72-L88为将MySQL工作负载迁移和升级到Azure Database for MySQL Flexible Server提供规模规划、HA/BCDR选择、性能特性选型以及迁移方法规划的指导
架构与设计模式L89-L97AKS连接MySQL Flexible Server、备份/恢复设计、数据流入/流出复制、高可用（区域冗余）以及基于只读副本的扩缩容模式
限制与配额L98-L106MySQL Flexible Server的限制、配额和性能上限：计算/存储/IOPS限制、配额提升流程、恢复保留限制、启停时长约束
安全L107-L133加固Azure Database for MySQL Flexible Server的安全性：网络隔离（Private Link、防火墙）、TLS与证书轮换、加密、Entra认证、用户管理以及迁移前后的审计日志
配置L134-L164配置MySQL Flexible Server：参数、HA、网络（VNet/防火墙）、复制、日志/慢查询、监控/指标、告警、扩缩容、维护、备份以及只读副本
集成与编码模式L165-L175通过CLI、Java/JDBC、Power BI连接Azure Database for MySQL Flexible Server，使用Key Vault管理连接字符串，以及从RDS、本地环境、VM或Workbench迁移数据
部署L176-L186自动化MySQL Flexible Server的部署与维护：使用Azure Pipelines/GitHub Actions实现CI/CD、备份/异地恢复、主版本升级以及计划/自动化管理任务

Troubleshooting

故障排除

TopicURL
Use MySQL Flexible Server error logs for troubleshootinghttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-error-logs
Resolve database corruption in Azure MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-fix-corrupt-database
Use self-heal to automatically repair MySQL flexible server issueshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-self-heal
Troubleshoot Azure CLI issues for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-cli-errors
Diagnose and fix MySQL flexible server connection issueshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-connection-issues
Troubleshoot common migration and usage errors in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-errors
Troubleshoot connectivity issues and connection handling in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-connectivity-issues
Troubleshoot high CPU utilization in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-high-cpu-utilization
Troubleshoot low memory issues in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-low-memory-issues
Troubleshoot query performance issues in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-query-performance-new
Resolve capacity errors when deploying or scaling MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/resolve-capacity-errors
Use Query Performance Insight to diagnose Azure MySQL querieshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-query-performance-insights
Troubleshoot replication latency on MySQL flexible server read replicashttps://learn.microsoft.com/en-us/azure/mysql/how-to-troubleshoot-replication-latency
主题URL
使用MySQL Flexible Server错误日志进行故障排除https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-error-logs
修复Azure MySQL flexible server中的数据库损坏https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-fix-corrupt-database
使用自修复功能自动修复MySQL flexible server问题https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-self-heal
排查MySQL flexible server的Azure CLI问题https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-cli-errors
诊断并修复MySQL flexible server的连接问题https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-connection-issues
排查MySQL flexible server中的常见迁移和使用错误https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-errors
排查MySQL flexible server的连接性问题与连接处理https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-connectivity-issues
排查MySQL flexible server的高CPU使用率问题https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-high-cpu-utilization
排查MySQL flexible server的低内存问题https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-low-memory-issues
排查MySQL flexible server的查询性能问题https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-query-performance-new
解决部署或扩缩容MySQL flexible server时的容量错误https://learn.microsoft.com/en-us/azure/mysql/flexible-server/resolve-capacity-errors
使用Query Performance Insight诊断Azure MySQL查询https://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-query-performance-insights
排查MySQL flexible server只读副本的复制延迟https://learn.microsoft.com/en-us/azure/mysql/how-to-troubleshoot-replication-latency

Best Practices

最佳实践

TopicURL
Implement monitoring best practices for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-monitor-best-practices
Apply operational best practices for Azure Database for MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-operation-excellence-best-practices
Run performance benchmarks on Azure MySQL flexible server effectivelyhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-perf-benchmark-best-practices
Optimize performance of Azure MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-performance-best-practices
Use Azure Monitor and Advisor for MySQL business continuityhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity-advisor-monitor
Apply troubleshooting best practices for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-troubleshooting-best-practices
Prevent and recover accidental deletion of MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-prevent-recover-accidental-delete
Restart Azure MySQL Flexible Server safely via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restart-server-portal
Profile and optimize MySQL flexible server queries using EXPLAINhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-query-performance
Use sys_schema to diagnose performance issues in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-sys-schema
Execute data migration from on-premises MySQL to Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/08-data-migration
Manage Azure Database for MySQL after migrationhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/10-post-migration-management
Optimize Azure Database for MySQL performance after migrationhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/11-optimization
Design BCDR for Azure Database for MySQL migrationshttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/12-business-continuity-and-disaster-recovery
主题URL
实施MySQL flexible server的监控最佳实践https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-monitor-best-practices
应用Azure Database for MySQL的运维最佳实践https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-operation-excellence-best-practices
有效运行Azure MySQL flexible server的性能基准测试https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-perf-benchmark-best-practices
优化Azure MySQL flexible server的性能https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-performance-best-practices
使用Azure Monitor和Advisor保障MySQL业务连续性https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity-advisor-monitor
应用MySQL flexible server的故障排除最佳实践https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-troubleshooting-best-practices
预防并恢复MySQL Flexible Server的意外删除https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-prevent-recover-accidental-delete
通过门户安全重启Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restart-server-portal
使用EXPLAIN分析并优化MySQL flexible server查询https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-query-performance
使用sys_schema诊断MySQL flexible server的性能问题https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-sys-schema
执行从本地MySQL到Azure的数据迁移https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/08-data-migration
迁移后管理Azure Database for MySQLhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/10-post-migration-management
迁移后优化Azure Database for MySQL的性能https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/11-optimization
为Azure Database for MySQL迁移设计BCDRhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/12-business-continuity-and-disaster-recovery

Decision Making

决策制定

TopicURL
Choose and purchase MySQL Flexible Server reserved capacityhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-reserved-pricing
Use accelerated logs for high-performance MySQL workloadshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-accelerated-logs
Plan business continuity for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity
High availability FAQ and choices for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-high-availability-faq
Select MySQL Flexible Server service tiers and storagehttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-service-tiers-storage
Perform minimal-downtime MySQL migration to Azure flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-migrate-online
Decide and plan major version upgrades for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade-faq
Use mydumper/myloader to migrate large MySQL databases to Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/concepts-migrate-mydumper-myloader
Plan and execute on-premises MySQL migration to Azure Database for MySQLhttps://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 Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/03-assessment
Plan Azure Database for MySQL migration landing zonehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/04-planning
Choose migration methods to Azure Database for MySQLhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/05-migration-methods
Establish performance baselines for MySQL migration to Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/07-performance-baselines
主题URL
选择并购买MySQL Flexible Server预留容量https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-reserved-pricing
为高性能MySQL工作负载使用加速日志https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-accelerated-logs
规划MySQL Flexible Server的业务连续性https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity
MySQL Flexible Server的高可用FAQ与选型https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-high-availability-faq
选择MySQL Flexible Server的服务层级与存储https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-service-tiers-storage
执行MySQL到Azure flexible server的低停机迁移https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-migrate-online
决策并规划Azure MySQL的主版本升级https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade-faq
使用mydumper/myloader将大型MySQL数据库迁移到Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/concepts-migrate-mydumper-myloader
规划并执行本地MySQL到Azure Database for MySQL的迁移https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/01-mysql-migration-guide-intro
评估本地MySQL向Azure迁移的可行性https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/03-assessment
规划Azure Database for MySQL迁移的着陆区https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/04-planning
选择向Azure Database for MySQL迁移的方法https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/05-migration-methods
为MySQL向Azure迁移建立性能基准https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/07-performance-baselines

Architecture & Design Patterns

架构与设计模式

TopicURL
Connect Azure Kubernetes Service to MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-aks
Backup and restore strategy for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore
Design data-in replication into MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-data-in-replication
Design data-out replication from MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-data-out-replication
Use read replicas to scale MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-read-replicas
主题URL
连接Azure Kubernetes Service到MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-aks
MySQL Flexible Server的备份与恢复策略https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore
设计向MySQL Flexible Server的数据流入复制https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-data-in-replication
设计从MySQL Flexible Server的数据流出复制https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-data-out-replication
使用只读副本扩缩容MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-read-replicas

Limits & Quotas

限制与配额

TopicURL
Service limitations for Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations
Storage IOPS performance characteristics for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-storage-iops
Request quota increases for Azure MySQL flexible server resourceshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-request-quota-increase
Restore deleted Azure MySQL flexible servers within retention limitshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-dropped-server
Restart, stop, and start MySQL flexible server with stop-duration limitshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-restart-stop-start
主题URL
Azure MySQL Flexible Server的服务限制https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations
MySQL Flexible Server的存储IOPS性能特征https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-storage-iops
请求提升Azure MySQL flexible server资源的配额https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-request-quota-increase
在保留期限内恢复已删除的Azure MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-dropped-server
受停机时长限制的MySQL flexible server重启、停止与启动https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-restart-stop-start

Security

安全

TopicURL
Use Private Link with Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-private-link
Configure public network access for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-public
Configure private network access for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-vnet
Configure Azure MySQL Private Link using Azure CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-azure-cli
Deny public network access for Azure MySQL via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-deny-public-access
Secure Azure MySQL with Private Link using portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-portal
Create and connect to MySQL Flexible Server with private accesshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-connect-server-vnet
Configure audit logging for MySQL flexible server via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-audit-logs
Use customer-managed keys for MySQL Flexible Server encryptionhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-customer-managed-key
Understand Microsoft Entra authentication for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-entra-authentication
Create and manage MySQL Flexible Server users securelyhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-create-users
Configure data encryption for MySQL Flexible Server using Azure CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-data-encryption-cli
Configure data encryption for MySQL Flexible Server in Azure portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-data-encryption-portal
Set up Microsoft Entra authentication for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-entra
Manage MySQL Flexible Server firewall rules via Azure CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-manage-firewall-cli
Manage MySQL Flexible Server firewall rules in Azure portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-manage-firewall-portal
Secure Azure Database for MySQL Flexible Server deploymentshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-overview
TLS requirements and configuration for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls
Connect securely to MySQL Flexible Server using TLShttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-how-to-connect
Handle root certificate rotation for Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-root-certificate-rotation
FAQ on root certificate rotation for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-root-certificate-rotation-faq
Configure and analyze audit logs for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-configure-audit
Secure Azure Database for MySQL during and after migrationhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/13-security
主题URL
为Azure MySQL Flexible Server使用Private Linkhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-private-link
配置MySQL Flexible Server的公网访问https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-public
配置MySQL Flexible Server的私网访问https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-vnet
使用Azure CLI配置Azure MySQL Private Linkhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-azure-cli
通过门户拒绝Azure MySQL的公网访问https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-deny-public-access
通过门户为Azure MySQL配置Private Link以加固安全https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-portal
创建并连接具有私网访问权限的MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-connect-server-vnet
通过CLI配置MySQL flexible server的审计日志https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-audit-logs
为MySQL Flexible Server使用客户管理密钥进行加密https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-customer-managed-key
了解MySQL Flexible Server的Microsoft Entra认证https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-entra-authentication
安全创建并管理MySQL Flexible Server用户https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-create-users
使用Azure CLI配置MySQL Flexible Server的数据加密https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-data-encryption-cli
在Azure门户中配置MySQL Flexible Server的数据加密https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-data-encryption-portal
为MySQL Flexible Server设置Microsoft Entra认证https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-entra
通过Azure CLI管理MySQL Flexible Server防火墙规则https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-manage-firewall-cli
在Azure门户中管理MySQL Flexible Server防火墙规则https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-manage-firewall-portal
加固Azure Database for MySQL Flexible Server的部署安全性https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-overview
MySQL Flexible Server的TLS要求与配置https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls
使用TLS安全连接到MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-how-to-connect
处理Azure MySQL Flexible Server的根证书轮换https://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-root-certificate-rotation
Azure MySQL根证书轮换FAQhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-root-certificate-rotation-faq
配置并分析Azure MySQL的审计日志https://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-configure-audit
迁移期间及之后加固Azure Database for MySQL的安全性https://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/13-security

Configuration

配置

TopicURL
Use built-in stored procedures in MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-built-in-store-procedure
Configure monitoring and alerts for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-monitor-mysql
Monitoring metrics and logs reference for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-monitor-mysql-reference
Configure MySQL Flexible Server parameters effectivelyhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-server-parameters
Set up metric-based alerts for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-alert-on-metric
Enable or disable zone redundant high availability via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-high-availability
Configure zone redundant high availability for Azure MySQL via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-high-availability-cli
Configure MySQL flexible server parameters via Azure CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-server-parameters-cli
Configure MySQL Flexible Server parameters in Azure portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-server-parameters-portal
Configure data-in replication into Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-data-in-replication
Configure data-out replication from Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-data-out-replication
Configure scheduled maintenance windows for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-maintenance-portal
Configure private VNet connectivity for Azure MySQL via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-manage-virtual-network-cli
Configure private VNet connectivity for Azure MySQL via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-manage-virtual-network-portal
Create and manage Azure MySQL read replicas using CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-read-replicas-cli
Create and manage Azure MySQL read replicas via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-read-replicas-portal
List and download Azure MySQL server logs using CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-server-logs-cli
Enable and download Azure MySQL server logs via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-server-logs-portal
List and modify MySQL flexible server parameters via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-change-server-parameters
Create MySQL flexible server with VNet private access via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-create-connect-private-access
Configure public access and firewall for MySQL flexible server via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-create-connect-public-access
Monitor and scale MySQL flexible server compute, storage, and IOPShttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-monitor-and-scale
Create and manage MySQL flexible server read replicas via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-read-replicas
Restore Azure MySQL flexible server to a point in time via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-restore-server
Configure same-zone high availability for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-same-zone-ha
Configure slow query logging for MySQL flexible server via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-slow-query-logs
Configure zone-redundant high availability for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-zone-redundant-ha
主题URL
在MySQL Flexible Server中使用内置存储过程https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-built-in-store-procedure
配置MySQL Flexible Server的监控与告警https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-monitor-mysql
MySQL Flexible Server的监控指标与日志参考https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-monitor-mysql-reference
有效配置MySQL Flexible Server参数https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-server-parameters
为Azure MySQL设置基于指标的告警https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-alert-on-metric
通过门户启用或禁用区域冗余高可用https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-high-availability
通过CLI为Azure MySQL配置区域冗余高可用https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-high-availability-cli
通过Azure CLI配置MySQL flexible server参数https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-server-parameters-cli
在Azure门户中配置MySQL Flexible Server参数https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-server-parameters-portal
配置向Azure MySQL Flexible Server的数据流入复制https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-data-in-replication
配置从Azure MySQL Flexible Server的数据流出复制https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-data-out-replication
为Azure MySQL配置计划维护窗口https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-maintenance-portal
通过CLI为Azure MySQL配置私网VNet连接https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-manage-virtual-network-cli
通过门户为Azure MySQL配置私网VNet连接https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-manage-virtual-network-portal
使用CLI创建并管理Azure MySQL只读副本https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-read-replicas-cli
通过门户创建并管理Azure MySQL只读副本https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-read-replicas-portal
使用CLI列出并下载Azure MySQL服务器日志https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-server-logs-cli
通过门户启用并下载Azure MySQL服务器日志https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-server-logs-portal
通过CLI列出并修改MySQL flexible server参数https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-change-server-parameters
通过CLI创建具有VNet私网访问权限的MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-create-connect-private-access
通过CLI配置MySQL flexible server的公网访问与防火墙https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-create-connect-public-access
监控并扩缩容MySQL flexible server的计算、存储与IOPShttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-monitor-and-scale
通过CLI创建并管理MySQL flexible server只读副本https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-read-replicas
通过CLI将Azure MySQL flexible server恢复到指定时间点https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-restore-server
为MySQL flexible server配置同区域高可用https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-same-zone-ha
通过CLI为MySQL flexible server配置慢查询日志https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-slow-query-logs
为MySQL flexible server配置区域冗余高可用https://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-zone-redundant-ha

Integrations & Coding Patterns

集成与编码模式

TopicURL
Use Azure CLI commands to connect to MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-azure-cli
Connect Java applications to MySQL Flexible Server with JDBChttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-java
Connect Azure MySQL Flexible Server to Power BI Desktophttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-with-powerbi-desktop
Migrate Amazon RDS MySQL to Azure flexible server using data-in replicationhttps://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 Vaulthttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-add-mysql-connection-in-key-vault
Migrate on-premises or VM MySQL to Azure flexible server using Import CLIhttps://learn.microsoft.com/en-us/azure/mysql/migrate/migrate-external-mysql-import-cli
Migrate MySQL data to Azure using MySQL Workbenchhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/09-data-migration-with-mysql-workbench
主题URL
使用Azure CLI命令连接到MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-azure-cli
使用JDBC将Java应用连接到MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-java
将Azure MySQL Flexible Server连接到Power BI Desktophttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-with-powerbi-desktop
使用数据流入复制将Amazon RDS MySQL迁移到Azure flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-migrate-rds-mysql-data-in-replication
将MySQL Flexible Server连接字符串存储在Azure Key Vault中https://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-add-mysql-connection-in-key-vault
使用Import CLI将本地或VM中的MySQL迁移到Azure flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/migrate/migrate-external-mysql-import-cli
使用MySQL Workbench将MySQL数据迁移到Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/09-data-migration-with-mysql-workbench

Deployment

部署

TopicURL
Configure Azure Pipelines task for Azure MySQL deploymentshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/azure-pipelines-deploy-database-task
Plan for scheduled maintenance on MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-maintenance
Create Azure Automation tasks for MySQL Flexible Server managementhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/create-automation-tasks
Move Azure MySQL Flexible Server between regions using geo-restorehttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-move-regions
Restore Azure MySQL Flexible Server from backup using CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-cli
Restore Azure MySQL Flexible Server from backup via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-portal
Perform major version upgrades for Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade
Use GitHub Actions to deploy changes to Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-mysql-github-actions
主题URL
配置Azure Pipelines任务以部署Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/azure-pipelines-deploy-database-task
规划MySQL Flexible Server的计划维护https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-maintenance
创建Azure自动化任务以管理MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/create-automation-tasks
使用异地恢复在区域间迁移Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-move-regions
通过CLI从备份恢复Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-cli
通过门户从备份恢复Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-portal
执行Azure MySQL Flexible Server的主版本升级https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade
使用GitHub Actions将变更部署到Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-mysql-github-actions