azure_mysql_flexible_server_create_with_mgmt_sdk.py

1import os
2from azure.identity import DefaultAzureCredential
3from azure.mgmt.mysqlflexibleservers import MySQLManagementClient
4
5def main():
6    # Replace these variables with your own values
7    subscription_id = os.environ.get("AZURE_SUBSCRIPTION_ID", "your-subscription-id")
8    resource_group_name = "myResourceGroup"
9    server_name = "my-flexible-server-unique-name"
10    location = "eastus"
11
12    # Authenticate using DefaultAzureCredential
13    # Ensure you have environment variables: AZURE_TENANT_ID, AZURE_CLIENT_ID, AZURE_CLIENT_SECRET
14    credential = DefaultAzureCredential()
15
16    # Initialize the Management Client
17    client = MySQLManagementClient(credential, subscription_id)
18
19    # Create the Flexible Server
20    # Note: High availability and storage parameters can be customized here
21    print(f"Creating MySQL Flexible Server: {server_name}...")
22    
23    poller = client.servers.begin_create(
24        resource_group_name,
25        server_name,
26        {
27            "location": location,
28            "sku": {
29                "name": "Standard_B1ms",
30                "tier": "Burstable"
31            },
32            "properties": {
33                "administratorLogin": "myadmin",
34                "administratorLoginPassword": "VerySecurePassword123!",
35                "version": "5.7",
36                "storage": {
37                    "storageSizeGB": 32
38                }
39            }
40        }
41    )
42
43    server = poller.result()
44    print(f"Server created successfully: {server.fully_qualified_domain_name}")
45
46if __name__ == "__main__":
47    main()