Difference between revisions of "Aws rds describe-db-instances"

From wikieduonline
Jump to navigation Jump to search
 
(4 intermediate revisions by 2 users not shown)
Line 3: Line 3:
 
https://awscli.amazonaws.com/v2/documentation/api/latest/reference/rds/describe-db-instances.html
 
https://awscli.amazonaws.com/v2/documentation/api/latest/reference/rds/describe-db-instances.html
  
* <code>aws rds describe-db-instances | egrep -w "DBInstanceIdentifier|[[Address]]"</code>
+
* <code>aws rds describe-db-instances | egrep -w "DBInstanceIdentifier|[[Address]]|[[PubliclyAccessible]]|[[DBInstanceStatus]]"</code>
 
* <code>aws rds describe-db-instances | egrep "DBInstanceIdentifier|[[AllocatedStorage]]"</code>
 
* <code>aws rds describe-db-instances | egrep "DBInstanceIdentifier|[[AllocatedStorage]]"</code>
 
* <code>aws rds describe-db-instances | [[grep -w]] [[DBInstanceIdentifier]]</code>
 
* <code>aws rds describe-db-instances | [[grep -w]] [[DBInstanceIdentifier]]</code>
Line 9: Line 9:
 
* <code>aws rds describe-db-instances | egrep -iw "[[Address]]|[[SubnetIdentifier]]"</code>  
 
* <code>aws rds describe-db-instances | egrep -iw "[[Address]]|[[SubnetIdentifier]]"</code>  
 
* <code>aws rds describe-db-instances | grep [[MultiAZ]]</code>
 
* <code>aws rds describe-db-instances | grep [[MultiAZ]]</code>
 +
* <code>aws rds describe-db-instances | grep [[MasterUsername]]</code>
 
* <code>[[aws rds describe-db-instances --db-instance-identifier MY_DB_NAME]]</code>
 
* <code>[[aws rds describe-db-instances --db-instance-identifier MY_DB_NAME]]</code>
 
* <code>[[aws rds describe-db-instances --output table]]</code>
 
* <code>[[aws rds describe-db-instances --output table]]</code>
Line 15: Line 16:
  
 
* <code>aws rds describe-db-instances | [[jq -r]] '.DBInstances[0].Endpoint.Address'</code>
 
* <code>aws rds describe-db-instances | [[jq -r]] '.DBInstances[0].Endpoint.Address'</code>
 
+
* <code>aws rds describe-db-instances | grep -i [[PreferredMaintenanceWindow]]</code>
 
+
* <code>aws rds describe-db-instances | grep -i [[PerformanceInsightsEnabled]]</code>
aws rds describe-db-instances | grep -i [[PreferredMaintenanceWindow]]
+
* <code>aws rds describe-db-instances | grep -i [[StorageEncrypted]]</code>
aws rds describe-db-instances | grep -i [[PerformanceInsightsEnabled]]
+
* <code>aws rds describe-db-instances | grep -i [[AutoMinorVersionUpgrade]]</code>
aws rds describe-db-instances | grep -i [[StorageEncrypted]]
+
* <code>aws rds describe-db-instances | grep -i [[PubliclyAccessible]]</code>
aws rds describe-db-instances | grep -i [[AutoMinorVersionUpgrade]]
+
* <code>aws rds describe-db-instances | egrep -i "Address|[[VpcId]]"</code>
aws rds describe-db-instances | grep -i [[PubliclyAccessible]]
 
aws rds describe-db-instances | egrep -i "Address|[[VpcId]]"
 
  
  
Line 80: Line 79:
 
* <code>[[aws rds describe-db-engine-versions]]</code>
 
* <code>[[aws rds describe-db-engine-versions]]</code>
 
* <code>[[aws rds describe-db-security-groups]]</code>
 
* <code>[[aws rds describe-db-security-groups]]</code>
 +
* <code>[[gcloud sql instances describe]]</code>
  
 
== See also ==
 
== See also ==

Latest revision as of 11:29, 28 December 2022

https://awscli.amazonaws.com/v2/documentation/api/latest/reference/rds/describe-db-instances.html


Replication[edit]

Storage data[edit]

arn:aws:rds:eu-central-1:4523523466:db:my_branches_name	postgres  my_branches_name	available

Version:

  • aws rds describe-db-instances | egrep -w "EngineVersion|DBInstanceIdentifier"

Example Output[edit]

{
    "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[edit]

See also[edit]

Advertising: