Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi IDP Pulumi Cloud Packages Tutorials
  1. Packages
  2. Linode Provider
  3. API Docs
  4. DatabaseMysqlV2
Linode v5.1.1 published on Thursday, Jul 31, 2025 by Pulumi
pulumi/pulumi-linode

linode.DatabaseMysqlV2

Explore with Pulumi AI

linode logo
Linode v5.1.1 published on Thursday, Jul 31, 2025 by Pulumi
pulumi/pulumi-linode

    Provides a Linode MySQL Database resource. This can be used to create, modify, and delete Linode MySQL Databases. For more information, see the Linode APIv4 docs.

    Please keep in mind that Managed Databases can take up to half an hour to provision.

    Example Usage

    Creating a simple MySQL database that does not allow connections:

    import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const foobar = new linode.DatabaseMysqlV2("foobar", {
    label: "mydatabase",
    engineId: "mysql/8",
    region: "us-mia",
    type: "g6-nanode-1",
});

    import pulumi
import pulumi_linode as linode

foobar = linode.DatabaseMysqlV2("foobar",
    label="mydatabase",
    engine_id="mysql/8",
    region="us-mia",
    type="g6-nanode-1")

    package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v5/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabaseMysqlV2(ctx, "foobar", &linode.DatabaseMysqlV2Args{
			Label:    pulumi.String("mydatabase"),
			EngineId: pulumi.String("mysql/8"),
			Region:   pulumi.String("us-mia"),
			Type:     pulumi.String("g6-nanode-1"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabaseMysqlV2("foobar", new()
    {
        Label = "mydatabase",
        EngineId = "mysql/8",
        Region = "us-mia",
        Type = "g6-nanode-1",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabaseMysqlV2;
import com.pulumi.linode.DatabaseMysqlV2Args;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var foobar = new DatabaseMysqlV2("foobar", DatabaseMysqlV2Args.builder()
            .label("mydatabase")
            .engineId("mysql/8")
            .region("us-mia")
            .type("g6-nanode-1")
            .build());

    }
}

    resources:
  foobar:
    type: linode:DatabaseMysqlV2
    properties:
      label: mydatabase
      engineId: mysql/8
      region: us-mia
      type: g6-nanode-1

    Creating a simple MySQL database that allows connections from all IPv4 addresses:

    import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const foobar = new linode.DatabaseMysqlV2("foobar", {
    label: "mydatabase",
    engineId: "mysql/8",
    region: "us-mia",
    type: "g6-nanode-1",
    allowLists: ["0.0.0.0/0"],
});

    import pulumi
import pulumi_linode as linode

foobar = linode.DatabaseMysqlV2("foobar",
    label="mydatabase",
    engine_id="mysql/8",
    region="us-mia",
    type="g6-nanode-1",
    allow_lists=["0.0.0.0/0"])

    package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v5/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabaseMysqlV2(ctx, "foobar", &linode.DatabaseMysqlV2Args{
			Label:    pulumi.String("mydatabase"),
			EngineId: pulumi.String("mysql/8"),
			Region:   pulumi.String("us-mia"),
			Type:     pulumi.String("g6-nanode-1"),
			AllowLists: pulumi.StringArray{
				pulumi.String("0.0.0.0/0"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabaseMysqlV2("foobar", new()
    {
        Label = "mydatabase",
        EngineId = "mysql/8",
        Region = "us-mia",
        Type = "g6-nanode-1",
        AllowLists = new[]
        {
            "0.0.0.0/0",
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabaseMysqlV2;
import com.pulumi.linode.DatabaseMysqlV2Args;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var foobar = new DatabaseMysqlV2("foobar", DatabaseMysqlV2Args.builder()
            .label("mydatabase")
            .engineId("mysql/8")
            .region("us-mia")
            .type("g6-nanode-1")
            .allowLists("0.0.0.0/0")
            .build());

    }
}

    resources:
  foobar:
    type: linode:DatabaseMysqlV2
    properties:
      label: mydatabase
      engineId: mysql/8
      region: us-mia
      type: g6-nanode-1
      allowLists:
        - 0.0.0.0/0

    Creating a complex MySQL database:

    Example coming soon!

    Example coming soon!

    Example coming soon!

    Example coming soon!

    Example coming soon!

    resources:
  foobar:
    type: linode:DatabaseMysqlV2
    properties:
      label: mydatabase
      engineId: mysql/8
      region: us-mia
      type: g6-nanode-1
      allowLists:
        - 10.0.0.3/32
      clusterSize: 3
      updates:
        duration: 4
        frequency: weekly
        hour_of_day: 22
        day_of_week: 3

    Creating a MySQL database with engine config fields specified:

    import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const foobar = new linode.DatabaseMysqlV2("foobar", {
    label: "mydatabase",
    engineId: "mysql/8",
    region: "us-mia",
    type: "g6-nanode-1",
    engineConfigBinlogRetentionPeriod: 3600,
    engineConfigMysqlConnectTimeout: 10,
    engineConfigMysqlDefaultTimeZone: "+00:00",
    engineConfigMysqlGroupConcatMaxLen: 4096,
    engineConfigMysqlInformationSchemaStatsExpiry: 3600,
    engineConfigMysqlInnodbChangeBufferMaxSize: 25,
    engineConfigMysqlInnodbFlushNeighbors: 0,
    engineConfigMysqlInnodbFtMinTokenSize: 7,
    engineConfigMysqlInnodbFtServerStopwordTable: "mysql/innodb_ft_default_stopword",
    engineConfigMysqlInnodbLockWaitTimeout: 300,
    engineConfigMysqlInnodbLogBufferSize: 16777216,
    engineConfigMysqlInnodbOnlineAlterLogMaxSize: 268435456,
    engineConfigMysqlInnodbReadIoThreads: 4,
    engineConfigMysqlInnodbRollbackOnTimeout: true,
    engineConfigMysqlInnodbThreadConcurrency: 8,
    engineConfigMysqlInnodbWriteIoThreads: 4,
    engineConfigMysqlInteractiveTimeout: 300,
    engineConfigMysqlInternalTmpMemStorageEngine: "TempTable",
    engineConfigMysqlMaxAllowedPacket: 67108864,
    engineConfigMysqlMaxHeapTableSize: 16777216,
    engineConfigMysqlNetBufferLength: 16384,
    engineConfigMysqlNetReadTimeout: 30,
    engineConfigMysqlNetWriteTimeout: 30,
    engineConfigMysqlSortBufferSize: 262144,
    engineConfigMysqlSqlMode: "TRADITIONAL,ANSI",
    engineConfigMysqlSqlRequirePrimaryKey: false,
    engineConfigMysqlTmpTableSize: 16777216,
    engineConfigMysqlWaitTimeout: 28800,
});

    import pulumi
import pulumi_linode as linode

foobar = linode.DatabaseMysqlV2("foobar",
    label="mydatabase",
    engine_id="mysql/8",
    region="us-mia",
    type="g6-nanode-1",
    engine_config_binlog_retention_period=3600,
    engine_config_mysql_connect_timeout=10,
    engine_config_mysql_default_time_zone="+00:00",
    engine_config_mysql_group_concat_max_len=4096,
    engine_config_mysql_information_schema_stats_expiry=3600,
    engine_config_mysql_innodb_change_buffer_max_size=25,
    engine_config_mysql_innodb_flush_neighbors=0,
    engine_config_mysql_innodb_ft_min_token_size=7,
    engine_config_mysql_innodb_ft_server_stopword_table="mysql/innodb_ft_default_stopword",
    engine_config_mysql_innodb_lock_wait_timeout=300,
    engine_config_mysql_innodb_log_buffer_size=16777216,
    engine_config_mysql_innodb_online_alter_log_max_size=268435456,
    engine_config_mysql_innodb_read_io_threads=4,
    engine_config_mysql_innodb_rollback_on_timeout=True,
    engine_config_mysql_innodb_thread_concurrency=8,
    engine_config_mysql_innodb_write_io_threads=4,
    engine_config_mysql_interactive_timeout=300,
    engine_config_mysql_internal_tmp_mem_storage_engine="TempTable",
    engine_config_mysql_max_allowed_packet=67108864,
    engine_config_mysql_max_heap_table_size=16777216,
    engine_config_mysql_net_buffer_length=16384,
    engine_config_mysql_net_read_timeout=30,
    engine_config_mysql_net_write_timeout=30,
    engine_config_mysql_sort_buffer_size=262144,
    engine_config_mysql_sql_mode="TRADITIONAL,ANSI",
    engine_config_mysql_sql_require_primary_key=False,
    engine_config_mysql_tmp_table_size=16777216,
    engine_config_mysql_wait_timeout=28800)

    package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v5/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabaseMysqlV2(ctx, "foobar", &linode.DatabaseMysqlV2Args{
			Label:                              pulumi.String("mydatabase"),
			EngineId:                           pulumi.String("mysql/8"),
			Region:                             pulumi.String("us-mia"),
			Type:                               pulumi.String("g6-nanode-1"),
			EngineConfigBinlogRetentionPeriod:  pulumi.Int(3600),
			EngineConfigMysqlConnectTimeout:    pulumi.Int(10),
			EngineConfigMysqlDefaultTimeZone:   pulumi.String("+00:00"),
			EngineConfigMysqlGroupConcatMaxLen: pulumi.Float64(4096),
			EngineConfigMysqlInformationSchemaStatsExpiry: pulumi.Int(3600),
			EngineConfigMysqlInnodbChangeBufferMaxSize:    pulumi.Int(25),
			EngineConfigMysqlInnodbFlushNeighbors:         pulumi.Int(0),
			EngineConfigMysqlInnodbFtMinTokenSize:         pulumi.Int(7),
			EngineConfigMysqlInnodbFtServerStopwordTable:  pulumi.String("mysql/innodb_ft_default_stopword"),
			EngineConfigMysqlInnodbLockWaitTimeout:        pulumi.Int(300),
			EngineConfigMysqlInnodbLogBufferSize:          pulumi.Int(16777216),
			EngineConfigMysqlInnodbOnlineAlterLogMaxSize:  pulumi.Int(268435456),
			EngineConfigMysqlInnodbReadIoThreads:          pulumi.Int(4),
			EngineConfigMysqlInnodbRollbackOnTimeout:      pulumi.Bool(true),
			EngineConfigMysqlInnodbThreadConcurrency:      pulumi.Int(8),
			EngineConfigMysqlInnodbWriteIoThreads:         pulumi.Int(4),
			EngineConfigMysqlInteractiveTimeout:           pulumi.Int(300),
			EngineConfigMysqlInternalTmpMemStorageEngine:  pulumi.String("TempTable"),
			EngineConfigMysqlMaxAllowedPacket:             pulumi.Int(67108864),
			EngineConfigMysqlMaxHeapTableSize:             pulumi.Int(16777216),
			EngineConfigMysqlNetBufferLength:              pulumi.Int(16384),
			EngineConfigMysqlNetReadTimeout:               pulumi.Int(30),
			EngineConfigMysqlNetWriteTimeout:              pulumi.Int(30),
			EngineConfigMysqlSortBufferSize:               pulumi.Int(262144),
			EngineConfigMysqlSqlMode:                      pulumi.String("TRADITIONAL,ANSI"),
			EngineConfigMysqlSqlRequirePrimaryKey:         pulumi.Bool(false),
			EngineConfigMysqlTmpTableSize:                 pulumi.Int(16777216),
			EngineConfigMysqlWaitTimeout:                  pulumi.Int(28800),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabaseMysqlV2("foobar", new()
    {
        Label = "mydatabase",
        EngineId = "mysql/8",
        Region = "us-mia",
        Type = "g6-nanode-1",
        EngineConfigBinlogRetentionPeriod = 3600,
        EngineConfigMysqlConnectTimeout = 10,
        EngineConfigMysqlDefaultTimeZone = "+00:00",
        EngineConfigMysqlGroupConcatMaxLen = 4096,
        EngineConfigMysqlInformationSchemaStatsExpiry = 3600,
        EngineConfigMysqlInnodbChangeBufferMaxSize = 25,
        EngineConfigMysqlInnodbFlushNeighbors = 0,
        EngineConfigMysqlInnodbFtMinTokenSize = 7,
        EngineConfigMysqlInnodbFtServerStopwordTable = "mysql/innodb_ft_default_stopword",
        EngineConfigMysqlInnodbLockWaitTimeout = 300,
        EngineConfigMysqlInnodbLogBufferSize = 16777216,
        EngineConfigMysqlInnodbOnlineAlterLogMaxSize = 268435456,
        EngineConfigMysqlInnodbReadIoThreads = 4,
        EngineConfigMysqlInnodbRollbackOnTimeout = true,
        EngineConfigMysqlInnodbThreadConcurrency = 8,
        EngineConfigMysqlInnodbWriteIoThreads = 4,
        EngineConfigMysqlInteractiveTimeout = 300,
        EngineConfigMysqlInternalTmpMemStorageEngine = "TempTable",
        EngineConfigMysqlMaxAllowedPacket = 67108864,
        EngineConfigMysqlMaxHeapTableSize = 16777216,
        EngineConfigMysqlNetBufferLength = 16384,
        EngineConfigMysqlNetReadTimeout = 30,
        EngineConfigMysqlNetWriteTimeout = 30,
        EngineConfigMysqlSortBufferSize = 262144,
        EngineConfigMysqlSqlMode = "TRADITIONAL,ANSI",
        EngineConfigMysqlSqlRequirePrimaryKey = false,
        EngineConfigMysqlTmpTableSize = 16777216,
        EngineConfigMysqlWaitTimeout = 28800,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabaseMysqlV2;
import com.pulumi.linode.DatabaseMysqlV2Args;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var foobar = new DatabaseMysqlV2("foobar", DatabaseMysqlV2Args.builder()
            .label("mydatabase")
            .engineId("mysql/8")
            .region("us-mia")
            .type("g6-nanode-1")
            .engineConfigBinlogRetentionPeriod(3600)
            .engineConfigMysqlConnectTimeout(10)
            .engineConfigMysqlDefaultTimeZone("+00:00")
            .engineConfigMysqlGroupConcatMaxLen(4096.0)
            .engineConfigMysqlInformationSchemaStatsExpiry(3600)
            .engineConfigMysqlInnodbChangeBufferMaxSize(25)
            .engineConfigMysqlInnodbFlushNeighbors(0)
            .engineConfigMysqlInnodbFtMinTokenSize(7)
            .engineConfigMysqlInnodbFtServerStopwordTable("mysql/innodb_ft_default_stopword")
            .engineConfigMysqlInnodbLockWaitTimeout(300)
            .engineConfigMysqlInnodbLogBufferSize(16777216)
            .engineConfigMysqlInnodbOnlineAlterLogMaxSize(268435456)
            .engineConfigMysqlInnodbReadIoThreads(4)
            .engineConfigMysqlInnodbRollbackOnTimeout(true)
            .engineConfigMysqlInnodbThreadConcurrency(8)
            .engineConfigMysqlInnodbWriteIoThreads(4)
            .engineConfigMysqlInteractiveTimeout(300)
            .engineConfigMysqlInternalTmpMemStorageEngine("TempTable")
            .engineConfigMysqlMaxAllowedPacket(67108864)
            .engineConfigMysqlMaxHeapTableSize(16777216)
            .engineConfigMysqlNetBufferLength(16384)
            .engineConfigMysqlNetReadTimeout(30)
            .engineConfigMysqlNetWriteTimeout(30)
            .engineConfigMysqlSortBufferSize(262144)
            .engineConfigMysqlSqlMode("TRADITIONAL,ANSI")
            .engineConfigMysqlSqlRequirePrimaryKey(false)
            .engineConfigMysqlTmpTableSize(16777216)
            .engineConfigMysqlWaitTimeout(28800)
            .build());

    }
}

    resources:
  foobar:
    type: linode:DatabaseMysqlV2
    properties:
      label: mydatabase
      engineId: mysql/8
      region: us-mia
      type: g6-nanode-1
      engineConfigBinlogRetentionPeriod: 3600
      engineConfigMysqlConnectTimeout: 10
      engineConfigMysqlDefaultTimeZone: +00:00
      engineConfigMysqlGroupConcatMaxLen: 4096
      engineConfigMysqlInformationSchemaStatsExpiry: 3600
      engineConfigMysqlInnodbChangeBufferMaxSize: 25
      engineConfigMysqlInnodbFlushNeighbors: 0
      engineConfigMysqlInnodbFtMinTokenSize: 7
      engineConfigMysqlInnodbFtServerStopwordTable: mysql/innodb_ft_default_stopword
      engineConfigMysqlInnodbLockWaitTimeout: 300
      engineConfigMysqlInnodbLogBufferSize: 1.6777216e+07
      engineConfigMysqlInnodbOnlineAlterLogMaxSize: 2.68435456e+08
      engineConfigMysqlInnodbReadIoThreads: 4
      engineConfigMysqlInnodbRollbackOnTimeout: true
      engineConfigMysqlInnodbThreadConcurrency: 8
      engineConfigMysqlInnodbWriteIoThreads: 4
      engineConfigMysqlInteractiveTimeout: 300
      engineConfigMysqlInternalTmpMemStorageEngine: TempTable
      engineConfigMysqlMaxAllowedPacket: 6.7108864e+07
      engineConfigMysqlMaxHeapTableSize: 1.6777216e+07
      engineConfigMysqlNetBufferLength: 16384
      engineConfigMysqlNetReadTimeout: 30
      engineConfigMysqlNetWriteTimeout: 30
      engineConfigMysqlSortBufferSize: 262144
      engineConfigMysqlSqlMode: TRADITIONAL,ANSI
      engineConfigMysqlSqlRequirePrimaryKey: false
      engineConfigMysqlTmpTableSize: 1.6777216e+07
      engineConfigMysqlWaitTimeout: 28800

    Creating a forked MySQL database:

    import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const foobar = new linode.DatabaseMysqlV2("foobar", {
    label: "mydatabase",
    engineId: "mysql/8",
    region: "us-mia",
    type: "g6-nanode-1",
    forkSource: 12345,
});

    import pulumi
import pulumi_linode as linode

foobar = linode.DatabaseMysqlV2("foobar",
    label="mydatabase",
    engine_id="mysql/8",
    region="us-mia",
    type="g6-nanode-1",
    fork_source=12345)

    package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v5/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabaseMysqlV2(ctx, "foobar", &linode.DatabaseMysqlV2Args{
			Label:      pulumi.String("mydatabase"),
			EngineId:   pulumi.String("mysql/8"),
			Region:     pulumi.String("us-mia"),
			Type:       pulumi.String("g6-nanode-1"),
			ForkSource: pulumi.Int(12345),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabaseMysqlV2("foobar", new()
    {
        Label = "mydatabase",
        EngineId = "mysql/8",
        Region = "us-mia",
        Type = "g6-nanode-1",
        ForkSource = 12345,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabaseMysqlV2;
import com.pulumi.linode.DatabaseMysqlV2Args;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var foobar = new DatabaseMysqlV2("foobar", DatabaseMysqlV2Args.builder()
            .label("mydatabase")
            .engineId("mysql/8")
            .region("us-mia")
            .type("g6-nanode-1")
            .forkSource(12345)
            .build());

    }
}

    resources:
  foobar:
    type: linode:DatabaseMysqlV2
    properties:
      label: mydatabase
      engineId: mysql/8
      region: us-mia
      type: g6-nanode-1
      forkSource: 12345

    NOTE: The name of the default database in the returned database cluster is defaultdb.

    pending_updates

    The following arguments are exposed by each entry in the pending_updates attribute:

    • deadline - The time when a mandatory update needs to be applied.

    • description - A description of the update.

    • planned_for - The date and time a maintenance update will be applied.

    updates

    The following arguments are supported in the updates specification block:

    • day_of_week - (Required) The day to perform maintenance. (monday, tuesday, …)

    • duration - (Required) The maximum maintenance window time in hours. (1..3)

    • frequency - (Required) The frequency at which maintenance occurs. (weekly)

    • hour_of_day - (Required) The hour to begin maintenance based in UTC time. (0..23)

    Create DatabaseMysqlV2 Resource

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

    Constructor syntax

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

@overload
def DatabaseMysqlV2(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    engine_id: Optional[str] = None,
                    type: Optional[str] = None,
                    region: Optional[str] = None,
                    label: Optional[str] = None,
                    engine_config_mysql_interactive_timeout: Optional[int] = None,
                    engine_config_mysql_max_heap_table_size: Optional[int] = None,
                    engine_config_mysql_information_schema_stats_expiry: Optional[int] = None,
                    engine_config_mysql_innodb_change_buffer_max_size: Optional[int] = None,
                    engine_config_mysql_innodb_flush_neighbors: Optional[int] = None,
                    engine_config_mysql_innodb_ft_min_token_size: Optional[int] = None,
                    engine_config_mysql_innodb_ft_server_stopword_table: Optional[str] = None,
                    engine_config_mysql_innodb_lock_wait_timeout: Optional[int] = None,
                    engine_config_mysql_innodb_log_buffer_size: Optional[int] = None,
                    engine_config_mysql_innodb_online_alter_log_max_size: Optional[int] = None,
                    engine_config_mysql_innodb_read_io_threads: Optional[int] = None,
                    engine_config_mysql_innodb_rollback_on_timeout: Optional[bool] = None,
                    engine_config_mysql_innodb_thread_concurrency: Optional[int] = None,
                    engine_config_mysql_innodb_write_io_threads: Optional[int] = None,
                    allow_lists: Optional[Sequence[str]] = None,
                    engine_config_mysql_internal_tmp_mem_storage_engine: Optional[str] = None,
                    engine_config_mysql_max_allowed_packet: Optional[int] = None,
                    engine_config_mysql_group_concat_max_len: Optional[float] = None,
                    engine_config_mysql_net_buffer_length: Optional[int] = None,
                    engine_config_mysql_net_read_timeout: Optional[int] = None,
                    engine_config_mysql_net_write_timeout: Optional[int] = None,
                    engine_config_mysql_sort_buffer_size: Optional[int] = None,
                    engine_config_mysql_sql_mode: Optional[str] = None,
                    engine_config_mysql_sql_require_primary_key: Optional[bool] = None,
                    engine_config_mysql_tmp_table_size: Optional[int] = None,
                    engine_config_mysql_wait_timeout: Optional[int] = None,
                    engine_config_mysql_default_time_zone: Optional[str] = None,
                    fork_restore_time: Optional[str] = None,
                    fork_source: Optional[int] = None,
                    engine_config_mysql_connect_timeout: Optional[int] = None,
                    engine_config_binlog_retention_period: Optional[int] = None,
                    suspended: Optional[bool] = None,
                    timeouts: Optional[DatabaseMysqlV2TimeoutsArgs] = None,
                    cluster_size: Optional[int] = None,
                    updates: Optional[DatabaseMysqlV2UpdatesArgs] = None)
    func NewDatabaseMysqlV2(ctx *Context, name string, args DatabaseMysqlV2Args, opts ...ResourceOption) (*DatabaseMysqlV2, error)
    public DatabaseMysqlV2(string name, DatabaseMysqlV2Args args, CustomResourceOptions? opts = null)
    public DatabaseMysqlV2(String name, DatabaseMysqlV2Args args)
public DatabaseMysqlV2(String name, DatabaseMysqlV2Args args, CustomResourceOptions options)

    type: linode:DatabaseMysqlV2
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 DatabaseMysqlV2Args
    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 DatabaseMysqlV2Args
    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 DatabaseMysqlV2Args
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatabaseMysqlV2Args
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DatabaseMysqlV2Args
    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 databaseMysqlV2Resource = new Linode.DatabaseMysqlV2("databaseMysqlV2Resource", new()
{
    EngineId = "string",
    Type = "string",
    Region = "string",
    Label = "string",
    EngineConfigMysqlInteractiveTimeout = 0,
    EngineConfigMysqlMaxHeapTableSize = 0,
    EngineConfigMysqlInformationSchemaStatsExpiry = 0,
    EngineConfigMysqlInnodbChangeBufferMaxSize = 0,
    EngineConfigMysqlInnodbFlushNeighbors = 0,
    EngineConfigMysqlInnodbFtMinTokenSize = 0,
    EngineConfigMysqlInnodbFtServerStopwordTable = "string",
    EngineConfigMysqlInnodbLockWaitTimeout = 0,
    EngineConfigMysqlInnodbLogBufferSize = 0,
    EngineConfigMysqlInnodbOnlineAlterLogMaxSize = 0,
    EngineConfigMysqlInnodbReadIoThreads = 0,
    EngineConfigMysqlInnodbRollbackOnTimeout = false,
    EngineConfigMysqlInnodbThreadConcurrency = 0,
    EngineConfigMysqlInnodbWriteIoThreads = 0,
    AllowLists = new[]
    {
        "string",
    },
    EngineConfigMysqlInternalTmpMemStorageEngine = "string",
    EngineConfigMysqlMaxAllowedPacket = 0,
    EngineConfigMysqlGroupConcatMaxLen = 0,
    EngineConfigMysqlNetBufferLength = 0,
    EngineConfigMysqlNetReadTimeout = 0,
    EngineConfigMysqlNetWriteTimeout = 0,
    EngineConfigMysqlSortBufferSize = 0,
    EngineConfigMysqlSqlMode = "string",
    EngineConfigMysqlSqlRequirePrimaryKey = false,
    EngineConfigMysqlTmpTableSize = 0,
    EngineConfigMysqlWaitTimeout = 0,
    EngineConfigMysqlDefaultTimeZone = "string",
    ForkRestoreTime = "string",
    ForkSource = 0,
    EngineConfigMysqlConnectTimeout = 0,
    EngineConfigBinlogRetentionPeriod = 0,
    Suspended = false,
    Timeouts = new Linode.Inputs.DatabaseMysqlV2TimeoutsArgs
    {
        Create = "string",
        Delete = "string",
        Update = "string",
    },
    ClusterSize = 0,
    Updates = new Linode.Inputs.DatabaseMysqlV2UpdatesArgs
    {
        DayOfWeek = 0,
        Duration = 0,
        Frequency = "string",
        HourOfDay = 0,
    },
});

    example, err := linode.NewDatabaseMysqlV2(ctx, "databaseMysqlV2Resource", &linode.DatabaseMysqlV2Args{
	EngineId:                            pulumi.String("string"),
	Type:                                pulumi.String("string"),
	Region:                              pulumi.String("string"),
	Label:                               pulumi.String("string"),
	EngineConfigMysqlInteractiveTimeout: pulumi.Int(0),
	EngineConfigMysqlMaxHeapTableSize:   pulumi.Int(0),
	EngineConfigMysqlInformationSchemaStatsExpiry: pulumi.Int(0),
	EngineConfigMysqlInnodbChangeBufferMaxSize:    pulumi.Int(0),
	EngineConfigMysqlInnodbFlushNeighbors:         pulumi.Int(0),
	EngineConfigMysqlInnodbFtMinTokenSize:         pulumi.Int(0),
	EngineConfigMysqlInnodbFtServerStopwordTable:  pulumi.String("string"),
	EngineConfigMysqlInnodbLockWaitTimeout:        pulumi.Int(0),
	EngineConfigMysqlInnodbLogBufferSize:          pulumi.Int(0),
	EngineConfigMysqlInnodbOnlineAlterLogMaxSize:  pulumi.Int(0),
	EngineConfigMysqlInnodbReadIoThreads:          pulumi.Int(0),
	EngineConfigMysqlInnodbRollbackOnTimeout:      pulumi.Bool(false),
	EngineConfigMysqlInnodbThreadConcurrency:      pulumi.Int(0),
	EngineConfigMysqlInnodbWriteIoThreads:         pulumi.Int(0),
	AllowLists: pulumi.StringArray{
		pulumi.String("string"),
	},
	EngineConfigMysqlInternalTmpMemStorageEngine: pulumi.String("string"),
	EngineConfigMysqlMaxAllowedPacket:            pulumi.Int(0),
	EngineConfigMysqlGroupConcatMaxLen:           pulumi.Float64(0),
	EngineConfigMysqlNetBufferLength:             pulumi.Int(0),
	EngineConfigMysqlNetReadTimeout:              pulumi.Int(0),
	EngineConfigMysqlNetWriteTimeout:             pulumi.Int(0),
	EngineConfigMysqlSortBufferSize:              pulumi.Int(0),
	EngineConfigMysqlSqlMode:                     pulumi.String("string"),
	EngineConfigMysqlSqlRequirePrimaryKey:        pulumi.Bool(false),
	EngineConfigMysqlTmpTableSize:                pulumi.Int(0),
	EngineConfigMysqlWaitTimeout:                 pulumi.Int(0),
	EngineConfigMysqlDefaultTimeZone:             pulumi.String("string"),
	ForkRestoreTime:                              pulumi.String("string"),
	ForkSource:                                   pulumi.Int(0),
	EngineConfigMysqlConnectTimeout:              pulumi.Int(0),
	EngineConfigBinlogRetentionPeriod:            pulumi.Int(0),
	Suspended:                                    pulumi.Bool(false),
	Timeouts: &linode.DatabaseMysqlV2TimeoutsArgs{
		Create: pulumi.String("string"),
		Delete: pulumi.String("string"),
		Update: pulumi.String("string"),
	},
	ClusterSize: pulumi.Int(0),
	Updates: &linode.DatabaseMysqlV2UpdatesArgs{
		DayOfWeek: pulumi.Int(0),
		Duration:  pulumi.Int(0),
		Frequency: pulumi.String("string"),
		HourOfDay: pulumi.Int(0),
	},
})

    var databaseMysqlV2Resource = new DatabaseMysqlV2("databaseMysqlV2Resource", DatabaseMysqlV2Args.builder()
    .engineId("string")
    .type("string")
    .region("string")
    .label("string")
    .engineConfigMysqlInteractiveTimeout(0)
    .engineConfigMysqlMaxHeapTableSize(0)
    .engineConfigMysqlInformationSchemaStatsExpiry(0)
    .engineConfigMysqlInnodbChangeBufferMaxSize(0)
    .engineConfigMysqlInnodbFlushNeighbors(0)
    .engineConfigMysqlInnodbFtMinTokenSize(0)
    .engineConfigMysqlInnodbFtServerStopwordTable("string")
    .engineConfigMysqlInnodbLockWaitTimeout(0)
    .engineConfigMysqlInnodbLogBufferSize(0)
    .engineConfigMysqlInnodbOnlineAlterLogMaxSize(0)
    .engineConfigMysqlInnodbReadIoThreads(0)
    .engineConfigMysqlInnodbRollbackOnTimeout(false)
    .engineConfigMysqlInnodbThreadConcurrency(0)
    .engineConfigMysqlInnodbWriteIoThreads(0)
    .allowLists("string")
    .engineConfigMysqlInternalTmpMemStorageEngine("string")
    .engineConfigMysqlMaxAllowedPacket(0)
    .engineConfigMysqlGroupConcatMaxLen(0.0)
    .engineConfigMysqlNetBufferLength(0)
    .engineConfigMysqlNetReadTimeout(0)
    .engineConfigMysqlNetWriteTimeout(0)
    .engineConfigMysqlSortBufferSize(0)
    .engineConfigMysqlSqlMode("string")
    .engineConfigMysqlSqlRequirePrimaryKey(false)
    .engineConfigMysqlTmpTableSize(0)
    .engineConfigMysqlWaitTimeout(0)
    .engineConfigMysqlDefaultTimeZone("string")
    .forkRestoreTime("string")
    .forkSource(0)
    .engineConfigMysqlConnectTimeout(0)
    .engineConfigBinlogRetentionPeriod(0)
    .suspended(false)
    .timeouts(DatabaseMysqlV2TimeoutsArgs.builder()
        .create("string")
        .delete("string")
        .update("string")
        .build())
    .clusterSize(0)
    .updates(DatabaseMysqlV2UpdatesArgs.builder()
        .dayOfWeek(0)
        .duration(0)
        .frequency("string")
        .hourOfDay(0)
        .build())
    .build());

    database_mysql_v2_resource = linode.DatabaseMysqlV2("databaseMysqlV2Resource",
    engine_id="string",
    type="string",
    region="string",
    label="string",
    engine_config_mysql_interactive_timeout=0,
    engine_config_mysql_max_heap_table_size=0,
    engine_config_mysql_information_schema_stats_expiry=0,
    engine_config_mysql_innodb_change_buffer_max_size=0,
    engine_config_mysql_innodb_flush_neighbors=0,
    engine_config_mysql_innodb_ft_min_token_size=0,
    engine_config_mysql_innodb_ft_server_stopword_table="string",
    engine_config_mysql_innodb_lock_wait_timeout=0,
    engine_config_mysql_innodb_log_buffer_size=0,
    engine_config_mysql_innodb_online_alter_log_max_size=0,
    engine_config_mysql_innodb_read_io_threads=0,
    engine_config_mysql_innodb_rollback_on_timeout=False,
    engine_config_mysql_innodb_thread_concurrency=0,
    engine_config_mysql_innodb_write_io_threads=0,
    allow_lists=["string"],
    engine_config_mysql_internal_tmp_mem_storage_engine="string",
    engine_config_mysql_max_allowed_packet=0,
    engine_config_mysql_group_concat_max_len=0,
    engine_config_mysql_net_buffer_length=0,
    engine_config_mysql_net_read_timeout=0,
    engine_config_mysql_net_write_timeout=0,
    engine_config_mysql_sort_buffer_size=0,
    engine_config_mysql_sql_mode="string",
    engine_config_mysql_sql_require_primary_key=False,
    engine_config_mysql_tmp_table_size=0,
    engine_config_mysql_wait_timeout=0,
    engine_config_mysql_default_time_zone="string",
    fork_restore_time="string",
    fork_source=0,
    engine_config_mysql_connect_timeout=0,
    engine_config_binlog_retention_period=0,
    suspended=False,
    timeouts={
        "create": "string",
        "delete": "string",
        "update": "string",
    },
    cluster_size=0,
    updates={
        "day_of_week": 0,
        "duration": 0,
        "frequency": "string",
        "hour_of_day": 0,
    })

    const databaseMysqlV2Resource = new linode.DatabaseMysqlV2("databaseMysqlV2Resource", {
    engineId: "string",
    type: "string",
    region: "string",
    label: "string",
    engineConfigMysqlInteractiveTimeout: 0,
    engineConfigMysqlMaxHeapTableSize: 0,
    engineConfigMysqlInformationSchemaStatsExpiry: 0,
    engineConfigMysqlInnodbChangeBufferMaxSize: 0,
    engineConfigMysqlInnodbFlushNeighbors: 0,
    engineConfigMysqlInnodbFtMinTokenSize: 0,
    engineConfigMysqlInnodbFtServerStopwordTable: "string",
    engineConfigMysqlInnodbLockWaitTimeout: 0,
    engineConfigMysqlInnodbLogBufferSize: 0,
    engineConfigMysqlInnodbOnlineAlterLogMaxSize: 0,
    engineConfigMysqlInnodbReadIoThreads: 0,
    engineConfigMysqlInnodbRollbackOnTimeout: false,
    engineConfigMysqlInnodbThreadConcurrency: 0,
    engineConfigMysqlInnodbWriteIoThreads: 0,
    allowLists: ["string"],
    engineConfigMysqlInternalTmpMemStorageEngine: "string",
    engineConfigMysqlMaxAllowedPacket: 0,
    engineConfigMysqlGroupConcatMaxLen: 0,
    engineConfigMysqlNetBufferLength: 0,
    engineConfigMysqlNetReadTimeout: 0,
    engineConfigMysqlNetWriteTimeout: 0,
    engineConfigMysqlSortBufferSize: 0,
    engineConfigMysqlSqlMode: "string",
    engineConfigMysqlSqlRequirePrimaryKey: false,
    engineConfigMysqlTmpTableSize: 0,
    engineConfigMysqlWaitTimeout: 0,
    engineConfigMysqlDefaultTimeZone: "string",
    forkRestoreTime: "string",
    forkSource: 0,
    engineConfigMysqlConnectTimeout: 0,
    engineConfigBinlogRetentionPeriod: 0,
    suspended: false,
    timeouts: {
        create: "string",
        "delete": "string",
        update: "string",
    },
    clusterSize: 0,
    updates: {
        dayOfWeek: 0,
        duration: 0,
        frequency: "string",
        hourOfDay: 0,
    },
});

    type: linode:DatabaseMysqlV2
properties:
    allowLists:
        - string
    clusterSize: 0
    engineConfigBinlogRetentionPeriod: 0
    engineConfigMysqlConnectTimeout: 0
    engineConfigMysqlDefaultTimeZone: string
    engineConfigMysqlGroupConcatMaxLen: 0
    engineConfigMysqlInformationSchemaStatsExpiry: 0
    engineConfigMysqlInnodbChangeBufferMaxSize: 0
    engineConfigMysqlInnodbFlushNeighbors: 0
    engineConfigMysqlInnodbFtMinTokenSize: 0
    engineConfigMysqlInnodbFtServerStopwordTable: string
    engineConfigMysqlInnodbLockWaitTimeout: 0
    engineConfigMysqlInnodbLogBufferSize: 0
    engineConfigMysqlInnodbOnlineAlterLogMaxSize: 0
    engineConfigMysqlInnodbReadIoThreads: 0
    engineConfigMysqlInnodbRollbackOnTimeout: false
    engineConfigMysqlInnodbThreadConcurrency: 0
    engineConfigMysqlInnodbWriteIoThreads: 0
    engineConfigMysqlInteractiveTimeout: 0
    engineConfigMysqlInternalTmpMemStorageEngine: string
    engineConfigMysqlMaxAllowedPacket: 0
    engineConfigMysqlMaxHeapTableSize: 0
    engineConfigMysqlNetBufferLength: 0
    engineConfigMysqlNetReadTimeout: 0
    engineConfigMysqlNetWriteTimeout: 0
    engineConfigMysqlSortBufferSize: 0
    engineConfigMysqlSqlMode: string
    engineConfigMysqlSqlRequirePrimaryKey: false
    engineConfigMysqlTmpTableSize: 0
    engineConfigMysqlWaitTimeout: 0
    engineId: string
    forkRestoreTime: string
    forkSource: 0
    label: string
    region: string
    suspended: false
    timeouts:
        create: string
        delete: string
        update: string
    type: string
    updates:
        dayOfWeek: 0
        duration: 0
        frequency: string
        hourOfDay: 0

    DatabaseMysqlV2 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 DatabaseMysqlV2 resource accepts the following input properties:

    EngineId string
    The Managed Database engine in engine/version format. (e.g. mysql)
    Label string
    A unique, user-defined string referring to the Managed Database.
    Region string
    The region to use for the Managed Database.
    Type string
    The Linode Instance type used for the nodes of the Managed Database.

    AllowLists List<string>
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    ClusterSize int
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    EngineConfigBinlogRetentionPeriod 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.
    EngineConfigMysqlConnectTimeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    EngineConfigMysqlDefaultTimeZone 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.
    EngineConfigMysqlGroupConcatMaxLen double
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    EngineConfigMysqlInformationSchemaStatsExpiry int
    The time, in seconds, before cached statistics expire.
    EngineConfigMysqlInnodbChangeBufferMaxSize int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    EngineConfigMysqlInnodbFlushNeighbors 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.
    EngineConfigMysqlInnodbFtMinTokenSize 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.
    EngineConfigMysqlInnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    EngineConfigMysqlInnodbLockWaitTimeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    EngineConfigMysqlInnodbLogBufferSize int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    EngineConfigMysqlInnodbOnlineAlterLogMaxSize int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    EngineConfigMysqlInnodbReadIoThreads 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.
    EngineConfigMysqlInnodbRollbackOnTimeout 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.
    EngineConfigMysqlInnodbThreadConcurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    EngineConfigMysqlInnodbWriteIoThreads 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.
    EngineConfigMysqlInteractiveTimeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    EngineConfigMysqlInternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    EngineConfigMysqlMaxAllowedPacket int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    EngineConfigMysqlMaxHeapTableSize int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    EngineConfigMysqlNetBufferLength 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.
    EngineConfigMysqlNetReadTimeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    EngineConfigMysqlNetWriteTimeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    EngineConfigMysqlSortBufferSize int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    EngineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    EngineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    EngineConfigMysqlTmpTableSize int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    EngineConfigMysqlWaitTimeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    ForkRestoreTime string
    The database timestamp from which it was restored.
    ForkSource int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    Suspended bool
    Whether this Managed Database should be suspended.
    Timeouts DatabaseMysqlV2Timeouts
    Updates DatabaseMysqlV2Updates
    Configuration settings for automated patch update maintenance for the Managed Database.
    EngineId string
    The Managed Database engine in engine/version format. (e.g. mysql)
    Label string
    A unique, user-defined string referring to the Managed Database.
    Region string
    The region to use for the Managed Database.
    Type string
    The Linode Instance type used for the nodes of the Managed Database.

    AllowLists []string
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    ClusterSize int
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    EngineConfigBinlogRetentionPeriod 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.
    EngineConfigMysqlConnectTimeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    EngineConfigMysqlDefaultTimeZone 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.
    EngineConfigMysqlGroupConcatMaxLen float64
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    EngineConfigMysqlInformationSchemaStatsExpiry int
    The time, in seconds, before cached statistics expire.
    EngineConfigMysqlInnodbChangeBufferMaxSize int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    EngineConfigMysqlInnodbFlushNeighbors 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.
    EngineConfigMysqlInnodbFtMinTokenSize 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.
    EngineConfigMysqlInnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    EngineConfigMysqlInnodbLockWaitTimeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    EngineConfigMysqlInnodbLogBufferSize int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    EngineConfigMysqlInnodbOnlineAlterLogMaxSize int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    EngineConfigMysqlInnodbReadIoThreads 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.
    EngineConfigMysqlInnodbRollbackOnTimeout 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.
    EngineConfigMysqlInnodbThreadConcurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    EngineConfigMysqlInnodbWriteIoThreads 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.
    EngineConfigMysqlInteractiveTimeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    EngineConfigMysqlInternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    EngineConfigMysqlMaxAllowedPacket int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    EngineConfigMysqlMaxHeapTableSize int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    EngineConfigMysqlNetBufferLength 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.
    EngineConfigMysqlNetReadTimeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    EngineConfigMysqlNetWriteTimeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    EngineConfigMysqlSortBufferSize int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    EngineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    EngineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    EngineConfigMysqlTmpTableSize int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    EngineConfigMysqlWaitTimeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    ForkRestoreTime string
    The database timestamp from which it was restored.
    ForkSource int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    Suspended bool
    Whether this Managed Database should be suspended.
    Timeouts DatabaseMysqlV2TimeoutsArgs
    Updates DatabaseMysqlV2UpdatesArgs
    Configuration settings for automated patch update maintenance for the Managed Database.
    engineId String
    The Managed Database engine in engine/version format. (e.g. mysql)
    label String
    A unique, user-defined string referring to the Managed Database.
    region String
    The region to use for the Managed Database.
    type String
    The Linode Instance type used for the nodes of the Managed Database.

    allowLists List<String>
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    clusterSize Integer
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    engineConfigBinlogRetentionPeriod 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.
    engineConfigMysqlConnectTimeout Integer
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    engineConfigMysqlDefaultTimeZone 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.
    engineConfigMysqlGroupConcatMaxLen Double
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    engineConfigMysqlInformationSchemaStatsExpiry Integer
    The time, in seconds, before cached statistics expire.
    engineConfigMysqlInnodbChangeBufferMaxSize Integer
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    engineConfigMysqlInnodbFlushNeighbors 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.
    engineConfigMysqlInnodbFtMinTokenSize 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.
    engineConfigMysqlInnodbFtServerStopwordTable String
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    engineConfigMysqlInnodbLockWaitTimeout Integer
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    engineConfigMysqlInnodbLogBufferSize Integer
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    engineConfigMysqlInnodbOnlineAlterLogMaxSize Integer
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    engineConfigMysqlInnodbReadIoThreads 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.
    engineConfigMysqlInnodbRollbackOnTimeout 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.
    engineConfigMysqlInnodbThreadConcurrency Integer
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    engineConfigMysqlInnodbWriteIoThreads 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.
    engineConfigMysqlInteractiveTimeout Integer
    The number of seconds the server waits for activity on an interactive connection before closing it.
    engineConfigMysqlInternalTmpMemStorageEngine String
    The storage engine for in-memory internal temporary tables.
    engineConfigMysqlMaxAllowedPacket Integer
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    engineConfigMysqlMaxHeapTableSize Integer
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    engineConfigMysqlNetBufferLength 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.
    engineConfigMysqlNetReadTimeout Integer
    The number of seconds to wait for more data from a connection before aborting the read.
    engineConfigMysqlNetWriteTimeout Integer
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    engineConfigMysqlSortBufferSize Integer
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    engineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    engineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    engineConfigMysqlTmpTableSize Integer
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    engineConfigMysqlWaitTimeout Integer
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    forkRestoreTime String
    The database timestamp from which it was restored.
    forkSource Integer
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    suspended Boolean
    Whether this Managed Database should be suspended.
    timeouts DatabaseMysqlV2Timeouts
    updates DatabaseMysqlV2Updates
    Configuration settings for automated patch update maintenance for the Managed Database.
    engineId string
    The Managed Database engine in engine/version format. (e.g. mysql)
    label string
    A unique, user-defined string referring to the Managed Database.
    region string
    The region to use for the Managed Database.
    type string
    The Linode Instance type used for the nodes of the Managed Database.

    allowLists string[]
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    clusterSize number
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    engineConfigBinlogRetentionPeriod 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.
    engineConfigMysqlConnectTimeout number
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    engineConfigMysqlDefaultTimeZone 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.
    engineConfigMysqlGroupConcatMaxLen number
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    engineConfigMysqlInformationSchemaStatsExpiry number
    The time, in seconds, before cached statistics expire.
    engineConfigMysqlInnodbChangeBufferMaxSize number
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    engineConfigMysqlInnodbFlushNeighbors 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.
    engineConfigMysqlInnodbFtMinTokenSize 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.
    engineConfigMysqlInnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    engineConfigMysqlInnodbLockWaitTimeout number
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    engineConfigMysqlInnodbLogBufferSize number
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    engineConfigMysqlInnodbOnlineAlterLogMaxSize number
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    engineConfigMysqlInnodbReadIoThreads 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.
    engineConfigMysqlInnodbRollbackOnTimeout 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.
    engineConfigMysqlInnodbThreadConcurrency number
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    engineConfigMysqlInnodbWriteIoThreads 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.
    engineConfigMysqlInteractiveTimeout number
    The number of seconds the server waits for activity on an interactive connection before closing it.
    engineConfigMysqlInternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    engineConfigMysqlMaxAllowedPacket number
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    engineConfigMysqlMaxHeapTableSize number
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    engineConfigMysqlNetBufferLength 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.
    engineConfigMysqlNetReadTimeout number
    The number of seconds to wait for more data from a connection before aborting the read.
    engineConfigMysqlNetWriteTimeout number
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    engineConfigMysqlSortBufferSize number
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    engineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    engineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    engineConfigMysqlTmpTableSize number
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    engineConfigMysqlWaitTimeout number
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    forkRestoreTime string
    The database timestamp from which it was restored.
    forkSource number
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    suspended boolean
    Whether this Managed Database should be suspended.
    timeouts DatabaseMysqlV2Timeouts
    updates DatabaseMysqlV2Updates
    Configuration settings for automated patch update maintenance for the Managed Database.
    engine_id str
    The Managed Database engine in engine/version format. (e.g. mysql)
    label str
    A unique, user-defined string referring to the Managed Database.
    region str
    The region to use for the Managed Database.
    type str
    The Linode Instance type used for the nodes of the Managed Database.

    allow_lists Sequence[str]
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    cluster_size int
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    engine_config_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.
    engine_config_mysql_connect_timeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    engine_config_mysql_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.
    engine_config_mysql_group_concat_max_len float
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    engine_config_mysql_information_schema_stats_expiry int
    The time, in seconds, before cached statistics expire.
    engine_config_mysql_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.
    engine_config_mysql_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.
    engine_config_mysql_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.
    engine_config_mysql_innodb_ft_server_stopword_table str
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    engine_config_mysql_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.
    engine_config_mysql_innodb_log_buffer_size int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    engine_config_mysql_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.
    engine_config_mysql_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.
    engine_config_mysql_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.
    engine_config_mysql_innodb_thread_concurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    engine_config_mysql_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.
    engine_config_mysql_interactive_timeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    engine_config_mysql_internal_tmp_mem_storage_engine str
    The storage engine for in-memory internal temporary tables.
    engine_config_mysql_max_allowed_packet int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    engine_config_mysql_max_heap_table_size int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    engine_config_mysql_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.
    engine_config_mysql_net_read_timeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    engine_config_mysql_net_write_timeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    engine_config_mysql_sort_buffer_size int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    engine_config_mysql_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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    engine_config_mysql_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. (default true)
    engine_config_mysql_tmp_table_size int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    engine_config_mysql_wait_timeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    fork_restore_time str
    The database timestamp from which it was restored.
    fork_source int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    suspended bool
    Whether this Managed Database should be suspended.
    timeouts DatabaseMysqlV2TimeoutsArgs
    updates DatabaseMysqlV2UpdatesArgs
    Configuration settings for automated patch update maintenance for the Managed Database.
    engineId String
    The Managed Database engine in engine/version format. (e.g. mysql)
    label String
    A unique, user-defined string referring to the Managed Database.
    region String
    The region to use for the Managed Database.
    type String
    The Linode Instance type used for the nodes of the Managed Database.

    allowLists List<String>
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    clusterSize Number
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    engineConfigBinlogRetentionPeriod 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.
    engineConfigMysqlConnectTimeout Number
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    engineConfigMysqlDefaultTimeZone 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.
    engineConfigMysqlGroupConcatMaxLen Number
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    engineConfigMysqlInformationSchemaStatsExpiry Number
    The time, in seconds, before cached statistics expire.
    engineConfigMysqlInnodbChangeBufferMaxSize Number
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    engineConfigMysqlInnodbFlushNeighbors 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.
    engineConfigMysqlInnodbFtMinTokenSize 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.
    engineConfigMysqlInnodbFtServerStopwordTable String
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    engineConfigMysqlInnodbLockWaitTimeout Number
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    engineConfigMysqlInnodbLogBufferSize Number
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    engineConfigMysqlInnodbOnlineAlterLogMaxSize Number
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    engineConfigMysqlInnodbReadIoThreads 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.
    engineConfigMysqlInnodbRollbackOnTimeout 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.
    engineConfigMysqlInnodbThreadConcurrency Number
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    engineConfigMysqlInnodbWriteIoThreads 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.
    engineConfigMysqlInteractiveTimeout Number
    The number of seconds the server waits for activity on an interactive connection before closing it.
    engineConfigMysqlInternalTmpMemStorageEngine String
    The storage engine for in-memory internal temporary tables.
    engineConfigMysqlMaxAllowedPacket Number
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    engineConfigMysqlMaxHeapTableSize Number
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    engineConfigMysqlNetBufferLength 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.
    engineConfigMysqlNetReadTimeout Number
    The number of seconds to wait for more data from a connection before aborting the read.
    engineConfigMysqlNetWriteTimeout Number
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    engineConfigMysqlSortBufferSize Number
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    engineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    engineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    engineConfigMysqlTmpTableSize Number
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    engineConfigMysqlWaitTimeout Number
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    forkRestoreTime String
    The database timestamp from which it was restored.
    forkSource Number
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    suspended Boolean
    Whether this Managed Database should be suspended.
    timeouts Property Map
    updates Property Map
    Configuration settings for automated patch update maintenance for the Managed Database.

    Outputs

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

    CaCert string
    The base64-encoded SSL CA certificate for the Managed Database.
    Created string
    When this Managed Database was created.
    Encrypted bool
    Whether the Managed Databases is encrypted.
    Engine string
    The Managed Database engine. (e.g. mysql)
    HostPrimary string
    The primary host for the Managed Database.
    HostSecondary string
    The secondary/private host for the managed database.
    Id string
    The provider-assigned unique ID for this managed resource.
    Members Dictionary<string, string>
    A mapping between IP addresses and strings designating them as primary or failover.
    OldestRestoreTime string
    The oldest time to which a database can be restored.
    PendingUpdates List<DatabaseMysqlV2PendingUpdate>
    A set of pending updates.
    Platform string
    The back-end platform for relational databases used by the service.
    Port int
    The access port for this Managed Database.
    RootPassword string
    The randomly-generated root password for the Managed Database instance.
    RootUsername string
    The root username for the Managed Database instance.
    SslConnection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    Status string
    The operating status of the Managed Database.
    Updated string
    When this Managed Database was last updated.
    Version string
    The Managed Database engine version. (e.g. 13.2)
    CaCert string
    The base64-encoded SSL CA certificate for the Managed Database.
    Created string
    When this Managed Database was created.
    Encrypted bool
    Whether the Managed Databases is encrypted.
    Engine string
    The Managed Database engine. (e.g. mysql)
    HostPrimary string
    The primary host for the Managed Database.
    HostSecondary string
    The secondary/private host for the managed database.
    Id string
    The provider-assigned unique ID for this managed resource.
    Members map[string]string
    A mapping between IP addresses and strings designating them as primary or failover.
    OldestRestoreTime string
    The oldest time to which a database can be restored.
    PendingUpdates []DatabaseMysqlV2PendingUpdate
    A set of pending updates.
    Platform string
    The back-end platform for relational databases used by the service.
    Port int
    The access port for this Managed Database.
    RootPassword string
    The randomly-generated root password for the Managed Database instance.
    RootUsername string
    The root username for the Managed Database instance.
    SslConnection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    Status string
    The operating status of the Managed Database.
    Updated string
    When this Managed Database was last updated.
    Version string
    The Managed Database engine version. (e.g. 13.2)
    caCert String
    The base64-encoded SSL CA certificate for the Managed Database.
    created String
    When this Managed Database was created.
    encrypted Boolean
    Whether the Managed Databases is encrypted.
    engine String
    The Managed Database engine. (e.g. mysql)
    hostPrimary String
    The primary host for the Managed Database.
    hostSecondary String
    The secondary/private host for the managed database.
    id String
    The provider-assigned unique ID for this managed resource.
    members Map<String,String>
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime String
    The oldest time to which a database can be restored.
    pendingUpdates List<DatabaseMysqlV2PendingUpdate>
    A set of pending updates.
    platform String
    The back-end platform for relational databases used by the service.
    port Integer
    The access port for this Managed Database.
    rootPassword String
    The randomly-generated root password for the Managed Database instance.
    rootUsername String
    The root username for the Managed Database instance.
    sslConnection Boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status String
    The operating status of the Managed Database.
    updated String
    When this Managed Database was last updated.
    version String
    The Managed Database engine version. (e.g. 13.2)
    caCert string
    The base64-encoded SSL CA certificate for the Managed Database.
    created string
    When this Managed Database was created.
    encrypted boolean
    Whether the Managed Databases is encrypted.
    engine string
    The Managed Database engine. (e.g. mysql)
    hostPrimary string
    The primary host for the Managed Database.
    hostSecondary string
    The secondary/private host for the managed database.
    id string
    The provider-assigned unique ID for this managed resource.
    members {[key: string]: string}
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime string
    The oldest time to which a database can be restored.
    pendingUpdates DatabaseMysqlV2PendingUpdate[]
    A set of pending updates.
    platform string
    The back-end platform for relational databases used by the service.
    port number
    The access port for this Managed Database.
    rootPassword string
    The randomly-generated root password for the Managed Database instance.
    rootUsername string
    The root username for the Managed Database instance.
    sslConnection boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status string
    The operating status of the Managed Database.
    updated string
    When this Managed Database was last updated.
    version string
    The Managed Database engine version. (e.g. 13.2)
    ca_cert str
    The base64-encoded SSL CA certificate for the Managed Database.
    created str
    When this Managed Database was created.
    encrypted bool
    Whether the Managed Databases is encrypted.
    engine str
    The Managed Database engine. (e.g. mysql)
    host_primary str
    The primary host for the Managed Database.
    host_secondary str
    The secondary/private host for the managed database.
    id str
    The provider-assigned unique ID for this managed resource.
    members Mapping[str, str]
    A mapping between IP addresses and strings designating them as primary or failover.
    oldest_restore_time str
    The oldest time to which a database can be restored.
    pending_updates Sequence[DatabaseMysqlV2PendingUpdate]
    A set of pending updates.
    platform str
    The back-end platform for relational databases used by the service.
    port int
    The access port for this Managed Database.
    root_password str
    The randomly-generated root password for the Managed Database instance.
    root_username str
    The root username for the Managed Database instance.
    ssl_connection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status str
    The operating status of the Managed Database.
    updated str
    When this Managed Database was last updated.
    version str
    The Managed Database engine version. (e.g. 13.2)
    caCert String
    The base64-encoded SSL CA certificate for the Managed Database.
    created String
    When this Managed Database was created.
    encrypted Boolean
    Whether the Managed Databases is encrypted.
    engine String
    The Managed Database engine. (e.g. mysql)
    hostPrimary String
    The primary host for the Managed Database.
    hostSecondary String
    The secondary/private host for the managed database.
    id String
    The provider-assigned unique ID for this managed resource.
    members Map<String>
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime String
    The oldest time to which a database can be restored.
    pendingUpdates List<Property Map>
    A set of pending updates.
    platform String
    The back-end platform for relational databases used by the service.
    port Number
    The access port for this Managed Database.
    rootPassword String
    The randomly-generated root password for the Managed Database instance.
    rootUsername String
    The root username for the Managed Database instance.
    sslConnection Boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status String
    The operating status of the Managed Database.
    updated String
    When this Managed Database was last updated.
    version String
    The Managed Database engine version. (e.g. 13.2)

    Look up Existing DatabaseMysqlV2 Resource

    Get an existing DatabaseMysqlV2 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?: DatabaseMysqlV2State, opts?: CustomResourceOptions): DatabaseMysqlV2
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        allow_lists: Optional[Sequence[str]] = None,
        ca_cert: Optional[str] = None,
        cluster_size: Optional[int] = None,
        created: Optional[str] = None,
        encrypted: Optional[bool] = None,
        engine: Optional[str] = None,
        engine_config_binlog_retention_period: Optional[int] = None,
        engine_config_mysql_connect_timeout: Optional[int] = None,
        engine_config_mysql_default_time_zone: Optional[str] = None,
        engine_config_mysql_group_concat_max_len: Optional[float] = None,
        engine_config_mysql_information_schema_stats_expiry: Optional[int] = None,
        engine_config_mysql_innodb_change_buffer_max_size: Optional[int] = None,
        engine_config_mysql_innodb_flush_neighbors: Optional[int] = None,
        engine_config_mysql_innodb_ft_min_token_size: Optional[int] = None,
        engine_config_mysql_innodb_ft_server_stopword_table: Optional[str] = None,
        engine_config_mysql_innodb_lock_wait_timeout: Optional[int] = None,
        engine_config_mysql_innodb_log_buffer_size: Optional[int] = None,
        engine_config_mysql_innodb_online_alter_log_max_size: Optional[int] = None,
        engine_config_mysql_innodb_read_io_threads: Optional[int] = None,
        engine_config_mysql_innodb_rollback_on_timeout: Optional[bool] = None,
        engine_config_mysql_innodb_thread_concurrency: Optional[int] = None,
        engine_config_mysql_innodb_write_io_threads: Optional[int] = None,
        engine_config_mysql_interactive_timeout: Optional[int] = None,
        engine_config_mysql_internal_tmp_mem_storage_engine: Optional[str] = None,
        engine_config_mysql_max_allowed_packet: Optional[int] = None,
        engine_config_mysql_max_heap_table_size: Optional[int] = None,
        engine_config_mysql_net_buffer_length: Optional[int] = None,
        engine_config_mysql_net_read_timeout: Optional[int] = None,
        engine_config_mysql_net_write_timeout: Optional[int] = None,
        engine_config_mysql_sort_buffer_size: Optional[int] = None,
        engine_config_mysql_sql_mode: Optional[str] = None,
        engine_config_mysql_sql_require_primary_key: Optional[bool] = None,
        engine_config_mysql_tmp_table_size: Optional[int] = None,
        engine_config_mysql_wait_timeout: Optional[int] = None,
        engine_id: Optional[str] = None,
        fork_restore_time: Optional[str] = None,
        fork_source: Optional[int] = None,
        host_primary: Optional[str] = None,
        host_secondary: Optional[str] = None,
        label: Optional[str] = None,
        members: Optional[Mapping[str, str]] = None,
        oldest_restore_time: Optional[str] = None,
        pending_updates: Optional[Sequence[DatabaseMysqlV2PendingUpdateArgs]] = None,
        platform: Optional[str] = None,
        port: Optional[int] = None,
        region: Optional[str] = None,
        root_password: Optional[str] = None,
        root_username: Optional[str] = None,
        ssl_connection: Optional[bool] = None,
        status: Optional[str] = None,
        suspended: Optional[bool] = None,
        timeouts: Optional[DatabaseMysqlV2TimeoutsArgs] = None,
        type: Optional[str] = None,
        updated: Optional[str] = None,
        updates: Optional[DatabaseMysqlV2UpdatesArgs] = None,
        version: Optional[str] = None) -> DatabaseMysqlV2
    func GetDatabaseMysqlV2(ctx *Context, name string, id IDInput, state *DatabaseMysqlV2State, opts ...ResourceOption) (*DatabaseMysqlV2, error)
    public static DatabaseMysqlV2 Get(string name, Input<string> id, DatabaseMysqlV2State? state, CustomResourceOptions? opts = null)
    public static DatabaseMysqlV2 get(String name, Output<String> id, DatabaseMysqlV2State state, CustomResourceOptions options)
    resources:  _:    type: linode:DatabaseMysqlV2    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:
    AllowLists List<string>
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    CaCert string
    The base64-encoded SSL CA certificate for the Managed Database.
    ClusterSize int
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    Created string
    When this Managed Database was created.
    Encrypted bool
    Whether the Managed Databases is encrypted.
    Engine string
    The Managed Database engine. (e.g. mysql)
    EngineConfigBinlogRetentionPeriod 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.
    EngineConfigMysqlConnectTimeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    EngineConfigMysqlDefaultTimeZone 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.
    EngineConfigMysqlGroupConcatMaxLen double
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    EngineConfigMysqlInformationSchemaStatsExpiry int
    The time, in seconds, before cached statistics expire.
    EngineConfigMysqlInnodbChangeBufferMaxSize int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    EngineConfigMysqlInnodbFlushNeighbors 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.
    EngineConfigMysqlInnodbFtMinTokenSize 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.
    EngineConfigMysqlInnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    EngineConfigMysqlInnodbLockWaitTimeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    EngineConfigMysqlInnodbLogBufferSize int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    EngineConfigMysqlInnodbOnlineAlterLogMaxSize int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    EngineConfigMysqlInnodbReadIoThreads 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.
    EngineConfigMysqlInnodbRollbackOnTimeout 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.
    EngineConfigMysqlInnodbThreadConcurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    EngineConfigMysqlInnodbWriteIoThreads 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.
    EngineConfigMysqlInteractiveTimeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    EngineConfigMysqlInternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    EngineConfigMysqlMaxAllowedPacket int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    EngineConfigMysqlMaxHeapTableSize int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    EngineConfigMysqlNetBufferLength 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.
    EngineConfigMysqlNetReadTimeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    EngineConfigMysqlNetWriteTimeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    EngineConfigMysqlSortBufferSize int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    EngineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    EngineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    EngineConfigMysqlTmpTableSize int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    EngineConfigMysqlWaitTimeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    EngineId string
    The Managed Database engine in engine/version format. (e.g. mysql)
    ForkRestoreTime string
    The database timestamp from which it was restored.
    ForkSource int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    HostPrimary string
    The primary host for the Managed Database.
    HostSecondary string
    The secondary/private host for the managed database.
    Label string
    A unique, user-defined string referring to the Managed Database.
    Members Dictionary<string, string>
    A mapping between IP addresses and strings designating them as primary or failover.
    OldestRestoreTime string
    The oldest time to which a database can be restored.
    PendingUpdates List<DatabaseMysqlV2PendingUpdate>
    A set of pending updates.
    Platform string
    The back-end platform for relational databases used by the service.
    Port int
    The access port for this Managed Database.
    Region string
    The region to use for the Managed Database.
    RootPassword string
    The randomly-generated root password for the Managed Database instance.
    RootUsername string
    The root username for the Managed Database instance.
    SslConnection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    Status string
    The operating status of the Managed Database.
    Suspended bool
    Whether this Managed Database should be suspended.
    Timeouts DatabaseMysqlV2Timeouts
    Type string
    The Linode Instance type used for the nodes of the Managed Database.

    Updated string
    When this Managed Database was last updated.
    Updates DatabaseMysqlV2Updates
    Configuration settings for automated patch update maintenance for the Managed Database.
    Version string
    The Managed Database engine version. (e.g. 13.2)
    AllowLists []string
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    CaCert string
    The base64-encoded SSL CA certificate for the Managed Database.
    ClusterSize int
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    Created string
    When this Managed Database was created.
    Encrypted bool
    Whether the Managed Databases is encrypted.
    Engine string
    The Managed Database engine. (e.g. mysql)
    EngineConfigBinlogRetentionPeriod 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.
    EngineConfigMysqlConnectTimeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    EngineConfigMysqlDefaultTimeZone 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.
    EngineConfigMysqlGroupConcatMaxLen float64
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    EngineConfigMysqlInformationSchemaStatsExpiry int
    The time, in seconds, before cached statistics expire.
    EngineConfigMysqlInnodbChangeBufferMaxSize int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    EngineConfigMysqlInnodbFlushNeighbors 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.
    EngineConfigMysqlInnodbFtMinTokenSize 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.
    EngineConfigMysqlInnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    EngineConfigMysqlInnodbLockWaitTimeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    EngineConfigMysqlInnodbLogBufferSize int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    EngineConfigMysqlInnodbOnlineAlterLogMaxSize int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    EngineConfigMysqlInnodbReadIoThreads 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.
    EngineConfigMysqlInnodbRollbackOnTimeout 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.
    EngineConfigMysqlInnodbThreadConcurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    EngineConfigMysqlInnodbWriteIoThreads 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.
    EngineConfigMysqlInteractiveTimeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    EngineConfigMysqlInternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    EngineConfigMysqlMaxAllowedPacket int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    EngineConfigMysqlMaxHeapTableSize int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    EngineConfigMysqlNetBufferLength 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.
    EngineConfigMysqlNetReadTimeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    EngineConfigMysqlNetWriteTimeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    EngineConfigMysqlSortBufferSize int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    EngineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    EngineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    EngineConfigMysqlTmpTableSize int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    EngineConfigMysqlWaitTimeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    EngineId string
    The Managed Database engine in engine/version format. (e.g. mysql)
    ForkRestoreTime string
    The database timestamp from which it was restored.
    ForkSource int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    HostPrimary string
    The primary host for the Managed Database.
    HostSecondary string
    The secondary/private host for the managed database.
    Label string
    A unique, user-defined string referring to the Managed Database.
    Members map[string]string
    A mapping between IP addresses and strings designating them as primary or failover.
    OldestRestoreTime string
    The oldest time to which a database can be restored.
    PendingUpdates []DatabaseMysqlV2PendingUpdateArgs
    A set of pending updates.
    Platform string
    The back-end platform for relational databases used by the service.
    Port int
    The access port for this Managed Database.
    Region string
    The region to use for the Managed Database.
    RootPassword string
    The randomly-generated root password for the Managed Database instance.
    RootUsername string
    The root username for the Managed Database instance.
    SslConnection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    Status string
    The operating status of the Managed Database.
    Suspended bool
    Whether this Managed Database should be suspended.
    Timeouts DatabaseMysqlV2TimeoutsArgs
    Type string
    The Linode Instance type used for the nodes of the Managed Database.

    Updated string
    When this Managed Database was last updated.
    Updates DatabaseMysqlV2UpdatesArgs
    Configuration settings for automated patch update maintenance for the Managed Database.
    Version string
    The Managed Database engine version. (e.g. 13.2)
    allowLists List<String>
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    caCert String
    The base64-encoded SSL CA certificate for the Managed Database.
    clusterSize Integer
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    created String
    When this Managed Database was created.
    encrypted Boolean
    Whether the Managed Databases is encrypted.
    engine String
    The Managed Database engine. (e.g. mysql)
    engineConfigBinlogRetentionPeriod 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.
    engineConfigMysqlConnectTimeout Integer
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    engineConfigMysqlDefaultTimeZone 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.
    engineConfigMysqlGroupConcatMaxLen Double
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    engineConfigMysqlInformationSchemaStatsExpiry Integer
    The time, in seconds, before cached statistics expire.
    engineConfigMysqlInnodbChangeBufferMaxSize Integer
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    engineConfigMysqlInnodbFlushNeighbors 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.
    engineConfigMysqlInnodbFtMinTokenSize 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.
    engineConfigMysqlInnodbFtServerStopwordTable String
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    engineConfigMysqlInnodbLockWaitTimeout Integer
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    engineConfigMysqlInnodbLogBufferSize Integer
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    engineConfigMysqlInnodbOnlineAlterLogMaxSize Integer
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    engineConfigMysqlInnodbReadIoThreads 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.
    engineConfigMysqlInnodbRollbackOnTimeout 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.
    engineConfigMysqlInnodbThreadConcurrency Integer
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    engineConfigMysqlInnodbWriteIoThreads 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.
    engineConfigMysqlInteractiveTimeout Integer
    The number of seconds the server waits for activity on an interactive connection before closing it.
    engineConfigMysqlInternalTmpMemStorageEngine String
    The storage engine for in-memory internal temporary tables.
    engineConfigMysqlMaxAllowedPacket Integer
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    engineConfigMysqlMaxHeapTableSize Integer
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    engineConfigMysqlNetBufferLength 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.
    engineConfigMysqlNetReadTimeout Integer
    The number of seconds to wait for more data from a connection before aborting the read.
    engineConfigMysqlNetWriteTimeout Integer
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    engineConfigMysqlSortBufferSize Integer
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    engineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    engineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    engineConfigMysqlTmpTableSize Integer
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    engineConfigMysqlWaitTimeout Integer
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    engineId String
    The Managed Database engine in engine/version format. (e.g. mysql)
    forkRestoreTime String
    The database timestamp from which it was restored.
    forkSource Integer
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    hostPrimary String
    The primary host for the Managed Database.
    hostSecondary String
    The secondary/private host for the managed database.
    label String
    A unique, user-defined string referring to the Managed Database.
    members Map<String,String>
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime String
    The oldest time to which a database can be restored.
    pendingUpdates List<DatabaseMysqlV2PendingUpdate>
    A set of pending updates.
    platform String
    The back-end platform for relational databases used by the service.
    port Integer
    The access port for this Managed Database.
    region String
    The region to use for the Managed Database.
    rootPassword String
    The randomly-generated root password for the Managed Database instance.
    rootUsername String
    The root username for the Managed Database instance.
    sslConnection Boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status String
    The operating status of the Managed Database.
    suspended Boolean
    Whether this Managed Database should be suspended.
    timeouts DatabaseMysqlV2Timeouts
    type String
    The Linode Instance type used for the nodes of the Managed Database.

    updated String
    When this Managed Database was last updated.
    updates DatabaseMysqlV2Updates
    Configuration settings for automated patch update maintenance for the Managed Database.
    version String
    The Managed Database engine version. (e.g. 13.2)
    allowLists string[]
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    caCert string
    The base64-encoded SSL CA certificate for the Managed Database.
    clusterSize number
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    created string
    When this Managed Database was created.
    encrypted boolean
    Whether the Managed Databases is encrypted.
    engine string
    The Managed Database engine. (e.g. mysql)
    engineConfigBinlogRetentionPeriod 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.
    engineConfigMysqlConnectTimeout number
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    engineConfigMysqlDefaultTimeZone 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.
    engineConfigMysqlGroupConcatMaxLen number
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    engineConfigMysqlInformationSchemaStatsExpiry number
    The time, in seconds, before cached statistics expire.
    engineConfigMysqlInnodbChangeBufferMaxSize number
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    engineConfigMysqlInnodbFlushNeighbors 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.
    engineConfigMysqlInnodbFtMinTokenSize 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.
    engineConfigMysqlInnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    engineConfigMysqlInnodbLockWaitTimeout number
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    engineConfigMysqlInnodbLogBufferSize number
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    engineConfigMysqlInnodbOnlineAlterLogMaxSize number
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    engineConfigMysqlInnodbReadIoThreads 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.
    engineConfigMysqlInnodbRollbackOnTimeout 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.
    engineConfigMysqlInnodbThreadConcurrency number
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    engineConfigMysqlInnodbWriteIoThreads 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.
    engineConfigMysqlInteractiveTimeout number
    The number of seconds the server waits for activity on an interactive connection before closing it.
    engineConfigMysqlInternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    engineConfigMysqlMaxAllowedPacket number
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    engineConfigMysqlMaxHeapTableSize number
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    engineConfigMysqlNetBufferLength 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.
    engineConfigMysqlNetReadTimeout number
    The number of seconds to wait for more data from a connection before aborting the read.
    engineConfigMysqlNetWriteTimeout number
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    engineConfigMysqlSortBufferSize number
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    engineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    engineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    engineConfigMysqlTmpTableSize number
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    engineConfigMysqlWaitTimeout number
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    engineId string
    The Managed Database engine in engine/version format. (e.g. mysql)
    forkRestoreTime string
    The database timestamp from which it was restored.
    forkSource number
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    hostPrimary string
    The primary host for the Managed Database.
    hostSecondary string
    The secondary/private host for the managed database.
    label string
    A unique, user-defined string referring to the Managed Database.
    members {[key: string]: string}
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime string
    The oldest time to which a database can be restored.
    pendingUpdates DatabaseMysqlV2PendingUpdate[]
    A set of pending updates.
    platform string
    The back-end platform for relational databases used by the service.
    port number
    The access port for this Managed Database.
    region string
    The region to use for the Managed Database.
    rootPassword string
    The randomly-generated root password for the Managed Database instance.
    rootUsername string
    The root username for the Managed Database instance.
    sslConnection boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status string
    The operating status of the Managed Database.
    suspended boolean
    Whether this Managed Database should be suspended.
    timeouts DatabaseMysqlV2Timeouts
    type string
    The Linode Instance type used for the nodes of the Managed Database.

    updated string
    When this Managed Database was last updated.
    updates DatabaseMysqlV2Updates
    Configuration settings for automated patch update maintenance for the Managed Database.
    version string
    The Managed Database engine version. (e.g. 13.2)
    allow_lists Sequence[str]
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    ca_cert str
    The base64-encoded SSL CA certificate for the Managed Database.
    cluster_size int
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    created str
    When this Managed Database was created.
    encrypted bool
    Whether the Managed Databases is encrypted.
    engine str
    The Managed Database engine. (e.g. mysql)
    engine_config_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.
    engine_config_mysql_connect_timeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    engine_config_mysql_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.
    engine_config_mysql_group_concat_max_len float
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    engine_config_mysql_information_schema_stats_expiry int
    The time, in seconds, before cached statistics expire.
    engine_config_mysql_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.
    engine_config_mysql_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.
    engine_config_mysql_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.
    engine_config_mysql_innodb_ft_server_stopword_table str
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    engine_config_mysql_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.
    engine_config_mysql_innodb_log_buffer_size int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    engine_config_mysql_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.
    engine_config_mysql_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.
    engine_config_mysql_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.
    engine_config_mysql_innodb_thread_concurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    engine_config_mysql_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.
    engine_config_mysql_interactive_timeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    engine_config_mysql_internal_tmp_mem_storage_engine str
    The storage engine for in-memory internal temporary tables.
    engine_config_mysql_max_allowed_packet int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    engine_config_mysql_max_heap_table_size int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    engine_config_mysql_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.
    engine_config_mysql_net_read_timeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    engine_config_mysql_net_write_timeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    engine_config_mysql_sort_buffer_size int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    engine_config_mysql_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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    engine_config_mysql_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. (default true)
    engine_config_mysql_tmp_table_size int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    engine_config_mysql_wait_timeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    engine_id str
    The Managed Database engine in engine/version format. (e.g. mysql)
    fork_restore_time str
    The database timestamp from which it was restored.
    fork_source int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    host_primary str
    The primary host for the Managed Database.
    host_secondary str
    The secondary/private host for the managed database.
    label str
    A unique, user-defined string referring to the Managed Database.
    members Mapping[str, str]
    A mapping between IP addresses and strings designating them as primary or failover.
    oldest_restore_time str
    The oldest time to which a database can be restored.
    pending_updates Sequence[DatabaseMysqlV2PendingUpdateArgs]
    A set of pending updates.
    platform str
    The back-end platform for relational databases used by the service.
    port int
    The access port for this Managed Database.
    region str
    The region to use for the Managed Database.
    root_password str
    The randomly-generated root password for the Managed Database instance.
    root_username str
    The root username for the Managed Database instance.
    ssl_connection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status str
    The operating status of the Managed Database.
    suspended bool
    Whether this Managed Database should be suspended.
    timeouts DatabaseMysqlV2TimeoutsArgs
    type str
    The Linode Instance type used for the nodes of the Managed Database.

    updated str
    When this Managed Database was last updated.
    updates DatabaseMysqlV2UpdatesArgs
    Configuration settings for automated patch update maintenance for the Managed Database.
    version str
    The Managed Database engine version. (e.g. 13.2)
    allowLists List<String>
    A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
    caCert String
    The base64-encoded SSL CA certificate for the Managed Database.
    clusterSize Number
    The number of Linode Instance nodes deployed to the Managed Database. (default 1)
    created String
    When this Managed Database was created.
    encrypted Boolean
    Whether the Managed Databases is encrypted.
    engine String
    The Managed Database engine. (e.g. mysql)
    engineConfigBinlogRetentionPeriod 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.
    engineConfigMysqlConnectTimeout Number
    The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
    engineConfigMysqlDefaultTimeZone 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.
    engineConfigMysqlGroupConcatMaxLen Number
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    engineConfigMysqlInformationSchemaStatsExpiry Number
    The time, in seconds, before cached statistics expire.
    engineConfigMysqlInnodbChangeBufferMaxSize Number
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    engineConfigMysqlInnodbFlushNeighbors 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.
    engineConfigMysqlInnodbFtMinTokenSize 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.
    engineConfigMysqlInnodbFtServerStopwordTable String
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. This field is nullable.
    engineConfigMysqlInnodbLockWaitTimeout Number
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    engineConfigMysqlInnodbLogBufferSize Number
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    engineConfigMysqlInnodbOnlineAlterLogMaxSize Number
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    engineConfigMysqlInnodbReadIoThreads 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.
    engineConfigMysqlInnodbRollbackOnTimeout 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.
    engineConfigMysqlInnodbThreadConcurrency Number
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    engineConfigMysqlInnodbWriteIoThreads 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.
    engineConfigMysqlInteractiveTimeout Number
    The number of seconds the server waits for activity on an interactive connection before closing it.
    engineConfigMysqlInternalTmpMemStorageEngine String
    The storage engine for in-memory internal temporary tables.
    engineConfigMysqlMaxAllowedPacket Number
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    engineConfigMysqlMaxHeapTableSize Number
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    engineConfigMysqlNetBufferLength 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.
    engineConfigMysqlNetReadTimeout Number
    The number of seconds to wait for more data from a connection before aborting the read.
    engineConfigMysqlNetWriteTimeout Number
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    engineConfigMysqlSortBufferSize Number
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    engineConfigMysqlSqlMode 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. (default ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES)
    engineConfigMysqlSqlRequirePrimaryKey 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. (default true)
    engineConfigMysqlTmpTableSize Number
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    engineConfigMysqlWaitTimeout Number
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    engineId String
    The Managed Database engine in engine/version format. (e.g. mysql)
    forkRestoreTime String
    The database timestamp from which it was restored.
    forkSource Number
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    hostPrimary String
    The primary host for the Managed Database.
    hostSecondary String
    The secondary/private host for the managed database.
    label String
    A unique, user-defined string referring to the Managed Database.
    members Map<String>
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime String
    The oldest time to which a database can be restored.
    pendingUpdates List<Property Map>
    A set of pending updates.
    platform String
    The back-end platform for relational databases used by the service.
    port Number
    The access port for this Managed Database.
    region String
    The region to use for the Managed Database.
    rootPassword String
    The randomly-generated root password for the Managed Database instance.
    rootUsername String
    The root username for the Managed Database instance.
    sslConnection Boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status String
    The operating status of the Managed Database.
    suspended Boolean
    Whether this Managed Database should be suspended.
    timeouts Property Map
    type String
    The Linode Instance type used for the nodes of the Managed Database.

    updated String
    When this Managed Database was last updated.
    updates Property Map
    Configuration settings for automated patch update maintenance for the Managed Database.
    version String
    The Managed Database engine version. (e.g. 13.2)

    Supporting Types

    DatabaseMysqlV2PendingUpdate, DatabaseMysqlV2PendingUpdateArgs

    Deadline string
    Description string
    PlannedFor string
    Deadline string
    Description string
    PlannedFor string
    deadline String
    description String
    plannedFor String
    deadline string
    description string
    plannedFor string
    deadline String
    description String
    plannedFor String

    DatabaseMysqlV2Timeouts, DatabaseMysqlV2TimeoutsArgs

    Create string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    Delete string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    Update string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    Create string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    Delete string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    Update string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    create String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    delete String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    update String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    create string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    delete string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    update string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    create str
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    delete str
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    update str
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    create String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    delete String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    update String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).

    DatabaseMysqlV2Updates, DatabaseMysqlV2UpdatesArgs

    dayOfWeek Integer
    duration Integer
    frequency String
    hourOfDay Integer
    dayOfWeek number
    duration number
    frequency string
    hourOfDay number
    dayOfWeek Number
    duration Number
    frequency String
    hourOfDay Number

    Import

    Linode MySQL Databases can be imported using the id, e.g.

    $ pulumi import linode:index/databaseMysqlV2:DatabaseMysqlV2 foobar 1234567

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Linode pulumi/pulumi-linode
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the linode Terraform Provider.
    linode logo
    Linode v5.1.1 published on Thursday, Jul 31, 2025 by Pulumi
    pulumi/pulumi-linode