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.

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.

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

• 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, up to June 2015 max size was 6 TB. Check official homepage for the latest information.

• 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., your database will be in storage-optimization status for some time but will be fully operational.

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
• Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid, RDMS
• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql
• Aurora MySQL and PostgreSQL compatible relational database
• AWS, Amazon Managed Services, AWS Management & Governance, computing, security, networking, AWS compliance, AWS Outposts AWS Free Tier, AWS certifications, AWS Trusted Advisor, AWS Systems Manager, AWS Config, IAM Access Analyzer, AWS Cost Explorer, AWS Cost Management, AWS Budgets, AWS Organizations, AWS dev: (CodeStar, Cloud9), AWS Partner Network (APN), AWS Resource Access Manager, AWS Quick Starts, AWS Global Accelerator, AWS Elemental MediaStore, AWS Enterprise support, AWS support, AWS Professional Services Consultants, AWS Cloud Map, AWS Marketplace, AWS CLI, AWS Management Console, AWS acceptable use policy, amazonaws.com, Quotas, AWS Support plans, AWS Resource Explorer, AWS Managed Services (AMS), AWS savings, AWS Nitro System, AWS Activate, Serverless, AWS timeline

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