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]] | ||
| − | [[Replication]] | + | == [[Replication]] == |
* <code>[[aws rds describe-db-instances]] | grep [[ReadReplicaSourceDBInstanceIdentifier]]</code> | * <code>[[aws rds describe-db-instances]] | grep [[ReadReplicaSourceDBInstanceIdentifier]]</code> | ||
* <code>[[aws rds describe-db-instances]] | grep -w Status</code> | * <code>[[aws rds describe-db-instances]] | grep -w Status</code> | ||
* <code>[[aws rds describe-db-instances]] | grep -w StatusType</code> | * <code>[[aws rds describe-db-instances]] | grep -w StatusType</code> | ||
| + | |||
| + | == [[Storage]] data == | ||
| + | * <code>[[AllocatedStorage]]</code> | ||
| + | |||
| + | * <code>[[StorageType]]</code>: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html | ||
| + | ** Standard: magnetic (also known as standard) | ||
| + | ** [[io1]]: provisioned IOPS [[SSD]] (also known as io1) | ||
| + | ** [[gp2]]: General Purpose SSD (also known as gp2) | ||
| + | * <code>[[StorageEncrypted]], [[MaxAllocatedStorage]]</code> | ||
[[arn]]:aws:rds:eu-central-1:4523523466:db:my_branches_name postgres my_branches_name available | [[arn]]:aws:rds:eu-central-1:4523523466:db:my_branches_name postgres my_branches_name available | ||
| Line 53: | Line 62: | ||
* <code>Engine: mysql, postgres</code> | * <code>Engine: mysql, postgres</code> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Related terms == | == Related terms == | ||
Revision as of 13:19, 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 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
Replication
aws rds describe-db-instances | grep ReadReplicaSourceDBInstanceIdentifieraws rds describe-db-instances | grep -w Statusaws rds describe-db-instances | grep -w StatusType
Storage data
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"
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
DBINSTANCESDBInstanceStatusDBInstanceIdentifierMasterUsernameaws cloudformation list-stacks --stack-status-filter CREATE_COMPLETEaws list all- VpcId:
aws rds describe-db-instances | grep VcpId - Connect to database:
psql aws rds describe-db-proxiesaws rds describe-db-log-files
See also
Advertising:
