Servers - Update

Reference

Service:: MySQL

API Version:: 2023-06-30

Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.

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

URI Parameters

Name	In	Required	Type	Description
resourceGroupName	path	True	string	The name of the resource group. The name is case insensitive.
serverName	path	True	string	The name of the server. Regex pattern: `^[a-z0-9][-a-z0-9]*(?<!-)$`
subscriptionId	path	True	string uuid	The ID of the target subscription. The value must be an UUID.
api-version	query	True	string	The API version to use for this operation.

Request Body

Name	Type	Description
identity.type	ManagedServiceIdentityType	Type of managed service identity.
identity.userAssignedIdentities	object	Metadata of user assigned identity.
properties.administratorLoginPassword	string	The password of the administrator login.
properties.backup	Backup	Backup related properties of a server.
properties.dataEncryption	DataEncryption	The Data Encryption for CMK.
properties.highAvailability	HighAvailability	High availability related properties of a server.
properties.maintenanceWindow	MaintenanceWindow	Maintenance window of a server.
properties.network	Network	Network related properties of a server
properties.replicationRole	ReplicationRole	The replication role of the server.
properties.storage	Storage	Storage related properties of a server.
properties.version	ServerVersion	Server version.
sku	MySQLServerSku	The SKU (pricing tier) of the server.
tags	object	Application-specific metadata in the form of key-value pairs.

Responses

Name	Type	Description
200 OK	Server	OK
202 Accepted		Accepted Headers Location: string
Other Status Codes	ErrorResponse	Error response describing why the operation failed.

Name

Type

Description

200 OK

Server

202 Accepted

Accepted

Headers

Location: string

Other Status Codes

ErrorResponse

Error response describing why the operation failed.

Security

azure_auth

Azure Active Directory OAuth2 Flow

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

Scopes

Name	Description
user_impersonation	impersonate your user account

Examples

Update a server

Update server customer maintenance window

Update server with byok

Update a server

Sample Request

HTTP

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

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

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",
      "autoIoScaling": "Disabled"
    },
    "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": "Disabled"
    },
    "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

Azure-AsyncOperation: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforMySQL/locations/southeastasia/azureAsyncOperation/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-06-30
Location: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforMySQL/locations/southeastasia/operationResults/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-06-30

Update server customer maintenance window

Sample Request

HTTP

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

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

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

Azure-AsyncOperation: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforMySQL/locations/southeastasia/azureAsyncOperation/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-06-30
Location: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforMySQL/locations/southeastasia/operationResults/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-06-30

Update server with byok

Sample Request

HTTP

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

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

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

Azure-AsyncOperation: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforMySQL/locations/southeastasia/azureAsyncOperation/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-06-30
Location: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforMySQL/locations/southeastasia/operationResults/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-06-30

Definitions

Name	Description
Backup	Storage Profile properties of a server
createdByType	The type of identity that created the resource.
CreateMode	The mode to create a new MySQL server.
DataEncryption	The date encryption for cmk.
DataEncryptionType	The key type, AzureKeyVault for enable cmk, SystemManaged for disable cmk.
EnableStatusEnum	Enum to indicate whether value is 'Enabled' or 'Disabled'
ErrorAdditionalInfo	The resource management error additional info.
ErrorDetail	The error detail.
ErrorResponse	Error response
HighAvailability	Network related properties of a server
HighAvailabilityMode	High availability mode for a server.
HighAvailabilityState	The state of server high availability.
ImportSourceProperties	Import source related properties.
ImportSourceStorageType	Storage type of import source.
MaintenanceWindow	Maintenance window of a server.
ManagedServiceIdentityType	Type of managed service identity.
MySQLServerSku	Billing information related properties of a server.
Network	Network related properties of a server
PrivateEndpoint	The private endpoint resource.
PrivateEndpointConnection	The private endpoint connection resource.
PrivateEndpointConnectionProvisioningState	The current provisioning state.
PrivateEndpointServiceConnectionStatus	The private endpoint connection status.
PrivateLinkServiceConnectionState	A collection of information about the state of the connection between service consumer and provider.
ReplicationRole	The replication role.
Server	Represents a server.
ServerForUpdate	Parameters allowed to update for a server.
ServerSkuTier	The tier of the particular SKU, e.g. GeneralPurpose.
ServerState	The state of a server.
ServerVersion	The version of a server.
Storage	Storage Profile properties of a server
systemData	Metadata pertaining to creation and last modification of the resource.

Backup

Storage Profile properties of a server

Name	Type	Default Value	Description
backupRetentionDays	integer		Backup retention days for the server.
earliestRestoreDate	string		Earliest restore point creation time (ISO8601 format)
geoRedundantBackup	EnableStatusEnum	Disabled	Whether or not geo redundant backup is enabled.

createdByType

The type of identity that created the resource.

Name	Type	Description
Application	string
Key	string
ManagedIdentity	string
User	string

CreateMode

The mode to create a new MySQL server.

Name	Type	Description
Default	string
GeoRestore	string
PointInTimeRestore	string
Replica	string

DataEncryption

The date encryption for cmk.

Name	Type	Description
geoBackupKeyURI	string	Geo backup key uri as key vault can't cross region, need cmk in same region as geo backup
geoBackupUserAssignedIdentityId	string	Geo backup user identity resource id as identity can't cross region, need identity in same region as geo backup
primaryKeyURI	string	Primary key uri
primaryUserAssignedIdentityId	string	Primary user identity resource id
type	DataEncryptionType	The key type, AzureKeyVault for enable cmk, SystemManaged for disable cmk.

DataEncryptionType

The key type, AzureKeyVault for enable cmk, SystemManaged for disable cmk.

Name	Type	Description
AzureKeyVault	string
SystemManaged	string

EnableStatusEnum

Enum to indicate whether value is 'Enabled' or 'Disabled'

Name	Type	Description
Disabled	string
Enabled	string

ErrorAdditionalInfo

The resource management error additional info.

Name	Type	Description
info	object	The additional info.
type	string	The additional info type.

ErrorDetail

The error detail.

Name	Type	Description
additionalInfo	ErrorAdditionalInfo[]	The error additional info.
code	string	The error code.
details	ErrorDetail[]	The error details.
message	string	The error message.
target	string	The error target.

ErrorResponse

Error response

Name	Type	Description
error	ErrorDetail	The error object.

HighAvailability

Network related properties of a server

Name	Type	Description
mode	HighAvailabilityMode	High availability mode for a server.
standbyAvailabilityZone	string	Availability zone of the standby server.
state	HighAvailabilityState	The state of server high availability.

HighAvailabilityMode

High availability mode for a server.

Name	Type	Description
Disabled	string
SameZone	string
ZoneRedundant	string

HighAvailabilityState

The state of server high availability.

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

ImportSourceProperties

Import source related properties.

Name	Type	Description
dataDirPath	string	Relative path of data directory in storage.
sasToken	string	Sas token for accessing source storage. Read and list permissions are required for sas token.
storageType	ImportSourceStorageType	Storage type of import source.
storageUrl	string	Uri of the import source storage.

ImportSourceStorageType

Storage type of import source.

Name	Type	Description
AzureBlob	string

MaintenanceWindow

Maintenance window of a server.

Name	Type	Description
customWindow	string	indicates whether custom window is enabled or disabled
dayOfWeek	integer	day of week for maintenance window
startHour	integer	start hour for maintenance window
startMinute	integer	start minute for maintenance window

ManagedServiceIdentityType

Type of managed service identity.

Name	Type	Description
UserAssigned	string

MySQLServerSku

Billing information related properties of a server.

Name	Type	Description
name	string	The name of the sku, e.g. Standard_D32s_v3.
tier	ServerSkuTier	The tier of the particular SKU, e.g. GeneralPurpose.

Network

Network related properties of a server

Name	Type	Description
delegatedSubnetResourceId	string	Delegated subnet resource id used to setup vnet for a server.
privateDnsZoneResourceId	string	Private DNS zone resource id.
publicNetworkAccess	EnableStatusEnum	Whether or not public network access is allowed for this server. Value is 'Disabled' when server has VNet integration.

PrivateEndpoint

The private endpoint resource.

Name	Type	Description
id	string	The ARM identifier for private endpoint.

PrivateEndpointConnection

The private endpoint connection resource.

Name	Type	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties.groupIds	string[]	The group ids for the private endpoint resource.
properties.privateEndpoint	PrivateEndpoint	The private endpoint resource.
properties.privateLinkServiceConnectionState	PrivateLinkServiceConnectionState	A collection of information about the state of the connection between service consumer and provider.
properties.provisioningState	PrivateEndpointConnectionProvisioningState	The provisioning state of the private endpoint connection resource.
systemData	systemData	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

PrivateEndpointConnectionProvisioningState

The current provisioning state.

Name	Type	Description
Creating	string
Deleting	string
Failed	string
Succeeded	string

PrivateEndpointServiceConnectionStatus

The private endpoint connection status.

Name	Type	Description
Approved	string
Pending	string
Rejected	string

PrivateLinkServiceConnectionState

A collection of information about the state of the connection between service consumer and provider.

Name	Type	Description
actionsRequired	string	A message indicating if changes on the service provider require any updates on the consumer.
description	string	The reason for approval/rejection of the connection.
status	PrivateEndpointServiceConnectionStatus	Indicates whether the connection has been Approved/Rejected/Removed by the owner of the service.

ReplicationRole

The replication role.

Name	Type	Description
None	string
Replica	string
Source	string

Server

Represents a server.

Name	Type	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
identity.principalId	string	ObjectId from the KeyVault
identity.tenantId	string	TenantId from the KeyVault
identity.type	ManagedServiceIdentityType	Type of managed service identity.
identity.userAssignedIdentities	object	Metadata of user assigned identity.
location	string	The geo-location where the resource lives
name	string	The name of the resource
properties.administratorLogin	string	The administrator's login name of a server. Can only be specified when the server is being created (and is required for creation).
properties.administratorLoginPassword	string	The password of the administrator login (required for server creation).
properties.availabilityZone	string	availability Zone information of the server.
properties.backup	Backup	Backup related properties of a server.
properties.createMode	CreateMode	The mode to create a new MySQL server.
properties.dataEncryption	DataEncryption	The Data Encryption for CMK.
properties.fullyQualifiedDomainName	string	The fully qualified domain name of a server.
properties.highAvailability	HighAvailability	High availability related properties of a server.
properties.importSourceProperties	ImportSourceProperties	Source properties for import from storage.
properties.maintenanceWindow	MaintenanceWindow	Maintenance window of a server.
properties.network	Network	Network related properties of a server.
properties.privateEndpointConnections	PrivateEndpointConnection[]	PrivateEndpointConnections related properties of a server.
properties.replicaCapacity	integer	The maximum number of replicas that a primary server can have.
properties.replicationRole	ReplicationRole	The replication role.
properties.restorePointInTime	string	Restore point creation time (ISO8601 format), specifying the time to restore from.
properties.sourceServerResourceId	string	The source MySQL server id.
properties.state	ServerState	The state of a server.
properties.storage	Storage	Storage related properties of a server.
properties.version	ServerVersion	Server version.
sku	MySQLServerSku	The SKU (pricing tier) of the server.
systemData	systemData	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

ServerForUpdate

Parameters allowed to update for a server.

Name	Type	Description
identity.principalId	string	ObjectId from the KeyVault
identity.tenantId	string	TenantId from the KeyVault
identity.type	ManagedServiceIdentityType	Type of managed service identity.
identity.userAssignedIdentities	object	Metadata of user assigned identity.
properties.administratorLoginPassword	string	The password of the administrator login.
properties.backup	Backup	Backup related properties of a server.
properties.dataEncryption	DataEncryption	The Data Encryption for CMK.
properties.highAvailability	HighAvailability	High availability related properties of a server.
properties.maintenanceWindow	MaintenanceWindow	Maintenance window of a server.
properties.network	Network	Network related properties of a server
properties.replicationRole	ReplicationRole	The replication role of the server.
properties.storage	Storage	Storage related properties of a server.
properties.version	ServerVersion	Server version.
sku	MySQLServerSku	The SKU (pricing tier) of the server.
tags	object	Application-specific metadata in the form of key-value pairs.

ServerSkuTier

The tier of the particular SKU, e.g. GeneralPurpose.

Name	Type	Description
Burstable	string
GeneralPurpose	string
MemoryOptimized	string

ServerState

The state of a server.

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

ServerVersion

The version of a server.

Name	Type	Description
5.7	string
8.0.21	string

Storage

Storage Profile properties of a server

Name	Type	Default Value	Description
autoGrow	EnableStatusEnum	Disabled	Enable Storage Auto Grow or not.
autoIoScaling	EnableStatusEnum	Disabled	Enable IO Auto Scaling or not.
iops	integer		Storage IOPS for a server.
logOnDisk	EnableStatusEnum	Disabled	Enable Log On Disk or not.
storageSizeGB	integer		Max storage size allowed for a server.
storageSku	string		The sku name of the server storage.

systemData

Metadata pertaining to creation and last modification of the resource.

Name	Type	Description
createdAt	string	The timestamp of resource creation (UTC).
createdBy	string	The identity that created the resource.
createdByType	createdByType	The type of identity that created the resource.
lastModifiedAt	string	The timestamp of resource last modification (UTC)
lastModifiedBy	string	The identity that last modified the resource.
lastModifiedByType	createdByType	The type of identity that last modified the resource.

Servers - Update

URI Parameters

Request Body

Responses

Security

azure_auth

Scopes

Examples

Update a server

Sample Request

Sample Response

Update server customer maintenance window

Sample Request

Sample Response

Update server with byok

Sample Request

Sample Response

Definitions

Backup

createdByType

CreateMode

DataEncryption

DataEncryptionType

EnableStatusEnum

ErrorAdditionalInfo

ErrorDetail

ErrorResponse

HighAvailability

HighAvailabilityMode

HighAvailabilityState

ImportSourceProperties

ImportSourceStorageType

MaintenanceWindow

ManagedServiceIdentityType

MySQLServerSku

Network

PrivateEndpoint

PrivateEndpointConnection

PrivateEndpointConnectionProvisioningState

PrivateEndpointServiceConnectionStatus

PrivateLinkServiceConnectionState

ReplicationRole

Server

ServerForUpdate

ServerSkuTier

ServerState

ServerVersion

Storage

systemData

Additional resources