Amazon Relational Database Services (RDS)

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

• Homepage: https://aws.amazon.com/rds/
• Pricing:
  • MariaDB: https://aws.amazon.com/rds/mariadb/pricing/
  • PostgreSQL: https://aws.amazon.com/rds/postgresql/pricing/
  • Aurora
    • Aurora PostgreSQL: price calculator: aprox 63 USD/month https://calculator.aws/#/createCalculator/AuroraPostgreSQL

You can create different types of DBs using:

1) AWS Management Console

2) AWS CLI: aws ec2 run-instances

3) AWS Cloudformation: AWS::RDS::DBInstance

4) Terraform: aws_db_instance

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.

Timeline

Amazon RDS was first released on 22 October 2009, supporting MySQL databases. This was followed by support for Oracle Database in June 2011, Microsoft SQL Server in May 2012, PostgreSQL in November 2013, and MariaDB (a fork of MySQL) in October 2015, and an additional 80 features during 2017.

In November 2014 AWS announced Amazon Aurora, a MySQL-compatible database offering enhanced high availability and performance, and in October 2017 a PostgreSQL-compatible database offering was launched.

In March 2019 AWS announced support of PostgreSQL 11 in RDS, five months after official release.

Nov 2021 https://aws.amazon.com/blogs/database/readable-standby-instances-in-amazon-rds-multi-az-deployments-a-new-high-availability-option

March 2022 Amazon RDS for SQL Server now supports M6i and R6i instances: https://aws.amazon.com/about-aws/whats-new/2022/03/amazon-rds-sql-server-supports-m6i-r6i-instances/

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:

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

Activities

• Read https://stackoverflow.com/questions/tagged/amazon-rds
• Read Amazon Relational Database Service – Looking Back at 2017
• Read: https://github.com/open-guides/og-aws#rds

News

• https://aws.amazon.com/blogs/aws/amazon-rds-multi-az-db-cluster/
• Mar 2021 Amazon RDS for PostgreSQL supports managed disaster recovery (DR) with Cross-Region Automated Backups
• RDS storage autoscaling (2019)
• Amazon RDS Proxy (Jun 2020)
• Amazon RDS Performance Insights (2018)
• Amazon RDS Read Replicas (2010)

Related terms

• DataFileRead
• Amazon RDS Backup and Restore: Retention period
• Amazon RDS IAM Authentication
• AWS CloudWatch: RDS
• CloudFormation: AWS::RDS::DBInstance
• AWS CloudFormation templates: https://s3.us-west-2.amazonaws.com/cloudformation-templates-us-west-2/RDS_Snapshot_On_Delete.template
• Terraform resource: aws_db_instance
• aws rds describe-db-engine-versions
• Multi-AZ and Multi-Region
• Average Active Sessions (AAS)
• Amazon RDS query editor for Aurora Serverless
• rds_superuser
• AWS RDS Snapshots

See Also

• AWS RDS: AWS::RDS, aws rds [ create-db-instance | create-db-instance-read-replica | describe-db-instances | modify-db-instance | modify-db-cluster | create-db-subnet-group | delete-db-instance | create-db-snapshot | aws rds create-db-parameter-group ], AllocatedStorage, FreeStorageSpace
• Amazon databases: AWS RDS, storage, aws rds, Amazon RDS Proxy, RDS FAQs, PostgreSQL, MySQL, SQL Server, AWS Outposts, Amazon Aurora, Amazon Aurora Serverless , Amazon DocumentDB, Amazon DynamoDB, Amazon Redshift, Amazon QLDB, Amazon RDS Performance Insights, DataFileRead, DMS, Amazon Neptune, Amazon MemoryDB for Redis, Amazon RDS query editor for Aurora Serverless, Amazon Redshift query editor, AWS RDS Snapshots, AWS RDS Instance Types, rds_superuser, Authentication, autoscaling

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