PolarDB-X 为了方便用户体验，提供了免费的实验环境，您可以在实验环境里体验 PolarDB-X 的安装部署和各种内核特性。除了免费的实验，PolarDB-X 也提供免费的视频课程，手把手教你玩转 PolarDB-X 分布式数据库。
本期实验将指导您如何使用PolarDB-X参数模板。
安装环境
本步骤将指导您如何安装Docker、kubectl、minikube和Helm3。
1.安装Docker。
1.1 执行如下命令，安装Docker。
curl -fsSL https://get.docker.com | bash -s docker --mirror Aliyun
1.2 执行如下命令，启动Docker。
systemctl start docker
2.安装kubectl。
2.1 执行如下命令，下载kubectl文件。
curl -LO https://storage.googleapis.com/kubernetes-release/release/$(curl -s https://storage.googleapis.com/kubernetes-release/release/stable.txt)/bin/linux/amd64/kubectl
2.2 执行如下命令，赋予可执行权限。
chmod +x ./kubectl
2.2. 执行如下命令，移动到系统目录。
mv ./kubectl /usr/local/bin/kubectl
3.安装minikube。
执行如下命令，下载并安装minikube。
curl -LO https://storage.googleapis.com/minikube/releases/latest/minikube-linux-amd64 sudo install minikube-linux-amd64 /usr/local/bin/minikube
4.安装Helm3。
4.1 执行如下命令，下载Helm3。
wget https://labfileapp.oss-cn-hangzhou.aliyuncs.com/helm-v3.9.0-linux-amd64.tar.gz
4.2 执行如下命令，解压Helm3。
tar -zxvf helm-v3.9.0-linux-amd64.tar.gz
4.3 执行如下命令，移动到系统目录。
mv linux-amd64/helm /usr/local/bin/helm
5.安装MySQL。
执行如下命令，安装MySQL。
yum install mysql -y
安装配置参数模板的 PolarDB-X
本步骤将指导您如何创建一个简单的Kubernetes集群并部署PolarDB-X Operator ，使用Operator部署一个完整的配置有参数模板的PolarDB-X集群，详细文档请参考通过Kubernetes安装PolarDB-X 和 配置参数模板 。
1.使用minikube创建Kubernetes集群。
minikube是由社区维护的用于快速创建Kubernetes测试集群的工具，适合测试和学习Kubernetes。使用minikube创建的Kubernetes集群可以运行在容器或是虚拟机中，本实验场景以CentOS 7.9上创建Kubernetes为例。
说明：如果您使用其他操作系统部署minikube，例如macOS或Windows，部分步骤可能略有不同。
1.1 执行如下命令，新建账号galaxykube，并将galaxykube加入docker组中。minikube要求使用非root账号进行部署，所以您需要新建一个账号。
useradd -ms /bin/bash galaxykube usermod -aG docker galaxykube
1.2 执行如下命令，切换到账号galaxykube。
su galaxykube
1.3 执行如下命令，进入到home/galaxykube目录。
cd
1.4 执行如下命令，启动一个minikube。
说明：这里我们使用了阿里云的minikube镜像源以及USTC提供的docker镜像源来加速镜像的拉取。
minikube start --cpus 4 --memory 12288 --nodes=3 --image-mirror-country cn --registry-mirror=https://docker.mirrors.sjtug.sjtu.edu.cn --kubernetes-version 1.23.3
返回结果如下，表示minikube已经正常运行，minikube将自动设置kubectl的配置文件。
1.5 执行如下命令，使用kubectl查看集群信息。
kubectl cluster-info
返回如下结果，您可以查看到集群相关信息。
2.部署 PolarDB-X Operator。
2.1 执行如下命令，创建一个名为polardbx-operator-system的命名空间。
kubectl create namespace polardbx-operator-system
2.2 执行如下命令，安装PolarDB-X Operator。
helm repo add polardbx https://polardbx-charts.oss-cn-beijing.aliyuncs.com helm install --namespace polardbx-operator-system polardbx-operator polardbx/polardbx-operator --version 1.3.0
2.3 执行如下命令，查看PolarDB-X Operator组件的运行情况。
kubectl get pods --namespace polardbx-operator-system
返回结果如下，请您耐心等待2分钟，等待所有组件都进入Running状态，表示PolarDB-X Operator已经安装完成。
3.部署参数模板
3.1 执行如下命令，创建parameter-template.yaml。
vim parameter-template.yaml
3.2 按i键进入编辑模式，将如下代码复制到文件中，然后按ECS退出编辑模式，输入:wq后按下Enter键保存并退出。
apiVersion: polardbx.aliyun.com/v1 kind: PolarDBXParameterTemplate metadata: name: test spec: nodeType: cn: name: cnTemplate paramList: - defaultValue: 05:00 divisibilityFactor: 0 mode: readwrite name: BACKGROUND_STATISTIC_COLLECTION_END_TIME optional: '[00:00|01:00|02:00|03:00|04:00|05:00|06:00|07:00|08:00|09:00|10:00|11:00|12:00|13:00|14:00|15:00|16:00|17:00|18:00|19:00|20:00|21:00|22:00|23:00]' restart: false unit: STRING - defaultValue: 02:00 divisibilityFactor: 0 mode: readwrite name: BACKGROUND_STATISTIC_COLLECTION_START_TIME optional: '[00:00|01:00|02:00|03:00|04:00|05:00|06:00|07:00|08:00|09:00|10:00|11:00|12:00|13:00|14:00|15:00|16:00|17:00|18:00|19:00|20:00|21:00|22:00|23:00]' restart: false unit: STRING - defaultValue: '5000' divisibilityFactor: 1 mode: readwrite name: CONN_POOL_BLOCK_TIMEOUT optional: '[1000-60000]' restart: false unit: INT - defaultValue: '30' divisibilityFactor: 1 mode: readwrite name: CONN_POOL_IDLE_TIMEOUT optional: '[1-60]' restart: false unit: INT - defaultValue: '60' divisibilityFactor: 1 mode: readwrite name: CONN_POOL_MAX_POOL_SIZE optional: '[1-1600]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: CONN_POOL_MAX_WAIT_THREAD_COUNT optional: '[-1-8192]' restart: false unit: INT - defaultValue: '20' divisibilityFactor: 1 mode: readwrite name: CONN_POOL_MIN_POOL_SIZE optional: '[0-60]' restart: false unit: INT - defaultValue: '512' divisibilityFactor: 1 mode: readwrite name: CONN_POOL_XPROTO_MAX_POOLED_SESSION_PER_INST optional: '[1-8192]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: CONN_POOL_XPROTO_STORAGE_DB_PORT optional: '[-1-0]' restart: false unit: INT - defaultValue: 'true' divisibilityFactor: 0 mode: readwrite name: ENABLE_BACKGROUND_STATISTIC_COLLECTION optional: '[true|false]' restart: false unit: STRING - defaultValue: 'true' divisibilityFactor: 1 mode: readwrite name: ENABLE_COMPLEX_DML_CROSS_DB optional: '[true|false]' restart: false unit: STRING - defaultValue: 'true' divisibilityFactor: 0 mode: readwrite name: ENABLE_HLL optional: '[true|false]' restart: false unit: STRING - defaultValue: 'true' divisibilityFactor: 0 mode: readwrite name: ENABLE_LOCAL_MODE optional: '[true|false]' restart: false unit: STRING - defaultValue: 'true' divisibilityFactor: 0 mode: readwrite name: ENABLE_LOGICALVIEW_COST optional: '[true|false]' restart: false unit: STRING - defaultValue: 'false' divisibilityFactor: 1 mode: readwrite name: ENABLE_RECYCLEBIN optional: '[true|false]' restart: false unit: STRING - defaultValue: 'true' divisibilityFactor: 0 mode: readwrite name: ENABLE_SPM optional: '[true|false]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 1 mode: readwrite name: ENABLE_SQL_FLASHBACK_EXACT_MATCH optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'true' divisibilityFactor: 0 mode: readwrite name: ENABLE_STATEMENTS_SUMMARY optional: '[true|false]' restart: false unit: STRING - defaultValue: 'true' divisibilityFactor: 0 mode: readwrite name: ENABLE_STATISTIC_FEEDBACK optional: '[true|false]' restart: false unit: STRING - defaultValue: 'true' divisibilityFactor: 1 mode: readwrite name: FORBID_EXECUTE_DML_ALL optional: '[true|false]' restart: false unit: STRING - defaultValue: '-1' divisibilityFactor: 1 mode: readwrite name: GENERAL_DYNAMIC_SPEED_LIMITATION optional: '[-1-10000000]' restart: false unit: INT - defaultValue: 'false' divisibilityFactor: 1 mode: readwrite name: INFO_SCHEMA_QUERY_WITH_STAT optional: '[true|false]' restart: false unit: STRING - defaultValue: '2' divisibilityFactor: 0 mode: readwrite name: IN_SUB_QUERY_THRESHOLD optional: '[1-65535]' restart: false unit: INT - defaultValue: SYSTEM divisibilityFactor: 1 mode: readwrite name: LOGICAL_DB_TIME_ZONE optional: '[SYSTEM|±HH:mm]' restart: false unit: TZ - defaultValue: '28800000' divisibilityFactor: 1 mode: readwrite name: LOGIC_IDLE_TIMEOUT optional: '[3600000-86400000]' restart: false unit: INT - defaultValue: '16777216' divisibilityFactor: 1 mode: readwrite name: MAX_ALLOWED_PACKET optional: '[4194304-33554432]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: PARALLELISM optional: '[-1-8]' restart: false unit: INT - defaultValue: '-1' divisibilityFactor: 1 mode: readwrite name: PER_QUERY_MEMORY_LIMIT optional: '[-1-9223372036854775807]' restart: false unit: INT - defaultValue: 00:00-01:00 divisibilityFactor: 1 mode: readwrite name: PURGE_TRANS_START_TIME optional: 00:00~23:59 restart: false unit: HOUR_RANGE - defaultValue: '1000' divisibilityFactor: 1 mode: readwrite name: SLOW_SQL_TIME optional: '[1000-900000]' restart: false unit: INT - defaultValue: '900000' divisibilityFactor: 1 mode: readwrite name: SOCKET_TIMEOUT optional: '[0-3600000]' restart: false unit: INT - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: STATEMENTS_SUMMARY_PERCENT optional: '[0-100]' restart: false unit: INT - defaultValue: REPEATABLE-READ divisibilityFactor: 0 mode: readwrite name: TRANSACTION_ISOLATION optional: '[REPEATABLE-READ|READ-COMMITTED|READ-UNCOMMITTED|SERIALIZABLE]' restart: false unit: STRING - defaultValue: '500' divisibilityFactor: 1 mode: readwrite name: XPROTO_MAX_DN_CONCURRENT optional: '[1-8192]' restart: false unit: INT - defaultValue: '32' divisibilityFactor: 1 mode: readwrite name: XPROTO_MAX_DN_WAIT_CONNECTION optional: '[1-8192]' restart: false unit: INT - defaultValue: 'false' divisibilityFactor: 1 mode: readwrite name: ENABLE_COROUTINE optional: '[true|false]' restart: true unit: STRING dn: name: dnTemplate paramList: - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: autocommit optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: automatic_sp_privileges optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: auto_increment_increment optional: '[1-65535]' restart: false unit: INT - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: auto_increment_offset optional: '[1-65535]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: avoid_temporal_upgrade optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1048576' divisibilityFactor: 4096 mode: readwrite name: binlog_cache_size optional: '[4096-16777216]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 1 mode: readwrite name: binlog_order_commits optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: binlog_rows_query_log_events optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: full divisibilityFactor: 0 mode: readwrite name: binlog_row_image optional: '[full|minimal]' restart: false unit: STRING - defaultValue: '32768' divisibilityFactor: 4096 mode: readwrite name: binlog_stmt_cache_size optional: '[4096-16777216]' restart: false unit: INT - defaultValue: '"aes-128-ecb"' divisibilityFactor: 1 mode: readwrite name: block_encryption_mode optional: '["aes-128-ecb"|"aes-192-ecb"|"aes-256-ecb"|"aes-128-cbc"|"aes-192-cbc"|"aes-256-cbc"]' restart: false unit: STRING - defaultValue: '4194304' divisibilityFactor: 1 mode: readwrite name: bulk_insert_buffer_size optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '2' divisibilityFactor: 0 mode: readwrite name: concurrent_insert optional: '[0|1|2]' restart: false unit: STRING - defaultValue: '10' divisibilityFactor: 1 mode: readwrite name: connect_timeout optional: '[1-3600]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: default_week_format optional: '[0-7]' restart: false unit: INT - defaultValue: '100' divisibilityFactor: 1 mode: readwrite name: delayed_insert_limit optional: '[1-4294967295]' restart: false unit: INT - defaultValue: '300' divisibilityFactor: 1 mode: readwrite name: delayed_insert_timeout optional: '[1-3600]' restart: false unit: INT - defaultValue: '1000' divisibilityFactor: 1 mode: readwrite name: delayed_queue_size optional: '[1-4294967295]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: delay_key_write optional: '[ON|OFF|ALL]' restart: false unit: STRING - defaultValue: '4' divisibilityFactor: 1 mode: readwrite name: div_precision_increment optional: '[0-30]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: end_markers_in_json optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '200' divisibilityFactor: 1 mode: readwrite name: eq_range_index_dive_limit optional: '[0-4294967295]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: event_scheduler optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: explicit_defaults_for_timestamp optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: flush_time optional: '[0-31536000]' restart: false unit: INT - defaultValue: '1024' divisibilityFactor: 1 mode: readwrite name: group_concat_max_len optional: '[4-1844674407370954752]' restart: false unit: INT - defaultValue: '644' divisibilityFactor: 1 mode: readwrite name: host_cache_size optional: '[0-65535]' restart: false unit: INT - defaultValue: '''''' divisibilityFactor: 0 mode: readwrite name: init_connect optional: '[''''|''set names utf8mb4''|''set names utf8''|''set default_collation_for_utf8mb4=utf8mb4_general_ci''|''set default_collation_for_utf8mb4=utf8mb4_general_ci;set names utf8mb4''|''set names utf8mb4 collate utf8mb4_general_ci'']' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_adaptive_flushing optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '10' divisibilityFactor: 1 mode: readwrite name: innodb_adaptive_flushing_lwm optional: '[0-70]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_adaptive_hash_index optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '150000' divisibilityFactor: 1 mode: readwrite name: innodb_adaptive_max_sleep_delay optional: '[1-1000000]' restart: false unit: INT - defaultValue: '64' divisibilityFactor: 1 mode: readwrite name: innodb_autoextend_increment optional: '[1-1000]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_buffer_pool_dump_at_shutdown optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '25' divisibilityFactor: 1 mode: readwrite name: innodb_buffer_pool_dump_pct optional: '[1-100]' restart: false unit: INT - defaultValue: none divisibilityFactor: 0 mode: readwrite name: innodb_change_buffering optional: '[none|inserts|deletes|changes|purges|all]' restart: false unit: STRING - defaultValue: '25' divisibilityFactor: 1 mode: readwrite name: innodb_change_buffer_max_size optional: '[0-50]' restart: false unit: INT - defaultValue: crc32 divisibilityFactor: 0 mode: readwrite name: innodb_checksum_algorithm optional: '[innodb|crc32|none|strict_innodb|strict_crc32|strict_none]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_cmp_per_index_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '5' divisibilityFactor: 1 mode: readwrite name: innodb_compression_failure_threshold_pct optional: '[0-100]' restart: false unit: INT - defaultValue: '6' divisibilityFactor: 1 mode: readwrite name: innodb_compression_level optional: '[0-9]' restart: false unit: INT - defaultValue: '50' divisibilityFactor: 1 mode: readwrite name: innodb_compression_pad_pct_max optional: '[0-70]' restart: false unit: INT - defaultValue: '5000' divisibilityFactor: 1 mode: readwrite name: innodb_concurrency_tickets optional: '[1-4294967295]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_data_file_purge optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '100' divisibilityFactor: 1 mode: readwrite name: innodb_data_file_purge_interval optional: '[0-10000]' restart: false unit: INT - defaultValue: '128' divisibilityFactor: 1 mode: readwrite name: innodb_data_file_purge_max_size optional: '[16-1073741824]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_deadlock_detect optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_disable_sort_file_cache optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1' divisibilityFactor: 0 mode: readwrite name: innodb_flush_log_at_trx_commit optional: '[0|1|2]' restart: false unit: STRING - defaultValue: '0' divisibilityFactor: 0 mode: readwrite name: innodb_flush_neighbors optional: '[0|1|2]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_flush_sync optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_ft_enable_diag_print optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_ft_enable_stopword optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '2000' divisibilityFactor: 1 mode: readwrite name: innodb_ft_num_word_optimize optional: '[0-10000]' restart: false unit: INT - defaultValue: '2000000000' divisibilityFactor: 1 mode: readwrite name: innodb_ft_result_cache_limit optional: '[1000000-4294967295]' restart: false unit: INT - defaultValue: '20000' divisibilityFactor: 1 mode: readwrite name: innodb_io_capacity optional: '[0-18446744073709551615]' restart: false unit: INT - defaultValue: '40000' divisibilityFactor: 1 mode: readwrite name: innodb_io_capacity_max optional: '[0-18446744073709551615]' restart: false unit: INT - defaultValue: '50' divisibilityFactor: 1 mode: readwrite name: innodb_lock_wait_timeout optional: '[1-1073741824]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_log_checksums optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_log_compressed_pages optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '8192' divisibilityFactor: 1 mode: readwrite name: innodb_lru_scan_depth optional: '[100-18446744073709551615]' restart: false unit: INT - defaultValue: '75' divisibilityFactor: 1 mode: readwrite name: innodb_max_dirty_pages_pct optional: '[0-99]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: innodb_max_dirty_pages_pct_lwm optional: '[0-99]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: innodb_max_purge_lag optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: innodb_max_purge_lag_delay optional: '[0-10000000]' restart: false unit: INT - defaultValue: '1073741824' divisibilityFactor: 1 mode: readwrite name: innodb_max_undo_log_size optional: '[10485760-18446744073709551615]' restart: false unit: INT - defaultValue: '' divisibilityFactor: 0 mode: readwrite name: innodb_monitor_disable optional: all restart: false unit: STRING - defaultValue: '' divisibilityFactor: 0 mode: readwrite name: innodb_monitor_enable optional: all restart: false unit: STRING - defaultValue: '37' divisibilityFactor: 1 mode: readwrite name: innodb_old_blocks_pct optional: '[5-95]' restart: false unit: INT - defaultValue: '1000' divisibilityFactor: 1 mode: readwrite name: innodb_old_blocks_time optional: '[0-1024]' restart: false unit: INT - defaultValue: '134217728' divisibilityFactor: 1 mode: readwrite name: innodb_online_alter_log_max_size optional: '[134217728-2147483647]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_optimize_fulltext_only optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_print_all_deadlocks optional: '[OFF|ON]' restart: false unit: STRING - defaultValue: '128' divisibilityFactor: 1 mode: readwrite name: innodb_purge_rseg_truncate_frequency optional: '[1-128]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_random_read_ahead optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: innodb_read_ahead_threshold optional: '[0-1024]' restart: false unit: INT - defaultValue: '128' divisibilityFactor: 1 mode: readwrite name: innodb_rollback_segments optional: '[1-128]' restart: false unit: INT - defaultValue: '6' divisibilityFactor: 1 mode: readwrite name: innodb_spin_wait_delay optional: '[0-4294967295]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_stats_auto_recalc optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: nulls_equal divisibilityFactor: 0 mode: readwrite name: innodb_stats_method optional: '[nulls_equal|nulls_unequal|nulls_ignored]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_stats_on_metadata optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_stats_persistent optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '20' divisibilityFactor: 1 mode: readwrite name: innodb_stats_persistent_sample_pages optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '8' divisibilityFactor: 1 mode: readwrite name: innodb_stats_transient_sample_pages optional: '[1-4294967295]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_status_output optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_status_output_locks optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_strict_mode optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '30' divisibilityFactor: 1 mode: readwrite name: innodb_sync_spin_loops optional: '[0-4294967295]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_table_locks optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: innodb_thread_concurrency optional: '[0-1000]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: innodb_thread_sleep_delay optional: '[0-1000000]' restart: false unit: INT - defaultValue: '7200' divisibilityFactor: 1 mode: readwrite name: interactive_timeout optional: '[10-86400]' restart: false unit: INT - defaultValue: '{LEAST(DBInstanceClassMemory/1048576*128, 262144)}' divisibilityFactor: 1 mode: readwrite name: join_buffer_size optional: '[128-4294967295]' restart: false unit: INT - defaultValue: '300' divisibilityFactor: 100 mode: readwrite name: key_cache_age_threshold optional: '[100-4294967295]' restart: false unit: INT - defaultValue: '1024' divisibilityFactor: 512 mode: readwrite name: key_cache_block_size optional: '[512-16384]' restart: false unit: B - defaultValue: '100' divisibilityFactor: 1 mode: readwrite name: key_cache_division_limit optional: '[1-100]' restart: false unit: INT - defaultValue: en_US divisibilityFactor: 0 mode: readwrite name: lc_time_names optional: '[ja_JP|pt_BR|en_US]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: local_infile optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '31536000' divisibilityFactor: 1 mode: readwrite name: lock_wait_timeout optional: '[1-1073741824]' restart: false unit: INT - defaultValue: '1' divisibilityFactor: 0 mode: readwrite name: log_bin_use_v1_row_events optional: '[0|1]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: log_queries_not_using_indexes optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: log_slow_admin_statements optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: log_throttle_queries_not_using_indexes optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '1' divisibilityFactor: 6 mode: readwrite name: long_query_time optional: '[0.1-31536000]' restart: false unit: DOUBLE - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_force_memory_to_innodb optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_force_myisam_to_innodb optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_ignore_index_hint_error optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: loose_implicit_primary_key optional: '[0-1]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_innodb_log_compressed_pages optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on divisibilityFactor: 0 mode: readwrite name: loose_optimizer_switch optional: .* restart: false unit: STRING - defaultValue: enabled=off,one_line=off divisibilityFactor: 0 mode: readwrite name: loose_optimizer_trace optional: .* restart: false unit: STRING - defaultValue: greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on divisibilityFactor: 0 mode: readwrite name: loose_optimizer_trace_features optional: .* restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_performance_agent_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '100' divisibilityFactor: 1 mode: readwrite name: loose_performance_agent_file_size optional: '[10-1000]' restart: false unit: INT - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: loose_performance_agent_interval optional: '[1-60]' restart: false unit: INT - defaultValue: '100000' divisibilityFactor: 1 mode: readwrite name: loose_rds_audit_log_row_limit optional: '[0-100000000]' restart: false unit: INT - defaultValue: MYSQL_V1 divisibilityFactor: 0 mode: readwrite name: loose_rds_audit_log_version optional: '[MYSQL_V1|MYSQL_V3]' restart: false unit: STRING - defaultValue: '2048' divisibilityFactor: 1 mode: readwrite name: loose_rds_audit_max_sql_size optional: '[0-10000000]' restart: false unit: INT - defaultValue: XA_RECOVER_ADMIN divisibilityFactor: 0 mode: readwrite name: loose_rds_expose_priv_list optional: .* restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_rds_force_myisam_to_innodb optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_rpl_semi_sync_master_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1000' divisibilityFactor: 1 mode: readwrite name: loose_rpl_semi_sync_master_timeout optional: '[0-18446744073709551615]' restart: false unit: INT - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: loose_rpl_semi_sync_master_trace_level optional: '[1|16|32|64]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_rpl_semi_sync_master_wait_no_slave optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: AFTER_SYNC divisibilityFactor: 0 mode: readwrite name: loose_rpl_semi_sync_master_wait_point optional: '[AFTER_SYNC|AFTER_COMMIT]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 1 mode: readwrite name: loose_rpl_semi_sync_slave_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: loose_rpl_semi_sync_slave_trace_level optional: '[1|16|32|64]' restart: false unit: STRING - defaultValue: '"*"' divisibilityFactor: 0 mode: readwrite name: loose_session_track_system_variables optional: .* restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_session_track_transaction_info optional: '[STATE|CHARACTERISTICS|OFF]' restart: false unit: STRING - defaultValue: '32' divisibilityFactor: 1 mode: readwrite name: loose_slave_parallel_workers optional: '[0-1024]' restart: false unit: INT - defaultValue: '8' divisibilityFactor: 1 mode: readwrite name: loose_validate_password_length optional: '[1-12]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 0 mode: readwrite name: low_priority_updates optional: '[0|1]' restart: false unit: STRING - defaultValue: TABLE divisibilityFactor: 0 mode: readwrite name: master_info_repository optional: '[TABLE|FILE]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: master_verify_checksum optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1073741824' divisibilityFactor: 1 mode: readwrite name: max_allowed_packet optional: '[16384-1073741824]' restart: false unit: INT - defaultValue: '18446744073709551615' divisibilityFactor: 1 mode: readwrite name: max_binlog_cache_size optional: '[4096-18446744073709547520]' restart: false unit: INT - defaultValue: '18446744073709551615' divisibilityFactor: 4096 mode: readwrite name: max_binlog_stmt_cache_size optional: '[4096-18446744073709547520]' restart: false unit: INT - defaultValue: '65536' divisibilityFactor: 1 mode: readwrite name: max_connect_errors optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '1024' divisibilityFactor: 1 mode: readwrite name: max_error_count optional: '[0-65535]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: max_execution_time optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '67108864' divisibilityFactor: 1024 mode: readwrite name: max_heap_table_size optional: '[16384-1844674407370954752]' restart: false unit: INT - defaultValue: '18446744073709551615' divisibilityFactor: 1 mode: readwrite name: max_join_size optional: '[1-18446744073709551615]' restart: false unit: INT - defaultValue: '4096' divisibilityFactor: 1 mode: readwrite name: max_length_for_sort_data optional: '[0-838860]' restart: false unit: INT - defaultValue: '16382' divisibilityFactor: 1 mode: readwrite name: max_prepared_stmt_count optional: '[0-1048576]' restart: false unit: INT - defaultValue: '18446744073709551615' divisibilityFactor: 1 mode: readwrite name: max_seeks_for_key optional: '[1-18446744073709551615]' restart: false unit: INT - defaultValue: '1024' divisibilityFactor: 1 mode: readwrite name: max_sort_length optional: '[4-8388608]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: max_sp_recursion_depth optional: '[0-255]' restart: false unit: INT - defaultValue: '102400' divisibilityFactor: 1 mode: readwrite name: max_write_lock_count optional: '[1-102400]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: min_examined_row_limit optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '262144' divisibilityFactor: 1 mode: readwrite name: myisam_sort_buffer_size optional: '[262144-16777216]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: mysql_native_password_proxy_users optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '16384' divisibilityFactor: 1024 mode: readwrite name: net_buffer_length optional: '[1024-1048576]' restart: false unit: INT - defaultValue: '30' divisibilityFactor: 1 mode: readwrite name: net_read_timeout optional: '[1-18446744073709551615]' restart: false unit: INT - defaultValue: '10' divisibilityFactor: 1 mode: readwrite name: net_retry_count optional: '[1-4294967295]' restart: false unit: INT - defaultValue: '60' divisibilityFactor: 1 mode: readwrite name: net_write_timeout optional: '[1-18446744073709551615]' restart: false unit: INT - defaultValue: '1' divisibilityFactor: 0 mode: readwrite name: optimizer_prune_level optional: '[0|1]' restart: false unit: STRING - defaultValue: '62' divisibilityFactor: 1 mode: readwrite name: optimizer_search_depth optional: '[0-62]' restart: false unit: INT - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: optimizer_trace_limit optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '1048576' divisibilityFactor: 1 mode: readwrite name: optimizer_trace_max_mem_size optional: '[0-4294967295]' restart: false unit: INT - defaultValue: '-1' divisibilityFactor: 1 mode: readwrite name: optimizer_trace_offset optional: '[-2147483648-2147483647]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_opt_enable_rds_priv_strategy optional: 'ON' restart: false unit: STRING - defaultValue: '2' divisibilityFactor: 1 mode: readwrite name: loose_performance_point_iostat_interval optional: '[0-60]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_performance_point_lock_rwlock_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '32768' divisibilityFactor: 1 mode: readwrite name: preload_buffer_size optional: '[1024-1073741824]' restart: false unit: INT - defaultValue: '8192' divisibilityFactor: 1024 mode: readwrite name: query_alloc_block_size optional: '[1024-16384]' restart: false unit: INT - defaultValue: '8192' divisibilityFactor: 1024 mode: readwrite name: query_prealloc_size optional: '[8192-1048576]' restart: false unit: INT - defaultValue: '4096' divisibilityFactor: 1 mode: readwrite name: range_alloc_block_size optional: '[4096-18446744073709551615]' restart: false unit: INT - defaultValue: '8388608' divisibilityFactor: 1 mode: readwrite name: range_optimizer_max_mem_size optional: '[0-18446744073709551615]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: rds_audit_log_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '{LEAST(DBInstanceClassMemory/1048576*128, 262144)}' divisibilityFactor: 1 mode: readwrite name: read_buffer_size optional: '[8200-2147479552]' restart: false unit: INT - defaultValue: TABLE divisibilityFactor: 0 mode: readwrite name: relay_log_info_repository optional: '[TABLE|FILE]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: session_track_gtids optional: '[OFF|OWN_GTID|ALL_GTIDS]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: session_track_schema optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: session_track_state_change optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: sha256_password_proxy_users optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: show_old_temporals optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: strict divisibilityFactor: 0 mode: readwrite name: slave_exec_mode optional: strict restart: false unit: STRING - defaultValue: '4' divisibilityFactor: 1 mode: readwrite name: slave_net_timeout optional: '[15-300]' restart: false unit: INT - defaultValue: '2' divisibilityFactor: 1 mode: readwrite name: slow_launch_time optional: '[1-1024]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: slow_query_log optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '868352' divisibilityFactor: 1 mode: readwrite name: sort_buffer_size optional: '[32768-4294967295]' restart: false unit: INT - defaultValue: NO_ENGINE_SUBSTITUTION divisibilityFactor: 0 mode: readwrite name: sql_mode optional: (s*|REAL_AS_FLOAT|PIPES_AS_CONCAT|ANSI_QUOTES|IGNORE_SPACE|ONLY_FULL_GROUP_BY|NO_UNSIGNED_SUBTRACTION|NO_DIR_IN_CREATE|ANSI|NO_AUTO_VALUE_ON_ZERO|NO_BACKSLASH_ESCAPES|STRICT_TRANS_TABLES|STRICT_ALL_TABLES|NO_ZERO_IN_DATE|NO_ZERO_DATE|ALLOW_INVALID_DATES|ERROR_FOR_DIVISION_BY_ZERO|TRADITIONAL|HIGH_NOT_PRECEDENCE|NO_ENGINE_SUBSTITUTION|PAD_CHAR_TO_FULL_LENGTH)(,REAL_AS_FLOAT|,PIPES_AS_CONCAT|,ANSI_QUOTES|,IGNORE_SPACE|,ONLY_FULL_GROUP_BY|,NO_UNSIGNED_SUBTRACTION|,NO_DIR_IN_CREATE|,ANSI|,NO_AUTO_VALUE_ON_ZERO|,NO_BACKSLASH_ESCAPES|,STRICT_TRANS_TABLES|,STRICT_ALL_TABLES|,NO_ZERO_IN_DATE|,NO_ZERO_DATE|,ALLOW_INVALID_DATES|,ERROR_FOR_DIVISION_BY_ZERO|,TRADITIONAL|,HIGH_NOT_PRECEDENCE|,NO_ENGINE_SUBSTITUTION|,PAD_CHAR_TO_FULL_LENGTH)* restart: false unit: STRING - defaultValue: '256' divisibilityFactor: 1 mode: readwrite name: stored_program_cache optional: '[16-524288]' restart: false unit: INT - defaultValue: '{LEAST(DBInstanceClassMemory/1073741824*512, 2048)}' divisibilityFactor: 1 mode: readwrite name: table_definition_cache optional: '[400-524288]' restart: false unit: INT - defaultValue: '{LEAST(DBInstanceClassMemory/1073741824*512, 8192)}' divisibilityFactor: 1 mode: readwrite name: table_open_cache optional: '[1-524288]' restart: false unit: INT - defaultValue: '100' divisibilityFactor: 1 mode: readwrite name: thread_cache_size optional: '[0-16384]' restart: false unit: INT - defaultValue: '2097152' divisibilityFactor: 1 mode: readwrite name: tmp_table_size optional: '[262144-134217728]' restart: false unit: INT - defaultValue: '8192' divisibilityFactor: 1024 mode: readwrite name: transaction_alloc_block_size optional: '[1024-131072]' restart: false unit: INT - defaultValue: REPEATABLE-READ divisibilityFactor: 0 mode: readwrite name: transaction_isolation optional: '[READ-UNCOMMITTED|READ-COMMITTED|REPEATABLE-READ|SERIALIZABLE]' restart: false unit: STRING - defaultValue: '4096' divisibilityFactor: 1024 mode: readwrite name: transaction_prealloc_size optional: '[1024-131072]' restart: false unit: INT - defaultValue: 'YES' divisibilityFactor: 0 mode: readwrite name: updatable_views_with_limit optional: '[YES|NO]' restart: false unit: STRING - defaultValue: '28800' divisibilityFactor: 1 mode: readwrite name: wait_timeout optional: '[1-31536000]' restart: false unit: INT - defaultValue: WRITESET divisibilityFactor: 1 mode: readwrite name: binlog_transaction_dependency_tracking optional: '[WRITESET|WRITESET_SESSION|COMMIT_ORDER]' restart: false unit: STRING - defaultValue: '2' divisibilityFactor: 1 mode: readwrite name: log_error_verbosity optional: '[1-3]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_ccl_max_waiting_count optional: '[0-9223372036854775807]' restart: false unit: INT - defaultValue: '4' divisibilityFactor: 1 mode: readwrite name: loose_ccl_queue_bucket_count optional: '[1-64]' restart: false unit: INT - defaultValue: '64' divisibilityFactor: 1 mode: readwrite name: loose_ccl_queue_bucket_size optional: '[1-4096]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_ccl_queue_hot_delete optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_ccl_queue_hot_update optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '86400' divisibilityFactor: 1 mode: readwrite name: loose_ccl_wait_timeout optional: '[1-31536000]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_clear_log_file_pagecache optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '2048' divisibilityFactor: 1 mode: readwrite name: loose_crash_sql_stmt_max_length optional: '[1-1000000000]' restart: false unit: INT - defaultValue: '86400' divisibilityFactor: 1 mode: readwrite name: loose_information_schema_stats_expiry optional: '[0-31536000]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_innodb_buffer_pool_in_core_file optional: '[OFF|ON]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_innodb_log_optimize_ddl optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '4096' divisibilityFactor: 1 mode: readwrite name: loose_innodb_log_write_ahead_size optional: '[512-16384]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_innodb_multi_blocks_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: loose_innodb_parallel_read_threads optional: '[0-256]' restart: false unit: INT - defaultValue: '100' divisibilityFactor: 1 mode: readwrite name: loose_innodb_rds_chunk_flush_interval optional: '[0-100000]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 1 mode: readwrite name: loose_innodb_rds_faster_ddl optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '30' divisibilityFactor: 1 mode: readwrite name: loose_innodb_rds_flashback_allow_gap optional: '[0-10080]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_innodb_rds_flashback_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: loose_innodb_rds_flashback_interval optional: '[1-10]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_innodb_rds_flashback_print_warning optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_innodb_rds_flashback_task_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 1 mode: readwrite name: loose_innodb_rds_free_resize optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_innodb_trx_resurrect_table_lock_accelerate optional: '[OFF|ON]' restart: false unit: STRING - defaultValue: '1800' divisibilityFactor: 1 mode: readwrite name: loose_innodb_undo_retention optional: '[0-172800]' restart: false unit: INT - defaultValue: '1024' divisibilityFactor: 1 mode: readwrite name: loose_innodb_undo_space_reserved_size optional: '[0-20480]' restart: false unit: INT - defaultValue: '102400' divisibilityFactor: 1 mode: readwrite name: loose_innodb_undo_space_supremum_size optional: '[0-524288]' restart: false unit: INT - defaultValue: TempTable divisibilityFactor: 0 mode: readwrite name: loose_internal_tmp_mem_storage_engine optional: '[TempTable|MEMORY]' restart: false unit: STRING - defaultValue: '10' divisibilityFactor: 1 mode: readwrite name: loose_keyring_rds_command_timeout_sec optional: '[1-999999]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_multi_blocks_count optional: '[0-1024]' restart: false unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_multi_blocks_ddl_count optional: '[0-1024]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 1 mode: readwrite name: loose_persist_binlog_to_redo optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '1048576' divisibilityFactor: 1 mode: readwrite name: loose_persist_binlog_to_redo_size_limit optional: '[0-10485760]' restart: false unit: STRING - defaultValue: '16777216' divisibilityFactor: 1 mode: readwrite name: loose_rds_audit_log_buffer_size optional: '[16777216-104857600]' restart: false unit: INT - defaultValue: '8192' divisibilityFactor: 1 mode: readwrite name: loose_rds_audit_log_event_buffer_size optional: '[0-32768]' restart: false unit: INT - defaultValue: '' divisibilityFactor: 0 mode: readwrite name: loose_rds_data_protect_admin optional: .* restart: false unit: STRING - defaultValue: '' divisibilityFactor: 0 mode: readwrite name: loose_rds_data_protect_ignore optional: .* restart: false unit: STRING - defaultValue: NONE divisibilityFactor: 0 mode: readwrite name: loose_rds_data_protect_level optional: '[ALL|DDL|NONE]' restart: false unit: STRING - defaultValue: aurora,Xtrabak,replicator,eagleye,aliyun_root divisibilityFactor: 0 mode: readwrite name: loose_rds_ignore_password_validation_user_list optional: .* restart: false unit: STRING - defaultValue: '' divisibilityFactor: 0 mode: readwrite name: loose_rds_kill_user_list optional: .* restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_recycle_bin optional: '[OFF|ON]' restart: false unit: STRING - defaultValue: '604800' divisibilityFactor: 86400 mode: readwrite name: loose_recycle_bin_retention optional: '[86400-1209600]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_recycle_scheduler optional: '[OFF|ON]' restart: false unit: STRING - defaultValue: '30' divisibilityFactor: 30 mode: readwrite name: loose_recycle_scheduler_interval optional: '[30-120]' restart: false unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_recycle_scheduler_purge_table_print optional: '[OFF|ON]' restart: false unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_sql_safe_updates optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: 'ON' divisibilityFactor: 1 mode: readwrite name: loose_thread_pool_enabled optional: '[ON|OFF]' restart: false unit: STRING - defaultValue: '32' divisibilityFactor: 1 mode: readwrite name: loose_thread_pool_oversubscribe optional: '[10-64]' restart: false unit: INT - defaultValue: '4' divisibilityFactor: 1 mode: readwrite name: loose_thread_pool_size optional: '[1-64]' restart: false unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_wait_binlog_flush optional: '[OFF|ON]' restart: false unit: STRING - defaultValue: '65536' divisibilityFactor: 1 mode: readwrite name: max_points_in_geometry optional: '[3-1048576]' restart: false unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: sync_master_info optional: '[0-18446744073709551615]' restart: false unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: sync_relay_log_info optional: '[0-18446744073709551615]' restart: false unit: INT - defaultValue: '1073741824' divisibilityFactor: 1 mode: readwrite name: temptable_max_ram optional: '[2097152-107374182400]' restart: false unit: INT - defaultValue: XXHASH64 divisibilityFactor: 1 mode: readwrite name: transaction_write_set_extraction optional: '[OFF|MURMUR32|XXHASH64]' restart: false unit: STRING - defaultValue: '3000' divisibilityFactor: 1 mode: readwrite name: back_log optional: '[0-65535]' restart: true unit: INT - defaultValue: CRC32 divisibilityFactor: 0 mode: readwrite name: binlog_checksum optional: '[CRC32|NONE]' restart: true unit: STRING - defaultValue: utf8 divisibilityFactor: 0 mode: readwrite name: character_set_server optional: '[utf8|latin1|gbk|gb18030|utf8mb4]' restart: true unit: STRING - defaultValue: InnoDB divisibilityFactor: 0 mode: readwrite name: default_storage_engine optional: '[InnoDB|innodb]' restart: true unit: STRING - defaultValue: SYSTEM divisibilityFactor: 0 mode: readwrite name: default_time_zone optional: '[SYSTEM|-12:00|-11:00|-10:00|-9:00|-8:00|-7:00|-6:00|-5:00|-4:00|-3:00|-2:00|-1:00|\+0:00|\+1:00|\+2:00|\+3:00|\+4:00|\+5:00|\+5:30|\+5:45|\+6:00|\+6:30|\+7:00|\+8:00|\+9:00|\+10:00|\+11:00|\+12:00|\+13:00]' restart: true unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: disconnect_on_expired_password optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: '84' divisibilityFactor: 1 mode: readwrite name: ft_max_word_len optional: '[10-4294967295]' restart: true unit: INT - defaultValue: '4' divisibilityFactor: 1 mode: readwrite name: ft_min_word_len optional: '[1-3600]' restart: true unit: INT - defaultValue: '20' divisibilityFactor: 1 mode: readwrite name: ft_query_expansion_limit optional: '[0-1000]' restart: true unit: INT - defaultValue: '2' divisibilityFactor: 0 mode: readwrite name: innodb_autoinc_lock_mode optional: '[0|1|2]' restart: true unit: STRING - defaultValue: '8' divisibilityFactor: 1 mode: readwrite name: innodb_buffer_pool_instances optional: '[1-64]' restart: true unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: innodb_buffer_pool_load_at_startup optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: '{DBInstanceClassMemory*3/4}' divisibilityFactor: 1 mode: readwrite name: innodb_buffer_pool_size optional: '[134217728-18446744073709551615]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: innodb_commit_concurrency optional: '[0-1000]' restart: true unit: INT - defaultValue: O_DIRECT divisibilityFactor: 0 mode: readwrite name: innodb_flush_method optional: '[fsync|O_DSYNC|littlesync|nosync|O_DIRECT|O_DIRECT_NO_FSYNC]' restart: true unit: STRING - defaultValue: '8000000' divisibilityFactor: 1 mode: readwrite name: innodb_ft_cache_size optional: '[1600000-80000000]' restart: true unit: INT - defaultValue: '84' divisibilityFactor: 1 mode: readwrite name: innodb_ft_max_token_size optional: '[10-84]' restart: true unit: INT - defaultValue: '3' divisibilityFactor: 1 mode: readwrite name: innodb_ft_min_token_size optional: '[0-16]' restart: true unit: INT - defaultValue: '2' divisibilityFactor: 1 mode: readwrite name: innodb_ft_sort_pll_degree optional: '[1-16]' restart: true unit: INT - defaultValue: '640000000' divisibilityFactor: 1 mode: readwrite name: innodb_ft_total_cache_size optional: '[32000000-1600000000]' restart: true unit: INT - defaultValue: '104857600' divisibilityFactor: 1024 mode: readwrite name: innodb_log_file_size optional: '[4194304-107374182400]' restart: true unit: INT - defaultValue: '20000' divisibilityFactor: 1 mode: readwrite name: innodb_open_files optional: '[10-2147483647]' restart: true unit: INT - defaultValue: '4' divisibilityFactor: 1 mode: readwrite name: innodb_page_cleaners optional: '[1-64]' restart: true unit: INT - defaultValue: '300' divisibilityFactor: 1 mode: readwrite name: innodb_purge_batch_size optional: '[1-5000]' restart: true unit: INT - defaultValue: '2' divisibilityFactor: 1 mode: readwrite name: innodb_purge_threads optional: '[1-32]' restart: true unit: INT - defaultValue: '4' divisibilityFactor: 1 mode: readwrite name: innodb_read_io_threads optional: '[1-64]' restart: true unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_rollback_on_timeout optional: '[OFF|ON]' restart: true unit: STRING - defaultValue: '1048576' divisibilityFactor: 512 mode: readwrite name: innodb_sort_buffer_size optional: '[65536-67108864]' restart: true unit: INT - defaultValue: '16' divisibilityFactor: 1 mode: readwrite name: innodb_sync_array_size optional: '[1-64]' restart: true unit: INT - defaultValue: '4' divisibilityFactor: 1 mode: readwrite name: innodb_write_io_threads optional: '[1-64]' restart: true unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_auto_detect_certs optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_innodb_numa_interleave optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: /usr/bin/kms_agent divisibilityFactor: 0 mode: readwrite name: loose_keyring_rds_kms_agent_cmd optional: .* restart: true unit: STRING - defaultValue: '2' divisibilityFactor: 1 mode: readwrite name: ngram_token_size optional: '[0-20]' restart: true unit: int - defaultValue: '65535' divisibilityFactor: 1 mode: readwrite name: open_files_limit optional: '[1-2147483647]' restart: true unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: opt_indexstat optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: opt_tablestat optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_point_iostat_volume_size optional: '[0-100000]' restart: true unit: INT - defaultValue: 'OFF' divisibilityFactor: 1 mode: readwrite name: performance_schema optional: '[0-1]' restart: true unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: relay_log_recovery optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: LOGICAL_CLOCK divisibilityFactor: 0 mode: readwrite name: slave_parallel_type optional: '[DATABASE|LOGICAL_CLOCK]' restart: true unit: STRING - defaultValue: '16' divisibilityFactor: 1 mode: readwrite name: table_open_cache_instances optional: '[1-64]' restart: true unit: INT - defaultValue: '262144' divisibilityFactor: 1024 mode: readwrite name: thread_stack optional: '[131072-2147483647]' restart: true unit: INT - defaultValue: TLSv1,TLSv1.1,TLSv1.2 divisibilityFactor: 0 mode: readwrite name: tls_version optional: '[TLSv1,TLSv1.1,TLSv1.2|TLSv1,TLSv1.1|TLSv1.2]' restart: true unit: STRING - defaultValue: mysql_native_password divisibilityFactor: 0 mode: readwrite name: default_authentication_plugin optional: '[mysql_native_password|sha256_password|caching_sha2_password]' restart: true unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: general_log optional: 'OFF' restart: true unit: STRING - defaultValue: '33554432' divisibilityFactor: 1048576 mode: readwrite name: innodb_buffer_pool_chunk_size optional: '[1048576-9223372036854775807]' restart: true unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_async_binlog_recovery optional: '[OFF|ON]' restart: true unit: STRING - defaultValue: '20971520' divisibilityFactor: 1 mode: readwrite name: loose_binlog_buffer_size optional: '[20971520-1073741824]' restart: true unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_innodb_buffer_pool_init_optimize optional: '[OFF|ON]' restart: true unit: STRING - defaultValue: '64' divisibilityFactor: 1 mode: readwrite name: loose_innodb_doublewrite_pages optional: '[0-512]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_accounts_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_digests_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_error_size optional: '[0-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_events_stages_history_long_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_events_stages_history_size optional: '[-1-1024]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_events_statements_history_long_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_events_statements_history_size optional: '[-1-1024]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_events_transactions_history_long_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_events_transactions_history_size optional: '[-1-1024]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_events_waits_history_long_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_events_waits_history_size optional: '[-1-1024]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_hosts_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_cond_classes optional: '[0-256]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_cond_instances optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_digest_length optional: '[0-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_digest_sample_age optional: '[0-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_file_classes optional: '[0-256]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_file_handles optional: '[-1-32768]' restart: true unit: INT - defaultValue: '1000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_file_instances optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_index_stat optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_memory_classes optional: '[0-1024]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_metadata_locks optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_mutex_classes optional: '[0-256]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_mutex_instances optional: '[-1-104857600]' restart: true unit: INT - defaultValue: '1000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_prepared_statements_instances optional: '[-1-4194304]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_program_instances optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_rwlock_classes optional: '[0-256]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_rwlock_instances optional: '[-1-104857600]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_socket_classes optional: '[0-256]' restart: true unit: INT - defaultValue: '1000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_socket_instances optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_sql_text_length optional: '[0-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_stage_classes optional: '[0-256]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_statement_classes optional: '[0-256]' restart: true unit: INT - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_statement_stack optional: '[0-256]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_table_handles optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '1000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_table_instances optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_table_lock_stat optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_thread_classes optional: '[0-256]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_max_thread_instances optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_session_connect_attrs_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_setup_actors_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_setup_objects_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_performance_schema_users_size optional: '[-1-1048576]' restart: true unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: loose_recovery_apply_binlog optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_xengine optional: '[1|0]' restart: true unit: STRING - defaultValue: '' divisibilityFactor: 0 mode: readwrite name: slave_type_conversions optional: '[s*|ALL_LOSSY|ALL_NON_LOSSY|ALL_SIGNED|ALL_UNSIGNED]' restart: true unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: enforce_gtid_consistency optional: .* restart: true unit: STRING - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: expire_logs_days optional: .* restart: true unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: gtid_mode optional: .* restart: true unit: STRING - defaultValue: '209715200' divisibilityFactor: 1 mode: readwrite name: innodb_log_buffer_size optional: .* restart: true unit: INT - defaultValue: '16777216' divisibilityFactor: 1 mode: readwrite name: key_buffer_size optional: .* restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: loose_kill_idle_transaction_timeout optional: .* restart: true unit: INT - defaultValue: '0' divisibilityFactor: 0 mode: readwrite name: log_slave_updates optional: .* restart: true unit: INT - defaultValue: '500' divisibilityFactor: 1 mode: readwrite name: loose_rds_reserved_connections optional: .* restart: true unit: INT - defaultValue: '2520' divisibilityFactor: 1 mode: readwrite name: max_connections optional: .* restart: true unit: INT - defaultValue: '2000' divisibilityFactor: 1 mode: readwrite name: max_user_connections optional: .* restart: true unit: INT - defaultValue: '442368' divisibilityFactor: 1 mode: readwrite name: read_rnd_buffer_size optional: .* restart: true unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: relay_log_purge optional: .* restart: true unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: replicate-same-server-id optional: .* restart: true unit: STRING - defaultValue: '' divisibilityFactor: 0 mode: readwrite name: rotate_log_table_last_name optional: .* restart: true unit: STRING - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: skip_slave_start optional: .* restart: true unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: skip_ssl optional: .* restart: true unit: STRING - defaultValue: '1073741824' divisibilityFactor: 1 mode: readwrite name: slave_pending_jobs_size_max optional: .* restart: true unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: slave_sql_verify_checksum optional: .* restart: true unit: STRING - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: sync_binlog optional: .* restart: false unit: INT - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: sync_relay_log optional: .* restart: true unit: INT - defaultValue: block divisibilityFactor: 0 mode: readwrite name: innodb_tcn_cache_level optional: .* restart: true unit: STRING - defaultValue: '1' divisibilityFactor: 1 mode: readwrite name: innodb_snapshot_update_gcn optional: .* restart: true unit: INT - defaultValue: '0' divisibilityFactor: 1 mode: readwrite name: innodb_equal_gcn_visible optional: .* restart: true unit: INT - defaultValue: '3000' divisibilityFactor: 1 mode: readwrite name: loose_replica_read_timeout optional: '[0-2147483647]' restart: true unit: INT - defaultValue: '9999999999' divisibilityFactor: 1 mode: readwrite name: innodb_commit_cleanout_max_rows optional: '[0-9223372036854775807]' restart: true unit: INT - defaultValue: 'OFF' divisibilityFactor: 0 mode: readwrite name: innodb_lizard_stat_enabled optional: '[ON|OFF]' restart: true unit: STRING - defaultValue: '1' divisibilityFactor: 0 mode: readwrite name: lower_case_table_names optional: '[0|1]' restart: true unit: STRING - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_consensus_election_timeout optional: .* restart: true unit: INT - defaultValue: '8' divisibilityFactor: 1 mode: readwrite name: loose_consensus_io_thread_cnt optional: .* restart: true unit: INT - defaultValue: '8' divisibilityFactor: 1 mode: readwrite name: loose_consensus_worker_thread_cnt optional: .* restart: true unit: INT - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_consensus_auto_leader_transfer optional: .* restart: true unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_consensus_auto_reset_match_index optional: .* restart: true unit: STRING - defaultValue: 'ON' divisibilityFactor: 0 mode: readwrite name: loose_consensus_large_trx optional: .* restart: true unit: STRING - defaultValue: '536870912' divisibilityFactor: 1 mode: readwrite name: loose_consensus_log_cache_size optional: .* restart: true unit: INT - defaultValue: '10000' divisibilityFactor: 1 mode: readwrite name: loose_consensus_max_delay_index optional: .* restart: true unit: INT - defaultValue: '20971520' divisibilityFactor: 1 mode: readwrite name: loose_consensus_max_log_size optional: .* restart: true unit: INT - defaultValue: '131072' divisibilityFactor: 1 mode: readwrite name: loose_consensus_max_packet_size optional: .* restart: true unit: INT - defaultValue: '268435456' divisibilityFactor: 1 mode: readwrite name: loose_consensus_prefetch_cache_size optional: .* restart: true unit: INT
3.3 执行如下命令，创建参数模板。
kubectl apply -f parameter-template.yaml
3.4 执行如下命令，查看创建好的参数模板。
kubectl get PolarDBXParameterTemplate
4.部署 PolarDB-X 集群。
4.1 执行如下命令，创建polardb-x.yaml。
vim polardb-x.yaml
4.2 按i键进入编辑模式，将如下代码复制到文件中，然后按ECS退出编辑模式，输入:wq后按下Enter键保存并退出。
说明：代码最下方包含了参数模板的名称。
apiVersion: polardbx.aliyun.com/v1 kind: PolarDBXCluster metadata: name: polardb-x spec: topology: nodes: cdc: replicas: 1 template: resources: limits: cpu: "1" memory: 1Gi requests: cpu: 100m memory: 500Mi cn: replicas: 1 template: resources: limits: cpu: "2" memory: 4Gi requests: cpu: 100m memory: 1Gi dn: replicas: 1 template: engine: galaxy resources: limits: cpu: "2" memory: 4Gi requests: cpu: 100m memory: 500Mi gms: template: engine: galaxy resources: limits: cpu: "1" memory: 1Gi requests: cpu: 100m memory: 500Mi parameterTemplate: name: test
4.3 执行如下命令，创建PolarDB-X集群。
kubectl apply -f polardb-x.yaml
4.4 执行如下命令，查看PolarDB-X集群创建状态。
kubectl get polardbxCluster polardb-x -o wide -w
返回结果如下，请您耐心等待七分钟左右，当PHASE显示为Running时，表示PolarDB-X集群已经部署完成。
4.5 按Ctrl+C键，退出查看PolarDB-X集群创建状态。
连接 PolarDB-X 集群
1.执行如下命令，查看PolarDB-X集群登录密码。
kubectl get secret polardb-x -o jsonpath="{.data['polardbx_root']}" | base64 -d - | xargs echo "Password: "
返回结果如下，您可以查看到PolarDB-X集群登录密码。
2.执行如下命令，将PolarDB-X集群端口转发到3306端口。
说明：使用MySQL Client方式登录通过k8s部署的PolarDB-X集群前，您需要进行获取PolarDB-X集群登录密码和端口转发。
kubectl port-forward svc/polardb-x 3306
3.在实验页面，单击右上角的➕图标，创建新的终端二。
4.执行如下命令，连接PolarDB-X集群。
- 您需要将替换为实际获取到的PolarDB-X集群登录密码。
- 如遇到mysql: [Warning] Using a password on the command line interface can be insecure.ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0报错，请您稍等一分钟，重新转发端口并连接PolarDB-X集群即可。
mysql -h127.0.0.1 -Ac -P3306 -upolardbx_root -p<PolarDB-X集群登录密码>
5.查看默认参数。
连接到mysql后，您可以执行下面两条SQL分别查看CN和DN中的参数和它们的默认值，在下一步中我们将动态修改这两个参数的值。
5.1 执行如下命令，设置显示所有参数。
set show_all_params = true;
5.2 执行如下命令，查看CN参数。
参数说明：
- XPROTO_MAX_DN_CONCURRENT：私有协议单DN最大并发数，默认值是500。
- XPROTO_MAX_DN_WAIT_CONNECTION：私有协议单DN最大建连数，默认值是32。
show global variables like "XPROTO_MAX_DN_CONCURRENT";
show global variables like "XPROTO_MAX_DN_WAIT_CONNECTION";
5.3 执行如下命令，查看DN参数（需要添加HINT下推SQL）。
参数说明：
- sync_binlog：同步binog策略，默认值是1。
/*+TDDL:node(0)*/ show global variables like "sync_binlog";
动态修改 PolarDB-X 的参数
本步骤将指导您如何动态修改PolarDB-X中的参数，详细文档请见动态修改参数。
1.部署动态参数
1.1 在实验页面，单击右上角的+图标，创建新的终端三。
1.2 在终端三种，执行如下命令，切换到galaxykube用户。
su galaxykube cd
1.3 执行如下命令，创建parameter-modify.yaml。
vim parameter-modify.yaml
1.4 按i键进入编辑模式，将如下代码复制到文件中，然后按ECS退出编辑模式，输入:wq后按下Enter键保存并退出。
说明：您可以根据自身需求修改、添加、删除代码中CN或DN参数列表中的参数。
apiVersion: polardbx.aliyun.com/v1 kind: PolarDBXParameter metadata: name: test-param labels: parameter: dynamic spec: clusterName: polardb-x templateName: test nodeType: cn: name: cn-parameter restartType: rollingRestart paramList: - name: XPROTO_MAX_DN_CONCURRENT value: "4000" - name: XPROTO_MAX_DN_WAIT_CONNECTION value: "4000" dn: name: dn-parameter restartType: rollingRestart paramList: - name: sync_binlog value: "0"
1.5 执行如下命令，动态修改参数。
kubectl apply -f parameter-modify.yaml
1.6 执行如下命令，查看参数修改的状态，当PHASE为Finished后表示更改已经完成。
kubectl get PolarDBXParameter test-param
2.切换回终端二。稍作等待后，您可以对修改的参数进行验证。
2.1 在终端二中，执行如下命令，设置显示所有参数。
set show_all_params = true;
2.2 执行如下命令，验证CN参数修改。
show global variables like "XPROTO_MAX_DN_CONCURRENT";
show global variables like "XPROTO_MAX_DN_WAIT_CONNECTION";
2.3 执行如下命令，验证DN参数修改。
/*+TDDL:node(0)*/ show global variables like "sync_binlog";
您可以看到变量已经修改为parameter-modify.yaml中所设定的值。
本文来源：PolarDB-X 知乎号，关注阅读更多干货好文。
