Flexible Database
Manages a MySQL Database within a MySQL Flexible Server
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const example = new azure.core.ResourceGroup("example", {
name: "example-resources",
location: "West Europe",
});
const exampleFlexibleServer = new azure.mysql.FlexibleServer("example", {
name: "example-mysql-flexible-server",
resourceGroupName: example.name,
location: example.location,
administratorLogin: "mysqladminun",
administratorPassword: "H@Sh1CoR3!",
skuName: "B_Standard_B1ms",
});
const exampleFlexibleDatabase = new azure.mysql.FlexibleDatabase("example", {
name: "exampledb",
resourceGroupName: example.name,
serverName: exampleFlexibleServer.name,
charset: "utf8",
collation: "utf8_unicode_ci",
});
Content copied to clipboard
import pulumi
import pulumi_azure as azure
example = azure.core.ResourceGroup("example",
name="example-resources",
location="West Europe")
example_flexible_server = azure.mysql.FlexibleServer("example",
name="example-mysql-flexible-server",
resource_group_name=example.name,
location=example.location,
administrator_login="mysqladminun",
administrator_password="H@Sh1CoR3!",
sku_name="B_Standard_B1ms")
example_flexible_database = azure.mysql.FlexibleDatabase("example",
name="exampledb",
resource_group_name=example.name,
server_name=example_flexible_server.name,
charset="utf8",
collation="utf8_unicode_ci")
Content copied to clipboard
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
var example = new Azure.Core.ResourceGroup("example", new()
{
Name = "example-resources",
Location = "West Europe",
});
var exampleFlexibleServer = new Azure.MySql.FlexibleServer("example", new()
{
Name = "example-mysql-flexible-server",
ResourceGroupName = example.Name,
Location = example.Location,
AdministratorLogin = "mysqladminun",
AdministratorPassword = "H@Sh1CoR3!",
SkuName = "B_Standard_B1ms",
});
var exampleFlexibleDatabase = new Azure.MySql.FlexibleDatabase("example", new()
{
Name = "exampledb",
ResourceGroupName = example.Name,
ServerName = exampleFlexibleServer.Name,
Charset = "utf8",
Collation = "utf8_unicode_ci",
});
});
Content copied to clipboard
package main
import (
"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/core"
"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/mysql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
example, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
Name: pulumi.String("example-resources"),
Location: pulumi.String("West Europe"),
})
if err != nil {
return err
}
exampleFlexibleServer, err := mysql.NewFlexibleServer(ctx, "example", &mysql.FlexibleServerArgs{
Name: pulumi.String("example-mysql-flexible-server"),
ResourceGroupName: example.Name,
Location: example.Location,
AdministratorLogin: pulumi.String("mysqladminun"),
AdministratorPassword: pulumi.String("H@Sh1CoR3!"),
SkuName: pulumi.String("B_Standard_B1ms"),
})
if err != nil {
return err
}
_, err = mysql.NewFlexibleDatabase(ctx, "example", &mysql.FlexibleDatabaseArgs{
Name: pulumi.String("exampledb"),
ResourceGroupName: example.Name,
ServerName: exampleFlexibleServer.Name,
Charset: pulumi.String("utf8"),
Collation: pulumi.String("utf8_unicode_ci"),
})
if err != nil {
return err
}
return nil
})
}
Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.mysql.FlexibleServer;
import com.pulumi.azure.mysql.FlexibleServerArgs;
import com.pulumi.azure.mysql.FlexibleDatabase;
import com.pulumi.azure.mysql.FlexibleDatabaseArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var example = new ResourceGroup("example", ResourceGroupArgs.builder()
.name("example-resources")
.location("West Europe")
.build());
var exampleFlexibleServer = new FlexibleServer("exampleFlexibleServer", FlexibleServerArgs.builder()
.name("example-mysql-flexible-server")
.resourceGroupName(example.name())
.location(example.location())
.administratorLogin("mysqladminun")
.administratorPassword("H@Sh1CoR3!")
.skuName("B_Standard_B1ms")
.build());
var exampleFlexibleDatabase = new FlexibleDatabase("exampleFlexibleDatabase", FlexibleDatabaseArgs.builder()
.name("exampledb")
.resourceGroupName(example.name())
.serverName(exampleFlexibleServer.name())
.charset("utf8")
.collation("utf8_unicode_ci")
.build());
}
}
Content copied to clipboard
resources:
example:
type: azure:core:ResourceGroup
properties:
name: example-resources
location: West Europe
exampleFlexibleServer:
type: azure:mysql:FlexibleServer
name: example
properties:
name: example-mysql-flexible-server
resourceGroupName: ${example.name}
location: ${example.location}
administratorLogin: mysqladminun
administratorPassword: H@Sh1CoR3!
skuName: B_Standard_B1ms
exampleFlexibleDatabase:
type: azure:mysql:FlexibleDatabase
name: example
properties:
name: exampledb
resourceGroupName: ${example.name}
serverName: ${exampleFlexibleServer.name}
charset: utf8
collation: utf8_unicode_ci
Content copied to clipboard
Import
MySQL Database's can be imported using the resource id
, e.g.
$ pulumi import azure:mysql/flexibleDatabase:FlexibleDatabase database1 /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/mygroup1/providers/Microsoft.DBforMySQL/flexibleServers/flexibleserver1/databases/database1
Content copied to clipboard
Properties
Link copied to clipboard
Specifies the Charset for the MySQL Database, which needs to be a valid MySQL Charset. Changing this forces a new resource to be created.
Link copied to clipboard
Specifies the Collation for the MySQL Database, which needs to be a valid MySQL Collation. Changing this forces a new resource to be created.
Link copied to clipboard
Specifies the name of the MySQL Database, which needs to be a valid MySQL identifier. Changing this forces a new resource to be created.
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
The name of the resource group in which the MySQL Server exists. Changing this forces a new resource to be created.
Link copied to clipboard
Specifies the name of the MySQL Flexible Server. Changing this forces a new resource to be created.