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
-