Difference between revisions of "Aws rds describe-db-instances"
Jump to navigation
Jump to search
Line 64: | Line 64: | ||
* <code>[[aws rds describe-db-log-files]]</code> | * <code>[[aws rds describe-db-log-files]]</code> | ||
* <code>[[aws list all]]</code> | * <code>[[aws list all]]</code> | ||
+ | * <code>[[aws cloudwatch get-metric-statistics]]</code> | ||
== See also == | == See also == |
Revision as of 13:48, 26 April 2022
aws rds describe-db-instances
https://awscli.amazonaws.com/v2/documentation/api/latest/reference/rds/describe-db-instances.html
aws rds describe-db-instances | egrep -w "DBInstanceIdentifier|Address"
aws rds describe-db-instances | grep -w DBInstanceIdentifier
aws rds describe-db-instances | grep Address
aws rds describe-db-instances | grep MultiAZ
aws rds describe-db-instances --db-instance-identifier MY_DB_NAME
aws rds describe-db-instances --output table
aws rds describe-db-instances --output text --query 'DBInstances[*].[DBInstanceArn,Engine,DBInstanceIdentifier,DBInstanceStatus]'
aws rds describe-db-instances | grep -i PreferredMaintenanceWindow aws rds describe-db-instances | grep -i PerformanceInsightsEnabled aws rds describe-db-instances | grep -i StorageEncrypted aws rds describe-db-instances | grep -i AutoMinorVersionUpgrade
Replication
aws rds describe-db-instances | grep ReadReplicaSourceDBInstanceIdentifier
aws rds describe-db-instances | grep -w Status
aws rds describe-db-instances | grep -w StatusType
Storage data
aws rds describe-db-instances | egrep "DBInstanceIdentifier|AllocatedStorage"
StorageType
: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.htmlStorageEncrypted, MaxAllocatedStorage
arn:aws:rds:eu-central-1:4523523466:db:my_branches_name postgres my_branches_name available
aws rds describe-db-instances | egrep -w "EngineVersion|DBInstanceIdentifier"
Example Output
{ "DBInstances": [ { "DBInstanceIdentifier": "mydbinstancecf", "DBInstanceClass": "db.t3.small", "Engine": "mysql", "DBInstanceStatus": "available", "MasterUsername": "masterawsuser", "Endpoint": { "Address": "mydbinstancecf.abcexample.us-east-1.rds.amazonaws.com", "Port": 3306, "HostedZoneId": "Z2R2ITUGPM61AM" }, ...some output truncated... } ] }
Engine: mysql, postgres
Related terms
DBINSTANCES
,DBInstanceStatus
,DBInstanceIdentifier
,MasterUsername
aws cloudformation list-stacks --stack-status-filter CREATE_COMPLETE
- VpcId:
aws rds describe-db-instances | grep VcpId
- Connect to database:
psql, mysql
aws rds describe-db-proxies
aws rds describe-db-log-files
aws list all
aws cloudwatch get-metric-statistics
See also
Advertising: