はじめに
GUIのこの部分のパラメータ
RDSのパラメータグループをGUIで管理するのは何かとは大変。CLIで取得する
コマンド
aws rds --profile=stg describe-db-parameters --db-parameter-group-name default.aurora-mysql5.7
staging環境や、本番環境など複数の環境を管理している場合は、
credentialを登録すると、環境を簡単に切り替えられるので便利
cat ~/.aws/credentials [stg] aws_access_key_id = xxxxxxx aws_secret_access_key = yyyyyyy region=ap-northeast-1 output=json [prd] aws_access_key_id = xxxxxxxx aws_secret_access_key = yyyyyyy region=ap-northeast-1 output=json
結果
$ aws rds --profile=stg describe-db-parameters --db-parameter-group-name default.aurora-mysql5.7
{
"Parameters": [
{
"ParameterName": "allow-suspicious-udfs",
"Description": "Controls whether user-defined functions that have only an xxx symbol for the main function can be loaded",
"Source": "engine-default",
"ApplyType": "static",
"DataType": "boolean",
"AllowedValues": "0,1",
"IsModifiable": false,
"ApplyMethod": "pending-reboot"
},
{
"ParameterName": "aurora_lab_mode",
"ParameterValue": "0",
"Description": "Enables new features in the Aurora engine.",
"Source": "engine-default",
"ApplyType": "static",
"DataType": "boolean",
"AllowedValues": "0,1",
"IsModifiable": true,
"ApplyMethod": "pending-reboot"
},