Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getMysqlConfigurations

This data source provides the list of Mysql Configurations in Oracle Cloud Infrastructure MySQL Database service.

Lists the Configurations available when creating a DB System.

This may include DEFAULT configurations per Shape and CUSTOM configurations.

The default sort order is a multi-part sort by:

  • shapeName, ascending
  • DEFAULT-before-CUSTOM
  • displayName ascending

Example Usage

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testMysqlConfigurations = Output.Create(Oci.Mysql.GetMysqlConfigurations.InvokeAsync(new Oci.Mysql.GetMysqlConfigurationsArgs
        {
            CompartmentId = @var.Compartment_id,
            ConfigurationId = @var.Mysql_configuration_id,
            DisplayName = @var.Mysql_configuration_display_name,
            ShapeName = @var.Mysql_shape_name,
            State = @var.Mysql_configuration_state,
            Types = @var.Mysql_configuration_type,
        }));
    }

}
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.GetMysqlConfigurations(ctx, &mysql.GetMysqlConfigurationsArgs{
			CompartmentId:   _var.Compartment_id,
			ConfigurationId: pulumi.StringRef(_var.Mysql_configuration_id),
			DisplayName:     pulumi.StringRef(_var.Mysql_configuration_display_name),
			ShapeName:       pulumi.StringRef(_var.Mysql_shape_name),
			State:           pulumi.StringRef(_var.Mysql_configuration_state),
			Types:           _var.Mysql_configuration_type,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

import pulumi
import pulumi_oci as oci

test_mysql_configurations = oci.Mysql.get_mysql_configurations(compartment_id=var["compartment_id"],
    configuration_id=var["mysql_configuration_id"],
    display_name=var["mysql_configuration_display_name"],
    shape_name=var["mysql_shape_name"],
    state=var["mysql_configuration_state"],
    types=var["mysql_configuration_type"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testMysqlConfigurations = oci.Mysql.getMysqlConfigurations({
    compartmentId: _var.compartment_id,
    configurationId: _var.mysql_configuration_id,
    displayName: _var.mysql_configuration_display_name,
    shapeName: _var.mysql_shape_name,
    state: _var.mysql_configuration_state,
    types: _var.mysql_configuration_type,
});

Coming soon!

Using getMysqlConfigurations

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 getMysqlConfigurations(args: GetMysqlConfigurationsArgs, opts?: InvokeOptions): Promise<GetMysqlConfigurationsResult>
function getMysqlConfigurationsOutput(args: GetMysqlConfigurationsOutputArgs, opts?: InvokeOptions): Output<GetMysqlConfigurationsResult>
def get_mysql_configurations(compartment_id: Optional[str] = None,
                             configuration_id: Optional[str] = None,
                             display_name: Optional[str] = None,
                             filters: Optional[Sequence[_mysql.GetMysqlConfigurationsFilter]] = None,
                             shape_name: Optional[str] = None,
                             state: Optional[str] = None,
                             types: Optional[Sequence[str]] = None,
                             opts: Optional[InvokeOptions] = None) -> GetMysqlConfigurationsResult
def get_mysql_configurations_output(compartment_id: Optional[pulumi.Input[str]] = None,
                             configuration_id: Optional[pulumi.Input[str]] = None,
                             display_name: Optional[pulumi.Input[str]] = None,
                             filters: Optional[pulumi.Input[Sequence[pulumi.Input[_mysql.GetMysqlConfigurationsFilterArgs]]]] = None,
                             shape_name: Optional[pulumi.Input[str]] = None,
                             state: Optional[pulumi.Input[str]] = None,
                             types: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                             opts: Optional[InvokeOptions] = None) -> Output[GetMysqlConfigurationsResult]
func GetMysqlConfigurations(ctx *Context, args *GetMysqlConfigurationsArgs, opts ...InvokeOption) (*GetMysqlConfigurationsResult, error)
func GetMysqlConfigurationsOutput(ctx *Context, args *GetMysqlConfigurationsOutputArgs, opts ...InvokeOption) GetMysqlConfigurationsResultOutput

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

public static class GetMysqlConfigurations 
{
    public static Task<GetMysqlConfigurationsResult> InvokeAsync(GetMysqlConfigurationsArgs args, InvokeOptions? opts = null)
    public static Output<GetMysqlConfigurationsResult> Invoke(GetMysqlConfigurationsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetMysqlConfigurationsResult> getMysqlConfigurations(GetMysqlConfigurationsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:Mysql/getMysqlConfigurations:getMysqlConfigurations
  Arguments:
    # Arguments dictionary

The following arguments are supported:

CompartmentId string

The compartment OCID.

ConfigurationId string

The requested Configuration instance.

DisplayName string

A filter to return only the resource matching the given display name exactly.

Filters List<GetMysqlConfigurationsFilter>
ShapeName string

The requested Shape name.

State string

Configuration Lifecycle State

Types List<string>

The requested Configuration types.

CompartmentId string

The compartment OCID.

ConfigurationId string

The requested Configuration instance.

DisplayName string

A filter to return only the resource matching the given display name exactly.

Filters []GetMysqlConfigurationsFilter
ShapeName string

The requested Shape name.

State string

Configuration Lifecycle State

Types []string

The requested Configuration types.

compartmentId String

The compartment OCID.

configurationId String

The requested Configuration instance.

displayName String

A filter to return only the resource matching the given display name exactly.

filters List<GetConfigurationsFilter>
shapeName String

The requested Shape name.

state String

Configuration Lifecycle State

types List<String>

The requested Configuration types.

compartmentId string

The compartment OCID.

configurationId string

The requested Configuration instance.

displayName string

A filter to return only the resource matching the given display name exactly.

filters GetMysqlConfigurationsFilter[]
shapeName string

The requested Shape name.

state string

Configuration Lifecycle State

types string[]

The requested Configuration types.

compartment_id str

The compartment OCID.

configuration_id str

The requested Configuration instance.

display_name str

A filter to return only the resource matching the given display name exactly.

filters GetMysqlConfigurationsFilter]
shape_name str

The requested Shape name.

state str

Configuration Lifecycle State

types Sequence[str]

The requested Configuration types.

compartmentId String

The compartment OCID.

configurationId String

The requested Configuration instance.

displayName String

A filter to return only the resource matching the given display name exactly.

filters List<Property Map>
shapeName String

The requested Shape name.

state String

Configuration Lifecycle State

types List<String>

The requested Configuration types.

getMysqlConfigurations Result

The following output properties are available:

CompartmentId string

OCID of the Compartment the Configuration exists in.

Configurations List<GetMysqlConfigurationsConfiguration>

The list of configurations.

Id string

The provider-assigned unique ID for this managed resource.

ConfigurationId string
DisplayName string

The display name of the Configuration.

Filters List<GetMysqlConfigurationsFilter>
ShapeName string

The name of the associated Shape.

State string

The current state of the Configuration.

Types List<string>

The Configuration type, DEFAULT or CUSTOM.

CompartmentId string

OCID of the Compartment the Configuration exists in.

Configurations []GetMysqlConfigurationsConfiguration

The list of configurations.

Id string

The provider-assigned unique ID for this managed resource.

ConfigurationId string
DisplayName string

The display name of the Configuration.

Filters []GetMysqlConfigurationsFilter
ShapeName string

The name of the associated Shape.

State string

The current state of the Configuration.

Types []string

The Configuration type, DEFAULT or CUSTOM.

compartmentId String

OCID of the Compartment the Configuration exists in.

configurations List<GetConfigurationsConfiguration>

The list of configurations.

id String

The provider-assigned unique ID for this managed resource.

configurationId String
displayName String

The display name of the Configuration.

filters List<GetConfigurationsFilter>
shapeName String

The name of the associated Shape.

state String

The current state of the Configuration.

types List<String>

The Configuration type, DEFAULT or CUSTOM.

compartmentId string

OCID of the Compartment the Configuration exists in.

configurations GetMysqlConfigurationsConfiguration[]

The list of configurations.

id string

The provider-assigned unique ID for this managed resource.

configurationId string
displayName string

The display name of the Configuration.

filters GetMysqlConfigurationsFilter[]
shapeName string

The name of the associated Shape.

state string

The current state of the Configuration.

types string[]

The Configuration type, DEFAULT or CUSTOM.

compartment_id str

OCID of the Compartment the Configuration exists in.

configurations GetMysqlConfigurationsConfiguration]

The list of configurations.

id str

The provider-assigned unique ID for this managed resource.

configuration_id str
display_name str

The display name of the Configuration.

filters GetMysqlConfigurationsFilter]
shape_name str

The name of the associated Shape.

state str

The current state of the Configuration.

types Sequence[str]

The Configuration type, DEFAULT or CUSTOM.

compartmentId String

OCID of the Compartment the Configuration exists in.

configurations List<Property Map>

The list of configurations.

id String

The provider-assigned unique ID for this managed resource.

configurationId String
displayName String

The display name of the Configuration.

filters List<Property Map>
shapeName String

The name of the associated Shape.

state String

The current state of the Configuration.

types List<String>

The Configuration type, DEFAULT or CUSTOM.

Supporting Types

GetMysqlConfigurationsConfiguration

CompartmentId string

The compartment OCID.

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

A filter to return only the resource matching the given display name exactly.

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.

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 requested Shape name.

State string

Configuration Lifecycle State

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 requested Configuration types.

Variables GetMysqlConfigurationsConfigurationVariables

User controllable service variables.

CompartmentId string

The compartment OCID.

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

A filter to return only the resource matching the given display name exactly.

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.

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 requested Shape name.

State string

Configuration Lifecycle State

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 requested Configuration types.

Variables GetMysqlConfigurationsConfigurationVariables

User controllable service variables.

compartmentId String

The compartment OCID.

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

A filter to return only the resource matching the given display name exactly.

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.

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 requested Shape name.

state String

Configuration Lifecycle State

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 requested Configuration types.

variables GetConfigurationsConfigurationVariables

User controllable service variables.

compartmentId string

The compartment OCID.

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

A filter to return only the resource matching the given display name exactly.

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.

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 requested Shape name.

state string

Configuration Lifecycle State

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 requested Configuration types.

variables GetMysqlConfigurationsConfigurationVariables

User controllable service variables.

compartment_id str

The compartment OCID.

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

A filter to return only the resource matching the given display name exactly.

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.

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 requested Shape name.

state str

Configuration Lifecycle State

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 requested Configuration types.

variables GetMysqlConfigurationsConfigurationVariables

User controllable service variables.

compartmentId String

The compartment OCID.

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

A filter to return only the resource matching the given display name exactly.

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.

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 requested Shape name.

state String

Configuration Lifecycle State

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 requested Configuration types.

variables Property Map

User controllable service variables.

GetMysqlConfigurationsConfigurationVariables

Autocommit bool

("autocommit")

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

("connect_timeout")

CteMaxRecursionDepth int

("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

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")

InnodbBufferPoolInstances int

("innodb_buffer_pool_instances")

InnodbBufferPoolSize string

("innodb_buffer_pool_size")

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 int

("innodb_ft_result_cache_limit")

InnodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

InnodbLockWaitTimeout int

("innodb_lock_wait_timeout")

InnodbMaxPurgeLag int

("innodb_max_purge_lag")

InnodbMaxPurgeLagDelay int

("innodb_max_purge_lag_delay")

LocalInfile bool

("local_infile")

MandatoryRoles string

("mandatory_roles")

MaxConnections int

("max_connections")

MaxExecutionTime int

("max_execution_time")

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.

MysqlxConnectTimeout int

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

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

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

MysqlxInteractiveTimeout int

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

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

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

MysqlxMinWorkerThreads int

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

MysqlxReadTimeout int

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

MysqlxWaitTimeout int

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

MysqlxWriteTimeout int

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

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")

ParserMaxMemSize int

("parser_max_mem_size")

QueryAllocBlockSize int

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

QueryPreallocSize int

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

SqlMode string

("sql_mode")

SqlRequirePrimaryKey bool

("sql_require_primary_key")

SqlWarnings bool

("sql_warnings")

TransactionIsolation string

("transaction_isolation")

Autocommit bool

("autocommit")

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

("connect_timeout")

CteMaxRecursionDepth int

("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

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")

InnodbBufferPoolInstances int

("innodb_buffer_pool_instances")

InnodbBufferPoolSize string

("innodb_buffer_pool_size")

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 int

("innodb_ft_result_cache_limit")

InnodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

InnodbLockWaitTimeout int

("innodb_lock_wait_timeout")

InnodbMaxPurgeLag int

("innodb_max_purge_lag")

InnodbMaxPurgeLagDelay int

("innodb_max_purge_lag_delay")

LocalInfile bool

("local_infile")

MandatoryRoles string

("mandatory_roles")

MaxConnections int

("max_connections")

MaxExecutionTime int

("max_execution_time")

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.

MysqlxConnectTimeout int

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

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

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

MysqlxInteractiveTimeout int

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

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

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

MysqlxMinWorkerThreads int

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

MysqlxReadTimeout int

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

MysqlxWaitTimeout int

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

MysqlxWriteTimeout int

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

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")

ParserMaxMemSize int

("parser_max_mem_size")

QueryAllocBlockSize int

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

QueryPreallocSize int

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

SqlMode string

("sql_mode")

SqlRequirePrimaryKey bool

("sql_require_primary_key")

SqlWarnings bool

("sql_warnings")

TransactionIsolation string

("transaction_isolation")

autocommit Boolean

("autocommit")

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

("connect_timeout")

cteMaxRecursionDepth Integer

("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

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")

innodbBufferPoolInstances Integer

("innodb_buffer_pool_instances")

innodbBufferPoolSize String

("innodb_buffer_pool_size")

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 Integer

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable String

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout Integer

("innodb_lock_wait_timeout")

innodbMaxPurgeLag Integer

("innodb_max_purge_lag")

innodbMaxPurgeLagDelay Integer

("innodb_max_purge_lag_delay")

localInfile Boolean

("local_infile")

mandatoryRoles String

("mandatory_roles")

maxConnections Integer

("max_connections")

maxExecutionTime Integer

("max_execution_time")

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.

mysqlxConnectTimeout Integer

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

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

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

mysqlxInteractiveTimeout Integer

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

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

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

mysqlxMinWorkerThreads Integer

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

mysqlxReadTimeout Integer

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

mysqlxWaitTimeout Integer

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

mysqlxWriteTimeout Integer

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

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")

parserMaxMemSize Integer

("parser_max_mem_size")

queryAllocBlockSize Integer

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

queryPreallocSize Integer

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

sqlMode String

("sql_mode")

sqlRequirePrimaryKey Boolean

("sql_require_primary_key")

sqlWarnings Boolean

("sql_warnings")

transactionIsolation String

("transaction_isolation")

autocommit boolean

("autocommit")

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

("connect_timeout")

cteMaxRecursionDepth number

("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

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")

innodbBufferPoolInstances number

("innodb_buffer_pool_instances")

innodbBufferPoolSize string

("innodb_buffer_pool_size")

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 number

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable string

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout number

("innodb_lock_wait_timeout")

innodbMaxPurgeLag number

("innodb_max_purge_lag")

innodbMaxPurgeLagDelay number

("innodb_max_purge_lag_delay")

localInfile boolean

("local_infile")

mandatoryRoles string

("mandatory_roles")

maxConnections number

("max_connections")

maxExecutionTime number

("max_execution_time")

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.

mysqlxConnectTimeout number

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

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

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

mysqlxInteractiveTimeout number

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

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

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

mysqlxMinWorkerThreads number

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

mysqlxReadTimeout number

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

mysqlxWaitTimeout number

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

mysqlxWriteTimeout number

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

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")

parserMaxMemSize number

("parser_max_mem_size")

queryAllocBlockSize number

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

queryPreallocSize number

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

sqlMode string

("sql_mode")

sqlRequirePrimaryKey boolean

("sql_require_primary_key")

sqlWarnings boolean

("sql_warnings")

transactionIsolation string

("transaction_isolation")

autocommit bool

("autocommit")

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

("connect_timeout")

cte_max_recursion_depth int

("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

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_instances int

("innodb_buffer_pool_instances")

innodb_buffer_pool_size str

("innodb_buffer_pool_size")

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 int

("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_max_purge_lag int

("innodb_max_purge_lag")

innodb_max_purge_lag_delay int

("innodb_max_purge_lag_delay")

local_infile bool

("local_infile")

mandatory_roles str

("mandatory_roles")

max_connections int

("max_connections")

max_execution_time int

("max_execution_time")

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.

mysqlx_connect_timeout int

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

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

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

mysqlx_interactive_timeout int

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

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

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

mysqlx_min_worker_threads int

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

mysqlx_read_timeout int

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

mysqlx_wait_timeout int

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

mysqlx_write_timeout int

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

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")

parser_max_mem_size int

("parser_max_mem_size")

query_alloc_block_size int

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

query_prealloc_size int

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

sql_mode str

("sql_mode")

sql_require_primary_key bool

("sql_require_primary_key")

sql_warnings bool

("sql_warnings")

transaction_isolation str

("transaction_isolation")

autocommit Boolean

("autocommit")

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

("connect_timeout")

cteMaxRecursionDepth Number

("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

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")

innodbBufferPoolInstances Number

("innodb_buffer_pool_instances")

innodbBufferPoolSize String

("innodb_buffer_pool_size")

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 Number

("innodb_ft_result_cache_limit")

innodbFtServerStopwordTable String

("innodb_ft_server_stopword_table")

innodbLockWaitTimeout Number

("innodb_lock_wait_timeout")

innodbMaxPurgeLag Number

("innodb_max_purge_lag")

innodbMaxPurgeLagDelay Number

("innodb_max_purge_lag_delay")

localInfile Boolean

("local_infile")

mandatoryRoles String

("mandatory_roles")

maxConnections Number

("max_connections")

maxExecutionTime Number

("max_execution_time")

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.

mysqlxConnectTimeout Number

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

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

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

mysqlxInteractiveTimeout Number

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

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

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

mysqlxMinWorkerThreads Number

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

mysqlxReadTimeout Number

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

mysqlxWaitTimeout Number

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

mysqlxWriteTimeout Number

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

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")

parserMaxMemSize Number

("parser_max_mem_size")

queryAllocBlockSize Number

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

queryPreallocSize Number

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

sqlMode String

("sql_mode")

sqlRequirePrimaryKey Boolean

("sql_require_primary_key")

sqlWarnings Boolean

("sql_warnings")

transactionIsolation String

("transaction_isolation")

GetMysqlConfigurationsFilter

Name string
Values List<string>
Regex bool
Name string
Values []string
Regex bool
name String
values List<String>
regex Boolean
name string
values string[]
regex boolean
name str
values Sequence[str]
regex bool
name String
values List<String>
regex Boolean

Package Details

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

This Pulumi package is based on the oci Terraform Provider.