はじめに
GUIのこの部分のパラメータ
RDSのパラメータグループをGUIで管理するのは何かとは大変。CLIで取得する
コマンド
1 |
aws rds --profile=stg describe-db-parameters --db-parameter-group-name default.aurora-mysql5.7 |
staging環境や、本番環境など複数の環境を管理している場合は、
credentialを登録すると、環境を簡単に切り替えられるので便利
1 2 3 4 5 6 7 8 9 10 11 |
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 |
結果
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
$ 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" }, |