😽

【AWS】 RDS Parameter groupsのdiffを取る

Lilycat2022/10/07に公開

Aurora MySQL 5.6が2023年2月にEOLを迎える事に伴い、5.7へのアップグレードが必要になりました。
Parameter groupsも5.7用に新しく作ることになりますが、5.6->5.7でデフォルト値は変更があるのでしょうか?
Webコンソールで比較するのは無理があるので、AWS CLIを使って差分を洗い出してみました。

Parameter groups

describe-db-parameters で取得できます。
リージョンやパラメータ名はご自身の環境に合わせてください。
https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-parameters.html

$ aws rds describe-db-parameters --region ap-northeast-1 --db-parameter-group-name db-param-56 | jq '.[][] | [.ParameterName,.ParameterValue] | @csv' > db-param-56.csv
$ aws rds describe-db-parameters --region ap-northeast-1 --db-parameter-group-name db-param-57 | jq '.[][] | [.ParameterName,.ParameterValue] | @csv' > db-param-57.csv

DB cluster parameter group

DB clustgerのparameter groupには、describe-db-cluster-parameters を使用します。
https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-cluster-parameters.html

$ aws rds describe-db-cluster-parameters --region ap-northeast-1 --db-cluster-parameter-group-name db-cluster-param-56 | jq '.[][] | [.ParameterName,.ParameterValue] | @csv' > db-cluster-param-56.csv
$ aws rds describe-db-cluster-parameters --region ap-northeast-1 --db-cluster-parameter-group-name db-cluster-param-57 | jq '.[][] | [.ParameterName,.ParameterValue] | @csv' > db-cluster-param-57.csv

diff

diff db-param-5.6.csv db-param-5.7.csv
6,7d5
< "\"aurora_pq\",\"1\""
< "\"aurora_pq_supported\",\"1\""
30d27
< "\"enforce_gtid_consistency\","
44d40
< "\"gtid-mode\",\"OFF\""
48a45
> "\"innodb_adaptive_hash_index_parts\","
51c48
< "\"innodb_buffer_pool_dump_at_shutdown\","
---
> "\"innodb_buffer_pool_dump_at_shutdown\",\"0\""
55c52
< "\"innodb_buffer_pool_load_at_startup\","
---
> "\"innodb_buffer_pool_load_at_startup\",\"0\""
102a100,101
> "\"innodb_status_output\","
> "\"innodb_status_output_locks\","
107a107
> "\"internal_tmp_disk_storage_engine\","
120c120,121
< "\"log_output\",\"TABLE\""
---
> "\"log_error_verbosity\","
> "\"log_output\",\"FILE\""
122a124,125
> "\"log_slow_admin_statements\","
> "\"log_slow_slave_statements\","
134a138
> "\"max_execution_time\","
138a143
> "\"max_points_in_geometry\","
186a192,193
> "\"performance_schema_events_transactions_history_long_size\","
> "\"performance_schema_events_transactions_history_size\","
196a204,206
> "\"performance_schema_max_index_stat\","
> "\"performance_schema_max_memory_classes\","
> "\"performance_schema_max_metadata_locks\","
198a209,210
> "\"performance_schema_max_prepared_statements_instances\","
> "\"performance_schema_max_program_instances\","
202a215
> "\"performance_schema_max_sql_text_length\","
204a218
> "\"performance_schema_max_statement_stack\","
206a221
> "\"performance_schema_max_table_lock_stat\","
225a241
> "\"range_optimizer_max_mem_size\","
233c249
< "\"secure_auth\","
---
> "\"secure_auth\",\"1\""
234a251
> "\"show_compatibility_56\","
264d280
< "\"timed_mutexes\","
diff db-cluster-param-5.6.csv db-cluster-param-5.7.csv
2,4c2,4
< "\"aurora_binlog_read_buffer_size\","
< "\"aurora_binlog_replication_max_yield_seconds\","
< "\"aurora_binlog_use_large_read_buffer\","
---
> "\"aurora_binlog_read_buffer_size\",\"5242880\""
> "\"aurora_binlog_replication_max_yield_seconds\",\"0\""
> "\"aurora_binlog_use_large_read_buffer\",\"1\""
8,9c8,9
< "\"aurora_enable_staggered_replica_restart\","
< "\"aurora_enable_zdr\","
---
> "\"aurora_fwd_master_idle_timeout\",\"60\""
> "\"aurora_fwd_master_max_connections_pct\",\"10\""
15,16d14
< "\"aurora_pq\",\"1\""
< "\"aurora_pq_supported\",\"1\""
22a21
> "\"aws_default_comprehend_role\","
25a25
> "\"aws_default_sagemaker_role\","
29a30
> "\"binlog_error_action\","
30a32
> "\"binlog_gtid_simple_recovery\","
43a46
> "\"check_proxy_users\","
50a54
> "\"default_password_lifetime\",\"0\""
75c79,81
< "\"gtid-mode\",\"OFF\""
---
> "\"gtid_executed_compression_period\","
> "\"gtid-mode\",\"OFF_PERMISSIVE\""
> "\"gtid_purged\","
79a86
> "\"innodb_adaptive_hash_index_parts\","
83c90
< "\"innodb_buffer_pool_dump_at_shutdown\","
---
> "\"innodb_buffer_pool_dump_at_shutdown\",\"0\""
87c94
< "\"innodb_buffer_pool_load_at_startup\","
---
> "\"innodb_buffer_pool_load_at_startup\",\"0\""
99a107,108
> "\"innodb_deadlock_detect\",\"ON\""
> "\"innodb_default_row_format\","
102a112
> "\"innodb_fill_factor\","
135a146
> "\"innodb_page_cleaners\","
154a166,167
> "\"innodb_status_output\","
> "\"innodb_status_output_locks\","
167a181
> "\"internal_tmp_disk_storage_engine\","
179a194
> "\"log_builtin_as_identified_by_password\","
181c196,197
< "\"log_output\",\"TABLE\""
---
> "\"log_error_verbosity\","
> "\"log_output\",\"FILE\""
183a200,201
> "\"log_slow_admin_statements\","
> "\"log_slow_slave_statements\","
198a217
> "\"max_execution_time\","
202a222
> "\"max_points_in_geometry\","
217a238
> "\"mysql_native_password_proxy_users\","
221a243
> "\"ngram_token_size\","
250a273,274
> "\"performance_schema_events_transactions_history_long_size\","
> "\"performance_schema_events_transactions_history_size\","
260a285,287
> "\"performance_schema_max_index_stat\","
> "\"performance_schema_max_memory_classes\","
> "\"performance_schema_max_metadata_locks\","
262a290,291
> "\"performance_schema_max_prepared_statements_instances\","
> "\"performance_schema_max_program_instances\","
266a296
> "\"performance_schema_max_sql_text_length\","
268a299
> "\"performance_schema_max_statement_stack\","
270a302
> "\"performance_schema_max_table_lock_stat\","
289a322
> "\"range_optimizer_max_mem_size\","
295a329
> "\"require_secure_transport\","
297c331
< "\"secure_auth\","
---
> "\"secure_auth\",\"1\""
303a338
> "\"server_audit_query_log_limit\",\"65536\""
304a340
> "\"show_compatibility_56\","
311a348
> "\"slave_parallel_type\","
313a351,352
> "\"slave_rows_search_algorithms\","
> "\"slave-skip-errors\","
339d377
< "\"timed_mutexes\","
340a379
> "\"tls_version\","
SARAH Tech Blog

SARAHでは一皿に特化したごはん情報の投稿・配信・収集・解析するサービスをtoC,toBと多角的に展開しています。アプリ / Web / SaaS / データサイエンス を最新の環境と技術で広く運用します。 技術スタック詳細はこちら→ https://stackshare.io/companies/sarah-inc

Discussion

ログインするとコメントできます