digitalocean.DatabaseAdvancedMysqlConfig

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

Note Advanced 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-advanced-mysql-cluster",
    engine: "advanced_mysql",
    version: "8",
    size: digitalocean.DatabaseSlug.DB_1VPCU1GB,
    region: digitalocean.Region.NYC1,
    nodeCount: 1,
});
const example = new digitalocean.DatabaseAdvancedMysqlConfig("example", {
    clusterId: exampleDatabaseCluster.id,
    mysqlParameters: {
        time_zone: "SYSTEM",
        connect_timeout: "10",
    },
});

import pulumi
import pulumi_digitalocean as digitalocean

example_database_cluster = digitalocean.DatabaseCluster("example",
    name="example-advanced-mysql-cluster",
    engine="advanced_mysql",
    version="8",
    size=digitalocean.DatabaseSlug.D_B_1_VPCU1_GB,
    region=digitalocean.Region.NYC1,
    node_count=1)
example = digitalocean.DatabaseAdvancedMysqlConfig("example",
    cluster_id=example_database_cluster.id,
    mysql_parameters={
        "time_zone": "SYSTEM",
        "connect_timeout": "10",
    })

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-advanced-mysql-cluster"),
			Engine:    pulumi.String("advanced_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.NewDatabaseAdvancedMysqlConfig(ctx, "example", &digitalocean.DatabaseAdvancedMysqlConfigArgs{
			ClusterId: exampleDatabaseCluster.ID().ToIDOutput().ToStringOutput(),
			MysqlParameters: pulumi.StringMap{
				"time_zone":       pulumi.String("SYSTEM"),
				"connect_timeout": pulumi.String("10"),
			},
		})
		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-advanced-mysql-cluster",
        Engine = "advanced_mysql",
        Version = "8",
        Size = DigitalOcean.DatabaseSlug.DB_1VPCU1GB,
        Region = DigitalOcean.Region.NYC1,
        NodeCount = 1,
    });

    var example = new DigitalOcean.DatabaseAdvancedMysqlConfig("example", new()
    {
        ClusterId = exampleDatabaseCluster.Id,
        MysqlParameters = 
        {
            { "time_zone", "SYSTEM" },
            { "connect_timeout", "10" },
        },
    });

});

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.DatabaseAdvancedMysqlConfig;
import com.pulumi.digitalocean.DatabaseAdvancedMysqlConfigArgs;
import java.util.ArrayList;
import java.util.Arrays;
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-advanced-mysql-cluster")
            .engine("advanced_mysql")
            .version("8")
            .size("db-s-1vcpu-1gb")
            .region("nyc1")
            .nodeCount(1)
            .build());

        var example = new DatabaseAdvancedMysqlConfig("example", DatabaseAdvancedMysqlConfigArgs.builder()
            .clusterId(exampleDatabaseCluster.id())
            .mysqlParameters(Map.ofEntries(
                Map.entry("time_zone", "SYSTEM"),
                Map.entry("connect_timeout", "10")
            ))
            .build());

    }
}

resources:
  example:
    type: digitalocean:DatabaseAdvancedMysqlConfig
    properties:
      clusterId: ${exampleDatabaseCluster.id}
      mysqlParameters:
        time_zone: SYSTEM
        connect_timeout: '10'
  exampleDatabaseCluster:
    type: digitalocean:DatabaseCluster
    name: example
    properties:
      name: example-advanced-mysql-cluster
      engine: advanced_mysql
      version: '8'
      size: db-s-1vcpu-1gb
      region: nyc1
      nodeCount: 1

pulumi {
  required_providers {
    digitalocean = {
      source = "pulumi/digitalocean"
    }
  }
}

resource "digitalocean_databaseadvancedmysqlconfig" "example" {
  cluster_id = digitalocean_databasecluster.example.id
  mysql_parameters = {
    "time_zone"       = "SYSTEM"
    "connect_timeout" = "10"
  }
}
resource "digitalocean_databasecluster" "example" {
  name       = "example-advanced-mysql-cluster"
  engine     = "advanced_mysql"
  version    = "8"
  size       = "db-s-1vcpu-1gb"
  region     = "nyc1"
  node_count = 1
}

Supported mysqlParameters

The following MySQL system variables can be set on advancedMysql clusters. Default values and restart requirements are returned by the DigitalOcean API and may vary by cluster size.

• backLog - (Optional) Pending connection queue size. Default: 512. Requires restart.
• binlogCacheSize - (Optional) Cache for transaction binlog events. Default: 32768.
• binlogChecksum - (Optional) Checksum: CRC32 or NONE. Default: CRC32.
• binlogExpireLogsSeconds - (Optional) Seconds before binlogs purged. Default: 2592000.
• binlogFormat - (Optional) Format: ROW, STATEMENT, or MIXED. Default: ROW.
• binlogGroupCommitSyncDelay - (Optional) Microseconds delay before sync. Default: 0.
• binlogGroupCommitSyncNoDelayCount - (Optional) Max txns to wait before sync. Default: 0.
• binlogOrderCommits - (Optional) Commit in binlog write order. Default: ON.
• binlogRowImage - (Optional) Row images: full, minimal, noblob. Default: full.
• binlogRowMetadata - (Optional) Metadata: MINIMAL or FULL. Default: FULL.
• binlogStmtCacheSize - (Optional) Cache for non-transactional binlog events. Default: 32768.
• binlogTransactionCompression - (Optional) Enable binlog txn compression. Default: OFF.
• binlogTransactionCompressionLevelZstd - (Optional) zstd level (1-22). Default: 3.
• characterSetServer - (Optional) Server character set for new databases. Default: utf8mb4. Requires restart.
• collationServer - (Optional) Server default collation for new databases. Default: utf8mb40900AiCi. Requires restart.
• connectTimeout - (Optional) Seconds for connection handshake. Default: 10.
• connectionMemoryChunkSize - (Optional) Connection memory accounting chunk. Default: 8192.
• connectionMemoryLimit - (Optional) Per-connection memory limit. Default: 9223372036854775807.
• cteMaxRecursionDepth - (Optional) Max CTE recursion depth. Default: 1000.
• eqRangeIndexDiveLimit - (Optional) Ranges before switching to stats. Default: 200.
• explicitDefaultsForTimestamp - (Optional) Explicit TIMESTAMP defaults. Default: ON.
• generalLog - (Optional) Enable general query log. Default: OFF.
• globalConnectionMemoryLimit - (Optional) Global memory limit all connections. Default: 9223372036854775807.
• globalConnectionMemoryTracking - (Optional) Per-connection memory tracking. Default: OFF.
• groupConcatMaxLen - (Optional) Max GROUP_CONCAT() result length. Default: 1024.
• groupReplicationCommunicationMaxMessageSize - (Optional) Max message size for Group Replication. Default: 10485760. Requires restart.
• groupReplicationConsistency - (Optional) Transaction consistency level for Group Replication. Default: BEFORE_ON_PRIMARY_FAILOVER.
• groupReplicationFlowControlMode - (Optional) Group Replication flow control mode. Default: QUOTA.
• groupReplicationFlowControlPeriod - (Optional) Seconds between flow control quota checks. Default: 1. Requires restart.
• groupReplicationMessageCacheSize - (Optional) Maximum memory used by Group Replication to cache messages. Default: 1073741824. Requires restart.
• groupReplicationPaxosSingleLeader - (Optional) Single-leader Paxos mode for Group Replication. Default: OFF.
• groupReplicationPollSpinLoops - (Optional) Spin loops before Group Replication poll. Default: 0.
• groupReplicationUnreachableMajorityTimeout - (Optional) Seconds before partitioned member action. Default: 5.
• informationSchemaStatsExpiry - (Optional) Seconds before cached schema stats expire. Default: 86400.
• innodbAdaptiveFlushing - (Optional) Adaptive flushing of dirty pages. Default: ON.
• innodbAdaptiveFlushingLwm - (Optional) Low water mark % for adaptive flushing. Default: 10.
• innodbAdaptiveHashIndex - (Optional) Enable/disable adaptive hash index. Default: ON.
• innodbAutoextendIncrement - (Optional) Tablespace auto-extend increment in MB. Default: 64.
• innodbBufferPoolSize - (Optional) Size in bytes of the InnoDB buffer pool. Default: 134217728.
• innodbChangeBufferMaxSize - (Optional) Max change buffer as % of pool. Default: 25.
• innodbChangeBuffering - (Optional) Types of operations buffered in change buffer. Default: all.
• innodbCompressionFailureThresholdPct - (Optional) Compression failure % before padding. Default: 5.
• innodbCompressionLevel - (Optional) zlib compression level (0-9). Default: 6.
• innodbCompressionPadPctMax - (Optional) Max % page padding for compressed tables. Default: 50.
• innodbConcurrencyTickets - (Optional) Tickets for thread re-entry without concurrency check. Default: 5000.
• innodbCorruptTableAction - (Optional) On corrupt table: assert, warn, salvage. Default: warn.
• innodbDdlThreads - (Optional) Threads for DDL sort/build operations. Default: 2. Requires restart.
• innodbDeadlockDetect - (Optional) Enable/disable deadlock detection. Default: ON.
• innodbFillFactor - (Optional) Fill factor for B-tree bulk load. Default: 100.
• innodbFlushLogAtTrxCommit - (Optional) Controls log flushing on transaction commit. Default: 1.
• innodbFlushMethod - (Optional) Method for flushing data to disk. Default: O_DIRECT. Requires restart.
• innodbFlushSync - (Optional) Ignore ioCapacity during checkpoints. Default: ON.
• innodbFsyncThreshold - (Optional) Bytes threshold for fsync on file create. Default: 0.
• innodbFtMaxTokenSize - (Optional) Max word length for full-text index. Default: 84. Requires restart.
• innodbFtMinTokenSize - (Optional) Min word length for full-text index. Default: 3. Requires restart.
• innodbFtServerStopwordTable - (Optional) Table for full-text stopwords.
• innodbIoCapacity - (Optional) Background I/O operations per second. Default: 200.
• innodbIoCapacityMax - (Optional) Upper limit for background I/O operations. Default: 2000.
• innodbLockWaitTimeout - (Optional) Seconds to wait for a row lock. Default: 50.
• innodbLogBufferSize - (Optional) Size of the redo log buffer in memory. Default: 33554432. Requires restart.
• innodbLogCompressedPages - (Optional) Log re-compressed pages to redo log. Default: ON.
• innodbLruScanDepth - (Optional) How deep page cleaner scans LRU list. Default: 1024.
• innodbMaxDirtyPagesPct - (Optional) Max % of dirty pages before flushing. Default: 90.000000.
• innodbMaxDirtyPagesPctLwm - (Optional) Low water mark for dirty page % preflushing. Default: 10.000000.
• innodbMonitorEnable - (Optional) Enable InnoDB performance schema monitors.
• innodbNumaInterleave - (Optional) NUMA memory interleaving for buffer pool. Default: OFF. Requires restart.
• innodbOldBlocksPct - (Optional) % of buffer pool for old block sublist. Default: 37.
• innodbOldBlocksTime - (Optional) ms block stays in old sublist before promotion. Default: 1000.
• innodbOnlineAlterLogMaxSize - (Optional) Max log size for online DDL operations. Default: 134217728.
• innodbOpenFiles - (Optional) InnoDB open files limit. Default: 4000. Requires restart.
• innodbPageCleaners - (Optional) Number of page cleaner threads. Default: 1. Requires restart.
• innodbParallelReadThreads - (Optional) Threads for parallel clustered index reads. Default: 2. Requires restart.
• innodbPrintAllDeadlocks - (Optional) Print all deadlocks to error log. Default: OFF.
• innodbPrintDdlLogs - (Optional) Print DDL logs to error log. Default: OFF.
• innodbPrintLockWaitTimeoutInfo - (Optional) Extra lock wait timeout info. Default: OFF.
• innodbPurgeThreads - (Optional) Number of background purge threads. Default: 1. Requires restart.
• innodbRandomReadAhead - (Optional) Enable random read-ahead. Default: OFF.
• innodbReadAheadThreshold - (Optional) Pages to trigger linear read-ahead. Default: 56.
• innodbReadIoThreads - (Optional) Number of read I/O threads. Default: 4. Requires restart.
• innodbRedoLogCapacity - (Optional) Total redo log capacity for InnoDB. Default: 104857600.
• innodbRollbackOnTimeout - (Optional) Rollback entire transaction on lock wait timeout. Default: OFF. Requires restart.
• innodbShowLocksHeld - (Optional) Max locks shown per txn. Default: 10.
• innodbSortBufferSize - (Optional) Sort buffer size for InnoDB online DDL. Default: 1048576. Requires restart.
• innodbSpinWaitDelay - (Optional) Delay between spin lock polls. Default: 6.
• innodbStatsAutoRecalc - (Optional) Auto-recalculate persistent stats. Default: ON.
• innodbStatsPersistent - (Optional) Whether index statistics are persistent. Default: ON.
• innodbStatsPersistentSamplePages - (Optional) Sample pages for persistent statistics. Default: 20.
• innodbStatsTransientSamplePages - (Optional) Sample pages for transient statistics. Default: 8.
• innodbStrictMode - (Optional) Strict mode (errors vs warnings). Default: ON.
• innodbSyncSpinLoops - (Optional) Spin loops before mutex wait. Default: 30.
• innodbThreadConcurrency - (Optional) Max threads inside InnoDB (0=unlimited). Default: 0.
• innodbUseFdatasync - (Optional) Use fdatasync() instead of fsync(). Default: OFF.
• innodbWriteIoThreads - (Optional) Number of write I/O threads. Default: 4. Requires restart.
• interactiveTimeout - (Optional) Seconds the server waits for activity on an interactive connection before closing it. Default: 28800.
• internalTmpMemStorageEngine - (Optional) Engine for temp tables: TempTable or MEMORY. Default: TempTable.
• joinBufferSize - (Optional) Per-session buffer for joins. Default: 262144.
• killIdleTransaction - (Optional) Seconds before killing idle transactions (Percona; was catalog misspell innodb_kill_idle_transaction). Default: 0.
• localInfile - (Optional) Enable LOAD DATA LOCAL INFILE. Default: OFF.
• lockWaitTimeout - (Optional) Seconds for metadata lock wait. Default: 31536000.
• logErrorVerbosity - (Optional) Error log verbosity (1-3). Default: 2.
• logOutput - (Optional) Log destination: TABLE, FILE, NONE. Default: FILE.
• logQueriesNotUsingIndexes - (Optional) Log no-index queries to slow log. Default: OFF.
• logSlowExtra - (Optional) Extra info in slow query log. Default: OFF.
• logSlowFilter - (Optional) PS 8.4 filter (comma-separated): full_scan, full_join, tmp_table, tmp_table_on_disk, filesort, filesort_on_disk; empty disables.
• logSlowRateLimit - (Optional) Rate-limit slow log (1=every query). Default: 1.
• logSlowSpStatements - (Optional) Log stored proc statements. Default: OFF.
• logSlowVerbosity - (Optional) Detail: microtime, query_plan, innodb.
• logThrottleQueriesNotUsingIndexes - (Optional) Throttle rate of no-index log entries. Default: 0.
• logTimestamps - (Optional) Log timestamps: UTC or SYSTEM. Default: UTC.
• longQueryTime - (Optional) Queries that take longer than this many seconds are logged to the slow query log. Default: 2.
• maxAllowedPacket - (Optional) Max client/server packet size. Default: 67108864.
• maxConnectErrors - (Optional) Consecutive errors before blocking host. Default: 100.
• maxConnections - (Optional) Maximum number of simultaneous client connections. Default: 512.
• maxHeapTableSize - (Optional) Maximum size for user-created MEMORY tables and internal in-memory tables. Default: 16777216.
• maxJoinSize - (Optional) Max rows for large join protection. Default: 9223372036854775807.
• maxPreparedStmtCount - (Optional) Max prepared statements server-wide. Default: 16382.
• maxSortLength - (Optional) Bytes sorting BLOB/TEXT values. Default: 1024.
• maxUserConnections - (Optional) Max simultaneous connections per user. Default: 0.
• netBufferLength - (Optional) Initial connection/result buffer size. Default: 16384.
• netReadTimeout - (Optional) Seconds to wait for read data. Default: 30.
• netWriteTimeout - (Optional) Seconds to wait for write. Default: 60.
• optimizerSwitch - (Optional) Optimizer feature flags (boot_val from PS 8.4.8 live; hypergraph_optimizer=on fails on non-debug builds). Default: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=on,hypergraph_optimizer=off,derived_condition_pushdown=on,hash_set_operations=on,favor_range_scan=off.
• passwordHistory - (Optional) Passwords tracked for reuse prevention. Default: 0.
• passwordReuseInterval - (Optional) Days before password reuse. Default: 0.
• performanceSchemaMaxDigestLength - (Optional) Max Performance Schema digest length. Default: 1024. Requires restart.
• performanceSchemaMaxSqlTextLength - (Optional) Max Performance Schema SQL text length. Default: 1024. Requires restart.
• rangeOptimizerMaxMemSize - (Optional) Max memory for range optimizer. Default: 8388608.
• readBufferSize - (Optional) Buffer for sequential scans. Default: 131072.
• readRndBufferSize - (Optional) Buffer for random reads after sort. Default: 262144.
• replicaCompressedProtocol - (Optional) Compression for replica protocol. Default: OFF.
• replicaExecMode - (Optional) STRICT or IDEMPOTENT. Default: STRICT.
• replicaParallelType - (Optional) LOGICAL_CLOCK or DATABASE. Default: LOGICAL_CLOCK.
• replicaParallelWorkers - (Optional) Parallel applier workers. Default: 4.
• replicaPreserveCommitOrder - (Optional) Preserve commit order on replicas. Default: ON.
• requireSecureTransport - (Optional) Require SSL/TLS. Default: OFF.
• slowQueryLog - (Optional) Whether the slow query log is enabled. Default: ON.
• sortBufferSize - (Optional) Per-session buffer for sorts. Default: 262144.
• sqlBufferResult - (Optional) Force results to temp tables. Default: OFF.
• sqlMode - (Optional) SQL modes that control SQL syntax and data validation. Default: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION.
• syncBinlog - (Optional) Sync binlog every N commits. Default: 1.
• tableDefinitionCache - (Optional) Table definitions to cache. Default: 2000.
• tableOpenCache - (Optional) Open tables to cache. Default: 4000.
• tableOpenCacheInstances - (Optional) Table cache instances. Default: 16. Requires restart.
• tablespaceDefinitionCache - (Optional) Tablespace definitions to cache. Default: 256.
• temptableMaxMmap - (Optional) Max TempTable mmap file size. Default: 1073741824.
• temptableMaxRam - (Optional) Max TempTable RAM before spill. Default: 1073741824.
• temptableUseMmap - (Optional) Allow TempTable mmap files. Default: ON.
• threadCacheSize - (Optional) Threads cached for reuse. Default: 9.
• threadPoolIdleTimeout - (Optional) Seconds before idle pool thread exits. Default: 60.
• threadPoolMaxThreads - (Optional) Max threads in thread pool. Default: 100000.
• threadPoolSize - (Optional) Thread groups in Percona thread pool. Default: 4. Requires restart.
• threadStack - (Optional) Stack size per thread. Default: 1048576. Requires restart.
• threadStatistics - (Optional) Per-thread statistics. Default: OFF.
• timeZone - (Optional) Server default time zone (replaces invalid catalog name default_time_zone). Default: SYSTEM.
• tmpTableSize - (Optional) Maximum size of internal in-memory temporary tables. Default: 16777216.
• userstat - (Optional) USER_STATISTICS tables. Default: OFF.
• waitTimeout - (Optional) Seconds the server waits for activity on a noninteractive connection before closing it. Default: 28800.
• windowingUseHighPrecision - (Optional) High precision window functions. Default: ON.

Create DatabaseAdvancedMysqlConfig Resource

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

Constructor syntax

new DatabaseAdvancedMysqlConfig(name: string, args: DatabaseAdvancedMysqlConfigArgs, opts?: CustomResourceOptions);

@overload
def DatabaseAdvancedMysqlConfig(resource_name: str,
                                args: DatabaseAdvancedMysqlConfigArgs,
                                opts: Optional[ResourceOptions] = None)

@overload
def DatabaseAdvancedMysqlConfig(resource_name: str,
                                opts: Optional[ResourceOptions] = None,
                                cluster_id: Optional[str] = None,
                                mysql_parameters: Optional[Mapping[str, str]] = None)

func NewDatabaseAdvancedMysqlConfig(ctx *Context, name string, args DatabaseAdvancedMysqlConfigArgs, opts ...ResourceOption) (*DatabaseAdvancedMysqlConfig, error)

public DatabaseAdvancedMysqlConfig(string name, DatabaseAdvancedMysqlConfigArgs args, CustomResourceOptions? opts = null)

public DatabaseAdvancedMysqlConfig(String name, DatabaseAdvancedMysqlConfigArgs args)
public DatabaseAdvancedMysqlConfig(String name, DatabaseAdvancedMysqlConfigArgs args, CustomResourceOptions options)

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

resource "digitalocean_database_advanced_mysql_config" "name" {
    # resource properties
}

Parameters

Constructor example

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

var databaseAdvancedMysqlConfigResource = new DigitalOcean.DatabaseAdvancedMysqlConfig("databaseAdvancedMysqlConfigResource", new()
{
    ClusterId = "string",
    MysqlParameters = 
    {
        { "string", "string" },
    },
});

example, err := digitalocean.NewDatabaseAdvancedMysqlConfig(ctx, "databaseAdvancedMysqlConfigResource", &digitalocean.DatabaseAdvancedMysqlConfigArgs{
	ClusterId: pulumi.String("string"),
	MysqlParameters: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
})

resource "digitalocean_database_advanced_mysql_config" "databaseAdvancedMysqlConfigResource" {
  lifecycle {
    create_before_destroy = true
  }
  cluster_id = "string"
  mysql_parameters = {
    "string" = "string"
  }
}

var databaseAdvancedMysqlConfigResource = new DatabaseAdvancedMysqlConfig("databaseAdvancedMysqlConfigResource", DatabaseAdvancedMysqlConfigArgs.builder()
    .clusterId("string")
    .mysqlParameters(Map.of("string", "string"))
    .build());

database_advanced_mysql_config_resource = digitalocean.DatabaseAdvancedMysqlConfig("databaseAdvancedMysqlConfigResource",
    cluster_id="string",
    mysql_parameters={
        "string": "string",
    })

const databaseAdvancedMysqlConfigResource = new digitalocean.DatabaseAdvancedMysqlConfig("databaseAdvancedMysqlConfigResource", {
    clusterId: "string",
    mysqlParameters: {
        string: "string",
    },
});

type: digitalocean:DatabaseAdvancedMysqlConfig
properties:
    clusterId: string
    mysqlParameters:
        string: string

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

Outputs

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

Look up Existing DatabaseAdvancedMysqlConfig Resource

Get an existing DatabaseAdvancedMysqlConfig 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?: DatabaseAdvancedMysqlConfigState, opts?: CustomResourceOptions): DatabaseAdvancedMysqlConfig

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        cluster_id: Optional[str] = None,
        mysql_parameters: Optional[Mapping[str, str]] = None) -> DatabaseAdvancedMysqlConfig

func GetDatabaseAdvancedMysqlConfig(ctx *Context, name string, id IDInput, state *DatabaseAdvancedMysqlConfigState, opts ...ResourceOption) (*DatabaseAdvancedMysqlConfig, error)

public static DatabaseAdvancedMysqlConfig Get(string name, Input<string> id, DatabaseAdvancedMysqlConfigState? state, CustomResourceOptions? opts = null)

public static DatabaseAdvancedMysqlConfig get(String name, Output<String> id, DatabaseAdvancedMysqlConfigState state, CustomResourceOptions options)

resources:  _:    type: digitalocean:DatabaseAdvancedMysqlConfig    get:      id: ${id}

import {
  to = digitalocean_database_advanced_mysql_config.example
  id = "${id}"
}

Import

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

$ pulumi import digitalocean:index/databaseAdvancedMysqlConfig:DatabaseAdvancedMysqlConfig example 52556c07-788e-4d41-b8a7-c796432197d1

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.