Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. DigitalOcean Provider
  3. API Docs
  4. DatabaseMysqlConfig
DigitalOcean v4.42.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-digitalocean

digitalocean.DatabaseMysqlConfig

Explore with Pulumi AI

DigitalOcean v4.42.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-digitalocean

Provides a virtual resource that can be used to change advanced configuration options for a DigitalOcean managed MySQL database cluster.

Note MySQL configurations are only removed from state when destroyed. The remote configuration is not unset.

Example Usage

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

const exampleDatabaseCluster = new digitalocean.DatabaseCluster("example", {
    name: "example-mysql-cluster",
    engine: "mysql",
    version: "8",
    size: digitalocean.DatabaseSlug.DB_1VPCU1GB,
    region: digitalocean.Region.NYC1,
    nodeCount: 1,
});
const example = new digitalocean.DatabaseMysqlConfig("example", {
    clusterId: exampleDatabaseCluster.id,
    connectTimeout: 10,
    defaultTimeZone: "UTC",
});
Copy
import pulumi
import pulumi_digitalocean as digitalocean

example_database_cluster = digitalocean.DatabaseCluster("example",
    name="example-mysql-cluster",
    engine="mysql",
    version="8",
    size=digitalocean.DatabaseSlug.D_B_1_VPCU1_GB,
    region=digitalocean.Region.NYC1,
    node_count=1)
example = digitalocean.DatabaseMysqlConfig("example",
    cluster_id=example_database_cluster.id,
    connect_timeout=10,
    default_time_zone="UTC")
Copy
package main

import (
	"github.com/pulumi/pulumi-digitalocean/sdk/v4/go/digitalocean"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		exampleDatabaseCluster, err := digitalocean.NewDatabaseCluster(ctx, "example", &digitalocean.DatabaseClusterArgs{
			Name:      pulumi.String("example-mysql-cluster"),
			Engine:    pulumi.String("mysql"),
			Version:   pulumi.String("8"),
			Size:      pulumi.String(digitalocean.DatabaseSlug_DB_1VPCU1GB),
			Region:    pulumi.String(digitalocean.RegionNYC1),
			NodeCount: pulumi.Int(1),
		})
		if err != nil {
			return err
		}
		_, err = digitalocean.NewDatabaseMysqlConfig(ctx, "example", &digitalocean.DatabaseMysqlConfigArgs{
			ClusterId:       exampleDatabaseCluster.ID(),
			ConnectTimeout:  pulumi.Int(10),
			DefaultTimeZone: pulumi.String("UTC"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using DigitalOcean = Pulumi.DigitalOcean;

return await Deployment.RunAsync(() => 
{
    var exampleDatabaseCluster = new DigitalOcean.DatabaseCluster("example", new()
    {
        Name = "example-mysql-cluster",
        Engine = "mysql",
        Version = "8",
        Size = DigitalOcean.DatabaseSlug.DB_1VPCU1GB,
        Region = DigitalOcean.Region.NYC1,
        NodeCount = 1,
    });

    var example = new DigitalOcean.DatabaseMysqlConfig("example", new()
    {
        ClusterId = exampleDatabaseCluster.Id,
        ConnectTimeout = 10,
        DefaultTimeZone = "UTC",
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.digitalocean.DatabaseCluster;
import com.pulumi.digitalocean.DatabaseClusterArgs;
import com.pulumi.digitalocean.DatabaseMysqlConfig;
import com.pulumi.digitalocean.DatabaseMysqlConfigArgs;
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 exampleDatabaseCluster = new DatabaseCluster("exampleDatabaseCluster", DatabaseClusterArgs.builder()
            .name("example-mysql-cluster")
            .engine("mysql")
            .version("8")
            .size("db-s-1vcpu-1gb")
            .region("nyc1")
            .nodeCount(1)
            .build());

        var example = new DatabaseMysqlConfig("example", DatabaseMysqlConfigArgs.builder()
            .clusterId(exampleDatabaseCluster.id())
            .connectTimeout(10)
            .defaultTimeZone("UTC")
            .build());

    }
}
Copy
resources:
  example:
    type: digitalocean:DatabaseMysqlConfig
    properties:
      clusterId: ${exampleDatabaseCluster.id}
      connectTimeout: 10
      defaultTimeZone: UTC
  exampleDatabaseCluster:
    type: digitalocean:DatabaseCluster
    name: example
    properties:
      name: example-mysql-cluster
      engine: mysql
      version: '8'
      size: db-s-1vcpu-1gb
      region: nyc1
      nodeCount: 1
Copy

Create DatabaseMysqlConfig Resource

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

Constructor syntax

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

@overload
def DatabaseMysqlConfig(resource_name: str,
                        opts: Optional[ResourceOptions] = None,
                        cluster_id: Optional[str] = None,
                        innodb_rollback_on_timeout: Optional[bool] = None,
                        sql_require_primary_key: Optional[bool] = None,
                        backup_minute: Optional[int] = None,
                        connect_timeout: Optional[int] = None,
                        default_time_zone: Optional[str] = None,
                        group_concat_max_len: Optional[int] = None,
                        information_schema_stats_expiry: Optional[int] = None,
                        innodb_ft_min_token_size: Optional[int] = None,
                        innodb_ft_server_stopword_table: Optional[str] = None,
                        innodb_lock_wait_timeout: Optional[int] = None,
                        innodb_log_buffer_size: Optional[int] = None,
                        interactive_timeout: Optional[int] = None,
                        binlog_retention_period: Optional[int] = None,
                        innodb_print_all_deadlocks: Optional[bool] = None,
                        innodb_online_alter_log_max_size: Optional[int] = None,
                        internal_tmp_mem_storage_engine: Optional[str] = None,
                        long_query_time: Optional[float] = None,
                        max_allowed_packet: Optional[int] = None,
                        max_heap_table_size: Optional[int] = None,
                        net_read_timeout: Optional[int] = None,
                        net_write_timeout: Optional[int] = None,
                        slow_query_log: Optional[bool] = None,
                        sort_buffer_size: Optional[int] = None,
                        sql_mode: Optional[str] = None,
                        backup_hour: Optional[int] = None,
                        tmp_table_size: Optional[int] = None,
                        wait_timeout: Optional[int] = None)
func NewDatabaseMysqlConfig(ctx *Context, name string, args DatabaseMysqlConfigArgs, opts ...ResourceOption) (*DatabaseMysqlConfig, error)
public DatabaseMysqlConfig(string name, DatabaseMysqlConfigArgs args, CustomResourceOptions? opts = null)
public DatabaseMysqlConfig(String name, DatabaseMysqlConfigArgs args)
public DatabaseMysqlConfig(String name, DatabaseMysqlConfigArgs args, CustomResourceOptions options)

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

Parameters

name This property is required. string
The unique name of the resource.
args This property is required. DatabaseMysqlConfigArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. DatabaseMysqlConfigArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name This property is required. string
The unique name of the resource.
args This property is required. DatabaseMysqlConfigArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. DatabaseMysqlConfigArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. DatabaseMysqlConfigArgs
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 databaseMysqlConfigResource = new DigitalOcean.DatabaseMysqlConfig("databaseMysqlConfigResource", new()
{
    ClusterId = "string",
    InnodbRollbackOnTimeout = false,
    SqlRequirePrimaryKey = false,
    BackupMinute = 0,
    ConnectTimeout = 0,
    DefaultTimeZone = "string",
    GroupConcatMaxLen = 0,
    InformationSchemaStatsExpiry = 0,
    InnodbFtMinTokenSize = 0,
    InnodbFtServerStopwordTable = "string",
    InnodbLockWaitTimeout = 0,
    InnodbLogBufferSize = 0,
    InteractiveTimeout = 0,
    BinlogRetentionPeriod = 0,
    InnodbPrintAllDeadlocks = false,
    InnodbOnlineAlterLogMaxSize = 0,
    InternalTmpMemStorageEngine = "string",
    LongQueryTime = 0,
    MaxAllowedPacket = 0,
    MaxHeapTableSize = 0,
    NetReadTimeout = 0,
    NetWriteTimeout = 0,
    SlowQueryLog = false,
    SortBufferSize = 0,
    SqlMode = "string",
    BackupHour = 0,
    TmpTableSize = 0,
    WaitTimeout = 0,
});
Copy
example, err := digitalocean.NewDatabaseMysqlConfig(ctx, "databaseMysqlConfigResource", &digitalocean.DatabaseMysqlConfigArgs{
	ClusterId:                    pulumi.String("string"),
	InnodbRollbackOnTimeout:      pulumi.Bool(false),
	SqlRequirePrimaryKey:         pulumi.Bool(false),
	BackupMinute:                 pulumi.Int(0),
	ConnectTimeout:               pulumi.Int(0),
	DefaultTimeZone:              pulumi.String("string"),
	GroupConcatMaxLen:            pulumi.Int(0),
	InformationSchemaStatsExpiry: pulumi.Int(0),
	InnodbFtMinTokenSize:         pulumi.Int(0),
	InnodbFtServerStopwordTable:  pulumi.String("string"),
	InnodbLockWaitTimeout:        pulumi.Int(0),
	InnodbLogBufferSize:          pulumi.Int(0),
	InteractiveTimeout:           pulumi.Int(0),
	BinlogRetentionPeriod:        pulumi.Int(0),
	InnodbPrintAllDeadlocks:      pulumi.Bool(false),
	InnodbOnlineAlterLogMaxSize:  pulumi.Int(0),
	InternalTmpMemStorageEngine:  pulumi.String("string"),
	LongQueryTime:                pulumi.Float64(0),
	MaxAllowedPacket:             pulumi.Int(0),
	MaxHeapTableSize:             pulumi.Int(0),
	NetReadTimeout:               pulumi.Int(0),
	NetWriteTimeout:              pulumi.Int(0),
	SlowQueryLog:                 pulumi.Bool(false),
	SortBufferSize:               pulumi.Int(0),
	SqlMode:                      pulumi.String("string"),
	BackupHour:                   pulumi.Int(0),
	TmpTableSize:                 pulumi.Int(0),
	WaitTimeout:                  pulumi.Int(0),
})
Copy
var databaseMysqlConfigResource = new DatabaseMysqlConfig("databaseMysqlConfigResource", DatabaseMysqlConfigArgs.builder()
    .clusterId("string")
    .innodbRollbackOnTimeout(false)
    .sqlRequirePrimaryKey(false)
    .backupMinute(0)
    .connectTimeout(0)
    .defaultTimeZone("string")
    .groupConcatMaxLen(0)
    .informationSchemaStatsExpiry(0)
    .innodbFtMinTokenSize(0)
    .innodbFtServerStopwordTable("string")
    .innodbLockWaitTimeout(0)
    .innodbLogBufferSize(0)
    .interactiveTimeout(0)
    .binlogRetentionPeriod(0)
    .innodbPrintAllDeadlocks(false)
    .innodbOnlineAlterLogMaxSize(0)
    .internalTmpMemStorageEngine("string")
    .longQueryTime(0)
    .maxAllowedPacket(0)
    .maxHeapTableSize(0)
    .netReadTimeout(0)
    .netWriteTimeout(0)
    .slowQueryLog(false)
    .sortBufferSize(0)
    .sqlMode("string")
    .backupHour(0)
    .tmpTableSize(0)
    .waitTimeout(0)
    .build());
Copy
database_mysql_config_resource = digitalocean.DatabaseMysqlConfig("databaseMysqlConfigResource",
    cluster_id="string",
    innodb_rollback_on_timeout=False,
    sql_require_primary_key=False,
    backup_minute=0,
    connect_timeout=0,
    default_time_zone="string",
    group_concat_max_len=0,
    information_schema_stats_expiry=0,
    innodb_ft_min_token_size=0,
    innodb_ft_server_stopword_table="string",
    innodb_lock_wait_timeout=0,
    innodb_log_buffer_size=0,
    interactive_timeout=0,
    binlog_retention_period=0,
    innodb_print_all_deadlocks=False,
    innodb_online_alter_log_max_size=0,
    internal_tmp_mem_storage_engine="string",
    long_query_time=0,
    max_allowed_packet=0,
    max_heap_table_size=0,
    net_read_timeout=0,
    net_write_timeout=0,
    slow_query_log=False,
    sort_buffer_size=0,
    sql_mode="string",
    backup_hour=0,
    tmp_table_size=0,
    wait_timeout=0)
Copy
const databaseMysqlConfigResource = new digitalocean.DatabaseMysqlConfig("databaseMysqlConfigResource", {
    clusterId: "string",
    innodbRollbackOnTimeout: false,
    sqlRequirePrimaryKey: false,
    backupMinute: 0,
    connectTimeout: 0,
    defaultTimeZone: "string",
    groupConcatMaxLen: 0,
    informationSchemaStatsExpiry: 0,
    innodbFtMinTokenSize: 0,
    innodbFtServerStopwordTable: "string",
    innodbLockWaitTimeout: 0,
    innodbLogBufferSize: 0,
    interactiveTimeout: 0,
    binlogRetentionPeriod: 0,
    innodbPrintAllDeadlocks: false,
    innodbOnlineAlterLogMaxSize: 0,
    internalTmpMemStorageEngine: "string",
    longQueryTime: 0,
    maxAllowedPacket: 0,
    maxHeapTableSize: 0,
    netReadTimeout: 0,
    netWriteTimeout: 0,
    slowQueryLog: false,
    sortBufferSize: 0,
    sqlMode: "string",
    backupHour: 0,
    tmpTableSize: 0,
    waitTimeout: 0,
});
Copy
type: digitalocean:DatabaseMysqlConfig
properties:
    backupHour: 0
    backupMinute: 0
    binlogRetentionPeriod: 0
    clusterId: string
    connectTimeout: 0
    defaultTimeZone: string
    groupConcatMaxLen: 0
    informationSchemaStatsExpiry: 0
    innodbFtMinTokenSize: 0
    innodbFtServerStopwordTable: string
    innodbLockWaitTimeout: 0
    innodbLogBufferSize: 0
    innodbOnlineAlterLogMaxSize: 0
    innodbPrintAllDeadlocks: false
    innodbRollbackOnTimeout: false
    interactiveTimeout: 0
    internalTmpMemStorageEngine: string
    longQueryTime: 0
    maxAllowedPacket: 0
    maxHeapTableSize: 0
    netReadTimeout: 0
    netWriteTimeout: 0
    slowQueryLog: false
    sortBufferSize: 0
    sqlMode: string
    sqlRequirePrimaryKey: false
    tmpTableSize: 0
    waitTimeout: 0
Copy

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

ClusterId
This property is required.
Changes to this property will trigger replacement.
string
The ID of the target MySQL cluster.
BackupHour int
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
BackupMinute int
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
BinlogRetentionPeriod int
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
ConnectTimeout int
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
DefaultTimeZone string
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
GroupConcatMaxLen int
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
InformationSchemaStatsExpiry int
The time, in seconds, before cached statistics expire.
InnodbFtMinTokenSize int
The minimum length of words that an InnoDB FULLTEXT index stores.
InnodbFtServerStopwordTable string
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
InnodbLockWaitTimeout int
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
InnodbLogBufferSize int
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
InnodbOnlineAlterLogMaxSize int
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
InnodbPrintAllDeadlocks bool
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
InnodbRollbackOnTimeout bool
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
InteractiveTimeout int
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
InternalTmpMemStorageEngine string
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
LongQueryTime double
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
MaxAllowedPacket int
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
MaxHeapTableSize int
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
NetReadTimeout int
The time, in seconds, to wait for more data from an existing connection. aborting the read.
NetWriteTimeout int
The number of seconds to wait for a block to be written to a connection before aborting the write.
SlowQueryLog bool
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
SortBufferSize int
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
SqlMode string
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
SqlRequirePrimaryKey bool
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
TmpTableSize int
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
WaitTimeout int
The number of seconds the server waits for activity on a noninteractive connection before closing it.
ClusterId
This property is required.
Changes to this property will trigger replacement.
string
The ID of the target MySQL cluster.
BackupHour int
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
BackupMinute int
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
BinlogRetentionPeriod int
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
ConnectTimeout int
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
DefaultTimeZone string
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
GroupConcatMaxLen int
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
InformationSchemaStatsExpiry int
The time, in seconds, before cached statistics expire.
InnodbFtMinTokenSize int
The minimum length of words that an InnoDB FULLTEXT index stores.
InnodbFtServerStopwordTable string
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
InnodbLockWaitTimeout int
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
InnodbLogBufferSize int
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
InnodbOnlineAlterLogMaxSize int
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
InnodbPrintAllDeadlocks bool
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
InnodbRollbackOnTimeout bool
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
InteractiveTimeout int
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
InternalTmpMemStorageEngine string
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
LongQueryTime float64
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
MaxAllowedPacket int
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
MaxHeapTableSize int
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
NetReadTimeout int
The time, in seconds, to wait for more data from an existing connection. aborting the read.
NetWriteTimeout int
The number of seconds to wait for a block to be written to a connection before aborting the write.
SlowQueryLog bool
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
SortBufferSize int
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
SqlMode string
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
SqlRequirePrimaryKey bool
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
TmpTableSize int
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
WaitTimeout int
The number of seconds the server waits for activity on a noninteractive connection before closing it.
clusterId
This property is required.
Changes to this property will trigger replacement.
String
The ID of the target MySQL cluster.
backupHour Integer
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
backupMinute Integer
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
binlogRetentionPeriod Integer
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
connectTimeout Integer
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
defaultTimeZone String
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
groupConcatMaxLen Integer
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
informationSchemaStatsExpiry Integer
The time, in seconds, before cached statistics expire.
innodbFtMinTokenSize Integer
The minimum length of words that an InnoDB FULLTEXT index stores.
innodbFtServerStopwordTable String
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodbLockWaitTimeout Integer
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
innodbLogBufferSize Integer
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
innodbOnlineAlterLogMaxSize Integer
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
innodbPrintAllDeadlocks Boolean
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
innodbRollbackOnTimeout Boolean
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
interactiveTimeout Integer
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
internalTmpMemStorageEngine String
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
longQueryTime Double
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
maxAllowedPacket Integer
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
maxHeapTableSize Integer
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
netReadTimeout Integer
The time, in seconds, to wait for more data from an existing connection. aborting the read.
netWriteTimeout Integer
The number of seconds to wait for a block to be written to a connection before aborting the write.
slowQueryLog Boolean
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
sortBufferSize Integer
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
sqlMode String
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
sqlRequirePrimaryKey Boolean
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize Integer
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
waitTimeout Integer
The number of seconds the server waits for activity on a noninteractive connection before closing it.
clusterId
This property is required.
Changes to this property will trigger replacement.
string
The ID of the target MySQL cluster.
backupHour number
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
backupMinute number
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
binlogRetentionPeriod number
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
connectTimeout number
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
defaultTimeZone string
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
groupConcatMaxLen number
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
informationSchemaStatsExpiry number
The time, in seconds, before cached statistics expire.
innodbFtMinTokenSize number
The minimum length of words that an InnoDB FULLTEXT index stores.
innodbFtServerStopwordTable string
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodbLockWaitTimeout number
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
innodbLogBufferSize number
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
innodbOnlineAlterLogMaxSize number
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
innodbPrintAllDeadlocks boolean
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
innodbRollbackOnTimeout boolean
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
interactiveTimeout number
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
internalTmpMemStorageEngine string
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
longQueryTime number
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
maxAllowedPacket number
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
maxHeapTableSize number
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
netReadTimeout number
The time, in seconds, to wait for more data from an existing connection. aborting the read.
netWriteTimeout number
The number of seconds to wait for a block to be written to a connection before aborting the write.
slowQueryLog boolean
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
sortBufferSize number
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
sqlMode string
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
sqlRequirePrimaryKey boolean
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize number
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
waitTimeout number
The number of seconds the server waits for activity on a noninteractive connection before closing it.
cluster_id
This property is required.
Changes to this property will trigger replacement.
str
The ID of the target MySQL cluster.
backup_hour int
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
backup_minute int
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
binlog_retention_period int
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
connect_timeout int
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
default_time_zone str
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
group_concat_max_len int
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
information_schema_stats_expiry int
The time, in seconds, before cached statistics expire.
innodb_ft_min_token_size int
The minimum length of words that an InnoDB FULLTEXT index stores.
innodb_ft_server_stopword_table str
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodb_lock_wait_timeout int
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
innodb_log_buffer_size int
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
innodb_online_alter_log_max_size int
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
innodb_print_all_deadlocks bool
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
innodb_rollback_on_timeout bool
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
interactive_timeout int
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
internal_tmp_mem_storage_engine str
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
long_query_time float
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
max_allowed_packet int
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
max_heap_table_size int
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
net_read_timeout int
The time, in seconds, to wait for more data from an existing connection. aborting the read.
net_write_timeout int
The number of seconds to wait for a block to be written to a connection before aborting the write.
slow_query_log bool
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
sort_buffer_size int
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
sql_mode str
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
sql_require_primary_key bool
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmp_table_size int
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
wait_timeout int
The number of seconds the server waits for activity on a noninteractive connection before closing it.
clusterId
This property is required.
Changes to this property will trigger replacement.
String
The ID of the target MySQL cluster.
backupHour Number
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
backupMinute Number
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
binlogRetentionPeriod Number
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
connectTimeout Number
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
defaultTimeZone String
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
groupConcatMaxLen Number
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
informationSchemaStatsExpiry Number
The time, in seconds, before cached statistics expire.
innodbFtMinTokenSize Number
The minimum length of words that an InnoDB FULLTEXT index stores.
innodbFtServerStopwordTable String
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodbLockWaitTimeout Number
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
innodbLogBufferSize Number
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
innodbOnlineAlterLogMaxSize Number
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
innodbPrintAllDeadlocks Boolean
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
innodbRollbackOnTimeout Boolean
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
interactiveTimeout Number
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
internalTmpMemStorageEngine String
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
longQueryTime Number
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
maxAllowedPacket Number
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
maxHeapTableSize Number
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
netReadTimeout Number
The time, in seconds, to wait for more data from an existing connection. aborting the read.
netWriteTimeout Number
The number of seconds to wait for a block to be written to a connection before aborting the write.
slowQueryLog Boolean
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
sortBufferSize Number
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
sqlMode String
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
sqlRequirePrimaryKey Boolean
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize Number
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
waitTimeout Number
The number of seconds the server waits for activity on a noninteractive connection before closing it.

Outputs

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

Id string
The provider-assigned unique ID for this managed resource.
Id string
The provider-assigned unique ID for this managed resource.
id String
The provider-assigned unique ID for this managed resource.
id string
The provider-assigned unique ID for this managed resource.
id str
The provider-assigned unique ID for this managed resource.
id String
The provider-assigned unique ID for this managed resource.

Look up Existing DatabaseMysqlConfig Resource

Get an existing DatabaseMysqlConfig 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?: DatabaseMysqlConfigState, opts?: CustomResourceOptions): DatabaseMysqlConfig
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        backup_hour: Optional[int] = None,
        backup_minute: Optional[int] = None,
        binlog_retention_period: Optional[int] = None,
        cluster_id: Optional[str] = None,
        connect_timeout: Optional[int] = None,
        default_time_zone: Optional[str] = None,
        group_concat_max_len: Optional[int] = None,
        information_schema_stats_expiry: Optional[int] = None,
        innodb_ft_min_token_size: Optional[int] = None,
        innodb_ft_server_stopword_table: Optional[str] = None,
        innodb_lock_wait_timeout: Optional[int] = None,
        innodb_log_buffer_size: Optional[int] = None,
        innodb_online_alter_log_max_size: Optional[int] = None,
        innodb_print_all_deadlocks: Optional[bool] = None,
        innodb_rollback_on_timeout: Optional[bool] = None,
        interactive_timeout: Optional[int] = None,
        internal_tmp_mem_storage_engine: Optional[str] = None,
        long_query_time: Optional[float] = None,
        max_allowed_packet: Optional[int] = None,
        max_heap_table_size: Optional[int] = None,
        net_read_timeout: Optional[int] = None,
        net_write_timeout: Optional[int] = None,
        slow_query_log: Optional[bool] = None,
        sort_buffer_size: Optional[int] = None,
        sql_mode: Optional[str] = None,
        sql_require_primary_key: Optional[bool] = None,
        tmp_table_size: Optional[int] = None,
        wait_timeout: Optional[int] = None) -> DatabaseMysqlConfig
func GetDatabaseMysqlConfig(ctx *Context, name string, id IDInput, state *DatabaseMysqlConfigState, opts ...ResourceOption) (*DatabaseMysqlConfig, error)
public static DatabaseMysqlConfig Get(string name, Input<string> id, DatabaseMysqlConfigState? state, CustomResourceOptions? opts = null)
public static DatabaseMysqlConfig get(String name, Output<String> id, DatabaseMysqlConfigState state, CustomResourceOptions options)
resources:  _:    type: digitalocean:DatabaseMysqlConfig    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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:
BackupHour int
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
BackupMinute int
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
BinlogRetentionPeriod int
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
ClusterId Changes to this property will trigger replacement. string
The ID of the target MySQL cluster.
ConnectTimeout int
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
DefaultTimeZone string
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
GroupConcatMaxLen int
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
InformationSchemaStatsExpiry int
The time, in seconds, before cached statistics expire.
InnodbFtMinTokenSize int
The minimum length of words that an InnoDB FULLTEXT index stores.
InnodbFtServerStopwordTable string
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
InnodbLockWaitTimeout int
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
InnodbLogBufferSize int
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
InnodbOnlineAlterLogMaxSize int
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
InnodbPrintAllDeadlocks bool
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
InnodbRollbackOnTimeout bool
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
InteractiveTimeout int
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
InternalTmpMemStorageEngine string
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
LongQueryTime double
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
MaxAllowedPacket int
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
MaxHeapTableSize int
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
NetReadTimeout int
The time, in seconds, to wait for more data from an existing connection. aborting the read.
NetWriteTimeout int
The number of seconds to wait for a block to be written to a connection before aborting the write.
SlowQueryLog bool
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
SortBufferSize int
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
SqlMode string
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
SqlRequirePrimaryKey bool
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
TmpTableSize int
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
WaitTimeout int
The number of seconds the server waits for activity on a noninteractive connection before closing it.
BackupHour int
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
BackupMinute int
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
BinlogRetentionPeriod int
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
ClusterId Changes to this property will trigger replacement. string
The ID of the target MySQL cluster.
ConnectTimeout int
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
DefaultTimeZone string
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
GroupConcatMaxLen int
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
InformationSchemaStatsExpiry int
The time, in seconds, before cached statistics expire.
InnodbFtMinTokenSize int
The minimum length of words that an InnoDB FULLTEXT index stores.
InnodbFtServerStopwordTable string
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
InnodbLockWaitTimeout int
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
InnodbLogBufferSize int
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
InnodbOnlineAlterLogMaxSize int
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
InnodbPrintAllDeadlocks bool
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
InnodbRollbackOnTimeout bool
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
InteractiveTimeout int
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
InternalTmpMemStorageEngine string
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
LongQueryTime float64
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
MaxAllowedPacket int
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
MaxHeapTableSize int
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
NetReadTimeout int
The time, in seconds, to wait for more data from an existing connection. aborting the read.
NetWriteTimeout int
The number of seconds to wait for a block to be written to a connection before aborting the write.
SlowQueryLog bool
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
SortBufferSize int
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
SqlMode string
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
SqlRequirePrimaryKey bool
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
TmpTableSize int
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
WaitTimeout int
The number of seconds the server waits for activity on a noninteractive connection before closing it.
backupHour Integer
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
backupMinute Integer
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
binlogRetentionPeriod Integer
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
clusterId Changes to this property will trigger replacement. String
The ID of the target MySQL cluster.
connectTimeout Integer
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
defaultTimeZone String
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
groupConcatMaxLen Integer
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
informationSchemaStatsExpiry Integer
The time, in seconds, before cached statistics expire.
innodbFtMinTokenSize Integer
The minimum length of words that an InnoDB FULLTEXT index stores.
innodbFtServerStopwordTable String
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodbLockWaitTimeout Integer
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
innodbLogBufferSize Integer
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
innodbOnlineAlterLogMaxSize Integer
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
innodbPrintAllDeadlocks Boolean
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
innodbRollbackOnTimeout Boolean
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
interactiveTimeout Integer
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
internalTmpMemStorageEngine String
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
longQueryTime Double
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
maxAllowedPacket Integer
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
maxHeapTableSize Integer
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
netReadTimeout Integer
The time, in seconds, to wait for more data from an existing connection. aborting the read.
netWriteTimeout Integer
The number of seconds to wait for a block to be written to a connection before aborting the write.
slowQueryLog Boolean
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
sortBufferSize Integer
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
sqlMode String
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
sqlRequirePrimaryKey Boolean
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize Integer
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
waitTimeout Integer
The number of seconds the server waits for activity on a noninteractive connection before closing it.
backupHour number
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
backupMinute number
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
binlogRetentionPeriod number
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
clusterId Changes to this property will trigger replacement. string
The ID of the target MySQL cluster.
connectTimeout number
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
defaultTimeZone string
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
groupConcatMaxLen number
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
informationSchemaStatsExpiry number
The time, in seconds, before cached statistics expire.
innodbFtMinTokenSize number
The minimum length of words that an InnoDB FULLTEXT index stores.
innodbFtServerStopwordTable string
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodbLockWaitTimeout number
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
innodbLogBufferSize number
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
innodbOnlineAlterLogMaxSize number
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
innodbPrintAllDeadlocks boolean
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
innodbRollbackOnTimeout boolean
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
interactiveTimeout number
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
internalTmpMemStorageEngine string
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
longQueryTime number
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
maxAllowedPacket number
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
maxHeapTableSize number
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
netReadTimeout number
The time, in seconds, to wait for more data from an existing connection. aborting the read.
netWriteTimeout number
The number of seconds to wait for a block to be written to a connection before aborting the write.
slowQueryLog boolean
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
sortBufferSize number
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
sqlMode string
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
sqlRequirePrimaryKey boolean
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize number
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
waitTimeout number
The number of seconds the server waits for activity on a noninteractive connection before closing it.
backup_hour int
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
backup_minute int
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
binlog_retention_period int
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
cluster_id Changes to this property will trigger replacement. str
The ID of the target MySQL cluster.
connect_timeout int
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
default_time_zone str
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
group_concat_max_len int
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
information_schema_stats_expiry int
The time, in seconds, before cached statistics expire.
innodb_ft_min_token_size int
The minimum length of words that an InnoDB FULLTEXT index stores.
innodb_ft_server_stopword_table str
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodb_lock_wait_timeout int
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
innodb_log_buffer_size int
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
innodb_online_alter_log_max_size int
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
innodb_print_all_deadlocks bool
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
innodb_rollback_on_timeout bool
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
interactive_timeout int
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
internal_tmp_mem_storage_engine str
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
long_query_time float
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
max_allowed_packet int
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
max_heap_table_size int
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
net_read_timeout int
The time, in seconds, to wait for more data from an existing connection. aborting the read.
net_write_timeout int
The number of seconds to wait for a block to be written to a connection before aborting the write.
slow_query_log bool
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
sort_buffer_size int
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
sql_mode str
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
sql_require_primary_key bool
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmp_table_size int
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
wait_timeout int
The number of seconds the server waits for activity on a noninteractive connection before closing it.
backupHour Number
The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
backupMinute Number
The minute of the backup hour when backup for the service starts. New backup only starts if previous backup has already completed.
binlogRetentionPeriod Number
The minimum amount of time, in seconds, to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
clusterId Changes to this property will trigger replacement. String
The ID of the target MySQL cluster.
connectTimeout Number
The number of seconds that the mysqld server waits for a connect packet before responding with bad handshake.
defaultTimeZone String
Default server time zone, in the form of an offset from UTC (from -12:00 to +12:00), a time zone name (EST), or SYSTEM to use the MySQL server default.
groupConcatMaxLen Number
The maximum permitted result length, in bytes, for the GROUP_CONCAT() function.
informationSchemaStatsExpiry Number
The time, in seconds, before cached statistics expire.
innodbFtMinTokenSize Number
The minimum length of words that an InnoDB FULLTEXT index stores.
innodbFtServerStopwordTable String
The InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodbLockWaitTimeout Number
The time, in seconds, that an InnoDB transaction waits for a row lock. before giving up.
innodbLogBufferSize Number
The size of the buffer, in bytes, that InnoDB uses to write to the log files. on disk.
innodbOnlineAlterLogMaxSize Number
The upper limit, in bytes, of the size of the temporary log files used during online DDL operations for InnoDB tables.
innodbPrintAllDeadlocks Boolean
When enabled, records information about all deadlocks in InnoDB user transactions in the error log. Disabled by default.
innodbRollbackOnTimeout Boolean
When enabled, transaction timeouts cause InnoDB to abort and roll back the entire transaction.
interactiveTimeout Number
The time, in seconds, the server waits for activity on an interactive. connection before closing it.
internalTmpMemStorageEngine String
The storage engine for in-memory internal temporary tables. Supported values are: TempTable, MEMORY.
longQueryTime Number
The time, in seconds, for a query to take to execute before being captured by slow_query_logs. Default is 10 seconds.
maxAllowedPacket Number
The size of the largest message, in bytes, that can be received by the server. Default is 67108864 (64M).
maxHeapTableSize Number
The maximum size, in bytes, of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
netReadTimeout Number
The time, in seconds, to wait for more data from an existing connection. aborting the read.
netWriteTimeout Number
The number of seconds to wait for a block to be written to a connection before aborting the write.
slowQueryLog Boolean
When enabled, captures slow queries. When disabled, also truncates the mysql.slow_log table. Default is false.
sortBufferSize Number
The sort buffer size, in bytes, for ORDER BY optimization. Default is 262144. (256K).
sqlMode String
Global SQL mode. If empty, uses MySQL server defaults. Must only include uppercase alphabetic characters, underscores, and commas.
sqlRequirePrimaryKey Boolean
Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize Number
The maximum size, in bytes, of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
waitTimeout Number
The number of seconds the server waits for activity on a noninteractive connection before closing it.

Import

A MySQL database cluster’s configuration can be imported using the id the parent cluster, e.g.

$ pulumi import digitalocean:index/databaseMysqlConfig:DatabaseMysqlConfig example 4b62829a-9c42-465b-aaa3-84051048e712
Copy

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

Package Details

Repository
DigitalOcean pulumi/pulumi-digitalocean
License
Apache-2.0
Notes
This Pulumi package is based on the digitalocean Terraform Provider.
DigitalOcean v4.42.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-digitalocean