Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getMysqlConfiguration

This data source provides details about a specific Mysql Configuration resource in Oracle Cloud Infrastructure MySQL Database service.

Get the full details of the specified Configuration, including the list of MySQL Variables and their values.

Example Usage

using System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testMysqlConfiguration = Oci.Mysql.GetMysqlConfiguration.Invoke(new()
    {
        ConfigurationId = @var.Mysql_configuration_id,
    });

});
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/go/oci/Mysql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := Mysql.GetMysqlConfiguration(ctx, &mysql.GetMysqlConfigurationArgs{
			ConfigurationId: _var.Mysql_configuration_id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Mysql.MysqlFunctions;
import com.pulumi.oci.Mysql.inputs.GetMysqlConfigurationArgs;
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) {
        final var testMysqlConfiguration = MysqlFunctions.getMysqlConfiguration(GetMysqlConfigurationArgs.builder()
            .configurationId(var_.mysql_configuration_id())
            .build());

    }
}
import pulumi
import pulumi_oci as oci

test_mysql_configuration = oci.Mysql.get_mysql_configuration(configuration_id=var["mysql_configuration_id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testMysqlConfiguration = oci.Mysql.getMysqlConfiguration({
    configurationId: _var.mysql_configuration_id,
});
variables:
  testMysqlConfiguration:
    Fn::Invoke:
      Function: oci:Mysql:getMysqlConfiguration
      Arguments:
        configurationId: ${var.mysql_configuration_id}

Using getMysqlConfiguration

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getMysqlConfiguration(args: GetMysqlConfigurationArgs, opts?: InvokeOptions): Promise<GetMysqlConfigurationResult>
function getMysqlConfigurationOutput(args: GetMysqlConfigurationOutputArgs, opts?: InvokeOptions): Output<GetMysqlConfigurationResult>
def get_mysql_configuration(configuration_id: Optional[str] = None,
                            opts: Optional[InvokeOptions] = None) -> GetMysqlConfigurationResult
def get_mysql_configuration_output(configuration_id: Optional[pulumi.Input[str]] = None,
                            opts: Optional[InvokeOptions] = None) -> Output[GetMysqlConfigurationResult]
func GetMysqlConfiguration(ctx *Context, args *GetMysqlConfigurationArgs, opts ...InvokeOption) (*GetMysqlConfigurationResult, error)
func GetMysqlConfigurationOutput(ctx *Context, args *GetMysqlConfigurationOutputArgs, opts ...InvokeOption) GetMysqlConfigurationResultOutput

> Note: This function is named GetMysqlConfiguration in the Go SDK.

public static class GetMysqlConfiguration 
{
    public static Task<GetMysqlConfigurationResult> InvokeAsync(GetMysqlConfigurationArgs args, InvokeOptions? opts = null)
    public static Output<GetMysqlConfigurationResult> Invoke(GetMysqlConfigurationInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetMysqlConfigurationResult> getMysqlConfiguration(GetMysqlConfigurationArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
  function: oci:Mysql/getMysqlConfiguration:getMysqlConfiguration
  arguments:
    # arguments dictionary

The following arguments are supported:

ConfigurationId string

The OCID of the Configuration.

ConfigurationId string

The OCID of the Configuration.

configurationId String

The OCID of the Configuration.

configurationId string

The OCID of the Configuration.

configuration_id str

The OCID of the Configuration.

configurationId String

The OCID of the Configuration.

getMysqlConfiguration Result

The following output properties are available:

CompartmentId string

OCID of the Compartment the Configuration exists in.

ConfigurationId string
DefinedTags Dictionary<string, object>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

Description string

User-provided data about the Configuration.

DisplayName string

The display name of the Configuration.

FreeformTags Dictionary<string, object>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

Id string

The OCID of the Configuration.

InitVariables List<GetMysqlConfigurationInitVariable>

User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.

ParentConfigurationId string

The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.

ShapeName string

The name of the associated Shape.

State string

The current state of the Configuration.

TimeCreated string

The date and time the Configuration was created, as described by RFC 3339.

TimeUpdated string

The date and time the Configuration was last updated, as described by RFC 3339.

Type string

The Configuration type, DEFAULT or CUSTOM.

Variables List<GetMysqlConfigurationVariable>

User-defined service variables.

CompartmentId string

OCID of the Compartment the Configuration exists in.

ConfigurationId string
DefinedTags map[string]interface{}

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

Description string

User-provided data about the Configuration.

DisplayName string

The display name of the Configuration.

FreeformTags map[string]interface{}

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

Id string

The OCID of the Configuration.

InitVariables []GetMysqlConfigurationInitVariable

User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.

ParentConfigurationId string

The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.

ShapeName string

The name of the associated Shape.

State string

The current state of the Configuration.

TimeCreated string

The date and time the Configuration was created, as described by RFC 3339.

TimeUpdated string

The date and time the Configuration was last updated, as described by RFC 3339.

Type string

The Configuration type, DEFAULT or CUSTOM.

Variables []GetMysqlConfigurationVariable

User-defined service variables.

compartmentId String

OCID of the Compartment the Configuration exists in.

configurationId String
definedTags Map<String,Object>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

description String

User-provided data about the Configuration.

displayName String

The display name of the Configuration.

freeformTags Map<String,Object>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

id String

The OCID of the Configuration.

initVariables List<GetConfigurationInitVariable>

User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.

parentConfigurationId String

The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.

shapeName String

The name of the associated Shape.

state String

The current state of the Configuration.

timeCreated String

The date and time the Configuration was created, as described by RFC 3339.

timeUpdated String

The date and time the Configuration was last updated, as described by RFC 3339.

type String

The Configuration type, DEFAULT or CUSTOM.

variables List<GetConfigurationVariable>

User-defined service variables.

compartmentId string

OCID of the Compartment the Configuration exists in.

configurationId string
definedTags {[key: string]: any}

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

description string

User-provided data about the Configuration.

displayName string

The display name of the Configuration.

freeformTags {[key: string]: any}

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

id string

The OCID of the Configuration.

initVariables GetMysqlConfigurationInitVariable[]

User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.

parentConfigurationId string

The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.

shapeName string

The name of the associated Shape.

state string

The current state of the Configuration.

timeCreated string

The date and time the Configuration was created, as described by RFC 3339.

timeUpdated string

The date and time the Configuration was last updated, as described by RFC 3339.

type string

The Configuration type, DEFAULT or CUSTOM.

variables GetMysqlConfigurationVariable[]

User-defined service variables.

compartment_id str

OCID of the Compartment the Configuration exists in.

configuration_id str
defined_tags Mapping[str, Any]

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

description str

User-provided data about the Configuration.

display_name str

The display name of the Configuration.

freeform_tags Mapping[str, Any]

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

id str

The OCID of the Configuration.

init_variables GetMysqlConfigurationInitVariable]

User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.

parent_configuration_id str

The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.

shape_name str

The name of the associated Shape.

state str

The current state of the Configuration.

time_created str

The date and time the Configuration was created, as described by RFC 3339.

time_updated str

The date and time the Configuration was last updated, as described by RFC 3339.

type str

The Configuration type, DEFAULT or CUSTOM.

variables GetMysqlConfigurationVariable]

User-defined service variables.

compartmentId String

OCID of the Compartment the Configuration exists in.

configurationId String
definedTags Map<Any>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

description String

User-provided data about the Configuration.

displayName String

The display name of the Configuration.

freeformTags Map<Any>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

id String

The OCID of the Configuration.

initVariables List<Property Map>

User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.

parentConfigurationId String

The OCID of the Configuration from which this Configuration is "derived". This is entirely a metadata relationship. There is no relation between the values in this Configuration and its parent.

shapeName String

The name of the associated Shape.

state String

The current state of the Configuration.

timeCreated String

The date and time the Configuration was created, as described by RFC 3339.

timeUpdated String

The date and time the Configuration was last updated, as described by RFC 3339.

type String

The Configuration type, DEFAULT or CUSTOM.

variables List<Property Map>

User-defined service variables.

Supporting Types

GetMysqlConfigurationInitVariable

LowerCaseTableNames string

Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

LowerCaseTableNames string

Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

lowerCaseTableNames String

Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

lowerCaseTableNames string

Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

lower_case_table_names str

Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

lowerCaseTableNames String

Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).

GetMysqlConfigurationVariable

Autocommit bool

("autocommit")

BigTables bool

If enabled, the server stores all temporary tables on disk rather than in memory.

BinlogExpireLogsSeconds int

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

BinlogRowMetadata string

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

BinlogRowValueOptions string

When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.

BinlogTransactionCompression bool

Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.

CompletionType string

("completion_type")

ConnectTimeout int

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

ConnectionMemoryChunkSize int

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

ConnectionMemoryLimit string

Set the maximum amount of memory that can be used by a single user connection.

CteMaxRecursionDepth string

("cte_max_recursion_depth")

DefaultAuthenticationPlugin string

("default_authentication_plugin")

ForeignKeyChecks bool

("foreign_key_checks")

GeneratedRandomPasswordLength int

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

GlobalConnectionMemoryLimit string

Set the total amount of memory that can be used by all user connections.

GlobalConnectionMemoryTracking bool

Determines whether the MySQL server calculates Global_connection_memory.

GroupReplicationConsistency string
  • EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
  • BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
  • BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
InformationSchemaStatsExpiry int

("information_schema_stats_expiry")

InnodbBufferPoolDumpPct int

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

InnodbBufferPoolInstances int

("innodb_buffer_pool_instances")

InnodbBufferPoolSize string

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

InnodbDdlBufferSize string

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

InnodbDdlThreads int

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

InnodbFtEnableStopword bool

("innodb_ft_enable_stopword")

InnodbFtMaxTokenSize int

("innodb_ft_max_token_size")

InnodbFtMinTokenSize int

("innodb_ft_min_token_size")

InnodbFtNumWordOptimize int

("innodb_ft_num_word_optimize")

InnodbFtResultCacheLimit string

("innodb_ft_result_cache_limit")

InnodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

InnodbLockWaitTimeout int

("innodb_lock_wait_timeout")

InnodbLogWriterThreads bool

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

InnodbMaxPurgeLag string

The desired maximum purge lag in terms of transactions.

InnodbMaxPurgeLagDelay int

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

InnodbStatsPersistentSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

InnodbStatsTransientSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

InteractiveTimeout int

The number of seconds the server waits for activity on an interactive connection before closing it.

LocalInfile bool

("local_infile")

MandatoryRoles string

("mandatory_roles")

MaxAllowedPacket int

The maximum size of one packet or any generated/intermediate string.

MaxBinlogCacheSize string

Sets the size of the transaction cache.

MaxConnectErrors string

("max_connect_errors")

MaxConnections int

("max_connections")

MaxExecutionTime string

("max_execution_time")

MaxHeapTableSize string

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

MaxPreparedStmtCount int

("max_prepared_stmt_count")

MysqlFirewallMode bool

("mysql_firewall_mode")

MysqlZstdDefaultCompressionLevel int

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated:

The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxConnectTimeout int

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

MysqlxDeflateDefaultCompressionLevel int

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

MysqlxDeflateMaxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

MysqlxDocumentIdUniquePrefix int

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxEnableHelloNotice bool

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

MysqlxIdleWorkerThreadTimeout int

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxInteractiveTimeout int

The number of seconds to wait for interactive clients to timeout.

MysqlxLz4defaultCompressionLevel int

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

MysqlxLz4maxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

MysqlxMaxAllowedPacket int

The maximum size of network packets that can be received by X Plugin.

MysqlxMinWorkerThreads int

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxReadTimeout int

The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.

MysqlxWaitTimeout int

The number of seconds that X Plugin waits for activity on a connection.

MysqlxWriteTimeout int

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

MysqlxZstdDefaultCompressionLevel int

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

MysqlxZstdMaxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

NetReadTimeout int

The number of seconds to wait for more data from a connection before aborting the read.

NetWriteTimeout int

The number of seconds to wait for a block to be written to a connection before aborting the write.

ParserMaxMemSize string

("parser_max_mem_size")

QueryAllocBlockSize string

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

QueryPreallocSize string

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

RegexpTimeLimit int

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

SortBufferSize string

Each session that must perform a sort allocates a buffer of this size.

SqlMode string

("sql_mode")

SqlRequirePrimaryKey bool

("sql_require_primary_key")

SqlWarnings bool

("sql_warnings")

ThreadPoolDedicatedListeners bool

Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.

ThreadPoolMaxTransactionsLimit int

Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.

TimeZone string

Initializes the time zone for each client that connects.

TmpTableSize string

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

TransactionIsolation string

("transaction_isolation")

WaitTimeout int

The number of seconds the server waits for activity on a noninteractive connection before closing it.

Autocommit bool

("autocommit")

BigTables bool

If enabled, the server stores all temporary tables on disk rather than in memory.

BinlogExpireLogsSeconds int

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

BinlogRowMetadata string

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

BinlogRowValueOptions string

When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.

BinlogTransactionCompression bool

Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.

CompletionType string

("completion_type")

ConnectTimeout int

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

ConnectionMemoryChunkSize int

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

ConnectionMemoryLimit string

Set the maximum amount of memory that can be used by a single user connection.

CteMaxRecursionDepth string

("cte_max_recursion_depth")

DefaultAuthenticationPlugin string

("default_authentication_plugin")

ForeignKeyChecks bool

("foreign_key_checks")

GeneratedRandomPasswordLength int

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

GlobalConnectionMemoryLimit string

Set the total amount of memory that can be used by all user connections.

GlobalConnectionMemoryTracking bool

Determines whether the MySQL server calculates Global_connection_memory.

GroupReplicationConsistency string
  • EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
  • BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
  • BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
InformationSchemaStatsExpiry int

("information_schema_stats_expiry")

InnodbBufferPoolDumpPct int

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

InnodbBufferPoolInstances int

("innodb_buffer_pool_instances")

InnodbBufferPoolSize string

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

InnodbDdlBufferSize string

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

InnodbDdlThreads int

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

InnodbFtEnableStopword bool

("innodb_ft_enable_stopword")

InnodbFtMaxTokenSize int

("innodb_ft_max_token_size")

InnodbFtMinTokenSize int

("innodb_ft_min_token_size")

InnodbFtNumWordOptimize int

("innodb_ft_num_word_optimize")

InnodbFtResultCacheLimit string

("innodb_ft_result_cache_limit")

InnodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

InnodbLockWaitTimeout int

("innodb_lock_wait_timeout")

InnodbLogWriterThreads bool

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

InnodbMaxPurgeLag string

The desired maximum purge lag in terms of transactions.

InnodbMaxPurgeLagDelay int

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

InnodbStatsPersistentSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

InnodbStatsTransientSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

InteractiveTimeout int

The number of seconds the server waits for activity on an interactive connection before closing it.

LocalInfile bool

("local_infile")

MandatoryRoles string

("mandatory_roles")

MaxAllowedPacket int

The maximum size of one packet or any generated/intermediate string.

MaxBinlogCacheSize string

Sets the size of the transaction cache.

MaxConnectErrors string

("max_connect_errors")

MaxConnections int

("max_connections")

MaxExecutionTime string

("max_execution_time")

MaxHeapTableSize string

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

MaxPreparedStmtCount int

("max_prepared_stmt_count")

MysqlFirewallMode bool

("mysql_firewall_mode")

MysqlZstdDefaultCompressionLevel int

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated:

The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxConnectTimeout int

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

MysqlxDeflateDefaultCompressionLevel int

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

MysqlxDeflateMaxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

MysqlxDocumentIdUniquePrefix int

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxEnableHelloNotice bool

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

MysqlxIdleWorkerThreadTimeout int

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxInteractiveTimeout int

The number of seconds to wait for interactive clients to timeout.

MysqlxLz4defaultCompressionLevel int

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

MysqlxLz4maxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

MysqlxMaxAllowedPacket int

The maximum size of network packets that can be received by X Plugin.

MysqlxMinWorkerThreads int

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

MysqlxReadTimeout int

The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.

MysqlxWaitTimeout int

The number of seconds that X Plugin waits for activity on a connection.

MysqlxWriteTimeout int

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

MysqlxZstdDefaultCompressionLevel int

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

MysqlxZstdMaxClientCompressionLevel int

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

NetReadTimeout int

The number of seconds to wait for more data from a connection before aborting the read.

NetWriteTimeout int

The number of seconds to wait for a block to be written to a connection before aborting the write.

ParserMaxMemSize string

("parser_max_mem_size")

QueryAllocBlockSize string

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

QueryPreallocSize string

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

RegexpTimeLimit int

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

SortBufferSize string

Each session that must perform a sort allocates a buffer of this size.

SqlMode string

("sql_mode")

SqlRequirePrimaryKey bool

("sql_require_primary_key")

SqlWarnings bool

("sql_warnings")

ThreadPoolDedicatedListeners bool

Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.

ThreadPoolMaxTransactionsLimit int

Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.

TimeZone string

Initializes the time zone for each client that connects.

TmpTableSize string

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

TransactionIsolation string

("transaction_isolation")

WaitTimeout int

The number of seconds the server waits for activity on a noninteractive connection before closing it.

autocommit Boolean

("autocommit")

bigTables Boolean

If enabled, the server stores all temporary tables on disk rather than in memory.

binlogExpireLogsSeconds Integer

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

binlogRowMetadata String

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

binlogRowValueOptions String

When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.

binlogTransactionCompression Boolean

Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.

completionType String

("completion_type")

connectTimeout Integer

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

connectionMemoryChunkSize Integer

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

connectionMemoryLimit String

Set the maximum amount of memory that can be used by a single user connection.

cteMaxRecursionDepth String

("cte_max_recursion_depth")

defaultAuthenticationPlugin String

("default_authentication_plugin")

foreignKeyChecks Boolean

("foreign_key_checks")

generatedRandomPasswordLength Integer

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

globalConnectionMemoryLimit String

Set the total amount of memory that can be used by all user connections.

globalConnectionMemoryTracking Boolean

Determines whether the MySQL server calculates Global_connection_memory.

groupReplicationConsistency String
  • EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
  • BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
  • BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
informationSchemaStatsExpiry Integer

("information_schema_stats_expiry")

innodbBufferPoolDumpPct Integer

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

innodbBufferPoolInstances Integer

("innodb_buffer_pool_instances")

innodbBufferPoolSize String

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

innodbDdlBufferSize String

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

innodbDdlThreads Integer

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

innodbFtEnableStopword Boolean

("innodb_ft_enable_stopword")

innodbFtMaxTokenSize Integer

("innodb_ft_max_token_size")

innodbFtMinTokenSize Integer

("innodb_ft_min_token_size")

innodbFtNumWordOptimize Integer

("innodb_ft_num_word_optimize")

innodbFtResultCacheLimit String

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable String

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout Integer

("innodb_lock_wait_timeout")

innodbLogWriterThreads Boolean

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

innodbMaxPurgeLag String

The desired maximum purge lag in terms of transactions.

innodbMaxPurgeLagDelay Integer

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

innodbStatsPersistentSamplePages String

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStatsTransientSamplePages String

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

interactiveTimeout Integer

The number of seconds the server waits for activity on an interactive connection before closing it.

localInfile Boolean

("local_infile")

mandatoryRoles String

("mandatory_roles")

maxAllowedPacket Integer

The maximum size of one packet or any generated/intermediate string.

maxBinlogCacheSize String

Sets the size of the transaction cache.

maxConnectErrors String

("max_connect_errors")

maxConnections Integer

("max_connections")

maxExecutionTime String

("max_execution_time")

maxHeapTableSize String

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

maxPreparedStmtCount Integer

("max_prepared_stmt_count")

mysqlFirewallMode Boolean

("mysql_firewall_mode")

mysqlZstdDefaultCompressionLevel Integer

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated:

The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxConnectTimeout Integer

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

mysqlxDeflateDefaultCompressionLevel Integer

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

mysqlxDeflateMaxClientCompressionLevel Integer

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

mysqlxDocumentIdUniquePrefix Integer

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxEnableHelloNotice Boolean

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

mysqlxIdleWorkerThreadTimeout Integer

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxInteractiveTimeout Integer

The number of seconds to wait for interactive clients to timeout.

mysqlxLz4defaultCompressionLevel Integer

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

mysqlxLz4maxClientCompressionLevel Integer

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

mysqlxMaxAllowedPacket Integer

The maximum size of network packets that can be received by X Plugin.

mysqlxMinWorkerThreads Integer

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxReadTimeout Integer

The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.

mysqlxWaitTimeout Integer

The number of seconds that X Plugin waits for activity on a connection.

mysqlxWriteTimeout Integer

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

mysqlxZstdDefaultCompressionLevel Integer

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

mysqlxZstdMaxClientCompressionLevel Integer

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

netReadTimeout Integer

The number of seconds to wait for more data from a connection before aborting the read.

netWriteTimeout Integer

The number of seconds to wait for a block to be written to a connection before aborting the write.

parserMaxMemSize String

("parser_max_mem_size")

queryAllocBlockSize String

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

queryPreallocSize String

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

regexpTimeLimit Integer

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

sortBufferSize String

Each session that must perform a sort allocates a buffer of this size.

sqlMode String

("sql_mode")

sqlRequirePrimaryKey Boolean

("sql_require_primary_key")

sqlWarnings Boolean

("sql_warnings")

threadPoolDedicatedListeners Boolean

Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.

threadPoolMaxTransactionsLimit Integer

Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.

timeZone String

Initializes the time zone for each client that connects.

tmpTableSize String

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

transactionIsolation String

("transaction_isolation")

waitTimeout Integer

The number of seconds the server waits for activity on a noninteractive connection before closing it.

autocommit boolean

("autocommit")

bigTables boolean

If enabled, the server stores all temporary tables on disk rather than in memory.

binlogExpireLogsSeconds number

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

binlogRowMetadata string

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

binlogRowValueOptions string

When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.

binlogTransactionCompression boolean

Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.

completionType string

("completion_type")

connectTimeout number

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

connectionMemoryChunkSize number

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

connectionMemoryLimit string

Set the maximum amount of memory that can be used by a single user connection.

cteMaxRecursionDepth string

("cte_max_recursion_depth")

defaultAuthenticationPlugin string

("default_authentication_plugin")

foreignKeyChecks boolean

("foreign_key_checks")

generatedRandomPasswordLength number

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

globalConnectionMemoryLimit string

Set the total amount of memory that can be used by all user connections.

globalConnectionMemoryTracking boolean

Determines whether the MySQL server calculates Global_connection_memory.

groupReplicationConsistency string
  • EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
  • BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
  • BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
informationSchemaStatsExpiry number

("information_schema_stats_expiry")

innodbBufferPoolDumpPct number

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

innodbBufferPoolInstances number

("innodb_buffer_pool_instances")

innodbBufferPoolSize string

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

innodbDdlBufferSize string

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

innodbDdlThreads number

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

innodbFtEnableStopword boolean

("innodb_ft_enable_stopword")

innodbFtMaxTokenSize number

("innodb_ft_max_token_size")

innodbFtMinTokenSize number

("innodb_ft_min_token_size")

innodbFtNumWordOptimize number

("innodb_ft_num_word_optimize")

innodbFtResultCacheLimit string

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout number

("innodb_lock_wait_timeout")

innodbLogWriterThreads boolean

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

innodbMaxPurgeLag string

The desired maximum purge lag in terms of transactions.

innodbMaxPurgeLagDelay number

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

innodbStatsPersistentSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStatsTransientSamplePages string

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

interactiveTimeout number

The number of seconds the server waits for activity on an interactive connection before closing it.

localInfile boolean

("local_infile")

mandatoryRoles string

("mandatory_roles")

maxAllowedPacket number

The maximum size of one packet or any generated/intermediate string.

maxBinlogCacheSize string

Sets the size of the transaction cache.

maxConnectErrors string

("max_connect_errors")

maxConnections number

("max_connections")

maxExecutionTime string

("max_execution_time")

maxHeapTableSize string

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

maxPreparedStmtCount number

("max_prepared_stmt_count")

mysqlFirewallMode boolean

("mysql_firewall_mode")

mysqlZstdDefaultCompressionLevel number

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated:

The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxConnectTimeout number

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

mysqlxDeflateDefaultCompressionLevel number

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

mysqlxDeflateMaxClientCompressionLevel number

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

mysqlxDocumentIdUniquePrefix number

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxEnableHelloNotice boolean

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

mysqlxIdleWorkerThreadTimeout number

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxInteractiveTimeout number

The number of seconds to wait for interactive clients to timeout.

mysqlxLz4defaultCompressionLevel number

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

mysqlxLz4maxClientCompressionLevel number

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

mysqlxMaxAllowedPacket number

The maximum size of network packets that can be received by X Plugin.

mysqlxMinWorkerThreads number

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxReadTimeout number

The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.

mysqlxWaitTimeout number

The number of seconds that X Plugin waits for activity on a connection.

mysqlxWriteTimeout number

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

mysqlxZstdDefaultCompressionLevel number

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

mysqlxZstdMaxClientCompressionLevel number

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

netReadTimeout number

The number of seconds to wait for more data from a connection before aborting the read.

netWriteTimeout number

The number of seconds to wait for a block to be written to a connection before aborting the write.

parserMaxMemSize string

("parser_max_mem_size")

queryAllocBlockSize string

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

queryPreallocSize string

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

regexpTimeLimit number

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

sortBufferSize string

Each session that must perform a sort allocates a buffer of this size.

sqlMode string

("sql_mode")

sqlRequirePrimaryKey boolean

("sql_require_primary_key")

sqlWarnings boolean

("sql_warnings")

threadPoolDedicatedListeners boolean

Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.

threadPoolMaxTransactionsLimit number

Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.

timeZone string

Initializes the time zone for each client that connects.

tmpTableSize string

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

transactionIsolation string

("transaction_isolation")

waitTimeout number

The number of seconds the server waits for activity on a noninteractive connection before closing it.

autocommit bool

("autocommit")

big_tables bool

If enabled, the server stores all temporary tables on disk rather than in memory.

binlog_expire_logs_seconds int

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

binlog_row_metadata str

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

binlog_row_value_options str

When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.

binlog_transaction_compression bool

Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.

completion_type str

("completion_type")

connect_timeout int

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

connection_memory_chunk_size int

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

connection_memory_limit str

Set the maximum amount of memory that can be used by a single user connection.

cte_max_recursion_depth str

("cte_max_recursion_depth")

default_authentication_plugin str

("default_authentication_plugin")

foreign_key_checks bool

("foreign_key_checks")

generated_random_password_length int

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

global_connection_memory_limit str

Set the total amount of memory that can be used by all user connections.

global_connection_memory_tracking bool

Determines whether the MySQL server calculates Global_connection_memory.

group_replication_consistency str
  • EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
  • BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
  • BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
information_schema_stats_expiry int

("information_schema_stats_expiry")

innodb_buffer_pool_dump_pct int

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

innodb_buffer_pool_instances int

("innodb_buffer_pool_instances")

innodb_buffer_pool_size str

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

innodb_ddl_buffer_size str

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

innodb_ddl_threads int

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

innodb_ft_enable_stopword bool

("innodb_ft_enable_stopword")

innodb_ft_max_token_size int

("innodb_ft_max_token_size")

innodb_ft_min_token_size int

("innodb_ft_min_token_size")

innodb_ft_num_word_optimize int

("innodb_ft_num_word_optimize")

innodb_ft_result_cache_limit str

("innodb_ft_result_cache_limit")

innodb_ft_server_stopword_table str

("innodb_ft_server_stopword_table")

innodb_lock_wait_timeout int

("innodb_lock_wait_timeout")

innodb_log_writer_threads bool

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

innodb_max_purge_lag str

The desired maximum purge lag in terms of transactions.

innodb_max_purge_lag_delay int

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

innodb_stats_persistent_sample_pages str

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodb_stats_transient_sample_pages str

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

interactive_timeout int

The number of seconds the server waits for activity on an interactive connection before closing it.

local_infile bool

("local_infile")

mandatory_roles str

("mandatory_roles")

max_allowed_packet int

The maximum size of one packet or any generated/intermediate string.

max_binlog_cache_size str

Sets the size of the transaction cache.

max_connect_errors str

("max_connect_errors")

max_connections int

("max_connections")

max_execution_time str

("max_execution_time")

max_heap_table_size str

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

max_prepared_stmt_count int

("max_prepared_stmt_count")

mysql_firewall_mode bool

("mysql_firewall_mode")

mysql_zstd_default_compression_level int

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated:

The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlx_connect_timeout int

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

mysqlx_deflate_default_compression_level int

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

mysqlx_deflate_max_client_compression_level int

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

mysqlx_document_id_unique_prefix int

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlx_enable_hello_notice bool

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

mysqlx_idle_worker_thread_timeout int

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlx_interactive_timeout int

The number of seconds to wait for interactive clients to timeout.

mysqlx_lz4default_compression_level int

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

mysqlx_lz4max_client_compression_level int

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

mysqlx_max_allowed_packet int

The maximum size of network packets that can be received by X Plugin.

mysqlx_min_worker_threads int

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlx_read_timeout int

The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.

mysqlx_wait_timeout int

The number of seconds that X Plugin waits for activity on a connection.

mysqlx_write_timeout int

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

mysqlx_zstd_default_compression_level int

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

mysqlx_zstd_max_client_compression_level int

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

net_read_timeout int

The number of seconds to wait for more data from a connection before aborting the read.

net_write_timeout int

The number of seconds to wait for a block to be written to a connection before aborting the write.

parser_max_mem_size str

("parser_max_mem_size")

query_alloc_block_size str

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

query_prealloc_size str

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

regexp_time_limit int

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

sort_buffer_size str

Each session that must perform a sort allocates a buffer of this size.

sql_mode str

("sql_mode")

sql_require_primary_key bool

("sql_require_primary_key")

sql_warnings bool

("sql_warnings")

thread_pool_dedicated_listeners bool

Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.

thread_pool_max_transactions_limit int

Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.

time_zone str

Initializes the time zone for each client that connects.

tmp_table_size str

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

transaction_isolation str

("transaction_isolation")

wait_timeout int

The number of seconds the server waits for activity on a noninteractive connection before closing it.

autocommit Boolean

("autocommit")

bigTables Boolean

If enabled, the server stores all temporary tables on disk rather than in memory.

binlogExpireLogsSeconds Number

Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

binlogRowMetadata String

Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.

binlogRowValueOptions String

When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.

binlogTransactionCompression Boolean

Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.

completionType String

("completion_type")

connectTimeout Number

The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.

connectionMemoryChunkSize Number

Set the chunking size for updates to the global memory usage counter Global_connection_memory.

connectionMemoryLimit String

Set the maximum amount of memory that can be used by a single user connection.

cteMaxRecursionDepth String

("cte_max_recursion_depth")

defaultAuthenticationPlugin String

("default_authentication_plugin")

foreignKeyChecks Boolean

("foreign_key_checks")

generatedRandomPasswordLength Number

("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

globalConnectionMemoryLimit String

Set the total amount of memory that can be used by all user connections.

globalConnectionMemoryTracking Boolean

Determines whether the MySQL server calculates Global_connection_memory.

groupReplicationConsistency String
  • EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
  • BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
  • BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
  • BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
informationSchemaStatsExpiry Number

("information_schema_stats_expiry")

innodbBufferPoolDumpPct Number

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.

innodbBufferPoolInstances Number

("innodb_buffer_pool_instances")

innodbBufferPoolSize String

The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.

innodbDdlBufferSize String

innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)

innodbDdlThreads Number

innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)

innodbFtEnableStopword Boolean

("innodb_ft_enable_stopword")

innodbFtMaxTokenSize Number

("innodb_ft_max_token_size")

innodbFtMinTokenSize Number

("innodb_ft_min_token_size")

innodbFtNumWordOptimize Number

("innodb_ft_num_word_optimize")

innodbFtResultCacheLimit String

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable String

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout Number

("innodb_lock_wait_timeout")

innodbLogWriterThreads Boolean

Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.

innodbMaxPurgeLag String

The desired maximum purge lag in terms of transactions.

innodbMaxPurgeLagDelay Number

The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.

innodbStatsPersistentSamplePages String

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

innodbStatsTransientSamplePages String

The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.

interactiveTimeout Number

The number of seconds the server waits for activity on an interactive connection before closing it.

localInfile Boolean

("local_infile")

mandatoryRoles String

("mandatory_roles")

maxAllowedPacket Number

The maximum size of one packet or any generated/intermediate string.

maxBinlogCacheSize String

Sets the size of the transaction cache.

maxConnectErrors String

("max_connect_errors")

maxConnections Number

("max_connections")

maxExecutionTime String

("max_execution_time")

maxHeapTableSize String

This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.

maxPreparedStmtCount Number

("max_prepared_stmt_count")

mysqlFirewallMode Boolean

("mysql_firewall_mode")

mysqlZstdDefaultCompressionLevel Number

DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Deprecated:

The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxConnectTimeout Number

The number of seconds X Plugin waits for the first packet to be received from newly connected clients.

mysqlxDeflateDefaultCompressionLevel Number

Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")

mysqlxDeflateMaxClientCompressionLevel Number

Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")

mysqlxDocumentIdUniquePrefix Number

("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxEnableHelloNotice Boolean

("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored

mysqlxIdleWorkerThreadTimeout Number

("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxInteractiveTimeout Number

The number of seconds to wait for interactive clients to timeout.

mysqlxLz4defaultCompressionLevel Number

Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")

mysqlxLz4maxClientCompressionLevel Number

Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")

mysqlxMaxAllowedPacket Number

The maximum size of network packets that can be received by X Plugin.

mysqlxMinWorkerThreads Number

("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

mysqlxReadTimeout Number

The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.

mysqlxWaitTimeout Number

The number of seconds that X Plugin waits for activity on a connection.

mysqlxWriteTimeout Number

The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.

mysqlxZstdDefaultCompressionLevel Number

Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")

mysqlxZstdMaxClientCompressionLevel Number

Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")

netReadTimeout Number

The number of seconds to wait for more data from a connection before aborting the read.

netWriteTimeout Number

The number of seconds to wait for a block to be written to a connection before aborting the write.

parserMaxMemSize String

("parser_max_mem_size")

queryAllocBlockSize String

("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

queryPreallocSize String

("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

Deprecated:

The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

regexpTimeLimit Number

regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)

sortBufferSize String

Each session that must perform a sort allocates a buffer of this size.

sqlMode String

("sql_mode")

sqlRequirePrimaryKey Boolean

("sql_require_primary_key")

sqlWarnings Boolean

("sql_warnings")

threadPoolDedicatedListeners Boolean

Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.

threadPoolMaxTransactionsLimit Number

Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.

timeZone String

Initializes the time zone for each client that connects.

tmpTableSize String

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

transactionIsolation String

("transaction_isolation")

waitTimeout Number

The number of seconds the server waits for activity on a noninteractive connection before closing it.

Package Details

Repository
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.