Servers(2017-12-01) - Create

Service:

MySQL

API Version:

2017-12-01

Membuat server baru atau memperbarui server yang sudah ada. Tindakan pembaruan akan menimpa server yang ada.

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

Parameter URI

Name	In	Required	Type	Description
resourceGroupName	path	True	string	Nama grup sumber daya. Nama tidak peka huruf besar/kecil.
serverName	path	True	string	Nama server.
subscriptionId	path	True	string	ID langganan target.
api-version	query	True	string	Versi API yang digunakan untuk operasi ini.

Isi Permintaan

Name	Required	Type	Description
location	True	string	Lokasi sumber daya berada.
properties	True	ServerPropertiesForCreate: ServerPropertiesForDefaultCreate ServerPropertiesForRestore ServerPropertiesForGeoRestore ServerPropertiesForReplica	Properti server.
identity		ResourceIdentity	Identitas Azure Active Directory server.
sku		Sku	SKU (tingkat harga) server.
tags		object	Metadata khusus aplikasi dalam bentuk pasangan kunci-nilai.

Respons

Name	Type	Description
200 OK	Server	OK
201 Created	Server	Dibuat
202 Accepted		Diterima
Other Status Codes	CloudError	Respons kesalahan yang menjelaskan mengapa operasi gagal.

Keamanan

azure_auth

Azure Active Directory Flow OAuth2

Type: oauth2
Flow: implicit
Authorization URL: https://login.microsoftonline.com/common/oauth2/authorize

Scopes

Name	Description
user_impersonation	meniru akun pengguna Anda

Contoh

Create a database as a point in time restore

Create a new server

Create a replica server

Create a server as a geo restore

Create a database as a point in time restore

Sample Request

HTTP

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

{
  "location": "brazilsouth",
  "properties": {
    "restorePointInTime": "2017-12-14T00:00:37.467Z",
    "createMode": "PointInTimeRestore",
    "sourceServerId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver"
  },
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "tags": {
    "ElasticServer": "1"
  }
}

Java

import com.azure.resourcemanager.mysql.models.ServerPropertiesForRestore;
import com.azure.resourcemanager.mysql.models.Sku;
import com.azure.resourcemanager.mysql.models.SkuTier;
import java.time.OffsetDateTime;
import java.util.HashMap;
import java.util.Map;

/** Samples for Servers Create. */
public final class Main {
    /*
     * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreatePointInTimeRestore.json
     */
    /**
     * Sample code: Create a database as a point in time restore.
     *
     * @param manager Entry point to MySqlManager.
     */
    public static void createADatabaseAsAPointInTimeRestore(com.azure.resourcemanager.mysql.MySqlManager manager) {
        manager
            .servers()
            .define("targetserver")
            .withRegion("brazilsouth")
            .withExistingResourceGroup("TargetResourceGroup")
            .withProperties(
                new ServerPropertiesForRestore()
                    .withSourceServerId(
                        "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver")
                    .withRestorePointInTime(OffsetDateTime.parse("2017-12-14T00:00:37.467Z")))
            .withTags(mapOf("ElasticServer", "1"))
            .withSku(
                new Sku().withName("GP_Gen5_2").withTier(SkuTier.GENERAL_PURPOSE).withCapacity(2).withFamily("Gen5"))
            .create();
    }

    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

Read this SDK documentation on how to add the SDK to your project and authenticate.

Go

package armmysql_test

import (
	"context"
	"log"

	"time"

	"github.com/Azure/azure-sdk-for-go/sdk/azcore/to"
	"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
	"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/mysql/armmysql"
)

// Generated from example definition: https://github.com/Azure/azure-rest-api-specs/tree/main/specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreatePointInTimeRestore.json
func ExampleServersClient_BeginCreate() {
	cred, err := azidentity.NewDefaultAzureCredential(nil)
	if err != nil {
		log.Fatalf("failed to obtain a credential: %v", err)
	}
	ctx := context.Background()
	client, err := armmysql.NewServersClient("ffffffff-ffff-ffff-ffff-ffffffffffff", cred, nil)
	if err != nil {
		log.Fatalf("failed to create client: %v", err)
	}
	poller, err := client.BeginCreate(ctx,
		"TargetResourceGroup",
		"targetserver",
		armmysql.ServerForCreate{
			Location: to.Ptr("brazilsouth"),
			Properties: &armmysql.ServerPropertiesForRestore{
				CreateMode:         to.Ptr(armmysql.CreateModePointInTimeRestore),
				RestorePointInTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2017-12-14T00:00:37.467Z"); return t }()),
				SourceServerID:     to.Ptr("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver"),
			},
			SKU: &armmysql.SKU{
				Name:     to.Ptr("GP_Gen5_2"),
				Capacity: to.Ptr[int32](2),
				Family:   to.Ptr("Gen5"),
				Tier:     to.Ptr(armmysql.SKUTierGeneralPurpose),
			},
			Tags: map[string]*string{
				"ElasticServer": to.Ptr("1"),
			},
		},
		nil)
	if err != nil {
		log.Fatalf("failed to finish the request: %v", err)
	}
	res, err := poller.PollUntilDone(ctx, nil)
	if err != nil {
		log.Fatalf("failed to pull the result: %v", err)
	}
	// TODO: use response item
	_ = res
}

Read this SDK documentation on how to add the SDK to your project and authenticate.

JavaScript

const { MySQLManagementClient } = require("@azure/arm-mysql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to Creates a new server or updates an existing server. The update action will overwrite the existing server.
 *
 * @summary Creates a new server or updates an existing server. The update action will overwrite the existing server.
 * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreatePointInTimeRestore.json
 */
async function createADatabaseAsAPointInTimeRestore() {
  const subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
  const resourceGroupName = "TargetResourceGroup";
  const serverName = "targetserver";
  const parameters = {
    location: "brazilsouth",
    properties: {
      createMode: "PointInTimeRestore",
      restorePointInTime: new Date("2017-12-14T00:00:37.467Z"),
      sourceServerId:
        "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver",
    },
    sku: {
      name: "GP_Gen5_2",
      capacity: 2,
      family: "Gen5",
      tier: "GeneralPurpose",
    },
    tags: { elasticServer: "1" },
  };
  const credential = new DefaultAzureCredential();
  const client = new MySQLManagementClient(credential, subscriptionId);
  const result = await client.servers.beginCreateAndWait(resourceGroupName, serverName, parameters);
  console.log(result);
}

createADatabaseAsAPointInTimeRestore().catch(console.error);

Read this SDK documentation on how to add the SDK to your project and authenticate.

Sample Response

Status code:

201

{
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Enabled"
    },
    "version": "5.7",
    "sslEnforcement": "Enabled",
    "userVisibleState": "Ready",
    "fullyQualifiedDomainName": "targetserver.mysql.database.azure.com",
    "earliestRestoreDate": "2018-03-14T18:02:41.577+00:00"
  },
  "location": "brazilsouth",
  "tags": {
    "ElasticServer": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/targetserver",
  "name": "targetserver",
  "type": "Microsoft.DBforMySQL/servers"
}

Status code:

200

{
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/targetserver",
  "name": "targetserver",
  "type": "Microsoft.DBforMySQL/servers",
  "location": "brazilsouth",
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "tags": {
    "elasticServer": "1"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Enabled"
    },
    "version": "5.7",
    "sslEnforcement": "Enabled",
    "userVisibleState": "Ready",
    "fullyQualifiedDomainName": "targetserver.mysql.database.azure.com",
    "earliestRestoreDate": "2018-03-14T18:02:41.577+00:00"
  }
}

Status code:

202

Create a new server

Sample Request

HTTP

PUT https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4?api-version=2017-12-01

{
  "location": "westus",
  "properties": {
    "administratorLogin": "cloudsa",
    "administratorLoginPassword": "<administratorLoginPassword>",
    "sslEnforcement": "Enabled",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Enabled"
    },
    "createMode": "Default"
  },
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "capacity": 2,
    "family": "Gen5"
  },
  "tags": {
    "ElasticServer": "1"
  }
}

Java

import com.azure.resourcemanager.mysql.models.GeoRedundantBackup;
import com.azure.resourcemanager.mysql.models.ServerPropertiesForDefaultCreate;
import com.azure.resourcemanager.mysql.models.Sku;
import com.azure.resourcemanager.mysql.models.SkuTier;
import com.azure.resourcemanager.mysql.models.SslEnforcementEnum;
import com.azure.resourcemanager.mysql.models.StorageProfile;
import java.util.HashMap;
import java.util.Map;

/** Samples for Servers Create. */
public final class Main {
    /*
     * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreate.json
     */
    /**
     * Sample code: Create a new server.
     *
     * @param manager Entry point to MySqlManager.
     */
    public static void createANewServer(com.azure.resourcemanager.mysql.MySqlManager manager) {
        manager
            .servers()
            .define("mysqltestsvc4")
            .withRegion("westus")
            .withExistingResourceGroup("testrg")
            .withProperties(
                new ServerPropertiesForDefaultCreate()
                    .withSslEnforcement(SslEnforcementEnum.ENABLED)
                    .withStorageProfile(
                        new StorageProfile()
                            .withBackupRetentionDays(7)
                            .withGeoRedundantBackup(GeoRedundantBackup.ENABLED)
                            .withStorageMB(128000))
                    .withAdministratorLogin("cloudsa")
                    .withAdministratorLoginPassword("<administratorLoginPassword>"))
            .withTags(mapOf("ElasticServer", "1"))
            .withSku(
                new Sku().withName("GP_Gen5_2").withTier(SkuTier.GENERAL_PURPOSE).withCapacity(2).withFamily("Gen5"))
            .create();
    }

    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

Read this SDK documentation on how to add the SDK to your project and authenticate.

JavaScript

const { MySQLManagementClient } = require("@azure/arm-mysql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to Creates a new server or updates an existing server. The update action will overwrite the existing server.
 *
 * @summary Creates a new server or updates an existing server. The update action will overwrite the existing server.
 * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreate.json
 */
async function createANewServer() {
  const subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
  const resourceGroupName = "testrg";
  const serverName = "mysqltestsvc4";
  const parameters = {
    location: "westus",
    properties: {
      administratorLogin: "cloudsa",
      administratorLoginPassword: "<administratorLoginPassword>",
      createMode: "Default",
      sslEnforcement: "Enabled",
      storageProfile: {
        backupRetentionDays: 7,
        geoRedundantBackup: "Enabled",
        storageMB: 128000,
      },
    },
    sku: {
      name: "GP_Gen5_2",
      capacity: 2,
      family: "Gen5",
      tier: "GeneralPurpose",
    },
    tags: { elasticServer: "1" },
  };
  const credential = new DefaultAzureCredential();
  const client = new MySQLManagementClient(credential, subscriptionId);
  const result = await client.servers.beginCreateAndWait(resourceGroupName, serverName, parameters);
  console.log(result);
}

createANewServer().catch(console.error);

Read this SDK documentation on how to add the SDK to your project and authenticate.

Sample Response

Status code:

201

{
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Enabled"
    },
    "version": "5.7",
    "sslEnforcement": "Enabled",
    "userVisibleState": "Ready",
    "fullyQualifiedDomainName": "mysqltestsvc4.mysql.database.azure.com",
    "earliestRestoreDate": "2018-03-14T18:02:41.577+00:00"
  },
  "location": "westus",
  "tags": {
    "ElasticServer": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4",
  "name": "mysqltestsvc4",
  "type": "Microsoft.DBforMySQL/servers"
}

Status code:

200

{
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4",
  "name": "mysqltestsvc4",
  "type": "Microsoft.DBforMySQL/servers",
  "location": "westus",
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "tags": {
    "elasticServer": "1"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Enabled"
    },
    "version": "5.7",
    "sslEnforcement": "Enabled",
    "userVisibleState": "Ready",
    "fullyQualifiedDomainName": "mysqltestsvc4.mysql.database.azure.com",
    "earliestRestoreDate": "2018-03-14T18:02:41.577+00:00"
  }
}

Status code:

202

Create a replica server

Sample Request

HTTP

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

{
  "location": "westus",
  "properties": {
    "createMode": "Replica",
    "sourceServerId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/MasterResourceGroup/providers/Microsoft.DBforMySQL/servers/masterserver"
  }
}

Java

import com.azure.resourcemanager.mysql.models.ServerPropertiesForReplica;
import java.util.HashMap;
import java.util.Map;

/** Samples for Servers Create. */
public final class Main {
    /*
     * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreateReplicaMode.json
     */
    /**
     * Sample code: Create a replica server.
     *
     * @param manager Entry point to MySqlManager.
     */
    public static void createAReplicaServer(com.azure.resourcemanager.mysql.MySqlManager manager) {
        manager
            .servers()
            .define("targetserver")
            .withRegion("westus")
            .withExistingResourceGroup("TargetResourceGroup")
            .withProperties(
                new ServerPropertiesForReplica()
                    .withSourceServerId(
                        "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/MasterResourceGroup/providers/Microsoft.DBforMySQL/servers/masterserver"))
            .create();
    }

    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

Read this SDK documentation on how to add the SDK to your project and authenticate.

JavaScript

const { MySQLManagementClient } = require("@azure/arm-mysql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to Creates a new server or updates an existing server. The update action will overwrite the existing server.
 *
 * @summary Creates a new server or updates an existing server. The update action will overwrite the existing server.
 * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreateReplicaMode.json
 */
async function createAReplicaServer() {
  const subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
  const resourceGroupName = "TargetResourceGroup";
  const serverName = "targetserver";
  const parameters = {
    location: "westus",
    properties: {
      createMode: "Replica",
      sourceServerId:
        "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/MasterResourceGroup/providers/Microsoft.DBforMySQL/servers/masterserver",
    },
  };
  const credential = new DefaultAzureCredential();
  const client = new MySQLManagementClient(credential, subscriptionId);
  const result = await client.servers.beginCreateAndWait(resourceGroupName, serverName, parameters);
  console.log(result);
}

createAReplicaServer().catch(console.error);

Read this SDK documentation on how to add the SDK to your project and authenticate.

Sample Response

Status code:

201

{
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 14,
      "geoRedundantBackup": "Enabled"
    },
    "version": "5.7",
    "sslEnforcement": "Enabled",
    "userVisibleState": "Ready",
    "fullyQualifiedDomainName": "targetserver.mysql.database.azure.com",
    "earliestRestoreDate": "2018-03-14T18:02:41.577+00:00",
    "replicationRole": "Replica",
    "masterServerId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/MasterResourceGroup/providers/Microsoft.DBforMySQL/servers/masterserver",
    "replicaCapacity": 0
  },
  "location": "westus",
  "tags": {
    "ElasticServer": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TargetResourceGroup/providers/Microsoft.DBforMySQL/servers/targetserver",
  "name": "targetserver",
  "type": "Microsoft.DBforMySQL/servers"
}

Status code:

200

{
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 14,
      "geoRedundantBackup": "Enabled"
    },
    "version": "5.7",
    "sslEnforcement": "Enabled",
    "userVisibleState": "Ready",
    "fullyQualifiedDomainName": "targetserver.mysql.database.azure.com",
    "earliestRestoreDate": "2018-03-14T18:02:41.577+00:00",
    "replicationRole": "Replica",
    "masterServerId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/MasterResourceGroup/providers/Microsoft.DBforMySQL/servers/masterserver",
    "replicaCapacity": 0
  },
  "location": "westus",
  "tags": {
    "ElasticServer": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TargetResourceGroup/providers/Microsoft.DBforMySQL/servers/targetserver",
  "name": "targetserver",
  "type": "Microsoft.DBforMySQL/servers"
}

Status code:

202

Create a server as a geo restore

Sample Request

HTTP

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

{
  "location": "westus",
  "properties": {
    "createMode": "GeoRestore",
    "sourceServerId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver"
  },
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "tags": {
    "ElasticServer": "1"
  }
}

Java

import com.azure.resourcemanager.mysql.models.ServerPropertiesForGeoRestore;
import com.azure.resourcemanager.mysql.models.Sku;
import com.azure.resourcemanager.mysql.models.SkuTier;
import java.util.HashMap;
import java.util.Map;

/** Samples for Servers Create. */
public final class Main {
    /*
     * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreateGeoRestoreMode.json
     */
    /**
     * Sample code: Create a server as a geo restore.
     *
     * @param manager Entry point to MySqlManager.
     */
    public static void createAServerAsAGeoRestore(com.azure.resourcemanager.mysql.MySqlManager manager) {
        manager
            .servers()
            .define("targetserver")
            .withRegion("westus")
            .withExistingResourceGroup("TargetResourceGroup")
            .withProperties(
                new ServerPropertiesForGeoRestore()
                    .withSourceServerId(
                        "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver"))
            .withTags(mapOf("ElasticServer", "1"))
            .withSku(
                new Sku().withName("GP_Gen5_2").withTier(SkuTier.GENERAL_PURPOSE).withCapacity(2).withFamily("Gen5"))
            .create();
    }

    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

Read this SDK documentation on how to add the SDK to your project and authenticate.

JavaScript

const { MySQLManagementClient } = require("@azure/arm-mysql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to Creates a new server or updates an existing server. The update action will overwrite the existing server.
 *
 * @summary Creates a new server or updates an existing server. The update action will overwrite the existing server.
 * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2017-12-01/examples/ServerCreateGeoRestoreMode.json
 */
async function createAServerAsAGeoRestore() {
  const subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
  const resourceGroupName = "TargetResourceGroup";
  const serverName = "targetserver";
  const parameters = {
    location: "westus",
    properties: {
      createMode: "GeoRestore",
      sourceServerId:
        "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver",
    },
    sku: {
      name: "GP_Gen5_2",
      capacity: 2,
      family: "Gen5",
      tier: "GeneralPurpose",
    },
    tags: { elasticServer: "1" },
  };
  const credential = new DefaultAzureCredential();
  const client = new MySQLManagementClient(credential, subscriptionId);
  const result = await client.servers.beginCreateAndWait(resourceGroupName, serverName, parameters);
  console.log(result);
}

createAServerAsAGeoRestore().catch(console.error);

Read this SDK documentation on how to add the SDK to your project and authenticate.

Sample Response

Status code:

201

{
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 14,
      "geoRedundantBackup": "Enabled"
    },
    "version": "5.7",
    "sslEnforcement": "Enabled",
    "userVisibleState": "Ready",
    "fullyQualifiedDomainName": "targetserver.mysql.database.azure.com",
    "earliestRestoreDate": "2018-03-14T18:02:41.577+00:00"
  },
  "location": "westus",
  "tags": {
    "ElasticServer": "1"
  },
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/targetserver",
  "name": "targetserver",
  "type": "Microsoft.DBforMySQL/servers"
}

Status code:

200

{
  "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/targetserver",
  "name": "targetserver",
  "type": "Microsoft.DBforMySQL/servers",
  "location": "westus",
  "sku": {
    "name": "GP_Gen5_2",
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "capacity": 2
  },
  "tags": {
    "elasticServer": "1"
  },
  "properties": {
    "administratorLogin": "cloudsa",
    "storageProfile": {
      "storageMB": 128000,
      "backupRetentionDays": 14,
      "geoRedundantBackup": "Enabled"
    },
    "version": "5.7",
    "sslEnforcement": "Enabled",
    "userVisibleState": "Ready",
    "fullyQualifiedDomainName": "targetserver.mysql.database.azure.com",
    "earliestRestoreDate": "2018-03-14T18:02:41.577+00:00"
  }
}

Status code:

202

Definisi

CloudError	Respons kesalahan dari layanan Batch.
ErrorAdditionalInfo	Info tambahan kesalahan manajemen sumber daya.
ErrorResponse	Respons Kesalahan
GeoRedundantBackup	Aktifkan Geo-redundan atau tidak untuk pencadangan server.
IdentityType	Jenis identitas. Atur ini ke 'SystemAssigned' untuk membuat dan menetapkan prinsipal Azure Active Directory untuk sumber daya secara otomatis.
InfrastructureEncryption	Tambahkan enkripsi lapisan kedua untuk data Anda menggunakan algoritma enkripsi baru yang memberikan perlindungan data tambahan. Nilai bersifat opsional tetapi jika diteruskan, harus 'Dinonaktifkan' atau 'Diaktifkan'.
MinimalTlsVersionEnum	Terapkan versi Tls minimal untuk server.
PrivateEndpointProperty
PrivateEndpointProvisioningState	Status koneksi titik akhir privat.
PrivateLinkServiceConnectionStateActionsRequire	Tindakan yang diperlukan untuk koneksi layanan tautan privat.
PrivateLinkServiceConnectionStateStatus	Status koneksi layanan tautan privat.
PublicNetworkAccessEnum	Apakah akses jaringan publik diperbolehkan untuk server ini atau tidak. Nilai bersifat opsional tetapi jika diteruskan, harus 'Diaktifkan' atau 'Dinonaktifkan'
ResourceIdentity	Azure Active Directory konfigurasi identitas untuk sumber daya.
Server	Mewakili server.
ServerForCreate	Mewakili server yang akan dibuat.
ServerPrivateEndpointConnection	Koneksi titik akhir privat di bawah server
ServerPrivateEndpointConnectionProperties	Properti koneksi titik akhir privat.
ServerPrivateLinkServiceConnectionStateProperty
ServerPropertiesForDefaultCreate	Properti yang digunakan untuk membuat server baru.
ServerPropertiesForGeoRestore	Properti yang digunakan untuk membuat server baru dengan memulihkan ke wilayah yang berbeda dari cadangan yang direplikasi secara geografis.
ServerPropertiesForReplica	Properti untuk membuat replika baru.
ServerPropertiesForRestore	Properti yang digunakan untuk membuat server baru dengan memulihkan dari cadangan.
ServerState	Status server yang terlihat oleh pengguna.
ServerVersion	Versi server.
Sku	Properti terkait informasi penagihan server.
SkuTier	Tingkat SKU tertentu, misalnya Dasar.
SslEnforcementEnum	Aktifkan penegakan ssl atau tidak saat tersambung ke server.
StorageAutogrow	Aktifkan Storage Tumbuh Otomatis.
StorageProfile	Storage Properti profil server

CloudError

Respons kesalahan dari layanan Batch.

Name	Type	Description
error	ErrorResponse	Respons Kesalahan Respons kesalahan umum untuk semua API Azure Resource Manager untuk mengembalikan detail kesalahan untuk operasi yang gagal. (Ini juga mengikuti format respons kesalahan OData.)

ErrorAdditionalInfo

Info tambahan kesalahan manajemen sumber daya.

Name	Type	Description
info	object	Info tambahan.
type	string	Jenis info tambahan.

ErrorResponse

Respons Kesalahan

Name	Type	Description
additionalInfo	ErrorAdditionalInfo[]	Info tambahan kesalahan.
code	string	Kode kesalahan.
details	ErrorResponse[]	Detail kesalahan.
message	string	Pesan kesalahan.
target	string	Target kesalahan.

GeoRedundantBackup

Aktifkan Geo-redundan atau tidak untuk pencadangan server.

Name	Type	Description
Disabled	string
Enabled	string

IdentityType

Jenis identitas. Atur ini ke 'SystemAssigned' untuk membuat dan menetapkan prinsipal Azure Active Directory untuk sumber daya secara otomatis.

Name	Type	Description
SystemAssigned	string

InfrastructureEncryption

Tambahkan enkripsi lapisan kedua untuk data Anda menggunakan algoritma enkripsi baru yang memberikan perlindungan data tambahan. Nilai bersifat opsional tetapi jika diteruskan, harus 'Dinonaktifkan' atau 'Diaktifkan'.

Name	Type	Description
Disabled	string	Lapisan enkripsi tambahan (ke-2) untuk data tidak aktif
Enabled	string	Nilai default untuk lapisan enkripsi tunggal untuk data tidak aktif.

MinimalTlsVersionEnum

Terapkan versi Tls minimal untuk server.

Name	Type	Description
TLS1_0	string
TLS1_1	string
TLS1_2	string
TLSEnforcementDisabled	string

PrivateEndpointProperty

Name	Type	Description
id	string	Id sumber daya titik akhir privat.

PrivateEndpointProvisioningState

Status koneksi titik akhir privat.

Name	Type	Description
Approving	string
Dropping	string
Failed	string
Ready	string
Rejecting	string

PrivateLinkServiceConnectionStateActionsRequire

Tindakan yang diperlukan untuk koneksi layanan tautan privat.

Name	Type	Description
None	string

PrivateLinkServiceConnectionStateStatus

Status koneksi layanan tautan privat.

Name	Type	Description
Approved	string
Disconnected	string
Pending	string
Rejected	string

PublicNetworkAccessEnum

Apakah akses jaringan publik diperbolehkan untuk server ini atau tidak. Nilai bersifat opsional tetapi jika diteruskan, harus 'Diaktifkan' atau 'Dinonaktifkan'

Name	Type	Description
Disabled	string
Enabled	string

ResourceIdentity

Azure Active Directory konfigurasi identitas untuk sumber daya.

Name	Type	Description
principalId	string	Id utama Azure Active Directory.
tenantId	string	Id penyewa Azure Active Directory.
type	IdentityType	Jenis identitas. Atur ini ke 'SystemAssigned' untuk membuat dan menetapkan prinsipal Azure Active Directory untuk sumber daya secara otomatis.

Server

Mewakili server.

Name	Type	Description
id	string	ID sumber daya yang sepenuhnya memenuhi syarat untuk sumber daya. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
identity	ResourceIdentity	Identitas Azure Active Directory server.
location	string	Lokasi geografis tempat sumber daya berada
name	string	Nama sumber daya.
properties.administratorLogin	string	Nama masuk administrator server. Hanya dapat ditentukan ketika server sedang dibuat (dan diperlukan untuk pembuatan).
properties.byokEnforcement	string	Status memperlihatkan apakah enkripsi data server diaktifkan dengan kunci yang dikelola pelanggan.
properties.earliestRestoreDate	string	Waktu pembuatan titik pemulihan paling awal (format ISO8601)
properties.fullyQualifiedDomainName	string	Nama domain server yang sepenuhnya memenuhi syarat.
properties.infrastructureEncryption	InfrastructureEncryption	Status memperlihatkan apakah enkripsi infrastruktur yang diaktifkan server.
properties.masterServerId	string	Id server master dari server replika.
properties.minimalTlsVersion	MinimalTlsVersionEnum	Terapkan versi Tls minimal untuk server.
properties.privateEndpointConnections	ServerPrivateEndpointConnection[]	Daftar koneksi titik akhir privat di server
properties.publicNetworkAccess	PublicNetworkAccessEnum	Apakah akses jaringan publik diperbolehkan untuk server ini atau tidak. Nilai bersifat opsional tetapi jika diteruskan, harus 'Diaktifkan' atau 'Dinonaktifkan'
properties.replicaCapacity	integer	Jumlah maksimum replika yang dapat dimiliki server master.
properties.replicationRole	string	Peran replikasi server.
properties.sslEnforcement	SslEnforcementEnum	Aktifkan penegakan ssl atau tidak saat tersambung ke server.
properties.storageProfile	StorageProfile	Storage profil server.
properties.userVisibleState	ServerState	Status server yang terlihat oleh pengguna.
properties.version	ServerVersion	Versi server.
sku	Sku	SKU (tingkat harga) server.
tags	object	Tag sumber daya.
type	string	Jenis sumber daya. Misalnya, "Microsoft.Compute/virtualMachines" atau "Microsoft. Storage/storageAccounts"

ServerForCreate

Mewakili server yang akan dibuat.

Name	Type	Description
identity	ResourceIdentity	Identitas Azure Active Directory server.
location	string	Lokasi sumber daya berada.
properties	ServerPropertiesForCreate: ServerPropertiesForDefaultCreate ServerPropertiesForGeoRestore ServerPropertiesForReplica ServerPropertiesForRestore	Properti server.
sku	Sku	SKU (tingkat harga) server.
tags	object	Metadata khusus aplikasi dalam bentuk pasangan kunci-nilai.

ServerPrivateEndpointConnection

Koneksi titik akhir privat di bawah server

Name	Type	Description
id	string	Id sumber daya koneksi titik akhir privat.
properties	ServerPrivateEndpointConnectionProperties	Properti koneksi titik akhir privat

ServerPrivateEndpointConnectionProperties

Properti koneksi titik akhir privat.

Name	Type	Description
privateEndpoint	PrivateEndpointProperty	Titik akhir privat tempat koneksi berada.
privateLinkServiceConnectionState	ServerPrivateLinkServiceConnectionStateProperty	Status koneksi koneksi titik akhir privat.
provisioningState	PrivateEndpointProvisioningState	Status koneksi titik akhir privat.

ServerPrivateLinkServiceConnectionStateProperty

Name	Type	Description
actionsRequired	PrivateLinkServiceConnectionStateActionsRequire	Tindakan yang diperlukan untuk koneksi layanan tautan privat.
description	string	Deskripsi koneksi layanan tautan privat.
status	PrivateLinkServiceConnectionStateStatus	Status koneksi layanan tautan privat.

ServerPropertiesForDefaultCreate

Properti yang digunakan untuk membuat server baru.

Name	Type	Description
administratorLogin	string	Nama masuk administrator server. Hanya dapat ditentukan ketika server sedang dibuat (dan diperlukan untuk pembuatan). Nama login diperlukan saat memperbarui kata sandi.
administratorLoginPassword	string	Kata sandi login administrator.
createMode	string: Default	Mode untuk membuat server baru.
infrastructureEncryption	InfrastructureEncryption	Status memperlihatkan apakah enkripsi infrastruktur yang diaktifkan server.
minimalTlsVersion	MinimalTlsVersionEnum	Terapkan versi Tls minimal untuk server.
publicNetworkAccess	PublicNetworkAccessEnum	Apakah akses jaringan publik diperbolehkan untuk server ini atau tidak. Nilai bersifat opsional tetapi jika diteruskan, harus 'Diaktifkan' atau 'Dinonaktifkan'
sslEnforcement	SslEnforcementEnum	Aktifkan penegakan ssl atau tidak saat tersambung ke server.
storageProfile	StorageProfile	Storage profil server.
version	ServerVersion	Versi server.

ServerPropertiesForGeoRestore

Properti yang digunakan untuk membuat server baru dengan memulihkan ke wilayah yang berbeda dari cadangan yang direplikasi secara geografis.

Name	Type	Description
createMode	string: GeoRestore	Mode untuk membuat server baru.
infrastructureEncryption	InfrastructureEncryption	Status memperlihatkan apakah enkripsi infrastruktur yang diaktifkan server.
minimalTlsVersion	MinimalTlsVersionEnum	Terapkan versi Tls minimal untuk server.
publicNetworkAccess	PublicNetworkAccessEnum	Apakah akses jaringan publik diperbolehkan untuk server ini atau tidak. Nilai bersifat opsional tetapi jika diteruskan, harus 'Diaktifkan' atau 'Dinonaktifkan'
sourceServerId	string	Id server sumber untuk dipulihkan.
sslEnforcement	SslEnforcementEnum	Aktifkan penegakan ssl atau tidak saat tersambung ke server.
storageProfile	StorageProfile	Storage profil server.
version	ServerVersion	Versi server.

ServerPropertiesForReplica

Properti untuk membuat replika baru.

Name	Type	Description
createMode	string: Replica	Mode untuk membuat server baru.
infrastructureEncryption	InfrastructureEncryption	Status memperlihatkan apakah enkripsi infrastruktur yang diaktifkan server.
minimalTlsVersion	MinimalTlsVersionEnum	Terapkan versi Tls minimal untuk server.
publicNetworkAccess	PublicNetworkAccessEnum	Apakah akses jaringan publik diperbolehkan untuk server ini atau tidak. Nilai bersifat opsional tetapi jika diteruskan, harus 'Diaktifkan' atau 'Dinonaktifkan'
sourceServerId	string	Id server master untuk membuat replika.
sslEnforcement	SslEnforcementEnum	Aktifkan penegakan ssl atau tidak saat tersambung ke server.
storageProfile	StorageProfile	Storage profil server.
version	ServerVersion	Versi server.

ServerPropertiesForRestore

Properti yang digunakan untuk membuat server baru dengan memulihkan dari cadangan.

Name	Type	Description
createMode	string: PointInTimeRestore	Mode untuk membuat server baru.
infrastructureEncryption	InfrastructureEncryption	Status memperlihatkan apakah enkripsi infrastruktur yang diaktifkan server.
minimalTlsVersion	MinimalTlsVersionEnum	Terapkan versi Tls minimal untuk server.
publicNetworkAccess	PublicNetworkAccessEnum	Apakah akses jaringan publik diperbolehkan untuk server ini atau tidak. Nilai bersifat opsional tetapi jika diteruskan, harus 'Diaktifkan' atau 'Dinonaktifkan'
restorePointInTime	string	Waktu pembuatan titik pemulihan (format ISO8601), menentukan waktu untuk memulihkan.
sourceServerId	string	Id server sumber untuk dipulihkan.
sslEnforcement	SslEnforcementEnum	Aktifkan penegakan ssl atau tidak saat tersambung ke server.
storageProfile	StorageProfile	Storage profil server.
version	ServerVersion	Versi server.

ServerState

Status server yang terlihat oleh pengguna.

Name	Type	Description
Disabled	string
Dropping	string
Inaccessible	string
Ready	string

ServerVersion

Versi server.

Name	Type	Description
5.6	string
5.7	string
8.0	string

Sku

Properti terkait informasi penagihan server.

Name	Type	Description
capacity	integer	Kapasitas peningkatan/peluasan skala, mewakili unit komputasi server.
family	string	Keluarga perangkat keras.
name	string	Nama sku, biasanya, tingkat + keluarga + inti, misalnya B_Gen4_1, GP_Gen5_8.
size	string	Kode ukuran, yang akan ditafsirkan oleh sumber daya yang sesuai.
tier	SkuTier	Tingkat SKU tertentu, misalnya Dasar.

SkuTier

Tingkat SKU tertentu, misalnya Dasar.

Name	Type	Description
Basic	string
GeneralPurpose	string
MemoryOptimized	string

SslEnforcementEnum

Aktifkan penegakan ssl atau tidak saat tersambung ke server.

Name	Type	Description
Disabled	string
Enabled	string

StorageAutogrow

Aktifkan Storage Tumbuh Otomatis.

Name	Type	Description
Disabled	string
Enabled	string

StorageProfile

Storage Properti profil server

Name	Type	Description
backupRetentionDays	integer	Hari retensi cadangan untuk server.
geoRedundantBackup	GeoRedundantBackup	Aktifkan Geo-redundan atau tidak untuk pencadangan server.
storageAutogrow	StorageAutogrow	Aktifkan Storage Tumbuh Otomatis.
storageMB	integer	Penyimpanan maks yang diizinkan untuk server.