ablog

不器用で落着きのない技術者のメモ

Aurora MySQL の DB パラメータグループと DB クラスターパラメータグループを比較してみた

Aurora MySQL の DB パラメータグループ(default.aurora-mysql5.7)と DB クラスターパラメータグループ(default.aurora-mysql5.7)を比較してみた。

$ aws rds describe-db-cluster-parameters --db-cluster-parameter-group-name default.aurora-mysql5.7|jq -r '.Parameters[]|@text "\(.ParameterName)"'|sort > default.aurora-mysql5.7_cluster.txt
$ aws rds describe-db-parameters --db-parameter-group-name default.aurora-mysql5.7|jq -r '.Parameters[]|@text "\(.ParameterName)"'|sort > default.aurora-mysql5.7.txt
$ wc -l default.aurora-mysql5.7.txt
293 default.aurora-mysql5.7.txt
$ wc -l default.aurora-mysql5.7_cluster.txt
389 default.aurora-mysql5.7_cluster.txt
$ sdiff -s default.aurora-mysql5.7.txt default.aurora-mysql5.7_cluster.txt
							      >	aurora_binlog_read_buffer_size
							      >	aurora_binlog_replication_max_yield_seconds
							      >	aurora_binlog_use_large_read_buffer
							      >	aurora_enable_repl_bin_log_filtering
							      >	aurora_enable_replica_log_compression
							      >	aurora_fwd_master_idle_timeout
							      >	aurora_fwd_master_max_connections_pct
							      >	aurora_load_from_s3_role
							      >	aurora_max_alter_table_log_entries
							      >	aurora_select_into_s3_role
							      >	auto_increment_increment
							      >	auto_increment_offset
							      >	aws_default_comprehend_role
							      >	aws_default_lambda_role
							      >	aws_default_logs_role
							      >	aws_default_s3_role
							      >	aws_default_sagemaker_role
							      >	binlog_checksum
							      >	binlog_error_action
							      >	binlog_format
							      >	binlog_gtid_simple_recovery
							      >	binlog_row_image
							      >	binlog_rows_query_log_events
							      >	character-set-client-handshake
							      >	character_set_client
							      >	character_set_connection
							      >	character_set_database
							      >	character_set_filesystem
							      >	character_set_results
							      >	character_set_server
							      >	check_proxy_users
							      >	collation_connection
							      >	collation_server
							      >	completion_type
							      >	default_password_lifetime
							      >	default_storage_engine
							      >	enforce_gtid_consistency
							      >	gtid-mode
							      >	gtid_executed_compression_period
							      >	gtid_purged
							      >	innodb_autoinc_lock_mode
							      >	innodb_checksum_algorithm
							      >	innodb_checksums
							      >	innodb_cmp_per_index_enabled
							      >	innodb_commit_concurrency
							      >	innodb_data_home_dir
							      >	innodb_default_row_format
							      >	innodb_doublewrite
							      >	innodb_file_per_table
							      >	innodb_fill_factor
							      >	innodb_flush_log_at_trx_commit
							      >	innodb_ft_max_token_size
							      >	innodb_ft_min_token_size
							      >	innodb_ft_num_word_optimize
							      >	innodb_ft_sort_pll_degree
							      >	innodb_online_alter_log_max_size
							      >	innodb_optimize_fulltext_only
							      >	innodb_page_cleaners
							      >	innodb_page_size
							      >	innodb_purge_batch_size
							      >	innodb_purge_threads
							      >	innodb_rollback_on_timeout
							      >	innodb_rollback_segments
							      >	innodb_spin_wait_delay
							      >	innodb_strict_mode
							      >	innodb_support_xa
							      >	innodb_sync_array_size
							      >	innodb_sync_spin_loops
							      >	innodb_table_locks
							      >	innodb_undo_directory
							      >	innodb_undo_logs
							      >	innodb_undo_tablespaces
							      >	lc_time_names
							      >	log_builtin_as_identified_by_password
							      >	lower_case_table_names
							      >	master-info-repository
							      >	master_verify_checksum
							      >	mysql_native_password_proxy_users
							      >	ngram_token_size
							      >	require_secure_transport
							      >	server_audit_events
							      >	server_audit_excl_users
							      >	server_audit_incl_users
							      >	server_audit_logging
							      >	server_audit_logs_upload
							      >	server_audit_query_log_limit
							      >	server_id
							      >	skip-character-set-client-handshake
							      >	skip_name_resolve
							      >	slave-skip-errors
							      >	slave_parallel_type
							      >	slave_rows_search_algorithms
							      >	slave_type_conversions
							      >	sync_frm
							      >	time_zone
							      >	tls_version