Servers - Update

Referensi

Service:: MySQL

API Version:: 2021-05-01

Memperbarui server yang ada. Isi permintaan dapat berisi satu hingga banyak properti yang ada dalam definisi server normal.

PATCH https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/flexibleServers/{serverName}?api-version=2021-05-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	Type	Description
identity.type	ManagedServiceIdentityType	Jenis identitas layanan terkelola.
identity.userAssignedIdentities	object	Metadata identitas yang ditetapkan pengguna.
properties.administratorLoginPassword	string	Kata sandi login administrator.
properties.backup	Backup	Properti terkait pencadangan server.
properties.dataEncryption	DataEncryption	Enkripsi Data untuk CMK.
properties.highAvailability	HighAvailability	Properti terkait ketersediaan tinggi server.
properties.maintenanceWindow	MaintenanceWindow	Jendela pemeliharaan server.
properties.replicationRole	ReplicationRole	Peran replikasi server.
properties.storage	Storage	Storage properti terkait 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
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

Update a server

Update server customer maintenance window

Update server with byok

Update a server

Sample Request

PATCH https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver?api-version=2021-05-01

{
  "properties": {
    "storage": {
      "storageSizeGB": 30,
      "iops": 200,
      "autoGrow": "Disabled"
    }
  }
}

import com.azure.core.util.Context;
import com.azure.resourcemanager.mysqlflexibleserver.models.EnableStatusEnum;
import com.azure.resourcemanager.mysqlflexibleserver.models.Server;
import com.azure.resourcemanager.mysqlflexibleserver.models.Storage;
import java.util.HashMap;
import java.util.Map;

/** Samples for Servers Update. */
public final class Main {
    /*
     * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2021-05-01/examples/ServerUpdate.json
     */
    /**
     * Sample code: Update a server.
     *
     * @param manager Entry point to MySqlManager.
     */
    public static void updateAServer(com.azure.resourcemanager.mysqlflexibleserver.MySqlManager manager) {
        Server resource =
            manager.servers().getByResourceGroupWithResponse("testrg", "mysqltestserver", Context.NONE).getValue();
        resource
            .update()
            .withStorage(new Storage().withStorageSizeGB(30).withIops(200).withAutoGrow(EnableStatusEnum.DISABLED))
            .apply();
    }

    @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.

package armmysqlflexibleservers_test

import (
	"context"
	"log"

	"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/armmysqlflexibleservers"
)

// Generated from example definition: https://github.com/Azure/azure-rest-api-specs/tree/main/specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2021-05-01/examples/ServerUpdate.json
func ExampleServersClient_BeginUpdate() {
	cred, err := azidentity.NewDefaultAzureCredential(nil)
	if err != nil {
		log.Fatalf("failed to obtain a credential: %v", err)
	}
	ctx := context.Background()
	client, err := armmysqlflexibleservers.NewServersClient("ffffffff-ffff-ffff-ffff-ffffffffffff", cred, nil)
	if err != nil {
		log.Fatalf("failed to create client: %v", err)
	}
	poller, err := client.BeginUpdate(ctx,
		"testrg",
		"mysqltestserver",
		armmysqlflexibleservers.ServerForUpdate{
			Properties: &armmysqlflexibleservers.ServerPropertiesForUpdate{
				Storage: &armmysqlflexibleservers.Storage{
					AutoGrow:      to.Ptr(armmysqlflexibleservers.EnableStatusEnumDisabled),
					Iops:          to.Ptr[int32](200),
					StorageSizeGB: to.Ptr[int32](30),
				},
			},
		},
		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.

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

/**
 * This sample demonstrates how to Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.
 *
 * @summary Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.
 * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2021-05-01/examples/ServerUpdate.json
 */
async function updateAServer() {
  const subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
  const resourceGroupName = "testrg";
  const serverName = "mysqltestserver";
  const parameters = {
    storage: { autoGrow: "Disabled", iops: 200, storageSizeGB: 30 },
  };
  const credential = new DefaultAzureCredential();
  const client = new MySQLManagementFlexibleServerClient(credential, subscriptionId);
  const result = await client.servers.beginUpdateAndWait(resourceGroupName, serverName, parameters);
  console.log(result);
}

updateAServer().catch(console.error);

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

Sample Response

Status code:: 200

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

Status code:: 202

Update server customer maintenance window

Sample Request

PATCH https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver?api-version=2021-05-01

{
  "properties": {
    "maintenanceWindow": {
      "customWindow": "Enabled",
      "dayOfWeek": 1,
      "startHour": 8,
      "startMinute": 0
    }
  }
}

import com.azure.core.util.Context;
import com.azure.resourcemanager.mysqlflexibleserver.models.MaintenanceWindow;
import com.azure.resourcemanager.mysqlflexibleserver.models.Server;
import java.util.HashMap;
import java.util.Map;

/** Samples for Servers Update. */
public final class Main {
    /*
     * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2021-05-01/examples/ServerUpdateWithCustomerMaintenanceWindow.json
     */
    /**
     * Sample code: Update server customer maintenance window.
     *
     * @param manager Entry point to MySqlManager.
     */
    public static void updateServerCustomerMaintenanceWindow(
        com.azure.resourcemanager.mysqlflexibleserver.MySqlManager manager) {
        Server resource =
            manager.servers().getByResourceGroupWithResponse("testrg", "mysqltestserver", Context.NONE).getValue();
        resource
            .update()
            .withMaintenanceWindow(
                new MaintenanceWindow()
                    .withCustomWindow("Enabled")
                    .withStartHour(8)
                    .withStartMinute(0)
                    .withDayOfWeek(1))
            .apply();
    }

    @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.

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

/**
 * This sample demonstrates how to Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.
 *
 * @summary Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.
 * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2021-05-01/examples/ServerUpdateWithCustomerMaintenanceWindow.json
 */
async function updateServerCustomerMaintenanceWindow() {
  const subscriptionId = "ffffffff-ffff-ffff-ffff-ffffffffffff";
  const resourceGroupName = "testrg";
  const serverName = "mysqltestserver";
  const parameters = {
    maintenanceWindow: {
      customWindow: "Enabled",
      dayOfWeek: 1,
      startHour: 8,
      startMinute: 0,
    },
  };
  const credential = new DefaultAzureCredential();
  const client = new MySQLManagementFlexibleServerClient(credential, subscriptionId);
  const result = await client.servers.beginUpdateAndWait(resourceGroupName, serverName, parameters);
  console.log(result);
}

updateServerCustomerMaintenanceWindow().catch(console.error);

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

Sample Response

Status code:: 200

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

Status code:: 202

Update server with byok

PATCH https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/flexibleServers/mysqltestserver?api-version=2021-05-01

{
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity": {}
    }
  },
  "properties": {
    "dataEncryption": {
      "type": "AzureKeyVault",
      "primaryUserAssignedIdentityId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity",
      "primaryKeyUri": "https://test.vault.azure.net/keys/key/c8a92236622244c0a4fdb892666f671a",
      "geoBackupUserAssignedIdentityId": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-geo-identity",
      "geoBackupKeyUri": "https://test-geo.vault.azure.net/keys/key/c8a92236622244c0a4fdb892666f671a"
    }
  }
}

import com.azure.core.management.serializer.SerializerFactory;
import com.azure.core.util.Context;
import com.azure.core.util.serializer.SerializerEncoding;
import com.azure.resourcemanager.mysqlflexibleserver.models.DataEncryption;
import com.azure.resourcemanager.mysqlflexibleserver.models.DataEncryptionType;
import com.azure.resourcemanager.mysqlflexibleserver.models.Identity;
import com.azure.resourcemanager.mysqlflexibleserver.models.ManagedServiceIdentityType;
import com.azure.resourcemanager.mysqlflexibleserver.models.Server;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

/** Samples for Servers Update. */
public final class Main {
    /*
     * x-ms-original-file: specification/mysql/resource-manager/Microsoft.DBforMySQL/stable/2021-05-01/examples/ServerUpdateWithBYOK.json
     */
    /**
     * Sample code: Update server with byok.
     *
     * @param manager Entry point to MySqlManager.
     */
    public static void updateServerWithByok(com.azure.resourcemanager.mysqlflexibleserver.MySqlManager manager)
        throws IOException {
        Server resource =
            manager.servers().getByResourceGroupWithResponse("testrg", "mysqltestserver", Context.NONE).getValue();
        resource
            .update()
            .withIdentity(
                new Identity()
                    .withType(ManagedServiceIdentityType.USER_ASSIGNED)
                    .withUserAssignedIdentities(
                        mapOf(
                            "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity",
                            SerializerFactory
                                .createDefaultManagementSerializerAdapter()
                                .deserialize("{}", Object.class, SerializerEncoding.JSON))))
            .withDataEncryption(
                new DataEncryption()
                    .withPrimaryUserAssignedIdentityId(
                        "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-identity")
                    .withPrimaryKeyUri("https://test.vault.azure.net/keys/key/c8a92236622244c0a4fdb892666f671a")
                    .withGeoBackupUserAssignedIdentityId(
                        "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.ManagedIdentity/userAssignedIdentities/test-geo-identity")
                    .withGeoBackupKeyUri("https://test-geo.vault.azure.net/keys/key/c8a92236622244c0a4fdb892666f671a")
                    .withType(DataEncryptionType.AZURE_KEY_VAULT))
            .apply();
    }

    @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.

Sample Response

Status code:: 200

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

Status code:: 202

Definisi

Backup	Storage Properti profil server
CloudError	Respons kesalahan dari layanan Batch.
createdByType	Jenis identitas yang membuat sumber daya.
CreateMode	Mode untuk membuat server MySQL baru.
DataEncryption	Enkripsi tanggal untuk cmk.
DataEncryptionType	Jenis kunci, AzureKeyVault untuk mengaktifkan cmk, SystemManaged untuk menonaktifkan cmk.
EnableStatusEnum	Enum untuk menunjukkan apakah nilainya 'Diaktifkan' atau 'Dinonaktifkan'
ErrorAdditionalInfo	Info tambahan kesalahan manajemen sumber daya.
ErrorResponse	Respons Kesalahan
HighAvailability	Properti terkait jaringan server
HighAvailabilityMode	Mode ketersediaan tinggi untuk server.
HighAvailabilityState	Status ketersediaan tinggi server.
MaintenanceWindow	Jendela pemeliharaan server.
ManagedServiceIdentityType	Jenis identitas layanan terkelola.
Network	Properti terkait jaringan server
ReplicationRole	Peran replikasi.
Server	Mewakili server.
ServerForUpdate	Parameter yang diizinkan untuk diperbarui untuk server.
ServerState	Status server.
ServerVersion	Versi server.
Sku	Properti terkait informasi penagihan server.
SkuTier	Tingkat SKU tertentu, misalnya GeneralPurpose.
Storage	Storage Properti profil server
systemData	Metadata yang berkaitan dengan pembuatan dan modifikasi terakhir sumber daya.

Backup

Storage Properti profil server

Name	Type	Description
backupRetentionDays	integer	Hari retensi cadangan untuk server.
earliestRestoreDate	string	Waktu pembuatan titik pemulihan paling awal (format ISO8601)
geoRedundantBackup	EnableStatusEnum	Apakah pencadangan redundan geografis diaktifkan atau tidak.

CloudError

Respons kesalahan dari layanan Batch.

Name	Type	Description
error	ErrorResponse	Respons Kesalahan Respons kesalahan manajemen sumber daya.

createdByType

Jenis identitas yang membuat sumber daya.

Name	Type	Description
Application	string
Key	string
ManagedIdentity	string
User	string

CreateMode

Mode untuk membuat server MySQL baru.

Name	Type	Description
Default	string
GeoRestore	string
PointInTimeRestore	string
Replica	string

DataEncryption

Enkripsi tanggal untuk cmk.

Name	Type	Description
geoBackupKeyUri	string	Uri kunci cadangan geografis karena brankas kunci tidak dapat melintasi wilayah, membutuhkan cmk di wilayah yang sama dengan cadangan geografis
geoBackupUserAssignedIdentityId	string	Id sumber daya identitas pengguna cadangan geografis karena identitas tidak dapat melintasi wilayah, memerlukan identitas di wilayah yang sama dengan cadangan geografis
primaryKeyUri	string	Uri kunci primer
primaryUserAssignedIdentityId	string	Id sumber daya identitas pengguna utama
type	DataEncryptionType	Jenis kunci, AzureKeyVault untuk mengaktifkan cmk, SystemManaged untuk menonaktifkan cmk.

DataEncryptionType

Jenis kunci, AzureKeyVault untuk mengaktifkan cmk, SystemManaged untuk menonaktifkan cmk.

Name	Type	Description
AzureKeyVault	string
SystemManaged	string

EnableStatusEnum

Enum untuk menunjukkan apakah nilainya 'Diaktifkan' atau 'Dinonaktifkan'

Name	Type	Description
Disabled	string
Enabled	string

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.

HighAvailability

Properti terkait jaringan server

Name	Type	Description
mode	HighAvailabilityMode	Mode ketersediaan tinggi untuk server.
standbyAvailabilityZone	string	Zona ketersediaan server siaga.
state	HighAvailabilityState	Status ketersediaan tinggi server.

HighAvailabilityMode

Mode ketersediaan tinggi untuk server.

Name	Type	Description
Disabled	string
SameZone	string
ZoneRedundant	string

HighAvailabilityState

Status ketersediaan tinggi server.

Name	Type	Description
CreatingStandby	string
FailingOver	string
Healthy	string
NotEnabled	string
RemovingStandby	string

MaintenanceWindow

Jendela pemeliharaan server.

Name	Type	Description
customWindow	string	menunjukkan apakah jendela kustom diaktifkan atau dinonaktifkan
dayOfWeek	integer	hari dalam seminggu untuk jendela pemeliharaan
startHour	integer	jam mulai untuk jendela pemeliharaan
startMinute	integer	menit mulai untuk jendela pemeliharaan

ManagedServiceIdentityType

Jenis identitas layanan terkelola.

Name	Type	Description
UserAssigned	string

Network

Properti terkait jaringan server

Name	Type	Description
delegatedSubnetResourceId	string	Id sumber daya subnet yang didelegasikan digunakan untuk menyiapkan vnet untuk server.
privateDnsZoneResourceId	string	Id sumber daya zona DNS privat.
publicNetworkAccess	EnableStatusEnum	Apakah akses jaringan publik diperbolehkan untuk server ini atau tidak. Nilai adalah 'Dinonaktifkan' ketika server memiliki integrasi VNet.

ReplicationRole

Peran replikasi.

Name	Type	Description
None	string
Replica	string
Source	string

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.principalId	string	ObjectId dari KeyVault
identity.tenantId	string	TenantId dari KeyVault
identity.type	ManagedServiceIdentityType	Jenis identitas layanan terkelola.
identity.userAssignedIdentities	object	Metadata identitas yang ditetapkan pengguna.
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.administratorLoginPassword	string	Kata sandi login administrator (diperlukan untuk pembuatan server).
properties.availabilityZone	string	informasi zona ketersediaan server.
properties.backup	Backup	Mencadangkan properti terkait server.
properties.createMode	CreateMode	Mode untuk membuat server MySQL baru.
properties.dataEncryption	DataEncryption	Enkripsi Data untuk CMK.
properties.fullyQualifiedDomainName	string	Nama domain server yang sepenuhnya memenuhi syarat.
properties.highAvailability	HighAvailability	Properti terkait ketersediaan tinggi dari server.
properties.maintenanceWindow	MaintenanceWindow	Jendela pemeliharaan server.
properties.network	Network	Properti terkait jaringan server.
properties.replicaCapacity	integer	Jumlah maksimum replika yang dapat dimiliki server utama.
properties.replicationRole	ReplicationRole	Peran replikasi.
properties.restorePointInTime	string	Waktu pembuatan titik pemulihan (format ISO8601), menentukan waktu untuk memulihkan.
properties.sourceServerResourceId	string	Id server MySQL sumber.
properties.state	ServerState	Status server.
properties.storage	Storage	Storage properti server terkait.
properties.version	ServerVersion	Versi server.
sku	Sku	SKU (tingkat harga) server.
systemData	systemData	Metadata sistem yang berkaitan dengan sumber daya ini.
tags	object	Tag sumber daya.
type	string	Jenis sumber daya. Misalnya, "Microsoft.Compute/virtualMachines" atau "Microsoft. Storage/storageAccounts"

ServerForUpdate

Parameter yang diizinkan untuk diperbarui untuk server.

Name	Type	Description
identity.principalId	string	ObjectId dari KeyVault
identity.tenantId	string	TenantId dari KeyVault
identity.type	ManagedServiceIdentityType	Jenis identitas layanan terkelola.
identity.userAssignedIdentities	object	Metadata identitas yang ditetapkan pengguna.
properties.administratorLoginPassword	string	Kata sandi login administrator.
properties.backup	Backup	Mencadangkan properti terkait server.
properties.dataEncryption	DataEncryption	Enkripsi Data untuk CMK.
properties.highAvailability	HighAvailability	Properti terkait ketersediaan tinggi dari server.
properties.maintenanceWindow	MaintenanceWindow	Jendela pemeliharaan server.
properties.replicationRole	ReplicationRole	Peran replikasi server.
properties.storage	Storage	Storage properti server terkait.
sku	Sku	SKU (tingkat harga) server.
tags	object	Metadata khusus aplikasi dalam bentuk pasangan kunci-nilai.

ServerState

Status server.

Name	Type	Description
Disabled	string
Dropping	string
Ready	string
Starting	string
Stopped	string
Stopping	string
Updating	string

ServerVersion

Versi server.

Name	Type	Description
5.7	string
8.0.21	string

Sku

Properti terkait informasi penagihan server.

Name	Type	Description
name	string	Nama sku, misalnya Standard_D32s_v3.
tier	SkuTier	Tingkat SKU tertentu, misalnya GeneralPurpose.

SkuTier

Tingkat SKU tertentu, misalnya GeneralPurpose.

Name	Type	Description
Burstable	string
GeneralPurpose	string
MemoryOptimized	string

Storage

Storage Properti profil server

Name	Type	Description
autoGrow	EnableStatusEnum	Aktifkan Storage Tumbuh Otomatis atau tidak.
iops	integer	Storage IOPS untuk server.
storageSizeGB	integer	Ukuran penyimpanan maksimum yang diizinkan untuk server.
storageSku	string	Nama sku penyimpanan server.

systemData

Metadata yang berkaitan dengan pembuatan dan modifikasi terakhir sumber daya.

Name	Type	Description
createdAt	string	Tanda waktu pembuatan sumber daya (UTC).
createdBy	string	Identitas yang membuat sumber daya.
createdByType	createdByType	Jenis identitas yang membuat sumber daya.
lastModifiedAt	string	Tanda waktu modifikasi terakhir sumber daya (UTC)
lastModifiedBy	string	Identitas yang terakhir memodifikasi sumber daya.
lastModifiedByType	createdByType	Jenis identitas yang terakhir mengubah sumber daya.