Configuration Manager

Overview

MariaDB SkySQL is configured by default for data protection, security, and performance.

Database configuration may be changed where permitted by SESSION variables or using the Configuration Manager. GLOBAL variables may not be customized except using the Configuration Manager. Power Tier customers may contact us regarding custom configuration needs.

What is configurable?

Available configuration parameters differ by service and topology.

Configuration Manager is not currently available for MariaDB Platform for Distributed SQL.

Enterprise Server

Parameter / Topology:

Transactional Standalone

HA

Galera

ColumnStore

HTAP

binlog_commit_wait_count

No

Yes

No

No

No

binlog_commit_wait_usec

No

Yes

No

No

No

cracklib_password_check

Yes

Yes

Yes

Yes

Yes

default_password_lifetime

Yes

Yes

Yes

Yes

Yes

disconnect_on_expired_password

Yes

Yes

Yes

Yes

Yes

eq_range_index_dive_limit

Yes

Yes

No

Yes

Yes

event_scheduler

Yes

Yes

Yes

Yes

Yes

gtid_strict_mode

No

Yes

No

No

No

idle_readonly_transaction_timeout

Yes

Yes

Yes

Yes

Yes

idle_transaction_timeout

Yes

Yes

Yes

Yes

Yes

idle_write_transaction_timeout

Yes

Yes

Yes

Yes

Yes

innodb_flush_log_at_trx_commit

Yes

Yes

Yes

No

Yes

innodb_log_file_size

Yes

Yes

Yes

No

Yes

interactive_timeout

Yes

Yes

Yes

Yes

Yes

local_infile

Yes

Yes

Yes

Yes

Yes

log_warnings

Yes

Yes

Yes

Yes

Yes

lower_case_table_names

Yes

Yes

Yes

Yes

Yes

max_allowed_packet

Yes

Yes

Yes

Yes

Yes

max_password_errors

Yes

Yes

Yes

Yes

Yes

optimizer_search_depth

Yes

Yes

Yes

Yes

Yes

performance_schema

Yes

Yes

Yes

Yes

Yes

performance_schema_accounts_size

Yes

Yes

Yes

Yes

Yes

performance_schema_digests_size

Yes

Yes

Yes

Yes

Yes

performance_schema_events_stages_history_long_size

Yes

Yes

Yes

Yes

Yes

performance_schema_events_stages_history_size

Yes

Yes

Yes

Yes

Yes

performance_schema_events_statements_history_long_size

Yes

Yes

Yes

Yes

Yes

performance_schema_events_statements_history_size

Yes

Yes

Yes

Yes

Yes

performance_schema_events_waits_history_long_size

Yes

Yes

Yes

Yes

Yes

performance_schema_events_waits_history_size

Yes

Yes

Yes

Yes

Yes

performance_schema_hosts_size

Yes

Yes

Yes

Yes

Yes

performance_schema_max_cond_classes

Yes

Yes

Yes

Yes

Yes

performance_schema_max_cond_instances

Yes

Yes

Yes

Yes

Yes

performance_schema_max_digest_length

Yes

Yes

Yes

Yes

Yes

performance_schema_max_file_classes

Yes

Yes

Yes

Yes

Yes

performance_schema_max_file_handles

Yes

Yes

Yes

Yes

Yes

performance_schema_max_file_instances

Yes

Yes

Yes

Yes

Yes

performance_schema_max_mutex_classes

Yes

Yes

Yes

Yes

Yes

performance_schema_max_mutex_instances

Yes

Yes

Yes

Yes

Yes

performance_schema_max_rwlock_classes

Yes

Yes

Yes

Yes

Yes

performance_schema_max_rwlock_instances

Yes

Yes

Yes

Yes

Yes

performance_schema_max_socket_classes

Yes

Yes

Yes

Yes

Yes

performance_schema_max_socket_instances

Yes

Yes

Yes

Yes

Yes

performance_schema_max_stage_classes

Yes

Yes

Yes

Yes

Yes

performance_schema_max_statement_classes

Yes

Yes

Yes

Yes

Yes

performance_schema_max_table_handles

Yes

Yes

Yes

Yes

Yes

performance_schema_max_table_instances

Yes

Yes

Yes

Yes

Yes

performance_schema_max_thread_classes

Yes

Yes

Yes

Yes

Yes

performance_schema_max_thread_instances

Yes

Yes

Yes

Yes

Yes

performance_schema_session_connect_attrs_size

Yes

Yes

Yes

Yes

Yes

performance_schema_users_size

Yes

Yes

Yes

Yes

Yes

rpl_semi_sync_master_enabled

No

Yes

No

No

No

rpl_semi_sync_master_timeout

No

Yes

No

No

No

rpl_semi_sync_master_wait_no_slave

No

Yes

No

No

No

rpl_semi_sync_master_wait_point

No

Yes

No

No

No

rpl_semi_sync_slave_delay_master

No

Yes

No

No

No

rpl_semi_sync_slave_enabled

No

Yes

No

No

No

rpl_semi_sync_slave_kill_conn_timeout

No

Yes

No

No

No

server_audit

Yes

Yes

Yes

Yes

Yes

server_audit_logging

Yes

Yes

Yes

Yes

Yes

simple_password_check_digits

Yes

Yes

Yes

Yes

Yes

simple_password_check_letters_same_case

Yes

Yes

Yes

Yes

Yes

simple_password_check_minimal_length

Yes

Yes

Yes

Yes

Yes

simple_password_check_other_characters

Yes

Yes

Yes

Yes

Yes

slave_compressed_protocol

No

Yes

No

No

No

slave_parallel_mode

No

Yes

No

No

No

slave_parallel_threads

No

Yes

No

No

No

slave_parallel_workers

No

Yes

No

No

No

sql_mode

Yes

Yes

Yes

Yes

No

strict_password_validation

Yes

Yes

Yes

Yes

Yes

sync_binlog

No

Yes

No

No

No

sync_master_info

No

Yes

No

No

No

sync_relay_log

No

Yes

No

No

No

sync_relay_log_info

No

Yes

No

No

No

system_versioning_alter_history

Yes

Yes

Yes

Yes

Yes

thread_cache_size

Yes

Yes

Yes

Yes

Yes

thread_handling

Yes

Yes

Yes

Yes

Yes

thread_pool_idle_timeout

Yes

Yes

Yes

Yes

Yes

thread_pool_max_threads

Yes

Yes

Yes

Yes

Yes

thread_pool_priority

Yes

Yes

Yes

Yes

Yes

thread_pool_size

Yes

Yes

Yes

Yes

Yes

tx_isolation

Yes

Yes

Yes

Yes

Yes

wait_timeout

Yes

Yes

Yes

Yes

Yes

wsrep_dirty_reads

No

No

Yes

No

No

wsrep_reject_queries

No

No

Yes

No

No

wsrep_retry_autocommit

No

No

Yes

No

No

wsrep_slave_threads

No

No

Yes

No

No

wsrep_sst_donor_rejects_queries

No

No

Yes

No

No

wsrep_sync_wait

No

No

Yes

No

No

Manage Configurations

The Configuration Manager option is found in the SkySQL main menu (left navigation). The "Configuration Manager" option becomes visible after you have launched your first service. You may need to refresh your browser to see it.

Access Configuration Manager

To access the Configuration Manager:

  1. Log in to the SkySQL Portal.

  2. Click on "Configuration Manager" in the SkySQL main menu.

Note

The "Configuration Manager" option is found in the SkySQL main menu (left navigation). It becomes visible after you have launched your first service. You may need to refresh your browser once your service is launched to make the Configuration Manager option visible.

View a Configuration

To view a configuration:

  1. Access the Configuration Manager.

  2. Click on the desired Configuration Name.

Create a Configuration

To create a new custom configuration:

  1. Access the Configuration Manager.

  2. Click on the "Create New Configuration" button on the "Configuration Manager" page.

  3. Enter a configuration name for the new configuration.

  4. Select the appropriate Topology based on the database service you want to configure.

  5. Use the Value drop-down for individual variables to customize the configuration.

  6. Click on the "Save" button.

Saved configurations must be applied to a service to take effect.

Edit a Configuration

To edit an existing configuration:

  1. Access the Configuration Manager.

  2. Click on the Configuration Name.

  3. Click on the "Actions" drop-down button.

  4. Click on the "Edit Configuration" menu option.

  5. Use the Value drop-down for individual variables to edit the configuration.

  6. Click on the "Save" button.

Edited configurations must be applied to a service to take effect.

Clone a Configuration

To use an existing configuration as a starting point for a new configuration:

  1. Access the Configuration Manager.

  2. Click on the Configuration Name.

  3. Click on the "Actions" drop-down button, and choose "Clone Configuration" and follow the prompts.

Saved configurations must be applied to a service to take effect.

Applying a Configuration to a Service

Note

Applying a configuration will cause a service to restart. During this time, the service will not be accessible.

Custom configurations must be applied to a service to take effect. To apply a saved configuration to a service:

  1. Log in to the SkySQL Portal.

  2. Click on "Configuration Manager" in the SkySQL main menu.

  3. Click on the name of the Configuration you want to apply.

  4. Click on the "Actions" button and click on "Apply to a Service" from the drop down.

  5. Click in the "Services" box to see a list of your services.

  6. Click on the name of every service you want to apply the custom configuration to.

  7. With the selected service names in the "Services" box, click on the "Apply" button to apply the custom configuration.