Oracle Cloud Infrastructure
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 Pulumi;
using Oci = Pulumi.Oci;
class MyStack : Stack
{
public MyStack()
{
var testMysqlConfiguration = Output.Create(Oci.Mysql.GetMysqlConfiguration.InvokeAsync(new Oci.Mysql.GetMysqlConfigurationArgs
{
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
})
}
Coming soon!
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,
});
Coming soon!
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:
- Configuration
Id string The OCID of the Configuration.
- Configuration
Id string The OCID of the Configuration.
- configuration
Id String The OCID of the Configuration.
- configuration
Id string The OCID of the Configuration.
- configuration_
id str The OCID of the Configuration.
- configuration
Id String The OCID of the Configuration.
getMysqlConfiguration Result
The following output properties are available:
- Compartment
Id string OCID of the Compartment the Configuration exists in.
- Configuration
Id string - 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.
- Display
Name string The display name of the Configuration.
- 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 provider-assigned unique ID for this managed resource.
- Parent
Configuration stringId 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 string The name of the associated Shape.
- State string
The current state of the Configuration.
- Time
Created string The date and time the Configuration was created, as described by RFC 3339.
- Time
Updated 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<Get
Mysql Configuration Variable> User controllable service variables.
- Compartment
Id string OCID of the Compartment the Configuration exists in.
- Configuration
Id string - 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.
- Display
Name string The display name of the Configuration.
- 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 provider-assigned unique ID for this managed resource.
- Parent
Configuration stringId 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 string The name of the associated Shape.
- State string
The current state of the Configuration.
- Time
Created string The date and time the Configuration was created, as described by RFC 3339.
- Time
Updated string The date and time the Configuration was last updated, as described by RFC 3339.
- Type string
The Configuration type, DEFAULT or CUSTOM.
- Variables
[]Get
Mysql Configuration Variable User controllable service variables.
- compartment
Id String OCID of the Compartment the Configuration exists in.
- configuration
Id String - 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.
- display
Name String The display name of the Configuration.
- 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 provider-assigned unique ID for this managed resource.
- parent
Configuration StringId 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 String The name of the associated Shape.
- state String
The current state of the Configuration.
- time
Created String The date and time the Configuration was created, as described by RFC 3339.
- time
Updated 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<Get
Configuration Variable> User controllable service variables.
- compartment
Id string OCID of the Compartment the Configuration exists in.
- configuration
Id string - {[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.
- display
Name string The display name of the Configuration.
- {[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 provider-assigned unique ID for this managed resource.
- parent
Configuration stringId 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 string The name of the associated Shape.
- state string
The current state of the Configuration.
- time
Created string The date and time the Configuration was created, as described by RFC 3339.
- time
Updated string The date and time the Configuration was last updated, as described by RFC 3339.
- type string
The Configuration type, DEFAULT or CUSTOM.
- variables
Get
Mysql Configuration Variable[] User controllable service variables.
- compartment_
id str OCID of the Compartment the Configuration exists in.
- configuration_
id str - 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.
- 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 provider-assigned unique ID for this managed resource.
- parent_
configuration_ strid 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
Get
Mysql Configuration Variable] User controllable service variables.
- compartment
Id String OCID of the Compartment the Configuration exists in.
- configuration
Id String - 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.
- display
Name String The display name of the Configuration.
- 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 provider-assigned unique ID for this managed resource.
- parent
Configuration StringId 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 String The name of the associated Shape.
- state String
The current state of the Configuration.
- time
Created String The date and time the Configuration was created, as described by RFC 3339.
- time
Updated 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 controllable service variables.
Supporting Types
GetMysqlConfigurationVariable
- Autocommit bool
("autocommit")
- Binlog
Expire intLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- Binlog
Row stringMetadata 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 stringValue Options 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 boolCompression 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 string ("completion_type")
- Connect
Timeout int ("connect_timeout")
- Cte
Max intRecursion Depth ("cte_max_recursion_depth")
- Default
Authentication stringPlugin ("default_authentication_plugin")
- Foreign
Key boolChecks ("foreign_key_checks")
- Generated
Random intPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- Group
Replication stringConsistency - 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 intStats Expiry ("information_schema_stats_expiry")
- Innodb
Buffer intPool Instances ("innodb_buffer_pool_instances")
- Innodb
Buffer stringPool Size ("innodb_buffer_pool_size")
- Innodb
Ft boolEnable Stopword ("innodb_ft_enable_stopword")
- Innodb
Ft intMax Token Size ("innodb_ft_max_token_size")
- Innodb
Ft intMin Token Size ("innodb_ft_min_token_size")
- Innodb
Ft intNum Word Optimize ("innodb_ft_num_word_optimize")
- Innodb
Ft intResult Cache Limit ("innodb_ft_result_cache_limit")
- Innodb
Ft stringServer Stopword Table ("innodb_ft_server_stopword_table")
- Innodb
Lock intWait Timeout ("innodb_lock_wait_timeout")
- Innodb
Max intPurge Lag ("innodb_max_purge_lag")
- Innodb
Max intPurge Lag Delay ("innodb_max_purge_lag_delay")
- Local
Infile bool ("local_infile")
- Mandatory
Roles string ("mandatory_roles")
- Max
Connections int ("max_connections")
- Max
Execution intTime ("max_execution_time")
- Max
Prepared intStmt Count ("max_prepared_stmt_count")
- Mysql
Firewall boolMode ("mysql_firewall_mode")
- Mysql
Zstd intDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- Mysqlx
Connect intTimeout ("mysqlx_connect_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Deflate intDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- Mysqlx
Deflate intMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- Mysqlx
Document intId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Enable boolHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Idle intWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Interactive intTimeout ("mysqlx_interactive_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Lz4default intCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- Mysqlx
Lz4max intClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- Mysqlx
Max intAllowed Packet ("mysqlx_max_allowed_packet") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Min intWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Read intTimeout ("mysqlx_read_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Wait intTimeout ("mysqlx_wait_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Write intTimeout ("mysqlx_write_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Zstd intDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- Mysqlx
Zstd intMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- Parser
Max intMem Size ("parser_max_mem_size")
- Query
Alloc intBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- Query
Prealloc intSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- Sql
Mode string ("sql_mode")
- Sql
Require boolPrimary Key ("sql_require_primary_key")
- Sql
Warnings bool ("sql_warnings")
- Transaction
Isolation string ("transaction_isolation")
- Autocommit bool
("autocommit")
- Binlog
Expire intLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- Binlog
Row stringMetadata 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 stringValue Options 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 boolCompression 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 string ("completion_type")
- Connect
Timeout int ("connect_timeout")
- Cte
Max intRecursion Depth ("cte_max_recursion_depth")
- Default
Authentication stringPlugin ("default_authentication_plugin")
- Foreign
Key boolChecks ("foreign_key_checks")
- Generated
Random intPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- Group
Replication stringConsistency - 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 intStats Expiry ("information_schema_stats_expiry")
- Innodb
Buffer intPool Instances ("innodb_buffer_pool_instances")
- Innodb
Buffer stringPool Size ("innodb_buffer_pool_size")
- Innodb
Ft boolEnable Stopword ("innodb_ft_enable_stopword")
- Innodb
Ft intMax Token Size ("innodb_ft_max_token_size")
- Innodb
Ft intMin Token Size ("innodb_ft_min_token_size")
- Innodb
Ft intNum Word Optimize ("innodb_ft_num_word_optimize")
- Innodb
Ft intResult Cache Limit ("innodb_ft_result_cache_limit")
- Innodb
Ft stringServer Stopword Table ("innodb_ft_server_stopword_table")
- Innodb
Lock intWait Timeout ("innodb_lock_wait_timeout")
- Innodb
Max intPurge Lag ("innodb_max_purge_lag")
- Innodb
Max intPurge Lag Delay ("innodb_max_purge_lag_delay")
- Local
Infile bool ("local_infile")
- Mandatory
Roles string ("mandatory_roles")
- Max
Connections int ("max_connections")
- Max
Execution intTime ("max_execution_time")
- Max
Prepared intStmt Count ("max_prepared_stmt_count")
- Mysql
Firewall boolMode ("mysql_firewall_mode")
- Mysql
Zstd intDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- Mysqlx
Connect intTimeout ("mysqlx_connect_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Deflate intDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- Mysqlx
Deflate intMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- Mysqlx
Document intId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Enable boolHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Idle intWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Interactive intTimeout ("mysqlx_interactive_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Lz4default intCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- Mysqlx
Lz4max intClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- Mysqlx
Max intAllowed Packet ("mysqlx_max_allowed_packet") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Min intWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Read intTimeout ("mysqlx_read_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Wait intTimeout ("mysqlx_wait_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Write intTimeout ("mysqlx_write_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Zstd intDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- Mysqlx
Zstd intMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- Parser
Max intMem Size ("parser_max_mem_size")
- Query
Alloc intBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- Query
Prealloc intSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- Sql
Mode string ("sql_mode")
- Sql
Require boolPrimary Key ("sql_require_primary_key")
- Sql
Warnings bool ("sql_warnings")
- Transaction
Isolation string ("transaction_isolation")
- autocommit Boolean
("autocommit")
- binlog
Expire IntegerLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row StringMetadata 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 StringValue Options 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 BooleanCompression 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 String ("completion_type")
- connect
Timeout Integer ("connect_timeout")
- cte
Max IntegerRecursion Depth ("cte_max_recursion_depth")
- default
Authentication StringPlugin ("default_authentication_plugin")
- foreign
Key BooleanChecks ("foreign_key_checks")
- generated
Random IntegerPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- group
Replication StringConsistency - 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 IntegerStats Expiry ("information_schema_stats_expiry")
- innodb
Buffer IntegerPool Instances ("innodb_buffer_pool_instances")
- innodb
Buffer StringPool Size ("innodb_buffer_pool_size")
- innodb
Ft BooleanEnable Stopword ("innodb_ft_enable_stopword")
- innodb
Ft IntegerMax Token Size ("innodb_ft_max_token_size")
- innodb
Ft IntegerMin Token Size ("innodb_ft_min_token_size")
- innodb
Ft IntegerNum Word Optimize ("innodb_ft_num_word_optimize")
- innodb
Ft IntegerResult Cache Limit ("innodb_ft_result_cache_limit")
- innodb
Ft StringServer Stopword Table ("innodb_ft_server_stopword_table")
- innodb
Lock IntegerWait Timeout ("innodb_lock_wait_timeout")
- innodb
Max IntegerPurge Lag ("innodb_max_purge_lag")
- innodb
Max IntegerPurge Lag Delay ("innodb_max_purge_lag_delay")
- local
Infile Boolean ("local_infile")
- mandatory
Roles String ("mandatory_roles")
- max
Connections Integer ("max_connections")
- max
Execution IntegerTime ("max_execution_time")
- max
Prepared IntegerStmt Count ("max_prepared_stmt_count")
- mysql
Firewall BooleanMode ("mysql_firewall_mode")
- mysql
Zstd IntegerDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- mysqlx
Connect IntegerTimeout ("mysqlx_connect_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Deflate IntegerDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate IntegerMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document IntegerId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Enable BooleanHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle IntegerWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Interactive IntegerTimeout ("mysqlx_interactive_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Lz4default IntegerCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max IntegerClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max IntegerAllowed Packet ("mysqlx_max_allowed_packet") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Min IntegerWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Read IntegerTimeout ("mysqlx_read_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Wait IntegerTimeout ("mysqlx_wait_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Write IntegerTimeout ("mysqlx_write_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Zstd IntegerDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd IntegerMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- parser
Max IntegerMem Size ("parser_max_mem_size")
- query
Alloc IntegerBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- query
Prealloc IntegerSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- sql
Mode String ("sql_mode")
- sql
Require BooleanPrimary Key ("sql_require_primary_key")
- sql
Warnings Boolean ("sql_warnings")
- transaction
Isolation String ("transaction_isolation")
- autocommit boolean
("autocommit")
- binlog
Expire numberLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row stringMetadata 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 stringValue Options 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 booleanCompression 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 string ("completion_type")
- connect
Timeout number ("connect_timeout")
- cte
Max numberRecursion Depth ("cte_max_recursion_depth")
- default
Authentication stringPlugin ("default_authentication_plugin")
- foreign
Key booleanChecks ("foreign_key_checks")
- generated
Random numberPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- group
Replication stringConsistency - 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 numberStats Expiry ("information_schema_stats_expiry")
- innodb
Buffer numberPool Instances ("innodb_buffer_pool_instances")
- innodb
Buffer stringPool Size ("innodb_buffer_pool_size")
- innodb
Ft booleanEnable Stopword ("innodb_ft_enable_stopword")
- innodb
Ft numberMax Token Size ("innodb_ft_max_token_size")
- innodb
Ft numberMin Token Size ("innodb_ft_min_token_size")
- innodb
Ft numberNum Word Optimize ("innodb_ft_num_word_optimize")
- innodb
Ft numberResult Cache Limit ("innodb_ft_result_cache_limit")
- innodb
Ft stringServer Stopword Table ("innodb_ft_server_stopword_table")
- innodb
Lock numberWait Timeout ("innodb_lock_wait_timeout")
- innodb
Max numberPurge Lag ("innodb_max_purge_lag")
- innodb
Max numberPurge Lag Delay ("innodb_max_purge_lag_delay")
- local
Infile boolean ("local_infile")
- mandatory
Roles string ("mandatory_roles")
- max
Connections number ("max_connections")
- max
Execution numberTime ("max_execution_time")
- max
Prepared numberStmt Count ("max_prepared_stmt_count")
- mysql
Firewall booleanMode ("mysql_firewall_mode")
- mysql
Zstd numberDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- mysqlx
Connect numberTimeout ("mysqlx_connect_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Deflate numberDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate numberMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document numberId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Enable booleanHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle numberWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Interactive numberTimeout ("mysqlx_interactive_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Lz4default numberCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max numberClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max numberAllowed Packet ("mysqlx_max_allowed_packet") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Min numberWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Read numberTimeout ("mysqlx_read_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Wait numberTimeout ("mysqlx_wait_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Write numberTimeout ("mysqlx_write_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Zstd numberDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd numberMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- parser
Max numberMem Size ("parser_max_mem_size")
- query
Alloc numberBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- query
Prealloc numberSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- sql
Mode string ("sql_mode")
- sql
Require booleanPrimary Key ("sql_require_primary_key")
- sql
Warnings boolean ("sql_warnings")
- transaction
Isolation string ("transaction_isolation")
- autocommit bool
("autocommit")
- binlog_
expire_ intlogs_ seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog_
row_ strmetadata 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_ strvalue_ options 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_ boolcompression 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_ intrecursion_ depth ("cte_max_recursion_depth")
- default_
authentication_ strplugin ("default_authentication_plugin")
- foreign_
key_ boolchecks ("foreign_key_checks")
- generated_
random_ intpassword_ length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- group_
replication_ strconsistency - 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_ intstats_ expiry ("information_schema_stats_expiry")
- innodb_
buffer_ intpool_ instances ("innodb_buffer_pool_instances")
- innodb_
buffer_ strpool_ size ("innodb_buffer_pool_size")
- innodb_
ft_ boolenable_ stopword ("innodb_ft_enable_stopword")
- innodb_
ft_ intmax_ token_ size ("innodb_ft_max_token_size")
- innodb_
ft_ intmin_ token_ size ("innodb_ft_min_token_size")
- innodb_
ft_ intnum_ word_ optimize ("innodb_ft_num_word_optimize")
- innodb_
ft_ intresult_ cache_ limit ("innodb_ft_result_cache_limit")
- innodb_
ft_ strserver_ stopword_ table ("innodb_ft_server_stopword_table")
- innodb_
lock_ intwait_ timeout ("innodb_lock_wait_timeout")
- innodb_
max_ intpurge_ lag ("innodb_max_purge_lag")
- innodb_
max_ intpurge_ lag_ delay ("innodb_max_purge_lag_delay")
- local_
infile bool ("local_infile")
- mandatory_
roles str ("mandatory_roles")
- max_
connections int ("max_connections")
- max_
execution_ inttime ("max_execution_time")
- max_
prepared_ intstmt_ count ("max_prepared_stmt_count")
- mysql_
firewall_ boolmode ("mysql_firewall_mode")
- mysql_
zstd_ intdefault_ compression_ level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- mysqlx_
connect_ inttimeout ("mysqlx_connect_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
deflate_ intdefault_ compression_ level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx_
deflate_ intmax_ client_ compression_ level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx_
document_ intid_ unique_ prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
enable_ boolhello_ notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
idle_ intworker_ thread_ timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
interactive_ inttimeout ("mysqlx_interactive_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
lz4default_ intcompression_ level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx_
lz4max_ intclient_ compression_ level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx_
max_ intallowed_ packet ("mysqlx_max_allowed_packet") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
min_ intworker_ threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
read_ inttimeout ("mysqlx_read_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
wait_ inttimeout ("mysqlx_wait_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
write_ inttimeout ("mysqlx_write_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
zstd_ intdefault_ compression_ level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx_
zstd_ intmax_ client_ compression_ level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- parser_
max_ intmem_ size ("parser_max_mem_size")
- query_
alloc_ intblock_ size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- query_
prealloc_ intsize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- sql_
mode str ("sql_mode")
- sql_
require_ boolprimary_ key ("sql_require_primary_key")
- sql_
warnings bool ("sql_warnings")
- transaction_
isolation str ("transaction_isolation")
- autocommit Boolean
("autocommit")
- binlog
Expire NumberLogs Seconds Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row StringMetadata 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 StringValue Options 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 BooleanCompression 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 String ("completion_type")
- connect
Timeout Number ("connect_timeout")
- cte
Max NumberRecursion Depth ("cte_max_recursion_depth")
- default
Authentication StringPlugin ("default_authentication_plugin")
- foreign
Key BooleanChecks ("foreign_key_checks")
- generated
Random NumberPassword Length ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- group
Replication StringConsistency - 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 NumberStats Expiry ("information_schema_stats_expiry")
- innodb
Buffer NumberPool Instances ("innodb_buffer_pool_instances")
- innodb
Buffer StringPool Size ("innodb_buffer_pool_size")
- innodb
Ft BooleanEnable Stopword ("innodb_ft_enable_stopword")
- innodb
Ft NumberMax Token Size ("innodb_ft_max_token_size")
- innodb
Ft NumberMin Token Size ("innodb_ft_min_token_size")
- innodb
Ft NumberNum Word Optimize ("innodb_ft_num_word_optimize")
- innodb
Ft NumberResult Cache Limit ("innodb_ft_result_cache_limit")
- innodb
Ft StringServer Stopword Table ("innodb_ft_server_stopword_table")
- innodb
Lock NumberWait Timeout ("innodb_lock_wait_timeout")
- innodb
Max NumberPurge Lag ("innodb_max_purge_lag")
- innodb
Max NumberPurge Lag Delay ("innodb_max_purge_lag_delay")
- local
Infile Boolean ("local_infile")
- mandatory
Roles String ("mandatory_roles")
- max
Connections Number ("max_connections")
- max
Execution NumberTime ("max_execution_time")
- max
Prepared NumberStmt Count ("max_prepared_stmt_count")
- mysql
Firewall BooleanMode ("mysql_firewall_mode")
- mysql
Zstd NumberDefault Compression Level DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- mysqlx
Connect NumberTimeout ("mysqlx_connect_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Deflate NumberDefault Compression Level Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate NumberMax Client Compression Level Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document NumberId Unique Prefix ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Enable BooleanHello Notice ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle NumberWorker Thread Timeout ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Interactive NumberTimeout ("mysqlx_interactive_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Lz4default NumberCompression Level Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max NumberClient Compression Level Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max NumberAllowed Packet ("mysqlx_max_allowed_packet") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Min NumberWorker Threads ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Read NumberTimeout ("mysqlx_read_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Wait NumberTimeout ("mysqlx_wait_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Write NumberTimeout ("mysqlx_write_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Zstd NumberDefault Compression Level Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd NumberMax Client Compression Level Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- parser
Max NumberMem Size ("parser_max_mem_size")
- query
Alloc NumberBlock Size ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- query
Prealloc NumberSize ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- sql
Mode String ("sql_mode")
- sql
Require BooleanPrimary Key ("sql_require_primary_key")
- sql
Warnings Boolean ("sql_warnings")
- transaction
Isolation String ("transaction_isolation")
Package Details
- Repository
- https://github.com/pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
oci
Terraform Provider.