Wikiversity

Amazon Web Services/Relational Database Service (RDS)

< Amazon Web Services

Amazon Relational Database Service (or Amazon RDS) is a distributed relational database service by Amazon Web Services (AWS), also included in the AWS Free Tier option.

You can create different types of DBs using AWS web page or AWS CLI.

Regarding possible cost while learning AWS RDS, just be aware that you will be able to stop AWS RDS instances from AWS Management Console or AWS CLI for 7 days period at a time, but after those 7 days, it will be automatically started by AWS.[1] [2]

Basic AWS Cli Commands

edit

Describe some basic parameters of RDS instances: 

aws rds describe-db-instances --output text --query 'DBInstances[*].[DBInstanceArn,Engine,DBInstanceIdentifier,DBInstanceStatus]'
arn:aws:rds:eu-central-1:4523523466:db:my_branches_name	postgres  my_branches_name	available

Describe additional parameters of RDS instances: 

/usr/bin/aws rds describe-db-instances --output text --query 'DBInstances[*].[DBInstanceArn,Engine,EngineVersion,AvailabilityZone,MultiAZ,DBInstanceIdentifier,DBInstanceClass,AllocatedStorage,DBInstanceStatus,PubliclyAccessible,MasterUsername]'
arn:aws:rds:eu-central-1:4523523466:db:my_branches_name1	postgres	9.6.6	eu-central-1b	True	my_branches_name1	db.t2.micro	50	available	False	root
arn:aws:rds:eu-central-1:4523523466:db:my_branches_name1	postgres	9.6.6	eu-central-1a	False	my_branches_name2	db.t2.medium	20	available	False	root

Readings

edit

FAQs

edit
  • What is the maximum Database storage size?
Since 08/2017 maximum Database storage size is 16TB[3], up to June 2015 max size was 6 TB[4]. Check official homepage for the latest information[5].
  • Can i limit the size of my Database under maximum AWS size?
No.
  • Do i have to stop my database to increase storage?
In most cases, No.[6], your database will be in storage-optimization status for some time but will be fully operational.[7]

See Also

edit

References

edit
  1. ↑ https://aws.amazon.com/about-aws/whats-new/2017/06/amazon-rds-supports-stopping-and-starting-of-database-instances/
  2. ↑ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html
  3. ↑ https://aws.amazon.com/about-aws/whats-new/2017/08/amazon-rds-for-sql-server-increases-maxiumum-database-storage-size-to-16-tb/
  4. ↑ https://aws.amazon.com/about-aws/whats-new/2015/06/amazon-rds-increases-storage-limits-to-6TB-for-piops-and-gp2/
  5. ↑ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html#Concepts.Storage.GeneralSSD
  6. ↑ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html
  7. ↑ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Status.html
Retrieved from "https://en.wikiversity.org/w/index.php?title=Amazon_Web_Services/Relational_Database_Service_(RDS)&oldid=2580426"