Difference between revisions of "Aws rds describe-db-instances"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
aws rds describe-db-instances | grep -i [[AutoMinorVersionUpgrade]] | aws rds describe-db-instances | grep -i [[AutoMinorVersionUpgrade]] | ||
aws rds describe-db-instances | grep -i [[PubliclyAccessible]] | aws rds describe-db-instances | grep -i [[PubliclyAccessible]] | ||
| + | aws rds describe-db-instances | egrep -i "Address|[[vpcid]]" | ||
| Line 62: | Line 63: | ||
* <code>[[DBINSTANCES]]</code>, <code>[[DBInstanceStatus]]</code>, <code>[[DBInstanceIdentifier]]</code>, <code>[[MasterUsername]]</code> | * <code>[[DBINSTANCES]]</code>, <code>[[DBInstanceStatus]]</code>, <code>[[DBInstanceIdentifier]]</code>, <code>[[MasterUsername]]</code> | ||
* <code>[[aws cloudformation list-stacks --stack-status-filter]] CREATE_COMPLETE</code> | * <code>[[aws cloudformation list-stacks --stack-status-filter]] CREATE_COMPLETE</code> | ||
| − | |||
* [[Connect to database]]: <code>[[psql]], [[mysql]]</code> | * [[Connect to database]]: <code>[[psql]], [[mysql]]</code> | ||
* <code>[[aws rds describe-db-proxies]]</code> | * <code>[[aws rds describe-db-proxies]]</code> | ||
Revision as of 18:04, 5 June 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 DBInstanceIdentifieraws rds describe-db-instances | grep Addressaws rds describe-db-instances | grep MultiAZaws rds describe-db-instances --db-instance-identifier MY_DB_NAMEaws rds describe-db-instances --output tableaws 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 aws rds describe-db-instances | grep -i PubliclyAccessible aws rds describe-db-instances | egrep -i "Address|vpcid"
Replication
aws rds describe-db-instances | grep ReadReplicaSourceDBInstanceIdentifieraws rds describe-db-instances | grep -w Statusaws 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,MasterUsernameaws cloudformation list-stacks --stack-status-filter CREATE_COMPLETE- Connect to database:
psql, mysql aws rds describe-db-proxiesaws rds describe-db-log-filesaws list allaws cloudwatch get-metric-statisticsaws redshift describe-clusters
See also
Advertising:
