ConfigurationVariables¶

class oci.mysql.models.ConfigurationVariables(**kwargs)¶

Bases: object

User controllable service variables.

Attributes

`BINLOG_ROW_METADATA_FULL`	A constant which can be used with the binlog_row_metadata property of a ConfigurationVariables.
`BINLOG_ROW_METADATA_MINIMAL`	A constant which can be used with the binlog_row_metadata property of a ConfigurationVariables.
`COMPLETION_TYPE_CHAIN`	A constant which can be used with the completion_type property of a ConfigurationVariables.
`COMPLETION_TYPE_NO_CHAIN`	A constant which can be used with the completion_type property of a ConfigurationVariables.
`COMPLETION_TYPE_RELEASE`	A constant which can be used with the completion_type property of a ConfigurationVariables.
`DEFAULT_AUTHENTICATION_PLUGIN_CACHING_SHA2_PASSWORD`	A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables.
`DEFAULT_AUTHENTICATION_PLUGIN_MYSQL_NATIVE_PASSWORD`	A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables.
`DEFAULT_AUTHENTICATION_PLUGIN_SHA256_PASSWORD`	A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables.
`GROUP_REPLICATION_CONSISTENCY_AFTER`	A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
`GROUP_REPLICATION_CONSISTENCY_BEFORE`	A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
`GROUP_REPLICATION_CONSISTENCY_BEFORE_AND_AFTER`	A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
`GROUP_REPLICATION_CONSISTENCY_BEFORE_ON_PRIMARY_FAILOVER`	A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
`GROUP_REPLICATION_CONSISTENCY_EVENTUAL`	A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
`TRANSACTION_ISOLATION_READ_COMMITED`	A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
`TRANSACTION_ISOLATION_READ_COMMITTED`	A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
`TRANSACTION_ISOLATION_READ_UNCOMMITTED`	A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
`TRANSACTION_ISOLATION_REPEATABLE_READ`	A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
`TRANSACTION_ISOLATION_SERIALIZABLE`	A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
`autocommit`	Gets the autocommit of this ConfigurationVariables.
`binlog_expire_logs_seconds`	Gets the binlog_expire_logs_seconds of this ConfigurationVariables.
`binlog_row_metadata`	Gets the binlog_row_metadata of this ConfigurationVariables.
`binlog_row_value_options`	Gets the binlog_row_value_options of this ConfigurationVariables.
`binlog_transaction_compression`	Gets the binlog_transaction_compression of this ConfigurationVariables.
`completion_type`	Gets the completion_type of this ConfigurationVariables.
`connect_timeout`	Gets the connect_timeout of this ConfigurationVariables.
`cte_max_recursion_depth`	Gets the cte_max_recursion_depth of this ConfigurationVariables.
`default_authentication_plugin`	Gets the default_authentication_plugin of this ConfigurationVariables.
`foreign_key_checks`	Gets the foreign_key_checks of this ConfigurationVariables.
`generated_random_password_length`	Gets the generated_random_password_length of this ConfigurationVariables.
`group_replication_consistency`	Gets the group_replication_consistency of this ConfigurationVariables.
`information_schema_stats_expiry`	Gets the information_schema_stats_expiry of this ConfigurationVariables.
`innodb_buffer_pool_instances`	Gets the innodb_buffer_pool_instances of this ConfigurationVariables.
`innodb_buffer_pool_size`	Gets the innodb_buffer_pool_size of this ConfigurationVariables.
`innodb_ft_enable_stopword`	Gets the innodb_ft_enable_stopword of this ConfigurationVariables.
`innodb_ft_max_token_size`	Gets the innodb_ft_max_token_size of this ConfigurationVariables.
`innodb_ft_min_token_size`	Gets the innodb_ft_min_token_size of this ConfigurationVariables.
`innodb_ft_num_word_optimize`	Gets the innodb_ft_num_word_optimize of this ConfigurationVariables.
`innodb_ft_result_cache_limit`	Gets the innodb_ft_result_cache_limit of this ConfigurationVariables.
`innodb_ft_server_stopword_table`	Gets the innodb_ft_server_stopword_table of this ConfigurationVariables.
`innodb_lock_wait_timeout`	Gets the innodb_lock_wait_timeout of this ConfigurationVariables.
`innodb_max_purge_lag`	Gets the innodb_max_purge_lag of this ConfigurationVariables.
`innodb_max_purge_lag_delay`	Gets the innodb_max_purge_lag_delay of this ConfigurationVariables.
`local_infile`	Gets the local_infile of this ConfigurationVariables.
`mandatory_roles`	Gets the mandatory_roles of this ConfigurationVariables.
`max_connections`	Gets the max_connections of this ConfigurationVariables.
`max_execution_time`	Gets the max_execution_time of this ConfigurationVariables.
`max_prepared_stmt_count`	Gets the max_prepared_stmt_count of this ConfigurationVariables.
`mysql_firewall_mode`	Gets the mysql_firewall_mode of this ConfigurationVariables.
`mysql_zstd_default_compression_level`	Gets the mysql_zstd_default_compression_level of this ConfigurationVariables.
`mysqlx_connect_timeout`	Gets the mysqlx_connect_timeout of this ConfigurationVariables.
`mysqlx_deflate_default_compression_level`	Gets the mysqlx_deflate_default_compression_level of this ConfigurationVariables.
`mysqlx_deflate_max_client_compression_level`	Gets the mysqlx_deflate_max_client_compression_level of this ConfigurationVariables.
`mysqlx_document_id_unique_prefix`	Gets the mysqlx_document_id_unique_prefix of this ConfigurationVariables.
`mysqlx_enable_hello_notice`	Gets the mysqlx_enable_hello_notice of this ConfigurationVariables.
`mysqlx_idle_worker_thread_timeout`	Gets the mysqlx_idle_worker_thread_timeout of this ConfigurationVariables.
`mysqlx_interactive_timeout`	Gets the mysqlx_interactive_timeout of this ConfigurationVariables.
`mysqlx_lz4_default_compression_level`	Gets the mysqlx_lz4_default_compression_level of this ConfigurationVariables.
`mysqlx_lz4_max_client_compression_level`	Gets the mysqlx_lz4_max_client_compression_level of this ConfigurationVariables.
`mysqlx_max_allowed_packet`	Gets the mysqlx_max_allowed_packet of this ConfigurationVariables.
`mysqlx_min_worker_threads`	Gets the mysqlx_min_worker_threads of this ConfigurationVariables.
`mysqlx_read_timeout`	Gets the mysqlx_read_timeout of this ConfigurationVariables.
`mysqlx_wait_timeout`	Gets the mysqlx_wait_timeout of this ConfigurationVariables.
`mysqlx_write_timeout`	Gets the mysqlx_write_timeout of this ConfigurationVariables.
`mysqlx_zstd_default_compression_level`	Gets the mysqlx_zstd_default_compression_level of this ConfigurationVariables.
`mysqlx_zstd_max_client_compression_level`	Gets the mysqlx_zstd_max_client_compression_level of this ConfigurationVariables.
`parser_max_mem_size`	Gets the parser_max_mem_size of this ConfigurationVariables.
`query_alloc_block_size`	Gets the query_alloc_block_size of this ConfigurationVariables.
`query_prealloc_size`	Gets the query_prealloc_size of this ConfigurationVariables.
`sql_mode`	Gets the sql_mode of this ConfigurationVariables.
`sql_require_primary_key`	Gets the sql_require_primary_key of this ConfigurationVariables.
`sql_warnings`	Gets the sql_warnings of this ConfigurationVariables.
`transaction_isolation`	Gets the transaction_isolation of this ConfigurationVariables.

Methods

__init__(**kwargs) Initializes a new ConfigurationVariables object with values from keyword arguments.

BINLOG_ROW_METADATA_FULL = 'FULL'¶: A constant which can be used with the binlog_row_metadata property of a ConfigurationVariables. This constant has a value of “FULL”

BINLOG_ROW_METADATA_MINIMAL = 'MINIMAL'¶: A constant which can be used with the binlog_row_metadata property of a ConfigurationVariables. This constant has a value of “MINIMAL”

COMPLETION_TYPE_CHAIN = 'CHAIN'¶: A constant which can be used with the completion_type property of a ConfigurationVariables. This constant has a value of “CHAIN”

COMPLETION_TYPE_NO_CHAIN = 'NO_CHAIN'¶: A constant which can be used with the completion_type property of a ConfigurationVariables. This constant has a value of “NO_CHAIN”

COMPLETION_TYPE_RELEASE = 'RELEASE'¶: A constant which can be used with the completion_type property of a ConfigurationVariables. This constant has a value of “RELEASE”

DEFAULT_AUTHENTICATION_PLUGIN_CACHING_SHA2_PASSWORD = 'caching_sha2_password'¶: A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables. This constant has a value of “caching_sha2_password”

DEFAULT_AUTHENTICATION_PLUGIN_MYSQL_NATIVE_PASSWORD = 'mysql_native_password'¶: A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables. This constant has a value of “mysql_native_password”

DEFAULT_AUTHENTICATION_PLUGIN_SHA256_PASSWORD = 'sha256_password'¶: A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables. This constant has a value of “sha256_password”

GROUP_REPLICATION_CONSISTENCY_AFTER = 'AFTER'¶: A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “AFTER”

GROUP_REPLICATION_CONSISTENCY_BEFORE = 'BEFORE'¶: A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “BEFORE”

GROUP_REPLICATION_CONSISTENCY_BEFORE_AND_AFTER = 'BEFORE_AND_AFTER'¶: A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “BEFORE_AND_AFTER”

GROUP_REPLICATION_CONSISTENCY_BEFORE_ON_PRIMARY_FAILOVER = 'BEFORE_ON_PRIMARY_FAILOVER'¶: A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “BEFORE_ON_PRIMARY_FAILOVER”

GROUP_REPLICATION_CONSISTENCY_EVENTUAL = 'EVENTUAL'¶: A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “EVENTUAL”

TRANSACTION_ISOLATION_READ_COMMITED = 'READ-COMMITED'¶: A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “READ-COMMITED”

TRANSACTION_ISOLATION_READ_COMMITTED = 'READ-COMMITTED'¶: A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “READ-COMMITTED”

TRANSACTION_ISOLATION_READ_UNCOMMITTED = 'READ-UNCOMMITTED'¶: A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “READ-UNCOMMITTED”

TRANSACTION_ISOLATION_REPEATABLE_READ = 'REPEATABLE-READ'¶: A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “REPEATABLE-READ”

TRANSACTION_ISOLATION_SERIALIZABLE = 'SERIALIZABLE'¶: A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “SERIALIZABLE”

__init__(**kwargs)¶

Initializes a new ConfigurationVariables object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

completion_type (str) – The value to assign to the completion_type property of this ConfigurationVariables. Allowed values for this property are: “NO_CHAIN”, “CHAIN”, “RELEASE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_authentication_plugin (str) – The value to assign to the default_authentication_plugin property of this ConfigurationVariables. Allowed values for this property are: “mysql_native_password”, “sha256_password”, “caching_sha2_password”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
transaction_isolation (str) – The value to assign to the transaction_isolation property of this ConfigurationVariables. Allowed values for this property are: “READ-UNCOMMITTED”, “READ-COMMITED”, “READ-COMMITTED”, “REPEATABLE-READ”, “SERIALIZABLE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
innodb_ft_server_stopword_table (str) – The value to assign to the innodb_ft_server_stopword_table property of this ConfigurationVariables.
mandatory_roles (str) – The value to assign to the mandatory_roles property of this ConfigurationVariables.
autocommit (bool) – The value to assign to the autocommit property of this ConfigurationVariables.
foreign_key_checks (bool) – The value to assign to the foreign_key_checks property of this ConfigurationVariables.
group_replication_consistency (str) – The value to assign to the group_replication_consistency property of this ConfigurationVariables. Allowed values for this property are: “EVENTUAL”, “BEFORE_ON_PRIMARY_FAILOVER”, “BEFORE”, “AFTER”, “BEFORE_AND_AFTER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
innodb_ft_enable_stopword (bool) – The value to assign to the innodb_ft_enable_stopword property of this ConfigurationVariables.
local_infile (bool) – The value to assign to the local_infile property of this ConfigurationVariables.
mysql_firewall_mode (bool) – The value to assign to the mysql_firewall_mode property of this ConfigurationVariables.
mysqlx_enable_hello_notice (bool) – The value to assign to the mysqlx_enable_hello_notice property of this ConfigurationVariables.
sql_require_primary_key (bool) – The value to assign to the sql_require_primary_key property of this ConfigurationVariables.
sql_warnings (bool) – The value to assign to the sql_warnings property of this ConfigurationVariables.
binlog_expire_logs_seconds (int) – The value to assign to the binlog_expire_logs_seconds property of this ConfigurationVariables.
binlog_row_metadata (str) – The value to assign to the binlog_row_metadata property of this ConfigurationVariables. Allowed values for this property are: “FULL”, “MINIMAL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
binlog_row_value_options (str) – The value to assign to the binlog_row_value_options property of this ConfigurationVariables.
binlog_transaction_compression (bool) – The value to assign to the binlog_transaction_compression property of this ConfigurationVariables.
innodb_buffer_pool_size (int) – The value to assign to the innodb_buffer_pool_size property of this ConfigurationVariables.
innodb_ft_result_cache_limit (int) – The value to assign to the innodb_ft_result_cache_limit property of this ConfigurationVariables.
max_connections (int) – The value to assign to the max_connections property of this ConfigurationVariables.
max_prepared_stmt_count (int) – The value to assign to the max_prepared_stmt_count property of this ConfigurationVariables.
connect_timeout (int) – The value to assign to the connect_timeout property of this ConfigurationVariables.
cte_max_recursion_depth (int) – The value to assign to the cte_max_recursion_depth property of this ConfigurationVariables.
generated_random_password_length (int) – The value to assign to the generated_random_password_length property of this ConfigurationVariables.
information_schema_stats_expiry (int) – The value to assign to the information_schema_stats_expiry property of this ConfigurationVariables.
innodb_buffer_pool_instances (int) – The value to assign to the innodb_buffer_pool_instances property of this ConfigurationVariables.
innodb_ft_max_token_size (int) – The value to assign to the innodb_ft_max_token_size property of this ConfigurationVariables.
innodb_ft_min_token_size (int) – The value to assign to the innodb_ft_min_token_size property of this ConfigurationVariables.
innodb_ft_num_word_optimize (int) – The value to assign to the innodb_ft_num_word_optimize property of this ConfigurationVariables.
innodb_lock_wait_timeout (int) – The value to assign to the innodb_lock_wait_timeout property of this ConfigurationVariables.
innodb_max_purge_lag (int) – The value to assign to the innodb_max_purge_lag property of this ConfigurationVariables.
innodb_max_purge_lag_delay (int) – The value to assign to the innodb_max_purge_lag_delay property of this ConfigurationVariables.
max_execution_time (int) – The value to assign to the max_execution_time property of this ConfigurationVariables.
mysqlx_connect_timeout (int) – The value to assign to the mysqlx_connect_timeout property of this ConfigurationVariables.
mysqlx_document_id_unique_prefix (int) – The value to assign to the mysqlx_document_id_unique_prefix property of this ConfigurationVariables.
mysqlx_idle_worker_thread_timeout (int) – The value to assign to the mysqlx_idle_worker_thread_timeout property of this ConfigurationVariables.
mysqlx_interactive_timeout (int) – The value to assign to the mysqlx_interactive_timeout property of this ConfigurationVariables.
mysqlx_max_allowed_packet (int) – The value to assign to the mysqlx_max_allowed_packet property of this ConfigurationVariables.
mysqlx_min_worker_threads (int) – The value to assign to the mysqlx_min_worker_threads property of this ConfigurationVariables.
mysqlx_read_timeout (int) – The value to assign to the mysqlx_read_timeout property of this ConfigurationVariables.
mysqlx_wait_timeout (int) – The value to assign to the mysqlx_wait_timeout property of this ConfigurationVariables.
mysqlx_write_timeout (int) – The value to assign to the mysqlx_write_timeout property of this ConfigurationVariables.
parser_max_mem_size (int) – The value to assign to the parser_max_mem_size property of this ConfigurationVariables.
query_alloc_block_size (int) – The value to assign to the query_alloc_block_size property of this ConfigurationVariables.
query_prealloc_size (int) – The value to assign to the query_prealloc_size property of this ConfigurationVariables.
sql_mode (str) – The value to assign to the sql_mode property of this ConfigurationVariables.
mysqlx_deflate_default_compression_level (int) – The value to assign to the mysqlx_deflate_default_compression_level property of this ConfigurationVariables.
mysqlx_deflate_max_client_compression_level (int) – The value to assign to the mysqlx_deflate_max_client_compression_level property of this ConfigurationVariables.
mysqlx_lz4_max_client_compression_level (int) – The value to assign to the mysqlx_lz4_max_client_compression_level property of this ConfigurationVariables.
mysqlx_lz4_default_compression_level (int) – The value to assign to the mysqlx_lz4_default_compression_level property of this ConfigurationVariables.
mysqlx_zstd_max_client_compression_level (int) – The value to assign to the mysqlx_zstd_max_client_compression_level property of this ConfigurationVariables.
mysqlx_zstd_default_compression_level (int) – The value to assign to the mysqlx_zstd_default_compression_level property of this ConfigurationVariables.
mysql_zstd_default_compression_level (int) – The value to assign to the mysql_zstd_default_compression_level property of this ConfigurationVariables.

autocommit¶

Gets the autocommit of this ConfigurationVariables. (“autocommit”)

Returns:	The autocommit of this ConfigurationVariables.
Return type:	bool

binlog_expire_logs_seconds¶

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

Returns:	The binlog_expire_logs_seconds of this ConfigurationVariables.
Return type:	int

binlog_row_metadata¶

Gets the binlog_row_metadata of this ConfigurationVariables. 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.

Allowed values for this property are: “FULL”, “MINIMAL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The binlog_row_metadata of this ConfigurationVariables.
Return type:	str

binlog_row_value_options¶

Gets the binlog_row_value_options of this ConfigurationVariables. 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.

Returns:	The binlog_row_value_options of this ConfigurationVariables.
Return type:	str

binlog_transaction_compression¶

Gets the binlog_transaction_compression of this ConfigurationVariables. 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.

Returns:	The binlog_transaction_compression of this ConfigurationVariables.
Return type:	bool

completion_type¶

Gets the completion_type of this ConfigurationVariables. (“completion_type”)

Allowed values for this property are: “NO_CHAIN”, “CHAIN”, “RELEASE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The completion_type of this ConfigurationVariables.
Return type:	str

connect_timeout¶

Gets the connect_timeout of this ConfigurationVariables. (“connect_timeout”)

Returns:	The connect_timeout of this ConfigurationVariables.
Return type:	int

cte_max_recursion_depth¶

Gets the cte_max_recursion_depth of this ConfigurationVariables. (“cte_max_recursion_depth”)

Returns:	The cte_max_recursion_depth of this ConfigurationVariables.
Return type:	int

default_authentication_plugin¶

Gets the default_authentication_plugin of this ConfigurationVariables. (“default_authentication_plugin”)

Allowed values for this property are: “mysql_native_password”, “sha256_password”, “caching_sha2_password”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The default_authentication_plugin of this ConfigurationVariables.
Return type:	str

foreign_key_checks¶

Gets the foreign_key_checks of this ConfigurationVariables. (“foreign_key_checks”)

Returns:	The foreign_key_checks of this ConfigurationVariables.
Return type:	bool

generated_random_password_length¶

Gets the generated_random_password_length of this ConfigurationVariables. (“generated_random_password_length”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The generated_random_password_length of this ConfigurationVariables.
Return type:	int

group_replication_consistency¶

Gets the group_replication_consistency of this ConfigurationVariables. - 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.

Allowed values for this property are: “EVENTUAL”, “BEFORE_ON_PRIMARY_FAILOVER”, “BEFORE”, “AFTER”, “BEFORE_AND_AFTER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The group_replication_consistency of this ConfigurationVariables.
Return type:	str

information_schema_stats_expiry¶

Gets the information_schema_stats_expiry of this ConfigurationVariables. (“information_schema_stats_expiry”)

Returns:	The information_schema_stats_expiry of this ConfigurationVariables.
Return type:	int

innodb_buffer_pool_instances¶

Gets the innodb_buffer_pool_instances of this ConfigurationVariables. (“innodb_buffer_pool_instances”)

Returns:	The innodb_buffer_pool_instances of this ConfigurationVariables.
Return type:	int

innodb_buffer_pool_size¶

Gets the innodb_buffer_pool_size of this ConfigurationVariables. (“innodb_buffer_pool_size”)

Returns:	The innodb_buffer_pool_size of this ConfigurationVariables.
Return type:	int

innodb_ft_enable_stopword¶

Gets the innodb_ft_enable_stopword of this ConfigurationVariables. (“innodb_ft_enable_stopword”)

Returns:	The innodb_ft_enable_stopword of this ConfigurationVariables.
Return type:	bool

innodb_ft_max_token_size¶

Gets the innodb_ft_max_token_size of this ConfigurationVariables. (“innodb_ft_max_token_size”)

Returns:	The innodb_ft_max_token_size of this ConfigurationVariables.
Return type:	int

innodb_ft_min_token_size¶

Gets the innodb_ft_min_token_size of this ConfigurationVariables. (“innodb_ft_min_token_size”)

Returns:	The innodb_ft_min_token_size of this ConfigurationVariables.
Return type:	int

innodb_ft_num_word_optimize¶

Gets the innodb_ft_num_word_optimize of this ConfigurationVariables. (“innodb_ft_num_word_optimize”)

Returns:	The innodb_ft_num_word_optimize of this ConfigurationVariables.
Return type:	int

innodb_ft_result_cache_limit¶

Gets the innodb_ft_result_cache_limit of this ConfigurationVariables. (“innodb_ft_result_cache_limit”)

Returns:	The innodb_ft_result_cache_limit of this ConfigurationVariables.
Return type:	int

innodb_ft_server_stopword_table¶

Gets the innodb_ft_server_stopword_table of this ConfigurationVariables. (“innodb_ft_server_stopword_table”)

Returns:	The innodb_ft_server_stopword_table of this ConfigurationVariables.
Return type:	str

innodb_lock_wait_timeout¶

Gets the innodb_lock_wait_timeout of this ConfigurationVariables. (“innodb_lock_wait_timeout”)

Returns:	The innodb_lock_wait_timeout of this ConfigurationVariables.
Return type:	int

innodb_max_purge_lag¶

Gets the innodb_max_purge_lag of this ConfigurationVariables. (“innodb_max_purge_lag”)

Returns:	The innodb_max_purge_lag of this ConfigurationVariables.
Return type:	int

innodb_max_purge_lag_delay¶

Gets the innodb_max_purge_lag_delay of this ConfigurationVariables. (“innodb_max_purge_lag_delay”)

Returns:	The innodb_max_purge_lag_delay of this ConfigurationVariables.
Return type:	int

local_infile¶

Gets the local_infile of this ConfigurationVariables. (“local_infile”)

Returns:	The local_infile of this ConfigurationVariables.
Return type:	bool

mandatory_roles¶

Gets the mandatory_roles of this ConfigurationVariables. (“mandatory_roles”)

Returns:	The mandatory_roles of this ConfigurationVariables.
Return type:	str

max_connections¶

Gets the max_connections of this ConfigurationVariables. (“max_connections”)

Returns:	The max_connections of this ConfigurationVariables.
Return type:	int

max_execution_time¶

Gets the max_execution_time of this ConfigurationVariables. (“max_execution_time”)

Returns:	The max_execution_time of this ConfigurationVariables.
Return type:	int

max_prepared_stmt_count¶

Gets the max_prepared_stmt_count of this ConfigurationVariables. (“max_prepared_stmt_count”)

Returns:	The max_prepared_stmt_count of this ConfigurationVariables.
Return type:	int

mysql_firewall_mode¶

Gets the mysql_firewall_mode of this ConfigurationVariables. (“mysql_firewall_mode”)

Returns:	The mysql_firewall_mode of this ConfigurationVariables.
Return type:	bool

mysql_zstd_default_compression_level¶

Gets the mysql_zstd_default_compression_level of this ConfigurationVariables. DEPRECATED – typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Returns:	The mysql_zstd_default_compression_level of this ConfigurationVariables.
Return type:	int

mysqlx_connect_timeout¶

Gets the mysqlx_connect_timeout of this ConfigurationVariables. (“mysqlx_connect_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_connect_timeout of this ConfigurationVariables.
Return type:	int

mysqlx_deflate_default_compression_level¶

Gets the mysqlx_deflate_default_compression_level of this ConfigurationVariables. Set the default compression level for the deflate algorithm. (“mysqlx_deflate_default_compression_level”)

Returns:	The mysqlx_deflate_default_compression_level of this ConfigurationVariables.
Return type:	int

mysqlx_deflate_max_client_compression_level¶

Gets the mysqlx_deflate_max_client_compression_level of this ConfigurationVariables. Limit the upper bound of accepted compression levels for the deflate algorithm. (“mysqlx_deflate_max_client_compression_level”)

Returns:	The mysqlx_deflate_max_client_compression_level of this ConfigurationVariables.
Return type:	int

mysqlx_document_id_unique_prefix¶

Gets the mysqlx_document_id_unique_prefix of this ConfigurationVariables. (“mysqlx_document_id_unique_prefix”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_document_id_unique_prefix of this ConfigurationVariables.
Return type:	int

mysqlx_enable_hello_notice¶

Gets the mysqlx_enable_hello_notice of this ConfigurationVariables. (“mysqlx_enable_hello_notice”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_enable_hello_notice of this ConfigurationVariables.
Return type:	bool

mysqlx_idle_worker_thread_timeout¶

Gets the mysqlx_idle_worker_thread_timeout of this ConfigurationVariables. (“mysqlx_idle_worker_thread_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_idle_worker_thread_timeout of this ConfigurationVariables.
Return type:	int

mysqlx_interactive_timeout¶

Gets the mysqlx_interactive_timeout of this ConfigurationVariables. (“mysqlx_interactive_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_interactive_timeout of this ConfigurationVariables.
Return type:	int

mysqlx_lz4_default_compression_level¶

Gets the mysqlx_lz4_default_compression_level of this ConfigurationVariables. Set the default compression level for the lz4 algorithm. (“mysqlx_lz4_default_compression_level”)

Returns:	The mysqlx_lz4_default_compression_level of this ConfigurationVariables.
Return type:	int

mysqlx_lz4_max_client_compression_level¶

Gets the mysqlx_lz4_max_client_compression_level of this ConfigurationVariables. Limit the upper bound of accepted compression levels for the lz4 algorithm. (“mysqlx_lz4_max_client_compression_level”)

Returns:	The mysqlx_lz4_max_client_compression_level of this ConfigurationVariables.
Return type:	int

mysqlx_max_allowed_packet¶

Gets the mysqlx_max_allowed_packet of this ConfigurationVariables. (“mysqlx_max_allowed_packet”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_max_allowed_packet of this ConfigurationVariables.
Return type:	int

mysqlx_min_worker_threads¶

Gets the mysqlx_min_worker_threads of this ConfigurationVariables. (“mysqlx_min_worker_threads”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_min_worker_threads of this ConfigurationVariables.
Return type:	int

mysqlx_read_timeout¶

Gets the mysqlx_read_timeout of this ConfigurationVariables. (“mysqlx_read_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_read_timeout of this ConfigurationVariables.
Return type:	int

mysqlx_wait_timeout¶

Gets the mysqlx_wait_timeout of this ConfigurationVariables. (“mysqlx_wait_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_wait_timeout of this ConfigurationVariables.
Return type:	int

mysqlx_write_timeout¶

Gets the mysqlx_write_timeout of this ConfigurationVariables. (“mysqlx_write_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The mysqlx_write_timeout of this ConfigurationVariables.
Return type:	int

mysqlx_zstd_default_compression_level¶

Gets the mysqlx_zstd_default_compression_level of this ConfigurationVariables. Set the default compression level for the zstd algorithm. (“mysqlx_zstd_default_compression_level”)

Returns:	The mysqlx_zstd_default_compression_level of this ConfigurationVariables.
Return type:	int

mysqlx_zstd_max_client_compression_level¶

Gets the mysqlx_zstd_max_client_compression_level of this ConfigurationVariables. Limit the upper bound of accepted compression levels for the zstd algorithm. (“mysqlx_zstd_max_client_compression_level”)

Returns:	The mysqlx_zstd_max_client_compression_level of this ConfigurationVariables.
Return type:	int

parser_max_mem_size¶

Gets the parser_max_mem_size of this ConfigurationVariables. (“parser_max_mem_size”)

Returns:	The parser_max_mem_size of this ConfigurationVariables.
Return type:	int

query_alloc_block_size¶

Gets the query_alloc_block_size of this ConfigurationVariables. (“query_alloc_block_size”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The query_alloc_block_size of this ConfigurationVariables.
Return type:	int

query_prealloc_size¶

Gets the query_prealloc_size of this ConfigurationVariables. (“query_prealloc_size”) DEPRECATED – variable should not be settable and will be ignored

Returns:	The query_prealloc_size of this ConfigurationVariables.
Return type:	int

sql_mode¶

Gets the sql_mode of this ConfigurationVariables. (“sql_mode”)

Returns:	The sql_mode of this ConfigurationVariables.
Return type:	str

sql_require_primary_key¶

Gets the sql_require_primary_key of this ConfigurationVariables. (“sql_require_primary_key”)

Returns:	The sql_require_primary_key of this ConfigurationVariables.
Return type:	bool

sql_warnings¶

Gets the sql_warnings of this ConfigurationVariables. (“sql_warnings”)

Returns:	The sql_warnings of this ConfigurationVariables.
Return type:	bool

transaction_isolation¶

Gets the transaction_isolation of this ConfigurationVariables. (“transaction_isolation”)

Allowed values for this property are: “READ-UNCOMMITTED”, “READ-COMMITED”, “READ-COMMITTED”, “REPEATABLE-READ”, “SERIALIZABLE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The transaction_isolation of this ConfigurationVariables.
Return type:	str