Share via

Microsoft.DBforMariaDB servers/databases 2018-06-01

Bicep resource definition

The servers/databases resource type can be deployed with operations that target:

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforMariaDB/servers/databases resource, add the following Bicep to your template.

resource symbolicname 'Microsoft.DBforMariaDB/servers/databases@2018-06-01' = {
  parent: resourceSymbolicName
  name: 'string'
  properties: {
    charset: 'string'
    collation: 'string'
  }
}

Property Values

Microsoft.DBforMariaDB/servers/databases

Name Description Value
name The resource name string (required)
parent In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource.

For more information, see Child resource outside parent resource.		 Symbolic name for resource of type: servers
properties The properties of a database. DatabaseProperties

DatabaseProperties

Name Description Value
charset The charset of the database. string
collation The collation of the database. string

ARM template resource definition

The servers/databases resource type can be deployed with operations that target:

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforMariaDB/servers/databases resource, add the following JSON to your template.

{
  "type": "Microsoft.DBforMariaDB/servers/databases",
  "apiVersion": "2018-06-01",
  "name": "string",
  "properties": {
    "charset": "string",
    "collation": "string"
  }
}

Property Values

Microsoft.DBforMariaDB/servers/databases

Name Description Value
apiVersion The api version '2018-06-01'
name The resource name string (required)
properties The properties of a database. DatabaseProperties
type The resource type 'Microsoft.DBforMariaDB/servers/databases'

DatabaseProperties

Name Description Value
charset The charset of the database. string
collation The collation of the database. string

Usage Examples

Terraform (AzAPI provider) resource definition

The servers/databases resource type can be deployed with operations that target:

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforMariaDB/servers/databases resource, add the following Terraform to your template.

resource "azapi_resource" "symbolicname" {
  type = "Microsoft.DBforMariaDB/servers/databases@2018-06-01"
  name = "string"
  parent_id = "string"
  body = {
    properties = {
      charset = "string"
      collation = "string"
    }
  }
}

Property Values

Microsoft.DBforMariaDB/servers/databases

Name Description Value
name The resource name string (required)
parent_id The ID of the resource that is the parent for this resource. ID for resource of type: servers
properties The properties of a database. DatabaseProperties
type The resource type "Microsoft.DBforMariaDB/servers/databases@2018-06-01"

DatabaseProperties

Name Description Value
charset The charset of the database. string
collation The collation of the database. string

Usage Examples

Terraform Samples

A basic example of deploying Database for MariaDB Servers Databases.

terraform {
  required_providers {
    azapi = {
      source = "Azure/azapi"
    }
  }
}

provider "azapi" {
  skip_provider_registration = false
}

variable "resource_name" {
  type    = string
  default = "acctest0001"
}

variable "location" {
  type    = string
  default = "westeurope"
}

variable "administrator_login" {
  type        = string
  description = "The administrator login for the MariaDB server"
}

variable "administrator_login_password" {
  type        = string
  description = "The administrator login password for the MariaDB server"
  sensitive   = true
}

resource "azapi_resource" "resourceGroup" {
  type     = "Microsoft.Resources/resourceGroups@2020-06-01"
  name     = var.resource_name
  location = var.location
}

resource "azapi_resource" "server" {
  type      = "Microsoft.DBforMariaDB/servers@2018-06-01"
  parent_id = azapi_resource.resourceGroup.id
  name      = var.resource_name
  location  = var.location
  body = {
    properties = {
      administratorLogin         = var.administrator_login
      administratorLoginPassword = var.administrator_login_password
      createMode                 = "Default"
      minimalTlsVersion          = "TLS1_2"
      publicNetworkAccess        = "Enabled"
      sslEnforcement             = "Enabled"
      storageProfile = {
        backupRetentionDays = 7
        storageAutogrow     = "Enabled"
        storageMB           = 51200
      }
      version = "10.2"
    }
    sku = {
      capacity = 2
      family   = "Gen5"
      name     = "B_Gen5_2"
      tier     = "Basic"
    }
  }
  schema_validation_enabled = false
  response_export_values    = ["*"]
}

resource "azapi_resource" "database" {
  type      = "Microsoft.DBforMariaDB/servers/databases@2018-06-01"
  parent_id = azapi_resource.server.id
  name      = var.resource_name
  body = {
    properties = {
      charset   = "utf8"
      collation = "utf8_general_ci"
    }
  }
  schema_validation_enabled = false
  response_export_values    = ["*"]
}
  • Last updated on