1. Packages
  2. DigitalOcean
  3. API Docs
  4. DatabaseMysqlConfig
DigitalOcean v4.30.2 published on Wednesday, Jun 5, 2024 by Pulumi

digitalocean.DatabaseMysqlConfig

Explore with Pulumi AI

digitalocean logo
DigitalOcean v4.30.2 published on Wednesday, Jun 5, 2024 by Pulumi

    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",
    });
    
    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")
    
    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
    	})
    }
    
    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",
        });
    
    });
    
    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());
    
        }
    }
    
    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
    

    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,
                            wait_timeout: Optional[int] = None,
                            innodb_print_all_deadlocks: Optional[bool] = 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,
                            backup_minute: Optional[int] = None,
                            binlog_retention_period: Optional[int] = None,
                            slow_query_log: Optional[bool] = 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,
                            interactive_timeout: Optional[int] = 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,
                            backup_hour: 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 string
    The unique name of the resource.
    args DatabaseMysqlConfigArgs
    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 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 string
    The unique name of the resource.
    args DatabaseMysqlConfigArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatabaseMysqlConfigArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args 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,
        WaitTimeout = 0,
        InnodbPrintAllDeadlocks = false,
        ConnectTimeout = 0,
        DefaultTimeZone = "string",
        GroupConcatMaxLen = 0,
        InformationSchemaStatsExpiry = 0,
        InnodbFtMinTokenSize = 0,
        InnodbFtServerStopwordTable = "string",
        InnodbLockWaitTimeout = 0,
        InnodbLogBufferSize = 0,
        InnodbOnlineAlterLogMaxSize = 0,
        BackupMinute = 0,
        BinlogRetentionPeriod = 0,
        SlowQueryLog = false,
        InternalTmpMemStorageEngine = "string",
        LongQueryTime = 0,
        MaxAllowedPacket = 0,
        MaxHeapTableSize = 0,
        NetReadTimeout = 0,
        NetWriteTimeout = 0,
        InteractiveTimeout = 0,
        SortBufferSize = 0,
        SqlMode = "string",
        SqlRequirePrimaryKey = false,
        TmpTableSize = 0,
        BackupHour = 0,
    });
    
    example, err := digitalocean.NewDatabaseMysqlConfig(ctx, "databaseMysqlConfigResource", &digitalocean.DatabaseMysqlConfigArgs{
    	ClusterId:                    pulumi.String("string"),
    	InnodbRollbackOnTimeout:      pulumi.Bool(false),
    	WaitTimeout:                  pulumi.Int(0),
    	InnodbPrintAllDeadlocks:      pulumi.Bool(false),
    	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),
    	InnodbOnlineAlterLogMaxSize:  pulumi.Int(0),
    	BackupMinute:                 pulumi.Int(0),
    	BinlogRetentionPeriod:        pulumi.Int(0),
    	SlowQueryLog:                 pulumi.Bool(false),
    	InternalTmpMemStorageEngine:  pulumi.String("string"),
    	LongQueryTime:                pulumi.Float64(0),
    	MaxAllowedPacket:             pulumi.Int(0),
    	MaxHeapTableSize:             pulumi.Int(0),
    	NetReadTimeout:               pulumi.Int(0),
    	NetWriteTimeout:              pulumi.Int(0),
    	InteractiveTimeout:           pulumi.Int(0),
    	SortBufferSize:               pulumi.Int(0),
    	SqlMode:                      pulumi.String("string"),
    	SqlRequirePrimaryKey:         pulumi.Bool(false),
    	TmpTableSize:                 pulumi.Int(0),
    	BackupHour:                   pulumi.Int(0),
    })
    
    var databaseMysqlConfigResource = new DatabaseMysqlConfig("databaseMysqlConfigResource", DatabaseMysqlConfigArgs.builder()
        .clusterId("string")
        .innodbRollbackOnTimeout(false)
        .waitTimeout(0)
        .innodbPrintAllDeadlocks(false)
        .connectTimeout(0)
        .defaultTimeZone("string")
        .groupConcatMaxLen(0)
        .informationSchemaStatsExpiry(0)
        .innodbFtMinTokenSize(0)
        .innodbFtServerStopwordTable("string")
        .innodbLockWaitTimeout(0)
        .innodbLogBufferSize(0)
        .innodbOnlineAlterLogMaxSize(0)
        .backupMinute(0)
        .binlogRetentionPeriod(0)
        .slowQueryLog(false)
        .internalTmpMemStorageEngine("string")
        .longQueryTime(0)
        .maxAllowedPacket(0)
        .maxHeapTableSize(0)
        .netReadTimeout(0)
        .netWriteTimeout(0)
        .interactiveTimeout(0)
        .sortBufferSize(0)
        .sqlMode("string")
        .sqlRequirePrimaryKey(false)
        .tmpTableSize(0)
        .backupHour(0)
        .build());
    
    database_mysql_config_resource = digitalocean.DatabaseMysqlConfig("databaseMysqlConfigResource",
        cluster_id="string",
        innodb_rollback_on_timeout=False,
        wait_timeout=0,
        innodb_print_all_deadlocks=False,
        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,
        innodb_online_alter_log_max_size=0,
        backup_minute=0,
        binlog_retention_period=0,
        slow_query_log=False,
        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,
        interactive_timeout=0,
        sort_buffer_size=0,
        sql_mode="string",
        sql_require_primary_key=False,
        tmp_table_size=0,
        backup_hour=0)
    
    const databaseMysqlConfigResource = new digitalocean.DatabaseMysqlConfig("databaseMysqlConfigResource", {
        clusterId: "string",
        innodbRollbackOnTimeout: false,
        waitTimeout: 0,
        innodbPrintAllDeadlocks: false,
        connectTimeout: 0,
        defaultTimeZone: "string",
        groupConcatMaxLen: 0,
        informationSchemaStatsExpiry: 0,
        innodbFtMinTokenSize: 0,
        innodbFtServerStopwordTable: "string",
        innodbLockWaitTimeout: 0,
        innodbLogBufferSize: 0,
        innodbOnlineAlterLogMaxSize: 0,
        backupMinute: 0,
        binlogRetentionPeriod: 0,
        slowQueryLog: false,
        internalTmpMemStorageEngine: "string",
        longQueryTime: 0,
        maxAllowedPacket: 0,
        maxHeapTableSize: 0,
        netReadTimeout: 0,
        netWriteTimeout: 0,
        interactiveTimeout: 0,
        sortBufferSize: 0,
        sqlMode: "string",
        sqlRequirePrimaryKey: false,
        tmpTableSize: 0,
        backupHour: 0,
    });
    
    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
    

    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

    The DatabaseMysqlConfig resource accepts the following input properties:

    ClusterId 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 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 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 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 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 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)
    Resource lookup is not supported in YAML
    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:
    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 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 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 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 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 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 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
    

    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 logo
    DigitalOcean v4.30.2 published on Wednesday, Jun 5, 2024 by Pulumi