Editing Amazon Relational Database Services (RDS)

[[wikipedia: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.<ref>https://aws.amazon.com/about-aws/whats-new/2017/06/amazon-rds-supports-stopping-and-starting-of-database-instances/</ref> <ref>https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html</ref>

==Timeline==
Amazon RDS was first released on 22 October [[2009]], supporting [[MySQL]] databases.<ref name="auto"/><ref>[http://developer.amazonwebservices.com/connect/entry.jspa?externalID=2942&categoryID=291 Release: Amazon Relational Database Service : Release Notes : Amazon Web Services]{{Dead link|date=October 2018 |bot=InternetArchiveBot |fix-attempted=yes }}. Developer.amazonwebservices.com. Retrieved on 2013-08-09.</ref><ref>Vogels, Werner. (2009-10-26) [http://www.allthingsdistributed.com/2009/10/amazon_relational_database_service.html Expanding the Cloud: The Amazon Relational Database Service (RDS)]. All Things Distributed. Retrieved on 2013-08-09.</ref> This was followed by support for [[Oracle Database]] in June 2011,<ref>{{cite web|title=Oracle database available as a service on Amazon AWS (RDS)|url=http://www.beyondoracle.com/2011/05/24/oracle-database-service-amazon-aws-rds/|date=2011-05-24|accessdate=2014-04-13|website=beyondoracle.com}}</ref><ref>{{cite web|title=AWS Announces Relational Database Service For Oracle|url=http://www.firstbiz.com/biztech/aws-announces-relational-database-service-for-oracle-12330.html|access-date=2014-04-13|website=firstbiz.com|archive-url=https://web.archive.org/web/20140413234027/http://www.firstbiz.com/biztech/aws-announces-relational-database-service-for-oracle-12330.html|archive-date=2014-04-13|url-status=dead|df=}}</ref> [[Microsoft SQL Server]] in May 2012,<ref>[http://aws.typepad.com/aws/2012/05/net-support-for-aws-elastic-beanstalk-amazon-rds-for-sql-server-.html Amazon Web Services Blog: Amazon RDS for SQL Server and .NET support for AWS Elastic Beanstalk] {{Webarchive|url=https://web.archive.org/web/20130103035539/http://aws.typepad.com/aws/2012/05/net-support-for-aws-elastic-beanstalk-amazon-rds-for-sql-server-.html |date=2013-01-03 }}. Aws.typepad.com (2012-05-08). Retrieved on 2013-08-09.</ref> [[PostgreSQL]] in November 2013,<ref>{{cite news |date={{date|2013-11-14}} |author=Alex Williams |title=PostgreSQL Now Available On Amazon's Relational Database Service |publisher=TechCrunch |url=https://techcrunch.com/2013/11/14/postgressql-now-available-on-amazons-relational-database-service/ }}</ref> and [[MariaDB]] (a fork of MySQL) in October 2015,<ref>{{cite web|title=Amazon Web Services Announces Two New Database Services – AWS Database Migration Service and Amazon RDS for MariaDB |publisher=MarketWatch, Inc |url=http://www.marketwatch.com/story/amazon-web-services-announces-two-new-database-services-aws-database-migration-service-and-amazon-rds-for-mariadb-2015-10-07/|date=2015-10-07|accessdate=2015-10-23}}</ref> and an additional 80 features during 2017.<ref name="ama aws">{{Cite web|url=https://aws.amazon.com/blogs/aws/amazon-relational-database-service-looking-back-at-2017/|title=Amazon Relational Database Service – Looking Back at 2017|date=February 12, 2018|website=Amazon Web Services}}</ref>

In November 2014 AWS announced [[Aurora database analytics engine|Amazon Aurora]], a MySQL-compatible database offering enhanced [[high availability]] and performance,<ref>{{Cite web|url=https://aws.amazon.com/blogs/aws/highly-scalable-mysql-compat-rds-db-engine/|title=Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS|date=November 12, 2014|website=Amazon Web Services}}</ref> and in October 2017 a PostgreSQL-compatible database offering<ref>{{Cite web|url=https://aws.amazon.com/blogs/aws/now-available-amazon-aurora-with-postgresql-compatibility/|title=Now Available – Amazon Aurora with PostgreSQL Compatibility|date=October 24, 2017|website=Amazon Web Services}}</ref><ref name="ama aws"/> was launched.<ref>{{Cite web|url=https://aws.amazon.com/rds/aurora/|title=Amazon Aurora – Relational Database Built for the Cloud - AWS|website=Amazon Web Services, Inc.}}</ref>

In March 2019 AWS announced support of PostgreSQL 11 in RDS,<ref>{{Cite web|url=https://aws.amazon.com/about-aws/whats-new/2019/03/postgresql11-now-supported-in-amazon-rds/|title=PostgreSQL 11 now Supported in Amazon RDS|website=Amazon Web Services, Inc.}}</ref> five months after official release.

== Basic AWS Cli Commands ==
Describe some basic parameters of RDS instances:
<pre>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
</pre>

Describe additional parameters of RDS instances:
<pre>
/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
</pre>

== Readings ==
* [https://aws.amazon.com/blogs/aws/amazon-relational-database-service-looking-back-at-2017/ Amazon Relational Database Service – Looking Back at 2017]

== FAQs ==
* What is the maximum Database storage size? 
::Since 08/2017 maximum Database storage size is 16TB<ref>https://aws.amazon.com/about-aws/whats-new/2017/08/amazon-rds-for-sql-server-increases-maxiumum-database-storage-size-to-16-tb/</ref>, up to June 2015 max size was 6 TB<ref>https://aws.amazon.com/about-aws/whats-new/2015/06/amazon-rds-increases-storage-limits-to-6TB-for-piops-and-gp2/</ref>. Check official homepage for the latest information<ref>https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html#Concepts.Storage.GeneralSSD</ref>.
* 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.<ref>https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html</ref>, your database will be in <code>storage-optimization</code> status for some time but will be fully operational.<ref>https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Status.html</ref>

== See Also ==
* [[Wikipedia: Amazon Relational Database Service]]
* https://aws.amazon.com/rds/
* https://aws.amazon.com/rds/faqs/
* https://github.com/open-guides/og-aws#rds
* {{RDS}}
* {{DBs}}
* {{SQL}}
* [[Aurora]] MySQL and PostgreSQL compatible relational database
* {{AWS}}


[[Category:Computing]]
[[Category:Internet]]
[[Category:Databases]]

{{CC license}}
Source: wikiversity