Servers - Create

服務:: MySQL

API 版本:: 2024-12-30

建立新的伺服器或更新現有的伺服器。更新動作會覆寫現有的伺服器。

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

URI 參數

名稱	位於	必要	類型	Description
resourceGroupName	path	True	string minLength: 1 maxLength: 90	資源群組的名稱。名稱不區分大小寫。
serverName	path	True	string minLength: 1 maxLength: 63 pattern: ^[a-z0-9][-a-z0-9]*(?	伺服器的名稱。
subscriptionId	path	True	string (uuid)	目標訂用帳戶的標識碼。此值必須是 UUID。
api-version	query	True	string minLength: 1	用於此作業的 API 版本。

要求本文

名稱	必要	類型	Description
location	True	string	資源所在的地理位置
identity		MySQLServerIdentity	伺服器的 Cmk 身分識別。
properties.administratorLogin		string	系統管理員的伺服器登入名稱。只有在建立伺服器時才能指定（而且是建立的必要專案）。
properties.administratorLoginPassword		string (password)	系統管理員登入的密碼（建立伺服器所需的密碼）。
properties.availabilityZone		string	伺服器的可用性區域資訊。
properties.backup		Backup	備份伺服器的相關屬性。
properties.createMode		CreateMode	建立新 MySQL 伺服器的模式。
properties.dataEncryption		DataEncryption	CMK 的數據加密。
properties.databasePort		integer (int32)	伺服器資料庫埠。只能在建立伺服器時指定。
properties.highAvailability		HighAvailability	伺服器的高可用性相關屬性。
properties.importSourceProperties		ImportSourceProperties	從記憶體匯入的來源屬性。
properties.maintenancePolicy		MaintenancePolicy	伺服器的維護原則。
properties.maintenanceWindow		MaintenanceWindow	伺服器的維護時間範圍。已知問題：無法在伺服器建立期間設定，或在伺服器更新期間以其他屬性更新;必須個別更新。
properties.network		Network	伺服器的網路相關屬性。
properties.replicationRole		ReplicationRole	複寫角色。
properties.restorePointInTime		string (date-time)	還原點建立時間（ISO8601格式），指定要還原的時間。
properties.sourceServerResourceId		string	來源 MySQL 伺服器識別碼。
properties.storage		Storage	伺服器的記憶體相關屬性。
properties.version		ServerVersion	MySQL 的主要版本。 8.0.21 代表 MySQL 8.0、5.7.44 代表 MySQL 5.7
sku		MySQLServerSku	伺服器的 SKU（定價層）。
tags		object	資源標籤。

回應

名稱	類型	Description
200 OK	Server	資源 'Server' 更新作業成功
201 Created	Server	資源 'Server' 建立作業成功標題 Location: string Retry-After: integer
202 Accepted		已接受資源作業。標題 Location: string Retry-After: integer
Other Status Codes	ErrorResponse	未預期的錯誤回應。

安全性

azure_auth

Azure Active Directory OAuth2 Flow。

類型: oauth2
Flow: implicit
授權 URL: https://login.microsoftonline.com/common/oauth2/authorize

範圍

名稱	Description
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-12-30

{
  "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": "ZoneRedundancy",
      "storageSizeGB": 100
    },
    "version": "5.7"
  },
  "sku": {
    "name": "Standard_D2ds_v4",
    "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.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": "ZoneRedundancy",
                    "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/stable/2024-12-30/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

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.MySql.FlexibleServers.Models;
using Azure.ResourceManager.Resources;
using Azure.ResourceManager.MySql.FlexibleServers;

// Generated from example definition: 2024-12-30/ServerCreate.json
// this example is just showing the usage of "Server_Create" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this ResourceGroupResource created on azure
// for more information of creating ResourceGroupResource, please refer to the document of ResourceGroupResource
string subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
string resourceGroupName = "testrg";
ResourceIdentifier resourceGroupResourceId = ResourceGroupResource.CreateResourceIdentifier(subscriptionId, resourceGroupName);
ResourceGroupResource resourceGroupResource = client.GetResourceGroupResource(resourceGroupResourceId);

// get the collection of this MySqlFlexibleServerResource
MySqlFlexibleServerCollection collection = resourceGroupResource.GetMySqlFlexibleServers();

// invoke the operation
string serverName = "mysqltestserver";
MySqlFlexibleServerData data = new MySqlFlexibleServerData(new AzureLocation("southeastasia"))
{
    Sku = new MySqlFlexibleServerSku("Standard_D2ds_v4", MySqlFlexibleServerSkuTier.GeneralPurpose),
    Tags =
    {
    ["num"] = "1"
    },
};
ArmOperation<MySqlFlexibleServerResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, serverName, data);
MySqlFlexibleServerResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
MySqlFlexibleServerData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

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

範例回覆

狀態碼:: 200

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

狀態碼:: 201

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

狀態碼:: 202

Create a replica server

範例要求

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

{
  "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/stable/2024-12-30/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

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.MySql.FlexibleServers.Models;
using Azure.ResourceManager.Resources;
using Azure.ResourceManager.MySql.FlexibleServers;

// Generated from example definition: 2024-12-30/ServerCreateReplica.json
// this example is just showing the usage of "Server_Create" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this ResourceGroupResource created on azure
// for more information of creating ResourceGroupResource, please refer to the document of ResourceGroupResource
string subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
string resourceGroupName = "testgr";
ResourceIdentifier resourceGroupResourceId = ResourceGroupResource.CreateResourceIdentifier(subscriptionId, resourceGroupName);
ResourceGroupResource resourceGroupResource = client.GetResourceGroupResource(resourceGroupResourceId);

// get the collection of this MySqlFlexibleServerResource
MySqlFlexibleServerCollection collection = resourceGroupResource.GetMySqlFlexibleServers();

// invoke the operation
string serverName = "replica-server";
MySqlFlexibleServerData data = new MySqlFlexibleServerData(new AzureLocation("SoutheastAsia"));
ArmOperation<MySqlFlexibleServerResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, serverName, data);
MySqlFlexibleServerResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
MySqlFlexibleServerData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

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

範例回覆

狀態碼:: 200

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

狀態碼:: 201

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

狀態碼:: 202

Create a server as a point in time restore

範例要求

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

{
  "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"
  }
}

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/stable/2024-12-30/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

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.MySql.FlexibleServers.Models;
using Azure.ResourceManager.Resources;
using Azure.ResourceManager.MySql.FlexibleServers;

// Generated from example definition: 2024-12-30/ServerCreateWithPointInTimeRestore.json
// this example is just showing the usage of "Server_Create" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this ResourceGroupResource created on azure
// for more information of creating ResourceGroupResource, please refer to the document of ResourceGroupResource
string subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
string resourceGroupName = "TargetResourceGroup";
ResourceIdentifier resourceGroupResourceId = ResourceGroupResource.CreateResourceIdentifier(subscriptionId, resourceGroupName);
ResourceGroupResource resourceGroupResource = client.GetResourceGroupResource(resourceGroupResourceId);

// get the collection of this MySqlFlexibleServerResource
MySqlFlexibleServerCollection collection = resourceGroupResource.GetMySqlFlexibleServers();

// invoke the operation
string serverName = "targetserver";
MySqlFlexibleServerData data = new MySqlFlexibleServerData(new AzureLocation("SoutheastAsia"))
{
    Sku = new MySqlFlexibleServerSku("Standard_D14_v2", MySqlFlexibleServerSkuTier.GeneralPurpose),
    Tags =
    {
    ["num"] = "1"
    },
};
ArmOperation<MySqlFlexibleServerResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, serverName, data);
MySqlFlexibleServerResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
MySqlFlexibleServerData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

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

範例回覆

狀態碼:: 200

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

狀態碼:: 201

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

狀態碼:: 202

Create a server with byok

範例要求

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

{
  "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": {
      "type": "AzureKeyVault",
      "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"
    },
    "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"
  }
}

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/stable/2024-12-30/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

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.MySql.FlexibleServers.Models;
using Azure.ResourceManager.Resources;
using Azure.ResourceManager.MySql.FlexibleServers;

// Generated from example definition: 2024-12-30/ServerCreateWithBYOK.json
// this example is just showing the usage of "Server_Create" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this ResourceGroupResource created on azure
// for more information of creating ResourceGroupResource, please refer to the document of ResourceGroupResource
string subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
string resourceGroupName = "testrg";
ResourceIdentifier resourceGroupResourceId = ResourceGroupResource.CreateResourceIdentifier(subscriptionId, resourceGroupName);
ResourceGroupResource resourceGroupResource = client.GetResourceGroupResource(resourceGroupResourceId);

// get the collection of this MySqlFlexibleServerResource
MySqlFlexibleServerCollection collection = resourceGroupResource.GetMySqlFlexibleServers();

// invoke the operation
string serverName = "mysqltestserver";
MySqlFlexibleServerData data = new MySqlFlexibleServerData(new AzureLocation("southeastasia"))
{
    Identity = new ManagedServiceIdentity("UserAssigned")
    {
        UserAssignedIdentities =
        {
        [new ResourceIdentifier("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity")] = new UserAssignedIdentity()
        },
    },
    Sku = new MySqlFlexibleServerSku("Standard_D2ds_v4", MySqlFlexibleServerSkuTier.GeneralPurpose),
    Tags =
    {
    ["num"] = "1"
    },
};
ArmOperation<MySqlFlexibleServerResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, serverName, data);
MySqlFlexibleServerResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
MySqlFlexibleServerData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

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

範例回覆

狀態碼:: 200

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

狀態碼:: 201

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

狀態碼:: 202

Create a server with non-default database port

範例要求

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

{
  "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"
  }
}

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/stable/2024-12-30/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

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.MySql.FlexibleServers.Models;
using Azure.ResourceManager.Resources;
using Azure.ResourceManager.MySql.FlexibleServers;

// Generated from example definition: 2024-12-30/ServerCreateWithDatabasePort.json
// this example is just showing the usage of "Server_Create" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this ResourceGroupResource created on azure
// for more information of creating ResourceGroupResource, please refer to the document of ResourceGroupResource
string subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
string resourceGroupName = "testrg";
ResourceIdentifier resourceGroupResourceId = ResourceGroupResource.CreateResourceIdentifier(subscriptionId, resourceGroupName);
ResourceGroupResource resourceGroupResource = client.GetResourceGroupResource(resourceGroupResourceId);

// get the collection of this MySqlFlexibleServerResource
MySqlFlexibleServerCollection collection = resourceGroupResource.GetMySqlFlexibleServers();

// invoke the operation
string serverName = "mysqltestserver";
MySqlFlexibleServerData data = new MySqlFlexibleServerData(new AzureLocation("southeastasia"))
{
    Sku = new MySqlFlexibleServerSku("Standard_D2ds_v4", MySqlFlexibleServerSkuTier.GeneralPurpose),
    Tags =
    {
    ["num"] = "1"
    },
};
ArmOperation<MySqlFlexibleServerResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, serverName, data);
MySqlFlexibleServerResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
MySqlFlexibleServerData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

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

範例回覆

狀態碼:: 200

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

狀態碼:: 201

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

狀態碼:: 202

定義

名稱	Description
Backup	伺服器的記憶體配置檔屬性
BatchOfMaintenance	啟用伺服器的自定義託管維護時段時的維護批次。
createdByType	建立資源的身分識別類型。
CreateMode	建立新 MySQL 伺服器的模式。
DataEncryption	cmk 的日期加密。
DataEncryptionType	密鑰類型：啟用 cmk 的 AzureKeyVault、適用於停用 cmk 的 SystemManaged。
EnableStatusEnum	列舉，指出值為 'Enabled' 或 'Disabled'
ErrorAdditionalInfo	資源管理錯誤其他資訊。
ErrorDetail	錯誤詳細數據。
ErrorResponse	錯誤回應
HighAvailability	伺服器的高可用性屬性
HighAvailabilityMode	伺服器的高可用性模式。
HighAvailabilityState	伺服器高可用性的狀態。
ImportSourceProperties	匯入來源相關屬性。
ImportSourceStorageType	匯入來源的儲存類型。
MaintenancePolicy	伺服器的維護原則。
MaintenanceWindow	伺服器的維護時間範圍。
ManagedServiceIdentityType	受控服務識別的類型。
MySQLServerIdentity	設定自備金鑰身分識別的屬性
MySQLServerSku	伺服器的計費資訊相關信息。
Network	伺服器的網路相關屬性
PatchStrategy	列舉以指出伺服器的修補程式策略
PrivateEndpoint	私人端點資源。
PrivateEndpointConnection	私人端點聯機資源。
PrivateEndpointConnectionProvisioningState	目前的布建狀態。
PrivateEndpointServiceConnectionStatus	私人端點連線狀態。
PrivateLinkServiceConnectionState	服務取用者與提供者之間連線狀態的相關信息集合。
ReplicationRole	複寫角色。
Server	表示伺服器。
ServerSkuTier	特定 SKU 的層級，例如 GeneralPurpose。
ServerState	伺服器的狀態。
ServerVersion	伺服器的主要版本。 8.0.21 代表 MySQL 8.0、5.7.44 代表 MySQL 5.7
Storage	伺服器的記憶體配置檔屬性
StorageRedundancyEnum	伺服器記憶體的備援類型。參數用於伺服器建立。
systemData	與建立和上次修改資源相關的元數據。
UserAssignedIdentity	使用者指派身分識別的元數據。

Backup

Object

伺服器的記憶體配置檔屬性

名稱	類型	預設值	Description
backupIntervalHours	integer (int32)		伺服器的備份間隔時數。
backupRetentionDays	integer (int32)		伺服器的備份保留天數。
earliestRestoreDate	string (date-time)		最早的還原點建立時間（ISO8601格式）
geoRedundantBackup	EnableStatusEnum	Disabled	是否啟用異地備援備份。

BatchOfMaintenance

列舉型別

啟用伺服器的自定義託管維護時段時的維護批次。

值	Description
Default
Batch1
Batch2

createdByType

列舉型別

建立資源的身分識別類型。

值	Description
User
Application
ManagedIdentity
Key

CreateMode

列舉型別

建立新 MySQL 伺服器的模式。

值	Description
Default
PointInTimeRestore
Replica
GeoRestore

DataEncryption

Object

cmk 的日期加密。

名稱	類型	Description
geoBackupKeyURI	string	異地備份密鑰 URI 作為金鑰保存庫無法跨區域，需要在與異地備份相同的區域中使用 cmk
geoBackupUserAssignedIdentityId	string	異地備份使用者身分識別資源標識碼作為身分識別無法跨區域，需要在與異地備份相同的區域中的身分識別
primaryKeyURI	string	主鍵 URI
primaryUserAssignedIdentityId	string	主要使用者身分識別資源標識碼
type	DataEncryptionType	密鑰類型：啟用 cmk 的 AzureKeyVault、適用於停用 cmk 的 SystemManaged。

DataEncryptionType

列舉型別

密鑰類型：啟用 cmk 的 AzureKeyVault、適用於停用 cmk 的 SystemManaged。

值	Description
AzureKeyVault
SystemManaged

EnableStatusEnum

列舉型別

列舉，指出值為 'Enabled' 或 'Disabled'

值	Description
Enabled
Disabled

ErrorAdditionalInfo

Object

資源管理錯誤其他資訊。

名稱	類型	Description
info	object	其他資訊。
type	string	其他信息類型。

ErrorDetail

Object

錯誤詳細數據。

名稱	類型	Description
additionalInfo	ErrorAdditionalInfo[]	錯誤其他資訊。
code	string	錯誤碼。
details	ErrorDetail[]	錯誤詳細數據。
message	string	錯誤訊息。
target	string	錯誤目標。

ErrorResponse

Object

錯誤回應

名稱	類型	Description
error	ErrorDetail	error 物件。

HighAvailability

Object

伺服器的高可用性屬性

名稱	類型	Description
mode	HighAvailabilityMode	伺服器的高可用性模式。
standbyAvailabilityZone	string	待命伺服器的可用性區域。
state	HighAvailabilityState	伺服器高可用性的狀態。

HighAvailabilityMode

列舉型別

伺服器的高可用性模式。

值	Description
Disabled
ZoneRedundant
SameZone

HighAvailabilityState

列舉型別

伺服器高可用性的狀態。

值	Description
NotEnabled
CreatingStandby
Healthy
FailingOver
RemovingStandby

ImportSourceProperties

Object

匯入來源相關屬性。

名稱	類型	Description
dataDirPath	string	記憶體中資料目錄的相對路徑。
sasToken	string (password)	用於存取來源記憶體的 Sas 令牌。 SAS 令牌需要讀取和列表許可權。
storageType	ImportSourceStorageType	匯入來源的儲存類型。
storageUrl	string	匯入來源記憶體的 URI。

ImportSourceStorageType

列舉型別

匯入來源的儲存類型。

值	Description
AzureBlob

MaintenancePolicy

Object

伺服器的維護原則。

名稱	類型	Description
patchStrategy	PatchStrategy	此伺服器的修補程式策略

MaintenanceWindow

Object

伺服器的維護時間範圍。

名稱	類型	Description
batchOfMaintenance	BatchOfMaintenance	啟用伺服器的自定義託管維護時段時的維護批次。
customWindow	string	指出是否啟用或停用自定義視窗
dayOfWeek	integer (int32)	維護時段的星期數
startHour	integer (int32)	維護時段的開始時間
startMinute	integer (int32)	維護時段的開始分鐘

ManagedServiceIdentityType

列舉型別

受控服務識別的類型。

值	Description
UserAssigned

MySQLServerIdentity

Object

設定自備金鑰身分識別的屬性

名稱	類型	Description
principalId	string	KeyVault 中的 ObjectId
tenantId	string	KeyVault 中的 TenantId
type	ManagedServiceIdentityType	受控服務識別的類型。
userAssignedIdentities	<string, UserAssignedIdentity>	使用者指派身分識別的元數據。

MySQLServerSku

Object

伺服器的計費資訊相關信息。

名稱	類型	Description
name	string	sku 的名稱，例如Standard_D32s_v3。
tier	ServerSkuTier	特定 SKU 的層級，例如 GeneralPurpose。

Network

Object

伺服器的網路相關屬性

名稱	類型	Description
delegatedSubnetResourceId	string	用來為伺服器設定 vnet 的委派子網資源標識碼。
privateDnsZoneResourceId	string	私人 DNS 區域資源識別碼。
publicNetworkAccess	EnableStatusEnum	此伺服器是否允許公用網路存取。當伺服器具有 VNet 整合時，值為『Disabled』。

PatchStrategy

列舉型別

列舉以指出伺服器的修補程式策略

值	Description
Regular
VirtualCanary

PrivateEndpoint

Object

私人端點資源。

名稱	類型	Description
id	string	私人端點的ARM標識碼。

PrivateEndpointConnection

Object

私人端點聯機資源。

名稱	類型	Description
id	string (arm-id)	資源的完整資源標識碼。例如 “/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}”
name	string	資源的名稱
properties.groupIds	string[]	私人端點資源的群組標識碼。
properties.privateEndpoint	PrivateEndpoint	私人端點資源。
properties.privateLinkServiceConnectionState	PrivateLinkServiceConnectionState	服務取用者與提供者之間連線狀態的相關信息集合。
properties.provisioningState	PrivateEndpointConnectionProvisioningState	私人端點聯機資源的布建狀態。
systemData	systemData	包含 createdBy 和 modifiedBy 資訊的 Azure Resource Manager 中繼資料。
type	string	資源的類型。例如「Microsoft.Compute/virtualMachines」或「Microsoft.Storage/storageAccounts」

PrivateEndpointConnectionProvisioningState

列舉型別

目前的布建狀態。

值	Description
Succeeded
Creating
Deleting
Failed

PrivateEndpointServiceConnectionStatus

列舉型別

私人端點連線狀態。

值	Description
Pending
Approved
Rejected

PrivateLinkServiceConnectionState

Object

服務取用者與提供者之間連線狀態的相關信息集合。

名稱	類型	Description
actionsRequired	string	訊息，指出服務提供者上的變更是否需要取用者的任何更新。
description	string	核准/拒絕連線的原因。
status	PrivateEndpointServiceConnectionStatus	指出服務擁有者是否已核准/拒絕/移除連線。

ReplicationRole

列舉型別

複寫角色。

值	Description
None
Source
Replica

Server

Object

表示伺服器。

名稱	類型	Description
id	string (arm-id)	資源的完整資源標識碼。例如 “/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}”
identity	MySQLServerIdentity	伺服器的 Cmk 身分識別。
location	string	資源所在的地理位置
name	string	資源的名稱
properties.administratorLogin	string	系統管理員的伺服器登入名稱。只有在建立伺服器時才能指定（而且是建立的必要專案）。
properties.administratorLoginPassword	string (password)	系統管理員登入的密碼（建立伺服器所需的密碼）。
properties.availabilityZone	string	伺服器的可用性區域資訊。
properties.backup	Backup	備份伺服器的相關屬性。
properties.createMode	CreateMode	建立新 MySQL 伺服器的模式。
properties.dataEncryption	DataEncryption	CMK 的數據加密。
properties.databasePort	integer (int32)	伺服器資料庫埠。只能在建立伺服器時指定。
properties.fullVersion	string	主要版本和實際引擎版本
properties.fullyQualifiedDomainName	string	伺服器的完整功能變數名稱。
properties.highAvailability	HighAvailability	伺服器的高可用性相關屬性。
properties.importSourceProperties	ImportSourceProperties	從記憶體匯入的來源屬性。
properties.maintenancePolicy	MaintenancePolicy	伺服器的維護原則。
properties.maintenanceWindow	MaintenanceWindow	伺服器的維護時間範圍。已知問題：無法在伺服器建立期間設定，或在伺服器更新期間以其他屬性更新;必須個別更新。
properties.network	Network	伺服器的網路相關屬性。
properties.privateEndpointConnections	PrivateEndpointConnection[]	Server 的 PrivateEndpointConnections 相關屬性。
properties.replicaCapacity	integer (int32) minimum: 0	主伺服器可以擁有的複本數目上限。
properties.replicationRole	ReplicationRole	複寫角色。
properties.restorePointInTime	string (date-time)	還原點建立時間（ISO8601格式），指定要還原的時間。
properties.sourceServerResourceId	string	來源 MySQL 伺服器識別碼。
properties.state	ServerState	伺服器的狀態。
properties.storage	Storage	伺服器的記憶體相關屬性。
properties.version	ServerVersion	MySQL 的主要版本。 8.0.21 代表 MySQL 8.0、5.7.44 代表 MySQL 5.7
sku	MySQLServerSku	伺服器的 SKU（定價層）。
systemData	systemData	包含 createdBy 和 modifiedBy 資訊的 Azure Resource Manager 中繼資料。
tags	object	資源標籤。
type	string	資源的類型。例如「Microsoft.Compute/virtualMachines」或「Microsoft.Storage/storageAccounts」

ServerSkuTier

列舉型別

特定 SKU 的層級，例如 GeneralPurpose。

值	Description
Burstable
GeneralPurpose
MemoryOptimized

ServerState

列舉型別

伺服器的狀態。

值	Description
Ready
Dropping
Disabled
Starting
Stopping
Stopped
Updating

ServerVersion

列舉型別

伺服器的主要版本。 8.0.21 代表 MySQL 8.0、5.7.44 代表 MySQL 5.7

值	Description
5.7
8.0.21

Storage

Object

伺服器的記憶體配置檔屬性

名稱	類型	預設值	Description
autoGrow	EnableStatusEnum	Disabled	啟用記憶體自動成長。
autoIoScaling	EnableStatusEnum	Enabled	啟用 IO 自動調整。
iops	integer (int32)		伺服器的記憶體 IOPS。
logOnDisk	EnableStatusEnum	Disabled	啟用登入磁碟。
storageRedundancy	StorageRedundancyEnum	LocalRedundancy	伺服器記憶體的備援類型。參數用於伺服器建立。
storageSizeGB	integer (int32)		伺服器允許的記憶體大小上限。
storageSku	string		伺服器記憶體的 SKU 名稱。

StorageRedundancyEnum

列舉型別

伺服器記憶體的備援類型。參數用於伺服器建立。

值	Description
LocalRedundancy
ZoneRedundancy

systemData

Object

與建立和上次修改資源相關的元數據。

名稱	類型	Description
createdAt	string (date-time)	資源建立的時間戳（UTC）。
createdBy	string	建立資源的身分識別。
createdByType	createdByType	建立資源的身分識別類型。
lastModifiedAt	string (date-time)	上次修改的資源時間戳（UTC）
lastModifiedBy	string	上次修改資源的身分識別。
lastModifiedByType	createdByType	上次修改資源的身分識別類型。

UserAssignedIdentity

Object

使用者指派身分識別的元數據。

名稱	類型	Description
clientId	string	使用者指派身分識別的用戶端識別碼
principalId	string	使用者指派身分識別的主體識別碼

共用方式為

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

BatchOfMaintenance

createdByType

CreateMode

DataEncryption

DataEncryptionType

EnableStatusEnum

ErrorAdditionalInfo

ErrorDetail

ErrorResponse

HighAvailability

HighAvailabilityMode

HighAvailabilityState

ImportSourceProperties

ImportSourceStorageType

MaintenancePolicy

MaintenanceWindow

ManagedServiceIdentityType

MySQLServerIdentity

MySQLServerSku

Network

PatchStrategy

PrivateEndpoint

PrivateEndpointConnection

PrivateEndpointConnectionProvisioningState

PrivateEndpointServiceConnectionStatus

PrivateLinkServiceConnectionState

ReplicationRole

Server

ServerSkuTier

ServerState

ServerVersion

Storage

StorageRedundancyEnum

systemData

UserAssignedIdentity