Difference between revisions of "Amazon Relational Database Services (RDS)"

From wikieduonline
Jump to navigation Jump to search
Line 34: Line 34:
 
* https://aws.amazon.com/rds/faqs/
 
* https://aws.amazon.com/rds/faqs/
 
* https://github.com/open-guides/og-aws#rds
 
* https://github.com/open-guides/og-aws#rds
−
* [[Databases]]: [[MariaDB]], [[PostgreSQL]]
+
* {{dbs}}
 
* [[SQL]]
 
* [[SQL]]
 
* [[Aurora]] MySQL and PostgreSQL compatible relational database
 
* [[Aurora]] MySQL and PostgreSQL compatible relational database

Revision as of 15:55, 12 January 2020

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

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

FAQs

  • 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

Text is available under the Creative Commons Attribution-ShareAlike License; additional terms may apply. By using this site, you agree to the Terms of Use and Privacy Policy.

Source: wikiversity

  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://www.wikieduonline.com/index.php?title=Amazon_Relational_Database_Services_(RDS)&oldid=7398"

Advertising: