Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. UpCloud
  3. API Docs
  4. ManagedDatabaseMysql
UpCloud v0.1.0 published on Friday, Mar 14, 2025 by UpCloudLtd
UpCloudLtd/pulumi-upcloud

upcloud.ManagedDatabaseMysql

Explore with Pulumi AI

upcloud logo
UpCloud v0.1.0 published on Friday, Mar 14, 2025 by UpCloudLtd
UpCloudLtd/pulumi-upcloud

    This resource represents MySQL managed database. See UpCloud Managed Databases product page for more details about the service.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as upcloud from "@upcloud/pulumi-upcloud";

// Minimal config
const example1 = new upcloud.ManagedDatabaseMysql("example_1", {
    name: "mysql-1",
    title: "mysql-1-example-1",
    plan: "1x1xCPU-2GB-25GB",
    zone: "fi-hel1",
});
// Shutdown instance after creation
const example2 = new upcloud.ManagedDatabaseMysql("example_2", {
    name: "mysql-2",
    title: "mysql-2-example-2",
    plan: "1x1xCPU-2GB-25GB",
    zone: "fi-hel1",
    powered: false,
});
// Service with custom properties
// Note that this basically sets strict mode off which is not normally recommended
const example3 = new upcloud.ManagedDatabaseMysql("example_3", {
    name: "mysql-3",
    title: "mysql-3-example-3",
    plan: "1x1xCPU-2GB-25GB",
    zone: "fi-hel1",
    properties: {
        sqlMode: "NO_ENGINE_SUBSTITUTION",
        waitTimeout: 300,
        sortBufferSize: 4000000,
        maxAllowedPacket: 16000000,
        adminUsername: "admin",
        adminPassword: "<ADMIN_PASSWORD>",
    },
});

    import pulumi
import pulumi_upcloud as upcloud

# Minimal config
example1 = upcloud.ManagedDatabaseMysql("example_1",
    name="mysql-1",
    title="mysql-1-example-1",
    plan="1x1xCPU-2GB-25GB",
    zone="fi-hel1")
# Shutdown instance after creation
example2 = upcloud.ManagedDatabaseMysql("example_2",
    name="mysql-2",
    title="mysql-2-example-2",
    plan="1x1xCPU-2GB-25GB",
    zone="fi-hel1",
    powered=False)
# Service with custom properties
# Note that this basically sets strict mode off which is not normally recommended
example3 = upcloud.ManagedDatabaseMysql("example_3",
    name="mysql-3",
    title="mysql-3-example-3",
    plan="1x1xCPU-2GB-25GB",
    zone="fi-hel1",
    properties={
        "sql_mode": "NO_ENGINE_SUBSTITUTION",
        "wait_timeout": 300,
        "sort_buffer_size": 4000000,
        "max_allowed_packet": 16000000,
        "admin_username": "admin",
        "admin_password": "<ADMIN_PASSWORD>",
    })

    package main

import (
	"github.com/UpCloudLtd/pulumi-upcloud/sdk/go/upcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		// Minimal config
		_, err := upcloud.NewManagedDatabaseMysql(ctx, "example_1", &upcloud.ManagedDatabaseMysqlArgs{
			Name:  pulumi.String("mysql-1"),
			Title: pulumi.String("mysql-1-example-1"),
			Plan:  pulumi.String("1x1xCPU-2GB-25GB"),
			Zone:  pulumi.String("fi-hel1"),
		})
		if err != nil {
			return err
		}
		// Shutdown instance after creation
		_, err = upcloud.NewManagedDatabaseMysql(ctx, "example_2", &upcloud.ManagedDatabaseMysqlArgs{
			Name:    pulumi.String("mysql-2"),
			Title:   pulumi.String("mysql-2-example-2"),
			Plan:    pulumi.String("1x1xCPU-2GB-25GB"),
			Zone:    pulumi.String("fi-hel1"),
			Powered: pulumi.Bool(false),
		})
		if err != nil {
			return err
		}
		// Service with custom properties
		// Note that this basically sets strict mode off which is not normally recommended
		_, err = upcloud.NewManagedDatabaseMysql(ctx, "example_3", &upcloud.ManagedDatabaseMysqlArgs{
			Name:  pulumi.String("mysql-3"),
			Title: pulumi.String("mysql-3-example-3"),
			Plan:  pulumi.String("1x1xCPU-2GB-25GB"),
			Zone:  pulumi.String("fi-hel1"),
			Properties: &upcloud.ManagedDatabaseMysqlPropertiesArgs{
				SqlMode:          pulumi.String("NO_ENGINE_SUBSTITUTION"),
				WaitTimeout:      pulumi.Int(300),
				SortBufferSize:   pulumi.Int(4000000),
				MaxAllowedPacket: pulumi.Int(16000000),
				AdminUsername:    pulumi.String("admin"),
				AdminPassword:    pulumi.String("<ADMIN_PASSWORD>"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using UpCloud = UpCloud.Pulumi.UpCloud;

return await Deployment.RunAsync(() => 
{
    // Minimal config
    var example1 = new UpCloud.ManagedDatabaseMysql("example_1", new()
    {
        Name = "mysql-1",
        Title = "mysql-1-example-1",
        Plan = "1x1xCPU-2GB-25GB",
        Zone = "fi-hel1",
    });

    // Shutdown instance after creation
    var example2 = new UpCloud.ManagedDatabaseMysql("example_2", new()
    {
        Name = "mysql-2",
        Title = "mysql-2-example-2",
        Plan = "1x1xCPU-2GB-25GB",
        Zone = "fi-hel1",
        Powered = false,
    });

    // Service with custom properties
    // Note that this basically sets strict mode off which is not normally recommended
    var example3 = new UpCloud.ManagedDatabaseMysql("example_3", new()
    {
        Name = "mysql-3",
        Title = "mysql-3-example-3",
        Plan = "1x1xCPU-2GB-25GB",
        Zone = "fi-hel1",
        Properties = new UpCloud.Inputs.ManagedDatabaseMysqlPropertiesArgs
        {
            SqlMode = "NO_ENGINE_SUBSTITUTION",
            WaitTimeout = 300,
            SortBufferSize = 4000000,
            MaxAllowedPacket = 16000000,
            AdminUsername = "admin",
            AdminPassword = "<ADMIN_PASSWORD>",
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.upcloud.ManagedDatabaseMysql;
import com.pulumi.upcloud.ManagedDatabaseMysqlArgs;
import com.pulumi.upcloud.inputs.ManagedDatabaseMysqlPropertiesArgs;
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) {
        // Minimal config
        var example1 = new ManagedDatabaseMysql("example1", ManagedDatabaseMysqlArgs.builder()
            .name("mysql-1")
            .title("mysql-1-example-1")
            .plan("1x1xCPU-2GB-25GB")
            .zone("fi-hel1")
            .build());

        // Shutdown instance after creation
        var example2 = new ManagedDatabaseMysql("example2", ManagedDatabaseMysqlArgs.builder()
            .name("mysql-2")
            .title("mysql-2-example-2")
            .plan("1x1xCPU-2GB-25GB")
            .zone("fi-hel1")
            .powered(false)
            .build());

        // Service with custom properties
        // Note that this basically sets strict mode off which is not normally recommended
        var example3 = new ManagedDatabaseMysql("example3", ManagedDatabaseMysqlArgs.builder()
            .name("mysql-3")
            .title("mysql-3-example-3")
            .plan("1x1xCPU-2GB-25GB")
            .zone("fi-hel1")
            .properties(ManagedDatabaseMysqlPropertiesArgs.builder()
                .sqlMode("NO_ENGINE_SUBSTITUTION")
                .waitTimeout(300)
                .sortBufferSize(4000000)
                .maxAllowedPacket(16000000)
                .adminUsername("admin")
                .adminPassword("<ADMIN_PASSWORD>")
                .build())
            .build());

    }
}

    resources:
  # Minimal config
  example1:
    type: upcloud:ManagedDatabaseMysql
    name: example_1
    properties:
      name: mysql-1
      title: mysql-1-example-1
      plan: 1x1xCPU-2GB-25GB
      zone: fi-hel1
  # Shutdown instance after creation
  example2:
    type: upcloud:ManagedDatabaseMysql
    name: example_2
    properties:
      name: mysql-2
      title: mysql-2-example-2
      plan: 1x1xCPU-2GB-25GB
      zone: fi-hel1
      powered: false
  # Service with custom properties
  # Note that this basically sets strict mode off which is not normally recommended
  example3:
    type: upcloud:ManagedDatabaseMysql
    name: example_3
    properties:
      name: mysql-3
      title: mysql-3-example-3
      plan: 1x1xCPU-2GB-25GB
      zone: fi-hel1
      properties:
        sqlMode: NO_ENGINE_SUBSTITUTION
        waitTimeout: 300
        sortBufferSize: 4e+06
        maxAllowedPacket: 1.6e+07
        adminUsername: admin
        adminPassword: <ADMIN_PASSWORD>

    Create ManagedDatabaseMysql Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new ManagedDatabaseMysql(name: string, args: ManagedDatabaseMysqlArgs, opts?: CustomResourceOptions);
    @overload
def ManagedDatabaseMysql(resource_name: str,
                         args: ManagedDatabaseMysqlArgs,
                         opts: Optional[ResourceOptions] = None)

@overload
def ManagedDatabaseMysql(resource_name: str,
                         opts: Optional[ResourceOptions] = None,
                         plan: Optional[str] = None,
                         title: Optional[str] = None,
                         zone: Optional[str] = None,
                         labels: Optional[Mapping[str, str]] = None,
                         maintenance_window_dow: Optional[str] = None,
                         maintenance_window_time: Optional[str] = None,
                         name: Optional[str] = None,
                         networks: Optional[Sequence[ManagedDatabaseMysqlNetworkArgs]] = None,
                         powered: Optional[bool] = None,
                         properties: Optional[ManagedDatabaseMysqlPropertiesArgs] = None,
                         termination_protection: Optional[bool] = None)
    func NewManagedDatabaseMysql(ctx *Context, name string, args ManagedDatabaseMysqlArgs, opts ...ResourceOption) (*ManagedDatabaseMysql, error)
    public ManagedDatabaseMysql(string name, ManagedDatabaseMysqlArgs args, CustomResourceOptions? opts = null)
    public ManagedDatabaseMysql(String name, ManagedDatabaseMysqlArgs args)
public ManagedDatabaseMysql(String name, ManagedDatabaseMysqlArgs args, CustomResourceOptions options)

    type: upcloud:ManagedDatabaseMysql
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args ManagedDatabaseMysqlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args ManagedDatabaseMysqlArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args ManagedDatabaseMysqlArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ManagedDatabaseMysqlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ManagedDatabaseMysqlArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var managedDatabaseMysqlResource = new UpCloud.ManagedDatabaseMysql("managedDatabaseMysqlResource", new()
{
    Plan = "string",
    Title = "string",
    Zone = "string",
    Labels = 
    {
        { "string", "string" },
    },
    MaintenanceWindowDow = "string",
    MaintenanceWindowTime = "string",
    Name = "string",
    Networks = new[]
    {
        new UpCloud.Inputs.ManagedDatabaseMysqlNetworkArgs
        {
            Family = "string",
            Name = "string",
            Type = "string",
            Uuid = "string",
        },
    },
    Powered = false,
    Properties = new UpCloud.Inputs.ManagedDatabaseMysqlPropertiesArgs
    {
        AdminPassword = "string",
        AdminUsername = "string",
        AutomaticUtilityNetworkIpFilter = false,
        BackupHour = 0,
        BackupMinute = 0,
        BinlogRetentionPeriod = 0,
        ConnectTimeout = 0,
        DefaultTimeZone = "string",
        GroupConcatMaxLen = 0,
        InformationSchemaStatsExpiry = 0,
        InnodbChangeBufferMaxSize = 0,
        InnodbFlushNeighbors = 0,
        InnodbFtMinTokenSize = 0,
        InnodbFtServerStopwordTable = "string",
        InnodbLockWaitTimeout = 0,
        InnodbLogBufferSize = 0,
        InnodbOnlineAlterLogMaxSize = 0,
        InnodbPrintAllDeadlocks = false,
        InnodbReadIoThreads = 0,
        InnodbRollbackOnTimeout = false,
        InnodbThreadConcurrency = 0,
        InnodbWriteIoThreads = 0,
        InteractiveTimeout = 0,
        InternalTmpMemStorageEngine = "string",
        IpFilters = new[]
        {
            "string",
        },
        LogOutput = "string",
        LongQueryTime = 0,
        MaxAllowedPacket = 0,
        MaxHeapTableSize = 0,
        Migration = new UpCloud.Inputs.ManagedDatabaseMysqlPropertiesMigrationArgs
        {
            Dbname = "string",
            Host = "string",
            IgnoreDbs = "string",
            IgnoreRoles = "string",
            Method = "string",
            Password = "string",
            Port = 0,
            Ssl = false,
            Username = "string",
        },
        NetBufferLength = 0,
        NetReadTimeout = 0,
        NetWriteTimeout = 0,
        PublicAccess = false,
        ServiceLog = false,
        SlowQueryLog = false,
        SortBufferSize = 0,
        SqlMode = "string",
        SqlRequirePrimaryKey = false,
        TmpTableSize = 0,
        Version = "string",
        WaitTimeout = 0,
    },
    TerminationProtection = false,
});

    example, err := upcloud.NewManagedDatabaseMysql(ctx, "managedDatabaseMysqlResource", &upcloud.ManagedDatabaseMysqlArgs{
	Plan:  pulumi.String("string"),
	Title: pulumi.String("string"),
	Zone:  pulumi.String("string"),
	Labels: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	MaintenanceWindowDow:  pulumi.String("string"),
	MaintenanceWindowTime: pulumi.String("string"),
	Name:                  pulumi.String("string"),
	Networks: upcloud.ManagedDatabaseMysqlNetworkArray{
		&upcloud.ManagedDatabaseMysqlNetworkArgs{
			Family: pulumi.String("string"),
			Name:   pulumi.String("string"),
			Type:   pulumi.String("string"),
			Uuid:   pulumi.String("string"),
		},
	},
	Powered: pulumi.Bool(false),
	Properties: &upcloud.ManagedDatabaseMysqlPropertiesArgs{
		AdminPassword:                   pulumi.String("string"),
		AdminUsername:                   pulumi.String("string"),
		AutomaticUtilityNetworkIpFilter: pulumi.Bool(false),
		BackupHour:                      pulumi.Int(0),
		BackupMinute:                    pulumi.Int(0),
		BinlogRetentionPeriod:           pulumi.Int(0),
		ConnectTimeout:                  pulumi.Int(0),
		DefaultTimeZone:                 pulumi.String("string"),
		GroupConcatMaxLen:               pulumi.Int(0),
		InformationSchemaStatsExpiry:    pulumi.Int(0),
		InnodbChangeBufferMaxSize:       pulumi.Int(0),
		InnodbFlushNeighbors:            pulumi.Int(0),
		InnodbFtMinTokenSize:            pulumi.Int(0),
		InnodbFtServerStopwordTable:     pulumi.String("string"),
		InnodbLockWaitTimeout:           pulumi.Int(0),
		InnodbLogBufferSize:             pulumi.Int(0),
		InnodbOnlineAlterLogMaxSize:     pulumi.Int(0),
		InnodbPrintAllDeadlocks:         pulumi.Bool(false),
		InnodbReadIoThreads:             pulumi.Int(0),
		InnodbRollbackOnTimeout:         pulumi.Bool(false),
		InnodbThreadConcurrency:         pulumi.Int(0),
		InnodbWriteIoThreads:            pulumi.Int(0),
		InteractiveTimeout:              pulumi.Int(0),
		InternalTmpMemStorageEngine:     pulumi.String("string"),
		IpFilters: pulumi.StringArray{
			pulumi.String("string"),
		},
		LogOutput:        pulumi.String("string"),
		LongQueryTime:    pulumi.Float64(0),
		MaxAllowedPacket: pulumi.Int(0),
		MaxHeapTableSize: pulumi.Int(0),
		Migration: &upcloud.ManagedDatabaseMysqlPropertiesMigrationArgs{
			Dbname:      pulumi.String("string"),
			Host:        pulumi.String("string"),
			IgnoreDbs:   pulumi.String("string"),
			IgnoreRoles: pulumi.String("string"),
			Method:      pulumi.String("string"),
			Password:    pulumi.String("string"),
			Port:        pulumi.Int(0),
			Ssl:         pulumi.Bool(false),
			Username:    pulumi.String("string"),
		},
		NetBufferLength:      pulumi.Int(0),
		NetReadTimeout:       pulumi.Int(0),
		NetWriteTimeout:      pulumi.Int(0),
		PublicAccess:         pulumi.Bool(false),
		ServiceLog:           pulumi.Bool(false),
		SlowQueryLog:         pulumi.Bool(false),
		SortBufferSize:       pulumi.Int(0),
		SqlMode:              pulumi.String("string"),
		SqlRequirePrimaryKey: pulumi.Bool(false),
		TmpTableSize:         pulumi.Int(0),
		Version:              pulumi.String("string"),
		WaitTimeout:          pulumi.Int(0),
	},
	TerminationProtection: pulumi.Bool(false),
})

    var managedDatabaseMysqlResource = new ManagedDatabaseMysql("managedDatabaseMysqlResource", ManagedDatabaseMysqlArgs.builder()
    .plan("string")
    .title("string")
    .zone("string")
    .labels(Map.of("string", "string"))
    .maintenanceWindowDow("string")
    .maintenanceWindowTime("string")
    .name("string")
    .networks(ManagedDatabaseMysqlNetworkArgs.builder()
        .family("string")
        .name("string")
        .type("string")
        .uuid("string")
        .build())
    .powered(false)
    .properties(ManagedDatabaseMysqlPropertiesArgs.builder()
        .adminPassword("string")
        .adminUsername("string")
        .automaticUtilityNetworkIpFilter(false)
        .backupHour(0)
        .backupMinute(0)
        .binlogRetentionPeriod(0)
        .connectTimeout(0)
        .defaultTimeZone("string")
        .groupConcatMaxLen(0)
        .informationSchemaStatsExpiry(0)
        .innodbChangeBufferMaxSize(0)
        .innodbFlushNeighbors(0)
        .innodbFtMinTokenSize(0)
        .innodbFtServerStopwordTable("string")
        .innodbLockWaitTimeout(0)
        .innodbLogBufferSize(0)
        .innodbOnlineAlterLogMaxSize(0)
        .innodbPrintAllDeadlocks(false)
        .innodbReadIoThreads(0)
        .innodbRollbackOnTimeout(false)
        .innodbThreadConcurrency(0)
        .innodbWriteIoThreads(0)
        .interactiveTimeout(0)
        .internalTmpMemStorageEngine("string")
        .ipFilters("string")
        .logOutput("string")
        .longQueryTime(0)
        .maxAllowedPacket(0)
        .maxHeapTableSize(0)
        .migration(ManagedDatabaseMysqlPropertiesMigrationArgs.builder()
            .dbname("string")
            .host("string")
            .ignoreDbs("string")
            .ignoreRoles("string")
            .method("string")
            .password("string")
            .port(0)
            .ssl(false)
            .username("string")
            .build())
        .netBufferLength(0)
        .netReadTimeout(0)
        .netWriteTimeout(0)
        .publicAccess(false)
        .serviceLog(false)
        .slowQueryLog(false)
        .sortBufferSize(0)
        .sqlMode("string")
        .sqlRequirePrimaryKey(false)
        .tmpTableSize(0)
        .version("string")
        .waitTimeout(0)
        .build())
    .terminationProtection(false)
    .build());

    managed_database_mysql_resource = upcloud.ManagedDatabaseMysql("managedDatabaseMysqlResource",
    plan="string",
    title="string",
    zone="string",
    labels={
        "string": "string",
    },
    maintenance_window_dow="string",
    maintenance_window_time="string",
    name="string",
    networks=[{
        "family": "string",
        "name": "string",
        "type": "string",
        "uuid": "string",
    }],
    powered=False,
    properties={
        "admin_password": "string",
        "admin_username": "string",
        "automatic_utility_network_ip_filter": False,
        "backup_hour": 0,
        "backup_minute": 0,
        "binlog_retention_period": 0,
        "connect_timeout": 0,
        "default_time_zone": "string",
        "group_concat_max_len": 0,
        "information_schema_stats_expiry": 0,
        "innodb_change_buffer_max_size": 0,
        "innodb_flush_neighbors": 0,
        "innodb_ft_min_token_size": 0,
        "innodb_ft_server_stopword_table": "string",
        "innodb_lock_wait_timeout": 0,
        "innodb_log_buffer_size": 0,
        "innodb_online_alter_log_max_size": 0,
        "innodb_print_all_deadlocks": False,
        "innodb_read_io_threads": 0,
        "innodb_rollback_on_timeout": False,
        "innodb_thread_concurrency": 0,
        "innodb_write_io_threads": 0,
        "interactive_timeout": 0,
        "internal_tmp_mem_storage_engine": "string",
        "ip_filters": ["string"],
        "log_output": "string",
        "long_query_time": 0,
        "max_allowed_packet": 0,
        "max_heap_table_size": 0,
        "migration": {
            "dbname": "string",
            "host": "string",
            "ignore_dbs": "string",
            "ignore_roles": "string",
            "method": "string",
            "password": "string",
            "port": 0,
            "ssl": False,
            "username": "string",
        },
        "net_buffer_length": 0,
        "net_read_timeout": 0,
        "net_write_timeout": 0,
        "public_access": False,
        "service_log": False,
        "slow_query_log": False,
        "sort_buffer_size": 0,
        "sql_mode": "string",
        "sql_require_primary_key": False,
        "tmp_table_size": 0,
        "version": "string",
        "wait_timeout": 0,
    },
    termination_protection=False)

    const managedDatabaseMysqlResource = new upcloud.ManagedDatabaseMysql("managedDatabaseMysqlResource", {
    plan: "string",
    title: "string",
    zone: "string",
    labels: {
        string: "string",
    },
    maintenanceWindowDow: "string",
    maintenanceWindowTime: "string",
    name: "string",
    networks: [{
        family: "string",
        name: "string",
        type: "string",
        uuid: "string",
    }],
    powered: false,
    properties: {
        adminPassword: "string",
        adminUsername: "string",
        automaticUtilityNetworkIpFilter: false,
        backupHour: 0,
        backupMinute: 0,
        binlogRetentionPeriod: 0,
        connectTimeout: 0,
        defaultTimeZone: "string",
        groupConcatMaxLen: 0,
        informationSchemaStatsExpiry: 0,
        innodbChangeBufferMaxSize: 0,
        innodbFlushNeighbors: 0,
        innodbFtMinTokenSize: 0,
        innodbFtServerStopwordTable: "string",
        innodbLockWaitTimeout: 0,
        innodbLogBufferSize: 0,
        innodbOnlineAlterLogMaxSize: 0,
        innodbPrintAllDeadlocks: false,
        innodbReadIoThreads: 0,
        innodbRollbackOnTimeout: false,
        innodbThreadConcurrency: 0,
        innodbWriteIoThreads: 0,
        interactiveTimeout: 0,
        internalTmpMemStorageEngine: "string",
        ipFilters: ["string"],
        logOutput: "string",
        longQueryTime: 0,
        maxAllowedPacket: 0,
        maxHeapTableSize: 0,
        migration: {
            dbname: "string",
            host: "string",
            ignoreDbs: "string",
            ignoreRoles: "string",
            method: "string",
            password: "string",
            port: 0,
            ssl: false,
            username: "string",
        },
        netBufferLength: 0,
        netReadTimeout: 0,
        netWriteTimeout: 0,
        publicAccess: false,
        serviceLog: false,
        slowQueryLog: false,
        sortBufferSize: 0,
        sqlMode: "string",
        sqlRequirePrimaryKey: false,
        tmpTableSize: 0,
        version: "string",
        waitTimeout: 0,
    },
    terminationProtection: false,
});

    type: upcloud:ManagedDatabaseMysql
properties:
    labels:
        string: string
    maintenanceWindowDow: string
    maintenanceWindowTime: string
    name: string
    networks:
        - family: string
          name: string
          type: string
          uuid: string
    plan: string
    powered: false
    properties:
        adminPassword: string
        adminUsername: string
        automaticUtilityNetworkIpFilter: false
        backupHour: 0
        backupMinute: 0
        binlogRetentionPeriod: 0
        connectTimeout: 0
        defaultTimeZone: string
        groupConcatMaxLen: 0
        informationSchemaStatsExpiry: 0
        innodbChangeBufferMaxSize: 0
        innodbFlushNeighbors: 0
        innodbFtMinTokenSize: 0
        innodbFtServerStopwordTable: string
        innodbLockWaitTimeout: 0
        innodbLogBufferSize: 0
        innodbOnlineAlterLogMaxSize: 0
        innodbPrintAllDeadlocks: false
        innodbReadIoThreads: 0
        innodbRollbackOnTimeout: false
        innodbThreadConcurrency: 0
        innodbWriteIoThreads: 0
        interactiveTimeout: 0
        internalTmpMemStorageEngine: string
        ipFilters:
            - string
        logOutput: string
        longQueryTime: 0
        maxAllowedPacket: 0
        maxHeapTableSize: 0
        migration:
            dbname: string
            host: string
            ignoreDbs: string
            ignoreRoles: string
            method: string
            password: string
            port: 0
            ssl: false
            username: string
        netBufferLength: 0
        netReadTimeout: 0
        netWriteTimeout: 0
        publicAccess: false
        serviceLog: false
        slowQueryLog: false
        sortBufferSize: 0
        sqlMode: string
        sqlRequirePrimaryKey: false
        tmpTableSize: 0
        version: string
        waitTimeout: 0
    terminationProtection: false
    title: string
    zone: string

    ManagedDatabaseMysql Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The ManagedDatabaseMysql resource accepts the following input properties:

    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Title string
    Title of a managed database instance
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Labels Dictionary<string, string>
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabaseMysqlNetwork>
    Private networks attached to the managed database
    Powered bool
    The administrative power state of the service
    Properties UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabaseMysqlProperties
    Database Engine properties for MySQL
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Title string
    Title of a managed database instance
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Labels map[string]string
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks []ManagedDatabaseMysqlNetworkArgs
    Private networks attached to the managed database
    Powered bool
    The administrative power state of the service
    Properties ManagedDatabaseMysqlPropertiesArgs
    Database Engine properties for MySQL
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title String
    Title of a managed database instance
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Map<String,String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<ManagedDatabaseMysqlNetwork>
    Private networks attached to the managed database
    powered Boolean
    The administrative power state of the service
    properties ManagedDatabaseMysqlProperties
    Database Engine properties for MySQL
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title string
    Title of a managed database instance
    zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels {[key: string]: string}
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks ManagedDatabaseMysqlNetwork[]
    Private networks attached to the managed database
    powered boolean
    The administrative power state of the service
    properties ManagedDatabaseMysqlProperties
    Database Engine properties for MySQL
    terminationProtection boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    plan str
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title str
    Title of a managed database instance
    zone str
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Mapping[str, str]
    User defined key-value pairs to classify the managed database.
    maintenance_window_dow str
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenance_window_time str
    Maintenance window UTC time in hh:mm:ss format
    name str
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks Sequence[ManagedDatabaseMysqlNetworkArgs]
    Private networks attached to the managed database
    powered bool
    The administrative power state of the service
    properties ManagedDatabaseMysqlPropertiesArgs
    Database Engine properties for MySQL
    termination_protection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title String
    Title of a managed database instance
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Map<String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<Property Map>
    Private networks attached to the managed database
    powered Boolean
    The administrative power state of the service
    properties Property Map
    Database Engine properties for MySQL
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the ManagedDatabaseMysql resource produces the following output properties:

    Components List<UpCloud.Pulumi.UpCloud.Outputs.ManagedDatabaseMysqlComponent>
    Service component information
    Id string
    The provider-assigned unique ID for this managed resource.
    NodeStates List<UpCloud.Pulumi.UpCloud.Outputs.ManagedDatabaseMysqlNodeState>
    Information about nodes providing the managed service
    PrimaryDatabase string
    Primary database name
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    State string
    State of the service
    Type string
    Type of the service
    Components []ManagedDatabaseMysqlComponent
    Service component information
    Id string
    The provider-assigned unique ID for this managed resource.
    NodeStates []ManagedDatabaseMysqlNodeState
    Information about nodes providing the managed service
    PrimaryDatabase string
    Primary database name
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    State string
    State of the service
    Type string
    Type of the service
    components List<ManagedDatabaseMysqlComponent>
    Service component information
    id String
    The provider-assigned unique ID for this managed resource.
    nodeStates List<ManagedDatabaseMysqlNodeState>
    Information about nodes providing the managed service
    primaryDatabase String
    Primary database name
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    state String
    State of the service
    type String
    Type of the service
    components ManagedDatabaseMysqlComponent[]
    Service component information
    id string
    The provider-assigned unique ID for this managed resource.
    nodeStates ManagedDatabaseMysqlNodeState[]
    Information about nodes providing the managed service
    primaryDatabase string
    Primary database name
    serviceHost string
    Hostname to the service instance
    servicePassword string
    Primary username's password to the service instance
    servicePort string
    Port to the service instance
    serviceUri string
    URI to the service instance
    serviceUsername string
    Primary username to the service instance
    state string
    State of the service
    type string
    Type of the service
    components Sequence[ManagedDatabaseMysqlComponent]
    Service component information
    id str
    The provider-assigned unique ID for this managed resource.
    node_states Sequence[ManagedDatabaseMysqlNodeState]
    Information about nodes providing the managed service
    primary_database str
    Primary database name
    service_host str
    Hostname to the service instance
    service_password str
    Primary username's password to the service instance
    service_port str
    Port to the service instance
    service_uri str
    URI to the service instance
    service_username str
    Primary username to the service instance
    state str
    State of the service
    type str
    Type of the service
    components List<Property Map>
    Service component information
    id String
    The provider-assigned unique ID for this managed resource.
    nodeStates List<Property Map>
    Information about nodes providing the managed service
    primaryDatabase String
    Primary database name
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    state String
    State of the service
    type String
    Type of the service

    Look up Existing ManagedDatabaseMysql Resource

    Get an existing ManagedDatabaseMysql resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: ManagedDatabaseMysqlState, opts?: CustomResourceOptions): ManagedDatabaseMysql
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        components: Optional[Sequence[ManagedDatabaseMysqlComponentArgs]] = None,
        labels: Optional[Mapping[str, str]] = None,
        maintenance_window_dow: Optional[str] = None,
        maintenance_window_time: Optional[str] = None,
        name: Optional[str] = None,
        networks: Optional[Sequence[ManagedDatabaseMysqlNetworkArgs]] = None,
        node_states: Optional[Sequence[ManagedDatabaseMysqlNodeStateArgs]] = None,
        plan: Optional[str] = None,
        powered: Optional[bool] = None,
        primary_database: Optional[str] = None,
        properties: Optional[ManagedDatabaseMysqlPropertiesArgs] = None,
        service_host: Optional[str] = None,
        service_password: Optional[str] = None,
        service_port: Optional[str] = None,
        service_uri: Optional[str] = None,
        service_username: Optional[str] = None,
        state: Optional[str] = None,
        termination_protection: Optional[bool] = None,
        title: Optional[str] = None,
        type: Optional[str] = None,
        zone: Optional[str] = None) -> ManagedDatabaseMysql
    func GetManagedDatabaseMysql(ctx *Context, name string, id IDInput, state *ManagedDatabaseMysqlState, opts ...ResourceOption) (*ManagedDatabaseMysql, error)
    public static ManagedDatabaseMysql Get(string name, Input<string> id, ManagedDatabaseMysqlState? state, CustomResourceOptions? opts = null)
    public static ManagedDatabaseMysql get(String name, Output<String> id, ManagedDatabaseMysqlState state, CustomResourceOptions options)
    resources:  _:    type: upcloud:ManagedDatabaseMysql    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Components List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabaseMysqlComponent>
    Service component information
    Labels Dictionary<string, string>
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabaseMysqlNetwork>
    Private networks attached to the managed database
    NodeStates List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabaseMysqlNodeState>
    Information about nodes providing the managed service
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Powered bool
    The administrative power state of the service
    PrimaryDatabase string
    Primary database name
    Properties UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabaseMysqlProperties
    Database Engine properties for MySQL
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    State string
    State of the service
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Title string
    Title of a managed database instance
    Type string
    Type of the service
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Components []ManagedDatabaseMysqlComponentArgs
    Service component information
    Labels map[string]string
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks []ManagedDatabaseMysqlNetworkArgs
    Private networks attached to the managed database
    NodeStates []ManagedDatabaseMysqlNodeStateArgs
    Information about nodes providing the managed service
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Powered bool
    The administrative power state of the service
    PrimaryDatabase string
    Primary database name
    Properties ManagedDatabaseMysqlPropertiesArgs
    Database Engine properties for MySQL
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    State string
    State of the service
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Title string
    Title of a managed database instance
    Type string
    Type of the service
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components List<ManagedDatabaseMysqlComponent>
    Service component information
    labels Map<String,String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<ManagedDatabaseMysqlNetwork>
    Private networks attached to the managed database
    nodeStates List<ManagedDatabaseMysqlNodeState>
    Information about nodes providing the managed service
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered Boolean
    The administrative power state of the service
    primaryDatabase String
    Primary database name
    properties ManagedDatabaseMysqlProperties
    Database Engine properties for MySQL
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    state String
    State of the service
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title String
    Title of a managed database instance
    type String
    Type of the service
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components ManagedDatabaseMysqlComponent[]
    Service component information
    labels {[key: string]: string}
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks ManagedDatabaseMysqlNetwork[]
    Private networks attached to the managed database
    nodeStates ManagedDatabaseMysqlNodeState[]
    Information about nodes providing the managed service
    plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered boolean
    The administrative power state of the service
    primaryDatabase string
    Primary database name
    properties ManagedDatabaseMysqlProperties
    Database Engine properties for MySQL
    serviceHost string
    Hostname to the service instance
    servicePassword string
    Primary username's password to the service instance
    servicePort string
    Port to the service instance
    serviceUri string
    URI to the service instance
    serviceUsername string
    Primary username to the service instance
    state string
    State of the service
    terminationProtection boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title string
    Title of a managed database instance
    type string
    Type of the service
    zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components Sequence[ManagedDatabaseMysqlComponentArgs]
    Service component information
    labels Mapping[str, str]
    User defined key-value pairs to classify the managed database.
    maintenance_window_dow str
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenance_window_time str
    Maintenance window UTC time in hh:mm:ss format
    name str
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks Sequence[ManagedDatabaseMysqlNetworkArgs]
    Private networks attached to the managed database
    node_states Sequence[ManagedDatabaseMysqlNodeStateArgs]
    Information about nodes providing the managed service
    plan str
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered bool
    The administrative power state of the service
    primary_database str
    Primary database name
    properties ManagedDatabaseMysqlPropertiesArgs
    Database Engine properties for MySQL
    service_host str
    Hostname to the service instance
    service_password str
    Primary username's password to the service instance
    service_port str
    Port to the service instance
    service_uri str
    URI to the service instance
    service_username str
    Primary username to the service instance
    state str
    State of the service
    termination_protection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    title str
    Title of a managed database instance
    type str
    Type of the service
    zone str
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components List<Property Map>
    Service component information
    labels Map<String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<Property Map>
    Private networks attached to the managed database
    nodeStates List<Property Map>
    Information about nodes providing the managed service
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered Boolean
    The administrative power state of the service
    primaryDatabase String
    Primary database name
    properties Property Map
    Database Engine properties for MySQL
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    state String
    State of the service
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title String
    Title of a managed database instance
    type String
    Type of the service
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.

    Supporting Types

    ManagedDatabaseMysqlComponent, ManagedDatabaseMysqlComponentArgs

    Component string
    Type of the component
    Host string
    Hostname of the component
    Port int
    Port number of the component
    Route string
    Component network route type
    Usage string
    Usage of the component
    Component string
    Type of the component
    Host string
    Hostname of the component
    Port int
    Port number of the component
    Route string
    Component network route type
    Usage string
    Usage of the component
    component String
    Type of the component
    host String
    Hostname of the component
    port Integer
    Port number of the component
    route String
    Component network route type
    usage String
    Usage of the component
    component string
    Type of the component
    host string
    Hostname of the component
    port number
    Port number of the component
    route string
    Component network route type
    usage string
    Usage of the component
    component str
    Type of the component
    host str
    Hostname of the component
    port int
    Port number of the component
    route str
    Component network route type
    usage str
    Usage of the component
    component String
    Type of the component
    host String
    Hostname of the component
    port Number
    Port number of the component
    route String
    Component network route type
    usage String
    Usage of the component

    ManagedDatabaseMysqlNetwork, ManagedDatabaseMysqlNetworkArgs

    Family string
    Network family. Currently only IPv4 is supported.
    Name string
    The name of the network. Must be unique within the service.
    Type string
    The type of the network. Must be private.
    Uuid string
    Private network UUID. Must reside in the same zone as the database.
    Family string
    Network family. Currently only IPv4 is supported.
    Name string
    The name of the network. Must be unique within the service.
    Type string
    The type of the network. Must be private.
    Uuid string
    Private network UUID. Must reside in the same zone as the database.
    family String
    Network family. Currently only IPv4 is supported.
    name String
    The name of the network. Must be unique within the service.
    type String
    The type of the network. Must be private.
    uuid String
    Private network UUID. Must reside in the same zone as the database.
    family string
    Network family. Currently only IPv4 is supported.
    name string
    The name of the network. Must be unique within the service.
    type string
    The type of the network. Must be private.
    uuid string
    Private network UUID. Must reside in the same zone as the database.
    family str
    Network family. Currently only IPv4 is supported.
    name str
    The name of the network. Must be unique within the service.
    type str
    The type of the network. Must be private.
    uuid str
    Private network UUID. Must reside in the same zone as the database.
    family String
    Network family. Currently only IPv4 is supported.
    name String
    The name of the network. Must be unique within the service.
    type String
    The type of the network. Must be private.
    uuid String
    Private network UUID. Must reside in the same zone as the database.

    ManagedDatabaseMysqlNodeState, ManagedDatabaseMysqlNodeStateArgs

    Name string
    Name plus a node iteration
    Role string
    Role of the node
    State string
    State of the node
    Name string
    Name plus a node iteration
    Role string
    Role of the node
    State string
    State of the node
    name String
    Name plus a node iteration
    role String
    Role of the node
    state String
    State of the node
    name string
    Name plus a node iteration
    role string
    Role of the node
    state string
    State of the node
    name str
    Name plus a node iteration
    role str
    Role of the node
    state str
    State of the node
    name String
    Name plus a node iteration
    role String
    Role of the node
    state String
    State of the node

    ManagedDatabaseMysqlProperties, ManagedDatabaseMysqlPropertiesArgs

    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    AutomaticUtilityNetworkIpFilter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    BackupHour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    BackupMinute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    BinlogRetentionPeriod int
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    ConnectTimeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    DefaultTimeZone string
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    GroupConcatMaxLen int
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    InformationSchemaStatsExpiry int
    The time, in seconds, before cached statistics expire.
    InnodbChangeBufferMaxSize int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    InnodbFlushNeighbors int
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    InnodbFtMinTokenSize int
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    InnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    InnodbLockWaitTimeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    InnodbLogBufferSize int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    InnodbOnlineAlterLogMaxSize int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    InnodbPrintAllDeadlocks bool
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    InnodbReadIoThreads int
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    InnodbRollbackOnTimeout bool
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    InnodbThreadConcurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    InnodbWriteIoThreads int
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    InteractiveTimeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    InternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    IpFilters List<string>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    LogOutput string
    The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
    LongQueryTime double
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute.
    MaxAllowedPacket int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    MaxHeapTableSize int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    Migration UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabaseMysqlPropertiesMigration
    Migrate data from existing server.
    NetBufferLength int
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    NetReadTimeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    NetWriteTimeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    PublicAccess bool
    Public Access. Allow access to the service from the public Internet.
    ServiceLog bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    SlowQueryLog bool
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
    SortBufferSize int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    SqlMode string
    Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
    SqlRequirePrimaryKey bool
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    TmpTableSize int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    Version string
    MySQL major version.
    WaitTimeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    AutomaticUtilityNetworkIpFilter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    BackupHour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    BackupMinute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    BinlogRetentionPeriod int
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    ConnectTimeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    DefaultTimeZone string
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    GroupConcatMaxLen int
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    InformationSchemaStatsExpiry int
    The time, in seconds, before cached statistics expire.
    InnodbChangeBufferMaxSize int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    InnodbFlushNeighbors int
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    InnodbFtMinTokenSize int
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    InnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    InnodbLockWaitTimeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    InnodbLogBufferSize int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    InnodbOnlineAlterLogMaxSize int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    InnodbPrintAllDeadlocks bool
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    InnodbReadIoThreads int
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    InnodbRollbackOnTimeout bool
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    InnodbThreadConcurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    InnodbWriteIoThreads int
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    InteractiveTimeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    InternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    IpFilters []string
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    LogOutput string
    The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
    LongQueryTime float64
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute.
    MaxAllowedPacket int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    MaxHeapTableSize int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    Migration ManagedDatabaseMysqlPropertiesMigration
    Migrate data from existing server.
    NetBufferLength int
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    NetReadTimeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    NetWriteTimeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    PublicAccess bool
    Public Access. Allow access to the service from the public Internet.
    ServiceLog bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    SlowQueryLog bool
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
    SortBufferSize int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    SqlMode string
    Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
    SqlRequirePrimaryKey bool
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    TmpTableSize int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    Version string
    MySQL major version.
    WaitTimeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    adminPassword String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername String
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter Boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    backupHour Integer
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute Integer
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    binlogRetentionPeriod Integer
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    connectTimeout Integer
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    defaultTimeZone String
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    groupConcatMaxLen Integer
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    informationSchemaStatsExpiry Integer
    The time, in seconds, before cached statistics expire.
    innodbChangeBufferMaxSize Integer
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    innodbFlushNeighbors Integer
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    innodbFtMinTokenSize Integer
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    innodbFtServerStopwordTable String
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    innodbLockWaitTimeout Integer
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    innodbLogBufferSize Integer
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    innodbOnlineAlterLogMaxSize Integer
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    innodbPrintAllDeadlocks Boolean
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    innodbReadIoThreads Integer
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    innodbRollbackOnTimeout Boolean
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    innodbThreadConcurrency Integer
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    innodbWriteIoThreads Integer
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    interactiveTimeout Integer
    The number of seconds the server waits for activity on an interactive connection before closing it.
    internalTmpMemStorageEngine String
    The storage engine for in-memory internal temporary tables.
    ipFilters List<String>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    logOutput String
    The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
    longQueryTime Double
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute.
    maxAllowedPacket Integer
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    maxHeapTableSize Integer
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    migration ManagedDatabaseMysqlPropertiesMigration
    Migrate data from existing server.
    netBufferLength Integer
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    netReadTimeout Integer
    The number of seconds to wait for more data from a connection before aborting the read.
    netWriteTimeout Integer
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    publicAccess Boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog Boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    slowQueryLog Boolean
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
    sortBufferSize Integer
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    sqlMode String
    Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
    sqlRequirePrimaryKey Boolean
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    tmpTableSize Integer
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    version String
    MySQL major version.
    waitTimeout Integer
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    adminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    backupHour number
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute number
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    binlogRetentionPeriod number
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    connectTimeout number
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    defaultTimeZone string
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    groupConcatMaxLen number
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    informationSchemaStatsExpiry number
    The time, in seconds, before cached statistics expire.
    innodbChangeBufferMaxSize number
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    innodbFlushNeighbors number
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    innodbFtMinTokenSize number
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    innodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    innodbLockWaitTimeout number
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    innodbLogBufferSize number
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    innodbOnlineAlterLogMaxSize number
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    innodbPrintAllDeadlocks boolean
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    innodbReadIoThreads number
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    innodbRollbackOnTimeout boolean
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    innodbThreadConcurrency number
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    innodbWriteIoThreads number
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    interactiveTimeout number
    The number of seconds the server waits for activity on an interactive connection before closing it.
    internalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    ipFilters string[]
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    logOutput string
    The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
    longQueryTime number
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute.
    maxAllowedPacket number
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    maxHeapTableSize number
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    migration ManagedDatabaseMysqlPropertiesMigration
    Migrate data from existing server.
    netBufferLength number
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    netReadTimeout number
    The number of seconds to wait for more data from a connection before aborting the read.
    netWriteTimeout number
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    publicAccess boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    slowQueryLog boolean
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
    sortBufferSize number
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    sqlMode string
    Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
    sqlRequirePrimaryKey boolean
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    tmpTableSize number
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    version string
    MySQL major version.
    waitTimeout number
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    admin_password str
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    admin_username str
    Custom username for admin user. This must be set only when a new service is being created.
    automatic_utility_network_ip_filter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    backup_hour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backup_minute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    binlog_retention_period int
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    connect_timeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    default_time_zone str
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    group_concat_max_len int
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    information_schema_stats_expiry int
    The time, in seconds, before cached statistics expire.
    innodb_change_buffer_max_size int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    innodb_flush_neighbors int
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    innodb_ft_min_token_size int
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    innodb_ft_server_stopword_table str
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    innodb_lock_wait_timeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    innodb_log_buffer_size int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    innodb_online_alter_log_max_size int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    innodb_print_all_deadlocks bool
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    innodb_read_io_threads int
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    innodb_rollback_on_timeout bool
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    innodb_thread_concurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    innodb_write_io_threads int
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    interactive_timeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    internal_tmp_mem_storage_engine str
    The storage engine for in-memory internal temporary tables.
    ip_filters Sequence[str]
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    log_output str
    The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
    long_query_time float
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute.
    max_allowed_packet int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    max_heap_table_size int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    migration ManagedDatabaseMysqlPropertiesMigration
    Migrate data from existing server.
    net_buffer_length int
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    net_read_timeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    net_write_timeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    public_access bool
    Public Access. Allow access to the service from the public Internet.
    service_log bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    slow_query_log bool
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
    sort_buffer_size int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    sql_mode str
    Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
    sql_require_primary_key bool
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    tmp_table_size int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    version str
    MySQL major version.
    wait_timeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    adminPassword String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername String
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter Boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    backupHour Number
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute Number
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    binlogRetentionPeriod Number
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    connectTimeout Number
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    defaultTimeZone String
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    groupConcatMaxLen Number
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    informationSchemaStatsExpiry Number
    The time, in seconds, before cached statistics expire.
    innodbChangeBufferMaxSize Number
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    innodbFlushNeighbors Number
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    innodbFtMinTokenSize Number
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    innodbFtServerStopwordTable String
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    innodbLockWaitTimeout Number
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    innodbLogBufferSize Number
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    innodbOnlineAlterLogMaxSize Number
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    innodbPrintAllDeadlocks Boolean
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    innodbReadIoThreads Number
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    innodbRollbackOnTimeout Boolean
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    innodbThreadConcurrency Number
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    innodbWriteIoThreads Number
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    interactiveTimeout Number
    The number of seconds the server waits for activity on an interactive connection before closing it.
    internalTmpMemStorageEngine String
    The storage engine for in-memory internal temporary tables.
    ipFilters List<String>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    logOutput String
    The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
    longQueryTime Number
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute.
    maxAllowedPacket Number
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    maxHeapTableSize Number
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    migration Property Map
    Migrate data from existing server.
    netBufferLength Number
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    netReadTimeout Number
    The number of seconds to wait for more data from a connection before aborting the read.
    netWriteTimeout Number
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    publicAccess Boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog Boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    slowQueryLog Boolean
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
    sortBufferSize Number
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    sqlMode String
    Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
    sqlRequirePrimaryKey Boolean
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    tmpTableSize Number
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    version String
    MySQL major version.
    waitTimeout Number
    The number of seconds the server waits for activity on a noninteractive connection before closing it.

    ManagedDatabaseMysqlPropertiesMigration, ManagedDatabaseMysqlPropertiesMigrationArgs

    Dbname string
    Database name for bootstrapping the initial connection.
    Host string
    Hostname or IP address of the server where to migrate data from.
    IgnoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    IgnoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    Method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    Password string
    Password for authentication with the server where to migrate data from.
    Port int
    Port number of the server where to migrate data from.
    Ssl bool
    The server where to migrate data from is secured with SSL.
    Username string
    User name for authentication with the server where to migrate data from.
    Dbname string
    Database name for bootstrapping the initial connection.
    Host string
    Hostname or IP address of the server where to migrate data from.
    IgnoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    IgnoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    Method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    Password string
    Password for authentication with the server where to migrate data from.
    Port int
    Port number of the server where to migrate data from.
    Ssl bool
    The server where to migrate data from is secured with SSL.
    Username string
    User name for authentication with the server where to migrate data from.
    dbname String
    Database name for bootstrapping the initial connection.
    host String
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs String
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles String
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method String
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password String
    Password for authentication with the server where to migrate data from.
    port Integer
    Port number of the server where to migrate data from.
    ssl Boolean
    The server where to migrate data from is secured with SSL.
    username String
    User name for authentication with the server where to migrate data from.
    dbname string
    Database name for bootstrapping the initial connection.
    host string
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password string
    Password for authentication with the server where to migrate data from.
    port number
    Port number of the server where to migrate data from.
    ssl boolean
    The server where to migrate data from is secured with SSL.
    username string
    User name for authentication with the server where to migrate data from.
    dbname str
    Database name for bootstrapping the initial connection.
    host str
    Hostname or IP address of the server where to migrate data from.
    ignore_dbs str
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignore_roles str
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method str
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password str
    Password for authentication with the server where to migrate data from.
    port int
    Port number of the server where to migrate data from.
    ssl bool
    The server where to migrate data from is secured with SSL.
    username str
    User name for authentication with the server where to migrate data from.
    dbname String
    Database name for bootstrapping the initial connection.
    host String
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs String
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles String
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method String
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password String
    Password for authentication with the server where to migrate data from.
    port Number
    Port number of the server where to migrate data from.
    ssl Boolean
    The server where to migrate data from is secured with SSL.
    username String
    User name for authentication with the server where to migrate data from.

    Package Details

    Repository
    upcloud UpCloudLtd/pulumi-upcloud
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the upcloud Terraform Provider.
    upcloud logo
    UpCloud v0.1.0 published on Friday, Mar 14, 2025 by UpCloudLtd
    UpCloudLtd/pulumi-upcloud