AWS DB 접속 명령어

aws secretsmanager get-secret-value --secret-id arn:aws:secretsmanager:us-west-2:642614214013:secret:mydbsecret-123-39JHNq --version-stage AWSCURRENT sh-4.2$ aws secretsmanager get-secret-value --secret-id arn:aws:secretsmanager:us-west-2:642614214013:secret:mydbsecret-123-39JHNq --version-stage AWSCURRENT {     "Name": "mydbsecret-123",     "VersionId": "ee1750fe-bc06-4b08-a507-429e370aba0b",     "SecretString": "{\"username\":\"admin\",\"password\":\"Pa33w0rd!\",\"engine\":\"mysql\",\"host\":\"rdslabdb.cin1rcsx20ld.us-west-2.rds.amazonaws.com\",\"port\":3306,\"dbname\":\"MyRDSLab\",\"dbInstanceIdentifier\":\"rdslabdb\"}",     "VersionStages": [         "AWSCURRENT"     ],     "CreatedDate": 1649816414.198,     "ARN": "arn:aws:secretsmanager:us-west-2:642614214013:secret:mydbsecret-123-39JHNq" } sh-4.2$ secret=$(aws secretsmanager get-secret-value --secret-id arn:aws:secretsmanager:us-west-2:642614214013:secret:mydbsecret-123-39JHNq | jq .SecretString | jq fromjson) user=$(echo $secret | jq -r .username) password=$(echo $secret | jq -r .password) endpoint=$(echo $secret | jq -r .host) port=$(echo $secret | jq -r .port) mysql -h $endpoint -u $user -P $port -p$password rdslabdb secret=$(aws secretsmanager get-secret-value --secret-id  aws secretsmanager get-secret-value --secret-id arn:aws:secretsmanager:us-west-2:642614214013:secret:mydbsecret-123-39JHNq | jq .SecretString | jq fromjson) user=$(echo $secret | jq -r .username) password=$(echo $secret | jq -r .password) endpoint=$(echo $secret | jq -r .host) port=$(echo $secret | jq -r .port) aws secretsmanager list-secret-version-ids --secret-id mydbsecret-456 {     "Name": "mydbsecret-456",     "ARN": "arn:aws:secretsmanager:us-west-2:642614214013:secret:mydbsecret-456-BXTNeQ",     "Versions": [         {             "VersionId": "bb8a8e83-e506-4123-8505-3172412da20c",             "VersionStages": [                 "AWSCURRENT"             ],             "LastAccessedDate": 1649808000.0,             "CreatedDate": 1649817582.691         }     ] } arn:aws:secretsmanager:us-west-2:642614214013:secret:mydbsecret-456-BXTNeQ secret=$(aws secretsmanager get-secret-value --secret-id arn:aws:secretsmanager:us-west-2:642614214013:secret:mydbsecret-456-BXTNeQ | jq .SecretString | jq fromjson) user=$(echo $secret | jq -r .username) password=$(echo $secret | jq -r .password) endpoint=$(echo $secret | jq -r .host) port=$(echo $secret | jq -r .port) mysql -h $endpoint --ssl-ca=rds-combined-ca-bundle.pem --ssl-verify-server-cert -u $user -P $port -p$password mydb ySQL [mydb]> STATUS -------------- mysql  Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1 Connection id:          35 Current database:       mydb Current user:           admin@10.0.1.218 SSL:                    Not in use Current pager:          stdout Using outfile:          '' Using delimiter:        ; Server:                 MySQL Server version:         5.7.22-log Source distribution Protocol version:       10 Connection:             mydb.cin1rcsx20ld.us-west-2.rds.amazonaws.com via TCP/IP Server characterset:    latin1 Db     characterset:    latin1 Client characterset:    utf8 Conn.  characterset:    utf8 TCP port:               3306 Uptime:                 2 hours 1 min 13 sec Threads: 2  Questions: 16909  Slow queries: 0  Opens: 371  Flush tables: 1  Open tables: 57  Queries per second avg: 2.324 mysql -u dbadmin -p -h qdd183c5b4qq1v.cyl8pclvpbyz.us-west-2.rds.amazonaws.com   nnodb_buffer_pool_read_requests      | 421321604   Innodb_buffer_pool_read_requests      | 452173597  |   nnodb_buffer_pool_read_requests      | 483025722   Innodb_buffer_pool_read_requests      | 483029657   ------------- mysql -u dbadmin -p -h qd11he8s6l6lx71.cyl8pclvpbyz.us-west-2.rds.amazonaws.com mongoimport --ssl --host mydocdb.cluster-cfsh5bndxhms.us-west-2.docdb.amazonaws.com:27017 \  --sslCAFile rds-combined-ca-bundle.pem \  --username docdbadmin \  --password Pa33w0rd! \  --collection cast_1990 --db cast \  --file /tmp/cast_1990.json --jsonArray mongo --ssl --host mydocdb.cluster-cfsh5bndxhms.us-west-2.docdb.amazonaws.com:27017 \ --sslCAFile rds-combined-ca-bundle.pem \ --username docdbadmin \ --password Pa33w0rd! mydocdb dbinstanceb-ozxtfkgbrskk : primary dbinstancea-ml2krds2zclb : replica aws docdb describe-db-clusters \     --db-cluster-identifier mydocdb  \     --query 'DBClusters[*].[DBClusterIdentifier,Status]' aws docdb describe-db-instances \ --db-instance-identifier dbinstanceb-ozxtfkgbrskk  \ --query 'DBInstances[*].[DBInstanceIdentifier,DBInstanceStatus]'

aws dynamodb scan --table-name Cast \   --filter-expression "genres = :a" \   --projection-expression "#YR, #TT" \   --expression-attribute-names file://expression-attribute-names.json \   --expression-attribute-values file://expression-attribute-values.json   aws dynamodb get-item --table-name Cast \     --key '{"year":{"N": "1999"},"title":{"S":"18 Shades of Dust"}}' \     --expression-attribute-name '{"#c": "cast"}' \     --projection-expression "titleId, title, runtimeMinutes, genres, #c"