Servers - Create

Dienst:: MySQL

API-Version:: 2024-12-30

Erstellt einen neuen Server oder aktualisiert einen vorhandenen Server. Die Aktualisierungsaktion überschreibt den vorhandenen Server.

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

URI-Parameter

Name	In	Erforderlich	Typ	Beschreibung
resourceGroupName	path	True	string minLength: 1 maxLength: 90	Der Name der Ressourcengruppe. Bei dem Namen wird die Groß-/Kleinschreibung nicht beachtet.
serverName	path	True	string minLength: 1 maxLength: 63 pattern: ^[a-z0-9][-a-z0-9]*(?	Name des Servers
subscriptionId	path	True	string (uuid)	Hierbei handelt es sich um die ID des Zielabonnements. Der Wert muss eine UUID sein.
api-version	query	True	string minLength: 1	Hierbei handelt es sich um die für diesen Vorgang zu verwendende API-Version.

Anforderungstext

Name	Erforderlich	Typ	Beschreibung
location	True	string	Der geografische Standort, an dem sich die Ressource befindet
identity		MySQLServerIdentity	Die cmk-Identität für den Server.
properties.administratorLogin		string	Der Anmeldename des Administrators eines Servers. Kann nur angegeben werden, wenn der Server erstellt wird (und für die Erstellung erforderlich ist).
properties.administratorLoginPassword		string (password)	Das Kennwort der Administratoranmeldung (erforderlich für die Servererstellung).
properties.availabilityZone		string	Verfügbarkeitszoneninformationen des Servers.
properties.backup		Backup	Sicherungsbezogene Eigenschaften eines Servers.
properties.createMode		CreateMode	Der Modus zum Erstellen eines neuen MySQL-Servers.
properties.dataEncryption		DataEncryption	Die Datenverschlüsselung für CMK.
properties.databasePort		integer (int32)	Der Serverdatenbankport. Kann nur angegeben werden, wenn der Server erstellt wird.
properties.highAvailability		HighAvailability	Hochverfügbarkeitsbezogene Eigenschaften eines Servers.
properties.importSourceProperties		ImportSourceProperties	Quelleigenschaften für den Import aus dem Speicher.
properties.maintenancePolicy		MaintenancePolicy	Wartungsrichtlinie eines Servers.
properties.maintenanceWindow		MaintenanceWindow	Wartungsfenster eines Servers. Bekanntes Problem: Kann während der Servererstellung nicht festgelegt oder mit anderen Eigenschaften während der Serveraktualisierung aktualisiert werden; muss separat aktualisiert werden.
properties.network		Network	Netzwerkbezogene Eigenschaften eines Servers.
properties.replicationRole		ReplicationRole	Die Replikationsrolle.
properties.restorePointInTime		string (date-time)	Zeit für die Wiederherstellung von Punkt (ISO8601 Format) angeben, um die Wiederherstellungszeit anzugeben.
properties.sourceServerResourceId		string	Die MySQL-Quellserver-ID.
properties.storage		Storage	Speicherbezogene Eigenschaften eines Servers.
properties.version		ServerVersion	Hauptversion von MySQL. 8.0.21 steht für MySQL 8.0, 5.7.44 steht für MySQL 5.7
sku		MySQLServerSku	Die SKU (Preisebene) des Servers.
tags		object	Ressourcentags.

Antworten

Name	Typ	Beschreibung
200 OK	Server	Der Aktualisierungsvorgang für die Ressource "Server" war erfolgreich
201 Created	Server	Der Erstellungsvorgang für die Ressource 'Server' war erfolgreich Header Location: string Retry-After: integer
202 Accepted		Ressourcenvorgang akzeptiert. Header Location: string Retry-After: integer
Other Status Codes	ErrorResponse	Unerwartete Fehlerantwort.

Sicherheit

azure_auth

Azure Active Directory OAuth2-Fluss.

Typ: oauth2
Ablauf: implicit
Autorisierungs-URL: https://login.microsoftonline.com/common/oauth2/authorize

Bereiche

Name	Beschreibung
user_impersonation	Identitätswechsel ihres Benutzerkontos

Beispiele

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

Beispielanforderung

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

Beispiel für eine Antwort

Statuscode:: 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"
  }
}

Statuscode:: 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"
  }
}

Statuscode:: 202

Create a replica server

Beispielanforderung

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

Beispiel für eine Antwort

Statuscode:: 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"
  }
}

Statuscode:: 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"
  }
}

Statuscode:: 202

Create a server as a point in time restore

Beispielanforderung

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

Beispiel für eine Antwort

Statuscode:: 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"
  }
}

Statuscode:: 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"
  }
}

Statuscode:: 202

Create a server with byok

Beispielanforderung

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

Beispiel für eine Antwort

Statuscode:: 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"
  }
}

Statuscode:: 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"
  }
}

Statuscode:: 202

Create a server with non-default database port

Beispielanforderung

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

Beispiel für eine Antwort

Statuscode:: 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"
  }
}

Statuscode:: 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"
  }
}

Statuscode:: 202

Definitionen

Name	Beschreibung
Backup	Speicherprofileigenschaften eines Servers
BatchOfMaintenance	Der Wartungsbatch, wenn das benutzerdefinierte verwaltete Wartungsfenster eines Servers aktiviert ist.
createdByType	Der Identitätstyp, der die Ressource erstellt hat.
CreateMode	Der Modus zum Erstellen eines neuen MySQL-Servers.
DataEncryption	Die Datumsverschlüsselung für cmk.
DataEncryptionType	Der Schlüsseltyp AzureKeyVault zum Aktivieren von cmk, SystemManaged für die Deaktivierung von cmk.
EnableStatusEnum	Enumeration, um anzugeben, ob der Wert "Aktiviert" oder "Deaktiviert" ist
ErrorAdditionalInfo	Der Ressourcenverwaltungsfehler zusätzliche Informationen.
ErrorDetail	Das Fehlerdetails.
ErrorResponse	Fehlerantwort
HighAvailability	Eigenschaften mit hoher Verfügbarkeit eines Servers
HighAvailabilityMode	Hochverfügbarkeitsmodus für einen Server.
HighAvailabilityState	Der Status der hohen Serververfügbarkeit.
ImportSourceProperties	Importieren Sie quellbezogene Eigenschaften.
ImportSourceStorageType	Speichertyp der Importquelle.
MaintenancePolicy	Wartungsrichtlinie eines Servers.
MaintenanceWindow	Wartungsfenster eines Servers.
ManagedServiceIdentityType	Typ der verwalteten Dienstidentität.
MySQLServerIdentity	Eigenschaften zum Konfigurieren der Identität für Bring Your Own Keys
MySQLServerSku	Abrechnungsinformationen im Zusammenhang mit Eigenschaften eines Servers.
Network	Netzwerkbezogene Eigenschaften eines Servers
PatchStrategy	Aufzählung zur Angabe der Patchstrategie eines Servers
PrivateEndpoint	Die private Endpunktressource.
PrivateEndpointConnection	Die private Endpunktverbindungsressource.
PrivateEndpointConnectionProvisioningState	Der aktuelle Bereitstellungsstatus.
PrivateEndpointServiceConnectionStatus	Der Status der privaten Endpunktverbindung.
PrivateLinkServiceConnectionState	Eine Sammlung von Informationen über den Status der Verbindung zwischen Service Consumer und Provider.
ReplicationRole	Die Replikationsrolle.
Server	Stellt einen Server dar.
ServerSkuTier	Die Ebene der jeweiligen SKU, z. B. GeneralPurpose.
ServerState	Der Status eines Servers.
ServerVersion	Die Hauptversion eines Servers. 8.0.21 steht für MySQL 8.0, 5.7.44 steht für MySQL 5.7
Storage	Speicherprofileigenschaften eines Servers
StorageRedundancyEnum	Der redundante Typ des Serverspeichers. Der Parameter wird für die Servererstellung verwendet.
systemData	Metadaten zur Erstellung und letzten Änderung der Ressource.
UserAssignedIdentity	Metadaten der vom Benutzer zugewiesenen Identität.

Backup

Objekt

Speicherprofileigenschaften eines Servers

Name	Typ	Standardwert	Beschreibung
backupIntervalHours	integer (int32)		Sicherungsintervallstunden für den Server.
backupRetentionDays	integer (int32)		Sicherungsaufbewahrungstage für den Server.
earliestRestoreDate	string (date-time)		Früheste Zeit für die Erstellung von Wiederherstellungspunkten (ISO8601 Format)
geoRedundantBackup	EnableStatusEnum	Disabled	Gibt an, ob die georedundante Sicherung aktiviert ist.

BatchOfMaintenance

Enumeration

Der Wartungsbatch, wenn das benutzerdefinierte verwaltete Wartungsfenster eines Servers aktiviert ist.

Wert	Beschreibung
Default
Batch1
Batch2

createdByType

Enumeration

Der Identitätstyp, der die Ressource erstellt hat.

Wert	Beschreibung
User
Application
ManagedIdentity
Key

CreateMode

Enumeration

Der Modus zum Erstellen eines neuen MySQL-Servers.

Wert	Beschreibung
Default
PointInTimeRestore
Replica
GeoRestore

DataEncryption

Objekt

Die Datumsverschlüsselung für cmk.

Name	Typ	Beschreibung
geoBackupKeyURI	string	Geo-Sicherungsschlüssel-URI, da der Schlüsseltresor nicht regionübergreifend sein kann, cmk in derselben Region wie geo-Sicherung benötigt
geoBackupUserAssignedIdentityId	string	Geo-Sicherungsbenutzeridentitätsressourcen-ID als Identität kann nicht regionübergreifend sein, benötigen Identität in derselben Region wie geo-Sicherung
primaryKeyURI	string	Primärschlüssel-URI
primaryUserAssignedIdentityId	string	Primäre Benutzeridentitätsressourcen-ID
type	DataEncryptionType	Der Schlüsseltyp AzureKeyVault zum Aktivieren von cmk, SystemManaged für die Deaktivierung von cmk.

DataEncryptionType

Enumeration

Der Schlüsseltyp AzureKeyVault zum Aktivieren von cmk, SystemManaged für die Deaktivierung von cmk.

Wert	Beschreibung
AzureKeyVault
SystemManaged

EnableStatusEnum

Enumeration

Enumeration, um anzugeben, ob der Wert "Aktiviert" oder "Deaktiviert" ist

Wert	Beschreibung
Enabled
Disabled

ErrorAdditionalInfo

Objekt

Der Ressourcenverwaltungsfehler zusätzliche Informationen.

Name	Typ	Beschreibung
info	object	Die zusätzlichen Informationen.
type	string	Der zusätzliche Informationstyp.

ErrorDetail

Objekt

Das Fehlerdetails.

Name	Typ	Beschreibung
additionalInfo	ErrorAdditionalInfo[]	Die zusätzlichen Informationen des Fehlers.
code	string	Der Fehlercode.
details	ErrorDetail[]	Die Fehlerdetails.
message	string	Die Fehlermeldung.
target	string	Das Fehlerziel.

ErrorResponse

Objekt

Fehlerantwort

Name	Typ	Beschreibung
error	ErrorDetail	Das Fehlerobjekt.

HighAvailability

Objekt

Eigenschaften mit hoher Verfügbarkeit eines Servers

Name	Typ	Beschreibung
mode	HighAvailabilityMode	Hochverfügbarkeitsmodus für einen Server.
standbyAvailabilityZone	string	Verfügbarkeitszone des Standbyservers.
state	HighAvailabilityState	Der Status der hohen Serververfügbarkeit.

HighAvailabilityMode

Enumeration

Hochverfügbarkeitsmodus für einen Server.

Wert	Beschreibung
Disabled
ZoneRedundant
SameZone

HighAvailabilityState

Enumeration

Der Status der hohen Serververfügbarkeit.

Wert	Beschreibung
NotEnabled
CreatingStandby
Healthy
FailingOver
RemovingStandby

ImportSourceProperties

Objekt

Importieren Sie quellbezogene Eigenschaften.

Name	Typ	Beschreibung
dataDirPath	string	Relativer Pfad des Datenverzeichnisses im Speicher.
sasToken	string (password)	Sas-Token für den Zugriff auf den Quellspeicher. Lese- und Listenberechtigungen sind für sas-Token erforderlich.
storageType	ImportSourceStorageType	Speichertyp der Importquelle.
storageUrl	string	URI des Importquellspeichers.

ImportSourceStorageType

Enumeration

Speichertyp der Importquelle.

Wert	Beschreibung
AzureBlob

MaintenancePolicy

Objekt

Wartungsrichtlinie eines Servers.

Name	Typ	Beschreibung
patchStrategy	PatchStrategy	Die Patchstrategie dieses Servers

MaintenanceWindow

Objekt

Wartungsfenster eines Servers.

Name	Typ	Beschreibung
batchOfMaintenance	BatchOfMaintenance	Der Wartungsbatch, wenn das benutzerdefinierte verwaltete Wartungsfenster eines Servers aktiviert ist.
customWindow	string	gibt an, ob das benutzerdefinierte Fenster aktiviert oder deaktiviert ist.
dayOfWeek	integer (int32)	Wochentag für Wartungsfenster
startHour	integer (int32)	Startstunde für Wartungsfenster
startMinute	integer (int32)	Startminute für Wartungsfenster

ManagedServiceIdentityType

Enumeration

Typ der verwalteten Dienstidentität.

Wert	Beschreibung
UserAssigned

MySQLServerIdentity

Objekt

Eigenschaften zum Konfigurieren der Identität für Bring Your Own Keys

Name	Typ	Beschreibung
principalId	string	ObjectId aus keyVault
tenantId	string	TenantId aus keyVault
type	ManagedServiceIdentityType	Typ der verwalteten Dienstidentität.
userAssignedIdentities	<string, UserAssignedIdentity>	Metadaten der vom Benutzer zugewiesenen Identität.

MySQLServerSku

Objekt

Abrechnungsinformationen im Zusammenhang mit Eigenschaften eines Servers.

Name	Typ	Beschreibung
name	string	Der Name der Sku, z. B. Standard_D32s_v3.
tier	ServerSkuTier	Die Ebene der jeweiligen SKU, z. B. GeneralPurpose.

Network

Objekt

Netzwerkbezogene Eigenschaften eines Servers

Name	Typ	Beschreibung
delegatedSubnetResourceId	string	Delegierte Subnetzressourcen-ID, die zum Einrichten von vnet für einen Server verwendet wird.
privateDnsZoneResourceId	string	Private DNS-Zonenressourcen-ID.
publicNetworkAccess	EnableStatusEnum	Gibt an, ob der Zugriff auf öffentliche Netzwerke für diesen Server zulässig ist. Der Wert ist "Deaktiviert", wenn der Server über die VNet-Integration verfügt.

PatchStrategy

Enumeration

Aufzählung zur Angabe der Patchstrategie eines Servers

Wert	Beschreibung
Regular
VirtualCanary

PrivateEndpoint

Objekt

Die private Endpunktressource.

Name	Typ	Beschreibung
id	string	Der ARM-Bezeichner für privaten Endpunkt.

PrivateEndpointConnection

Objekt

Die private Endpunktverbindungsressource.

Name	Typ	Beschreibung
id	string (arm-id)	Vollqualifizierte Ressourcen-ID für die Ressource. Z. B. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	Der Name der Ressource
properties.groupIds	string[]	Die Gruppen-IDs für die private Endpunktressource.
properties.privateEndpoint	PrivateEndpoint	Die private Endpunktressource.
properties.privateLinkServiceConnectionState	PrivateLinkServiceConnectionState	Eine Sammlung von Informationen über den Status der Verbindung zwischen Service Consumer und Provider.
properties.provisioningState	PrivateEndpointConnectionProvisioningState	Der Bereitstellungsstatus der privaten Endpunktverbindungsressource.
systemData	systemData	Azure Resource Manager-Metadaten mit createdBy- und modifiedBy-Informationen.
type	string	Der Typ der Ressource. Z. B. "Microsoft.Compute/virtualMachines" oder "Microsoft.Storage/storageAccounts"

PrivateEndpointConnectionProvisioningState

Enumeration

Der aktuelle Bereitstellungsstatus.

Wert	Beschreibung
Succeeded
Creating
Deleting
Failed

PrivateEndpointServiceConnectionStatus

Enumeration

Der Status der privaten Endpunktverbindung.

Wert	Beschreibung
Pending
Approved
Rejected

PrivateLinkServiceConnectionState

Objekt

Eine Sammlung von Informationen über den Status der Verbindung zwischen Service Consumer und Provider.

Name	Typ	Beschreibung
actionsRequired	string	Eine Meldung, die angibt, ob Änderungen am Dienstanbieter Updates für den Verbraucher erfordern.
description	string	Der Grund für die Genehmigung/Ablehnung der Verbindung.
status	PrivateEndpointServiceConnectionStatus	Gibt an, ob die Verbindung vom Besitzer des Diensts genehmigt/abgelehnt/entfernt wurde.

ReplicationRole

Enumeration

Die Replikationsrolle.

Wert	Beschreibung
None
Source
Replica

Server

Objekt

Stellt einen Server dar.

Name	Typ	Beschreibung
id	string (arm-id)	Vollqualifizierte Ressourcen-ID für die Ressource. Z. B. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
identity	MySQLServerIdentity	Die cmk-Identität für den Server.
location	string	Der geografische Standort, an dem sich die Ressource befindet
name	string	Der Name der Ressource
properties.administratorLogin	string	Der Anmeldename des Administrators eines Servers. Kann nur angegeben werden, wenn der Server erstellt wird (und für die Erstellung erforderlich ist).
properties.administratorLoginPassword	string (password)	Das Kennwort der Administratoranmeldung (erforderlich für die Servererstellung).
properties.availabilityZone	string	Verfügbarkeitszoneninformationen des Servers.
properties.backup	Backup	Sicherungsbezogene Eigenschaften eines Servers.
properties.createMode	CreateMode	Der Modus zum Erstellen eines neuen MySQL-Servers.
properties.dataEncryption	DataEncryption	Die Datenverschlüsselung für CMK.
properties.databasePort	integer (int32)	Der Serverdatenbankport. Kann nur angegeben werden, wenn der Server erstellt wird.
properties.fullVersion	string	Hauptversion und tatsächliche Motorversion
properties.fullyQualifiedDomainName	string	Der vollqualifizierte Domänenname eines Servers.
properties.highAvailability	HighAvailability	Hochverfügbarkeitsbezogene Eigenschaften eines Servers.
properties.importSourceProperties	ImportSourceProperties	Quelleigenschaften für den Import aus dem Speicher.
properties.maintenancePolicy	MaintenancePolicy	Wartungsrichtlinie eines Servers.
properties.maintenanceWindow	MaintenanceWindow	Wartungsfenster eines Servers. Bekanntes Problem: Kann während der Servererstellung nicht festgelegt oder mit anderen Eigenschaften während der Serveraktualisierung aktualisiert werden; muss separat aktualisiert werden.
properties.network	Network	Netzwerkbezogene Eigenschaften eines Servers.
properties.privateEndpointConnections	PrivateEndpointConnection[]	PrivateEndpointConnections-verwandte Eigenschaften eines Servers.
properties.replicaCapacity	integer (int32) minimum: 0	Die maximale Anzahl von Replikaten, die ein primärer Server haben kann.
properties.replicationRole	ReplicationRole	Die Replikationsrolle.
properties.restorePointInTime	string (date-time)	Zeit für die Wiederherstellung von Punkt (ISO8601 Format) angeben, um die Wiederherstellungszeit anzugeben.
properties.sourceServerResourceId	string	Die MySQL-Quellserver-ID.
properties.state	ServerState	Der Status eines Servers.
properties.storage	Storage	Speicherbezogene Eigenschaften eines Servers.
properties.version	ServerVersion	Hauptversion von MySQL. 8.0.21 steht für MySQL 8.0, 5.7.44 steht für MySQL 5.7
sku	MySQLServerSku	Die SKU (Preisebene) des Servers.
systemData	systemData	Azure Resource Manager-Metadaten mit createdBy- und modifiedBy-Informationen.
tags	object	Ressourcentags.
type	string	Der Typ der Ressource. Z. B. "Microsoft.Compute/virtualMachines" oder "Microsoft.Storage/storageAccounts"

ServerSkuTier

Enumeration

Die Ebene der jeweiligen SKU, z. B. GeneralPurpose.

Wert	Beschreibung
Burstable
GeneralPurpose
MemoryOptimized

ServerState

Enumeration

Der Status eines Servers.

Wert	Beschreibung
Ready
Dropping
Disabled
Starting
Stopping
Stopped
Updating

ServerVersion

Enumeration

Die Hauptversion eines Servers. 8.0.21 steht für MySQL 8.0, 5.7.44 steht für MySQL 5.7

Wert	Beschreibung
5.7
8.0.21

Storage

Objekt

Speicherprofileigenschaften eines Servers

Name	Typ	Standardwert	Beschreibung
autoGrow	EnableStatusEnum	Disabled	Speicher automatisch vergrößern oder nicht aktivieren.
autoIoScaling	EnableStatusEnum	Enabled	Aktivieren Sie die automatische E/A-Skalierung.
iops	integer (int32)		Speicher-IOPS für einen Server.
logOnDisk	EnableStatusEnum	Disabled	Aktivieren Sie die Anmeldung auf dem Datenträger oder nicht.
storageRedundancy	StorageRedundancyEnum	LocalRedundancy	Der redundante Typ des Serverspeichers. Der Parameter wird für die Servererstellung verwendet.
storageSizeGB	integer (int32)		Maximale Speichergröße für einen Server zulässig.
storageSku	string		Der SKU-Name des Serverspeichers.

StorageRedundancyEnum

Enumeration

Der redundante Typ des Serverspeichers. Der Parameter wird für die Servererstellung verwendet.

Wert	Beschreibung
LocalRedundancy
ZoneRedundancy

systemData

Objekt

Metadaten zur Erstellung und letzten Änderung der Ressource.

Name	Typ	Beschreibung
createdAt	string (date-time)	Der Zeitstempel der Ressourcenerstellung (UTC).
createdBy	string	Die Identität, die die Ressource erstellt hat.
createdByType	createdByType	Der Identitätstyp, der die Ressource erstellt hat.
lastModifiedAt	string (date-time)	Der Zeitstempel der letzten Änderung der Ressource (UTC)
lastModifiedBy	string	Die Identität, die die Ressource zuletzt geändert hat.
lastModifiedByType	createdByType	Der Identitätstyp, der die Ressource zuletzt geändert hat.

UserAssignedIdentity

Objekt

Metadaten der vom Benutzer zugewiesenen Identität.

Name	Typ	Beschreibung
clientId	string	Client-ID der vom Benutzer zugewiesenen Identität
principalId	string	Prinzipal-ID der vom Benutzer zugewiesenen Identität

Freigeben über

Servers - Create

URI-Parameter

Anforderungstext

Antworten

Sicherheit

azure_auth

Bereiche

Beispiele

Create a new server

Beispielanforderung

Beispiel für eine Antwort

Create a replica server

Beispielanforderung

Beispiel für eine Antwort

Create a server as a point in time restore

Beispielanforderung

Beispiel für eine Antwort

Create a server with byok

Beispielanforderung

Beispiel für eine Antwort

Create a server with non-default database port

Beispielanforderung

Beispiel für eine Antwort

Definitionen

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