你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

Servers - Create

参考

服务:: MySQL

API 版本:: 2024-06-01-preview

创建新的服务器或更新现有服务器。更新操作将覆盖现有服务器。

PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/flexibleServers/{serverName}?api-version=2024-06-01-preview

URI 参数

名称	在	必需	类型	说明
resourceGroupName	path	True	string	资源组的名称。名称不区分大小写。
serverName	path	True	string	服务器的名称。正则表达式模式: `^[a-z0-9][-a-z0-9]*(?<!-)$`
subscriptionId	path	True	string uuid	目标订阅的 ID。该值必须是 UUID。
api-version	query	True	string	用于此操作的 API 版本。

请求正文

名称	必需	类型	说明
location	True	string	资源所在的地理位置
identity.type		ManagedServiceIdentityType	托管服务标识的类型。
identity.userAssignedIdentities		object	用户分配标识的元数据。
properties.administratorLogin		string	管理员的服务器登录名。只能在创建服务器时指定（并且是创建所必需的）。
properties.administratorLoginPassword		string	管理员登录名的密码（创建服务器时需要）。
properties.availabilityZone		string	服务器的可用性区域信息。
properties.backup		Backup	备份服务器的相关属性。
properties.createMode		CreateMode	创建新的 MySQL 服务器的模式。
properties.dataEncryption		DataEncryption	CMK 的数据加密。
properties.databasePort		integer	服务器数据库端口。只能在创建服务器时指定。
properties.highAvailability		HighAvailability	服务器的高可用性相关属性。
properties.importSourceProperties		ImportSourceProperties	从存储导入的源属性。
properties.maintenancePolicy		MaintenancePolicy	服务器的维护策略。
properties.maintenanceWindow		MaintenanceWindow	服务器的维护时段。已知问题：无法在服务器创建期间设置，也不能在服务器更新期间使用其他属性进行更新;必须单独更新。
properties.network		Network	服务器的网络相关属性。
properties.replicationRole		ReplicationRole	复制角色。
properties.restorePointInTime		string	还原点创建时间（ISO8601格式），指定要从中还原的时间。
properties.sourceServerResourceId		string	源 MySQL 服务器 ID。
properties.storage		Storage	服务器的存储相关属性。
properties.version		ServerVersion	服务器版本。
sku		MySQLServerSku	服务器的 SKU（定价层）。
tags		object	资源标记。

响应

名称	类型	说明
200 OK	Server	还行
201 Created	Server	创建
202 Accepted		接受标头 Location: string
Other Status Codes	ErrorResponse	描述操作失败的原因的错误响应。

安全性

azure_auth

Azure Active Directory OAuth2 Flow

类型: oauth2
流向: implicit
授权 URL: https://login.microsoftonline.com/common/oauth2/authorize

作用域

名称	说明
user_impersonation	模拟用户帐户

示例

Create a new server

Create a replica server

Create a server as a point in time restore

Create a server with byok

Create a server with non-default database port

Create a new server

PUT https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver?api-version=2024-06-01-preview

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "administratorLoginPassword": "your_password",
    "availabilityZone": "1",
    "version": "5.7",
    "createMode": "Default",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Disabled",
      "storageRedundancy": "LocalRedundancy"
    },
    "backup": {
      "backupRetentionDays": 7,
      "backupIntervalHours": 24,
      "geoRedundantBackup": "Disabled"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "standbyAvailabilityZone": "3"
    }
  },
  "location": "southeastasia",
  "tags": {
    "num": "1"
  }
}

from azure.identity import DefaultAzureCredential

from azure.mgmt.mysqlflexibleservers import MySQLManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-mysqlflexibleservers
# USAGE
    python server_create.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = MySQLManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="ffffffff-ffff-ffff-ffff-ffffffffffff",
    )

    response = client.servers.begin_create(
        resource_group_name="testrg",
        server_name="mysqltestserver",
        parameters={
            "location": "southeastasia",
            "properties": {
                "administratorLogin": "cloudsa",
                "administratorLoginPassword": "your_password",
                "availabilityZone": "1",
                "backup": {"backupIntervalHours": 24, "backupRetentionDays": 7, "geoRedundantBackup": "Disabled"},
                "createMode": "Default",
                "highAvailability": {"mode": "ZoneRedundant", "standbyAvailabilityZone": "3"},
                "storage": {
                    "autoGrow": "Disabled",
                    "iops": 600,
                    "storageRedundancy": "LocalRedundancy",
                    "storageSizeGB": 100,
                },
                "version": "5.7",
            },
            "sku": {"name": "Standard_D2ds_v4", "tier": "GeneralPurpose"},
            "tags": {"num": "1"},
        },
    ).result()
    print(response)


# x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/FlexibleServers/preview/2024-06-01-preview/examples/ServerCreate.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

示例响应

状态代码:: 201

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS",
      "storageRedundancy": "LocalRedundancy"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "mysqltestserver.database.mysql.azure.com",
    "availabilityZone": "1",
    "maintenancePolicy": {
      "patchStrategy": "Regular"
    },
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "None",
    "replicaCapacity": 10,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-17T06:11:38.4150019+00:00"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "state": "Healthy",
      "standbyAvailabilityZone": "3"
    },
    "databasePort": 3306
  },
  "location": "Southeast Asia",
  "tags": {
    "num": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver",
  "name": "mysqltestserver",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 200

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS",
      "storageRedundancy": "LocalRedundancy"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "mysqltestserver.database.mysql.azure.com",
    "availabilityZone": "1",
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "None",
    "replicaCapacity": 10,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-17T06:11:38.4150019+00:00"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "state": "Healthy",
      "standbyAvailabilityZone": "3"
    },
    "databasePort": 3306
  },
  "location": "Southeast Asia",
  "tags": {
    "num": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver",
  "name": "mysqltestserver",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 202

Create a replica server

示例请求

HTTP
Python

PUT https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/replica-server?api-version=2024-06-01-preview

{
  "location": "SoutheastAsia",
  "properties": {
    "createMode": "Replica",
    "sourceServerResourceId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/source-server"
  }
}

from azure.identity import DefaultAzureCredential

from azure.mgmt.mysqlflexibleservers import MySQLManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-mysqlflexibleservers
# USAGE
    python server_create_replica.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = MySQLManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="ffffffff-ffff-ffff-ffff-ffffffffffff",
    )

    response = client.servers.begin_create(
        resource_group_name="testgr",
        server_name="replica-server",
        parameters={
            "location": "SoutheastAsia",
            "properties": {
                "createMode": "Replica",
                "sourceServerResourceId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/source-server",
            },
        },
    ).result()
    print(response)


# x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/FlexibleServers/preview/2024-06-01-preview/examples/ServerCreateReplica.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

示例响应

状态代码:: 201

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storage": {
      "storageSizeGB": 20,
      "iops": 360,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS",
      "storageRedundancy": "LocalRedundancy"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "replica-server.database.mysql.azure.com",
    "sourceServerResourceId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/source-server",
    "availabilityZone": "3",
    "maintenancePolicy": {
      "patchStrategy": "Regular"
    },
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "Replica",
    "replicaCapacity": 0,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "backupIntervalHours": 24,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-24T08:19:18.5729164+00:00"
    },
    "highAvailability": {
      "mode": "Disabled",
      "state": "NotEnabled"
    },
    "databasePort": 3306
  },
  "location": "Southeast Asia",
  "tags": {
    "ElasticServer": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/replica-server",
  "name": "replica-server",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 200

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storage": {
      "storageSizeGB": 20,
      "iops": 360,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS",
      "storageRedundancy": "LocalRedundancy"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "replica-server.database.mysql.azure.com",
    "sourceServerResourceId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/source-server",
    "availabilityZone": "3",
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "Replica",
    "replicaCapacity": 0,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-24T08:19:18.5729164+00:00"
    },
    "highAvailability": {
      "mode": "Disabled",
      "state": "NotEnabled"
    },
    "databasePort": 3306
  },
  "location": "Southeast Asia",
  "tags": {
    "ElasticServer": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testgr/providers/Microsoft.DBforMySQL/flexibleServers/replica-server",
  "name": "replica-server",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 202

Create a server as a point in time restore

示例请求

HTTP
Python

PUT https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TargetResourceGroup/providers/Microsoft.DBforMySQL/flexibleServers/targetserver?api-version=2024-06-01-preview

{
  "location": "SoutheastAsia",
  "properties": {
    "restorePointInTime": "2021-06-24T00:00:37.467Z",
    "createMode": "PointInTimeRestore",
    "sourceServerResourceId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/flexibleServers/sourceserver"
  },
  "sku": {
    "name": "Standard_D14_v2",
    "tier": "GeneralPurpose"
  },
  "tags": {
    "num": "1"
  }
}

from azure.identity import DefaultAzureCredential

from azure.mgmt.mysqlflexibleservers import MySQLManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-mysqlflexibleservers
# USAGE
    python server_create_with_point_in_time_restore.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = MySQLManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="ffffffff-ffff-ffff-ffff-ffffffffffff",
    )

    response = client.servers.begin_create(
        resource_group_name="TargetResourceGroup",
        server_name="targetserver",
        parameters={
            "location": "SoutheastAsia",
            "properties": {
                "createMode": "PointInTimeRestore",
                "restorePointInTime": "2021-06-24T00:00:37.467Z",
                "sourceServerResourceId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/flexibleServers/sourceserver",
            },
            "sku": {"name": "Standard_D14_v2", "tier": "GeneralPurpose"},
            "tags": {"num": "1"},
        },
    ).result()
    print(response)


# x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/FlexibleServers/preview/2024-06-01-preview/examples/ServerCreateWithPointInTimeRestore.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

示例响应

状态代码:: 201

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "adminuser",
    "storage": {
      "storageSizeGB": 20,
      "iops": 360,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS",
      "storageRedundancy": "LocalRedundancy"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "targetserver.database.mysql.azure.com",
    "availabilityZone": "1",
    "maintenancePolicy": {
      "patchStrategy": "Regular"
    },
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "None",
    "replicaCapacity": 10,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "backupIntervalHours": 24,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-24T00:15:24.00+00:00"
    },
    "highAvailability": {
      "mode": "Disabled",
      "state": "NotEnabled"
    },
    "databasePort": 3306
  },
  "location": "Southeast Asia",
  "tags": {
    "num": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TargetResourceGroup/providers/Microsoft.DBforMySQL/flexibleServers/targetserver",
  "name": "targetserver",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 200

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "adminuser",
    "storage": {
      "storageSizeGB": 20,
      "iops": 360,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "targetserver.database.mysql.azure.com",
    "availabilityZone": "1",
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "None",
    "replicaCapacity": 10,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "backupIntervalHours": 24,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-24T00:15:24.00+00:00"
    },
    "highAvailability": {
      "mode": "Disabled",
      "state": "NotEnabled"
    },
    "databasePort": 3306
  },
  "location": "Southeast Asia",
  "tags": {
    "num": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TargetResourceGroup/providers/Microsoft.DBforMySQL/flexibleServers/targetserver",
  "name": "targetserver",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 202

Create a server with byok

示例请求

HTTP
Python

PUT https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver?api-version=2024-06-01-preview

{
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity": {}
    }
  },
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "administratorLoginPassword": "your_password",
    "availabilityZone": "1",
    "version": "5.7",
    "createMode": "Default",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Disabled",
      "storageRedundancy": "LocalRedundancy"
    },
    "backup": {
      "backupRetentionDays": 7,
      "backupIntervalHours": 24,
      "geoRedundantBackup": "Disabled"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "standbyAvailabilityZone": "3"
    },
    "dataEncryption": {
      "type": "AzureKeyVault",
      "primaryUserAssignedIdentityId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity",
      "primaryKeyURI": "https://test.vault.azure.net/keys/key/c8a92236622244c0a4fdb892666f671a",
      "geoBackupUserAssignedIdentityId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-geo-identity",
      "geoBackupKeyURI": "https://test-geo.vault.azure.net/keys/key/c8a92236622244c0a4fdb892666f671a"
    }
  },
  "location": "southeastasia",
  "tags": {
    "num": "1"
  }
}

from azure.identity import DefaultAzureCredential

from azure.mgmt.mysqlflexibleservers import MySQLManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-mysqlflexibleservers
# USAGE
    python server_create_with_byok.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = MySQLManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="ffffffff-ffff-ffff-ffff-ffffffffffff",
    )

    response = client.servers.begin_create(
        resource_group_name="testrg",
        server_name="mysqltestserver",
        parameters={
            "identity": {
                "type": "UserAssigned",
                "userAssignedIdentities": {
                    "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity": {}
                },
            },
            "location": "southeastasia",
            "properties": {
                "administratorLogin": "cloudsa",
                "administratorLoginPassword": "your_password",
                "availabilityZone": "1",
                "backup": {"backupIntervalHours": 24, "backupRetentionDays": 7, "geoRedundantBackup": "Disabled"},
                "createMode": "Default",
                "dataEncryption": {
                    "geoBackupKeyURI": "https://test-geo.vault.azure.net/keys/key/c8a92236622244c0a4fdb892666f671a",
                    "geoBackupUserAssignedIdentityId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-geo-identity",
                    "primaryKeyURI": "https://test.vault.azure.net/keys/key/c8a92236622244c0a4fdb892666f671a",
                    "primaryUserAssignedIdentityId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity",
                    "type": "AzureKeyVault",
                },
                "highAvailability": {"mode": "ZoneRedundant", "standbyAvailabilityZone": "3"},
                "storage": {
                    "autoGrow": "Disabled",
                    "iops": 600,
                    "storageRedundancy": "LocalRedundancy",
                    "storageSizeGB": 100,
                },
                "version": "5.7",
            },
            "sku": {"name": "Standard_D2ds_v4", "tier": "GeneralPurpose"},
            "tags": {"num": "1"},
        },
    ).result()
    print(response)


# x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/FlexibleServers/preview/2024-06-01-preview/examples/ServerCreateWithBYOK.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

示例响应

状态代码:: 201

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "mysqltestserver.database.mysql.azure.com",
    "availabilityZone": "1",
    "maintenancePolicy": {
      "patchStrategy": "Regular"
    },
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "None",
    "replicaCapacity": 10,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-17T06:11:38.4150019+00:00"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "state": "Healthy",
      "standbyAvailabilityZone": "3"
    },
    "databasePort": 3306
  },
  "location": "Southeast Asia",
  "tags": {
    "num": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver",
  "name": "mysqltestserver",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 200

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "mysqltestserver.database.mysql.azure.com",
    "availabilityZone": "1",
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "None",
    "replicaCapacity": 10,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-17T06:11:38.4150019+00:00"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "state": "Healthy",
      "standbyAvailabilityZone": "3"
    },
    "databasePort": 3306
  },
  "location": "Southeast Asia",
  "tags": {
    "num": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver",
  "name": "mysqltestserver",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 202

Create a server with non-default database port

示例请求

HTTP
Python

PUT https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver?api-version=2024-06-01-preview

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "administratorLoginPassword": "your_password",
    "availabilityZone": "1",
    "version": "5.7",
    "createMode": "Default",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Disabled",
      "storageRedundancy": "LocalRedundancy"
    },
    "backup": {
      "backupRetentionDays": 7,
      "backupIntervalHours": 24,
      "geoRedundantBackup": "Disabled"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "standbyAvailabilityZone": "3"
    },
    "databasePort": 8888
  },
  "location": "southeastasia",
  "tags": {
    "num": "1"
  }
}

from azure.identity import DefaultAzureCredential

from azure.mgmt.mysqlflexibleservers import MySQLManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-mysqlflexibleservers
# USAGE
    python server_create_with_database_port.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = MySQLManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="ffffffff-ffff-ffff-ffff-ffffffffffff",
    )

    response = client.servers.begin_create(
        resource_group_name="testrg",
        server_name="mysqltestserver",
        parameters={
            "location": "southeastasia",
            "properties": {
                "administratorLogin": "cloudsa",
                "administratorLoginPassword": "your_password",
                "availabilityZone": "1",
                "backup": {"backupIntervalHours": 24, "backupRetentionDays": 7, "geoRedundantBackup": "Disabled"},
                "createMode": "Default",
                "databasePort": 8888,
                "highAvailability": {"mode": "ZoneRedundant", "standbyAvailabilityZone": "3"},
                "storage": {
                    "autoGrow": "Disabled",
                    "iops": 600,
                    "storageRedundancy": "LocalRedundancy",
                    "storageSizeGB": 100,
                },
                "version": "5.7",
            },
            "sku": {"name": "Standard_D2ds_v4", "tier": "GeneralPurpose"},
            "tags": {"num": "1"},
        },
    ).result()
    print(response)


# x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/FlexibleServers/preview/2024-06-01-preview/examples/ServerCreateWithDatabasePort.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

示例响应

状态代码:: 201

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS",
      "storageRedundancy": "LocalRedundancy"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "mysqltestserver.database.mysql.azure.com",
    "availabilityZone": "1",
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "None",
    "replicaCapacity": 10,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-17T06:11:38.4150019+00:00"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "state": "Healthy",
      "standbyAvailabilityZone": "3"
    },
    "databasePort": 8888
  },
  "location": "Southeast Asia",
  "tags": {
    "num": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver",
  "name": "mysqltestserver",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 200

{
  "sku": {
    "name": "Standard_D2ds_v4",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storage": {
      "storageSizeGB": 100,
      "iops": 600,
      "autoGrow": "Enabled",
      "storageSku": "Premium_LRS",
      "storageRedundancy": "LocalRedundancy"
    },
    "version": "5.7",
    "state": "Ready",
    "fullyQualifiedDomainName": "mysqltestserver.database.mysql.azure.com",
    "availabilityZone": "1",
    "maintenanceWindow": {
      "customWindow": "Disabled",
      "dayOfWeek": 0,
      "startHour": 0,
      "startMinute": 0
    },
    "replicationRole": "None",
    "replicaCapacity": 10,
    "network": {
      "publicNetworkAccess": "Enabled"
    },
    "backup": {
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Disabled",
      "earliestRestoreDate": "2021-06-17T06:11:38.4150019+00:00"
    },
    "highAvailability": {
      "mode": "ZoneRedundant",
      "state": "Healthy",
      "standbyAvailabilityZone": "3"
    },
    "databasePort": 8888
  },
  "location": "Southeast Asia",
  "tags": {
    "num": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver",
  "name": "mysqltestserver",
  "type": "Microsoft.DBforMySQL/flexibleServers"
}

状态代码:: 202

定义

名称	说明
Backup	服务器的存储配置文件属性
createdByType	创建资源的标识的类型。
CreateMode	创建新的 MySQL 服务器的模式。
DataEncryption	cmk 的日期加密。
DataEncryptionType	密钥类型，用于启用 cmk 的 AzureKeyVault、用于禁用 cmk 的 SystemManaged。
EnableStatusEnum	用于指示值是“Enabled”还是“Disabled”的枚举
ErrorAdditionalInfo	资源管理错误附加信息。
ErrorDetail	错误详细信息。
ErrorResponse	错误响应
HighAvailability	服务器的高可用性属性
HighAvailabilityMode	服务器的高可用性模式。
HighAvailabilityState	服务器高可用性的状态。
ImportSourceProperties	导入源相关属性。
ImportSourceStorageType	导入源的存储类型。
MaintenancePolicy	服务器的维护策略。
MaintenanceWindow	服务器的维护时段。
ManagedServiceIdentityType	托管服务标识的类型。
MySQLServerSku	与服务器相关的计费信息属性。
Network	服务器的网络相关属性
PatchStrategy	用于指示服务器的修补策略的枚举
PrivateEndpoint	专用终结点资源。
PrivateEndpointConnection	专用终结点连接资源。
PrivateEndpointConnectionProvisioningState	当前预配状态。
PrivateEndpointServiceConnectionStatus	专用终结点连接状态。
PrivateLinkServiceConnectionState	有关服务使用者与提供程序之间的连接状态的信息集合。
ReplicationRole	复制角色。
Server	表示服务器。
ServerSkuTier	特定 SKU 的层，例如 GeneralPurpose。
ServerState	服务器的状态。
ServerVersion	服务器的版本。
Storage	服务器的存储配置文件属性
StorageRedundancyEnum	用于指示存储 SKU 值是“ZoneRedundancy”还是“LocalRedundancy”的枚举
systemData	与创建和上次修改资源相关的元数据。

Backup

服务器的存储配置文件属性

名称	类型	默认值	说明
backupIntervalHours	integer		服务器的备份间隔小时数。
backupRetentionDays	integer		服务器的备份保留日。
earliestRestoreDate	string		最早的还原点创建时间（ISO8601格式）
geoRedundantBackup	EnableStatusEnum	Disabled	是否启用异地冗余备份。

createdByType

创建资源的标识的类型。

名称	类型	说明
Application	string
Key	string
ManagedIdentity	string
User	string

CreateMode

创建新的 MySQL 服务器的模式。

名称	类型	说明
Default	string
GeoRestore	string
PointInTimeRestore	string
Replica	string

DataEncryption

cmk 的日期加密。

名称	类型	说明
geoBackupKeyURI	string	异地备份密钥 URI，因为密钥保管库不能跨区域，需要与异地备份位于同一区域中的 cmk
geoBackupUserAssignedIdentityId	string	异地备份用户标识资源 ID 作为标识不能跨区域，需要与异地备份位于同一区域中的标识
primaryKeyURI	string	主键 URI
primaryUserAssignedIdentityId	string	主要用户标识资源 ID
type	DataEncryptionType	密钥类型，用于启用 cmk 的 AzureKeyVault、用于禁用 cmk 的 SystemManaged。

DataEncryptionType

密钥类型，用于启用 cmk 的 AzureKeyVault、用于禁用 cmk 的 SystemManaged。

名称	类型	说明
AzureKeyVault	string
SystemManaged	string

EnableStatusEnum

用于指示值是“Enabled”还是“Disabled”的枚举

名称	类型	说明
Disabled	string
Enabled	string

ErrorAdditionalInfo

资源管理错误附加信息。

名称	类型	说明
info	object	其他信息。
type	string	其他信息类型。

ErrorDetail

错误详细信息。

名称	类型	说明
additionalInfo	ErrorAdditionalInfo[]	错误附加信息。
code	string	错误代码。
details	ErrorDetail[]	错误详细信息。
message	string	错误消息。
target	string	错误目标。

ErrorResponse

错误响应

名称	类型	说明
error	ErrorDetail	错误对象。

HighAvailability

服务器的高可用性属性

名称	类型	说明
mode	HighAvailabilityMode	服务器的高可用性模式。
standbyAvailabilityZone	string	备用服务器的可用性区域。
state	HighAvailabilityState	服务器高可用性的状态。

HighAvailabilityMode

服务器的高可用性模式。

名称	类型	说明
Disabled	string
SameZone	string
ZoneRedundant	string

HighAvailabilityState

服务器高可用性的状态。

名称	类型	说明
CreatingStandby	string
FailingOver	string
Healthy	string
NotEnabled	string
RemovingStandby	string

ImportSourceProperties

导入源相关属性。

名称	类型	说明
dataDirPath	string	存储中的数据目录的相对路径。
sasToken	string	用于访问源存储的 Sas 令牌。 SAS 令牌需要读取和列出权限。
storageType	ImportSourceStorageType	导入源的存储类型。
storageUrl	string	导入源存储的 URI。

ImportSourceStorageType

导入源的存储类型。

名称	类型	说明
AzureBlob	string

MaintenancePolicy

服务器的维护策略。

名称	类型	说明
patchStrategy	PatchStrategy	此服务器的修补策略

MaintenanceWindow

服务器的维护时段。

名称	类型	说明
customWindow	string	指示是启用还是禁用自定义窗口
dayOfWeek	integer	维护时段的星期几
startHour	integer	维护时段的开始时间
startMinute	integer	维护时段的开始时间

ManagedServiceIdentityType

托管服务标识的类型。

名称	类型	说明
UserAssigned	string

MySQLServerSku

与服务器相关的计费信息属性。

名称	类型	说明
name	string	sku 的名称，例如Standard_D32s_v3。
tier	ServerSkuTier	特定 SKU 的层，例如 GeneralPurpose。

Network

服务器的网络相关属性

名称	类型	说明
delegatedSubnetResourceId	string	用于为服务器设置 vnet 的委托子网资源 ID。
privateDnsZoneResourceId	string	专用 DNS 区域资源 ID。
publicNetworkAccess	EnableStatusEnum	是否允许此服务器访问公用网络。当服务器具有 VNet 集成时，值为“Disabled”。

PatchStrategy

用于指示服务器的修补策略的枚举

名称	类型	说明
Regular	string
VirtualCanary	string

PrivateEndpoint

专用终结点资源。

名称	类型	说明
id	string	专用终结点的 ARM 标识符。

PrivateEndpointConnection

专用终结点连接资源。

名称	类型	说明
id	string	资源的完全限定资源 ID。例如“/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}”
name	string	资源的名称
properties.groupIds	string[]	专用终结点资源的组 ID。
properties.privateEndpoint	PrivateEndpoint	专用终结点资源。
properties.privateLinkServiceConnectionState	PrivateLinkServiceConnectionState	有关服务使用者与提供程序之间的连接状态的信息集合。
properties.provisioningState	PrivateEndpointConnectionProvisioningState	专用终结点连接资源的预配状态。
systemData	systemData	包含 createdBy 和 modifiedBy 信息的 Azure 资源管理器元数据。
type	string	资源的类型。例如“Microsoft.Compute/virtualMachines”或“Microsoft.Storage/storageAccounts”

PrivateEndpointConnectionProvisioningState

当前预配状态。

名称	类型	说明
Creating	string
Deleting	string
Failed	string
Succeeded	string

PrivateEndpointServiceConnectionStatus

专用终结点连接状态。

名称	类型	说明
Approved	string
Pending	string
Rejected	string

PrivateLinkServiceConnectionState

有关服务使用者与提供程序之间的连接状态的信息集合。

名称	类型	说明
actionsRequired	string	一条消息，指示服务提供商上的更改是否需要对使用者进行任何更新。
description	string	批准/拒绝连接的原因。
status	PrivateEndpointServiceConnectionStatus	指示连接是否已被服务的所有者批准/拒绝/删除。

ReplicationRole

复制角色。

名称	类型	说明
None	string
Replica	string
Source	string

Server

表示服务器。

名称	类型	说明
id	string	资源的完全限定资源 ID。例如“/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}”
identity.principalId	string	KeyVault 中的 ObjectId
identity.tenantId	string	KeyVault 中的 TenantId
identity.type	ManagedServiceIdentityType	托管服务标识的类型。
identity.userAssignedIdentities	object	用户分配标识的元数据。
location	string	资源所在的地理位置
name	string	资源的名称
properties.administratorLogin	string	管理员的服务器登录名。只能在创建服务器时指定（并且是创建所必需的）。
properties.administratorLoginPassword	string	管理员登录名的密码（创建服务器时需要）。
properties.availabilityZone	string	服务器的可用性区域信息。
properties.backup	Backup	备份服务器的相关属性。
properties.createMode	CreateMode	创建新的 MySQL 服务器的模式。
properties.dataEncryption	DataEncryption	CMK 的数据加密。
properties.databasePort	integer	服务器数据库端口。只能在创建服务器时指定。
properties.fullyQualifiedDomainName	string	服务器的完全限定域名。
properties.highAvailability	HighAvailability	服务器的高可用性相关属性。
properties.importSourceProperties	ImportSourceProperties	从存储导入的源属性。
properties.maintenancePolicy	MaintenancePolicy	服务器的维护策略。
properties.maintenanceWindow	MaintenanceWindow	服务器的维护时段。已知问题：无法在服务器创建期间设置，也不能在服务器更新期间使用其他属性进行更新;必须单独更新。
properties.network	Network	服务器的网络相关属性。
properties.privateEndpointConnections	PrivateEndpointConnection[]	服务器的 PrivateEndpointConnections 相关属性。
properties.replicaCapacity	integer	主服务器可以拥有的最大副本数。
properties.replicationRole	ReplicationRole	复制角色。
properties.restorePointInTime	string	还原点创建时间（ISO8601格式），指定要从中还原的时间。
properties.sourceServerResourceId	string	源 MySQL 服务器 ID。
properties.state	ServerState	服务器的状态。
properties.storage	Storage	服务器的存储相关属性。
properties.version	ServerVersion	服务器版本。
sku	MySQLServerSku	服务器的 SKU（定价层）。
systemData	systemData	包含 createdBy 和 modifiedBy 信息的 Azure 资源管理器元数据。
tags	object	资源标记。
type	string	资源的类型。例如“Microsoft.Compute/virtualMachines”或“Microsoft.Storage/storageAccounts”

ServerSkuTier

特定 SKU 的层，例如 GeneralPurpose。

名称	类型	说明
Burstable	string
GeneralPurpose	string
MemoryOptimized	string

ServerState

服务器的状态。

名称	类型	说明
Disabled	string
Dropping	string
Ready	string
Starting	string
Stopped	string
Stopping	string
Updating	string

ServerVersion

服务器的版本。

名称	类型	说明
5.7	string
8.0.21	string

Storage

服务器的存储配置文件属性

名称	类型	默认值	说明
autoGrow	EnableStatusEnum	Disabled	启用存储自动增长。
autoIoScaling	EnableStatusEnum	Enabled	启用 IO 自动缩放。
iops	integer		服务器的存储 IOPS。
logOnDisk	EnableStatusEnum	Disabled	启用登录磁盘。
storageRedundancy	StorageRedundancyEnum	LocalRedundancy	服务器存储的冗余类型。参数用于服务器创建。
storageSizeGB	integer		服务器允许的最大存储大小。
storageSku	string		服务器存储的 SKU 名称。

StorageRedundancyEnum

用于指示存储 SKU 值是“ZoneRedundancy”还是“LocalRedundancy”的枚举

名称	类型	说明
LocalRedundancy	string
ZoneRedundancy	string

systemData

与创建和上次修改资源相关的元数据。

名称	类型	说明
createdAt	string	资源创建时间戳（UTC）。
createdBy	string	创建资源的标识。
createdByType	createdByType	创建资源的标识的类型。
lastModifiedAt	string	上次修改的资源时间戳（UTC）
lastModifiedBy	string	上次修改资源的标识。
lastModifiedByType	createdByType	上次修改资源的标识的类型。

通过

Servers - Create

URI 参数

请求正文

响应

安全性

azure_auth

作用域

示例

Create a new server

示例请求

示例响应

Create a replica server

示例请求

示例响应

Create a server as a point in time restore

示例请求

示例响应

Create a server with byok

示例请求

示例响应

Create a server with non-default database port

示例请求

示例响应

定义

Backup

createdByType

CreateMode

DataEncryption

DataEncryptionType

EnableStatusEnum

ErrorAdditionalInfo

ErrorDetail

ErrorResponse

HighAvailability

HighAvailabilityMode

HighAvailabilityState

ImportSourceProperties

ImportSourceStorageType

MaintenancePolicy

MaintenanceWindow

ManagedServiceIdentityType

MySQLServerSku

Network

PatchStrategy

PrivateEndpoint

PrivateEndpointConnection

PrivateEndpointConnectionProvisioningState

PrivateEndpointServiceConnectionStatus

PrivateLinkServiceConnectionState

ReplicationRole

Server

ServerSkuTier

ServerState

ServerVersion

Storage

StorageRedundancyEnum

systemData

其他资源