azure-resource-manager-mysql-dotnet

This skill provides a comprehensive interface for .NET developers to manage Azure Database for MySQL Flexible Server instances programmatically. It leverages the Azure.ResourceManager.MySql library, enabling seamless infrastructure-as-code patterns within AI-driven development workflows. The skill is specifically designed for cloud engineers and software architects tasked with automating the lifecycle of managed database services, ensuring consistent deployment standards across development, staging, and production environments. By using the ArmClient and DefaultAzureCredential, the skill simplifies secure authentication while providing full control over resource hierarchies, from individual database objects to complex high-availability clusters.

• Full lifecycle management of MySQL Flexible Server instances, including creation, updates, and configuration tuning.

• Automated database provisioning and schema initialization capabilities via the SDK.

• Fine-grained control over network security, specifically managing firewall rules for IP ranges and Azure service access.

• Configuration management, allowing dynamic updates to server parameters such as connection limits, query logs, and storage optimizations.

• Built-in support for business continuity features, including backup retention settings and high-availability mode selection (e.g., zone-redundant).

• Integration with Microsoft Entra ID (formerly Azure AD) for administrative identity management and role-based access control.

• The skill requires a valid Azure subscription and configured resource groups for all operations.

• Input parameters should include the subscription ID, resource group name, and target server name as environment variables or explicit parameters.

• Ensure the project has the necessary dependencies installed, specifically the Azure.ResourceManager.MySql and Azure.Identity packages.

• Use the provided classes to manage server configurations, such as tuning innodb_buffer_pool_size or enabling slow_query_log for observability.

• Note that this skill targets Flexible Server exclusively, as Single Server deployments are deprecated and should not be used for new projects.

• The output includes operation handles which allow for asynchronous monitoring of long-running resource deployment tasks through the ArmOperation pattern.