Relational Database Service - AWS RDS
AWS RDS (Relational Database Service)
In this article, we will see about AWS RDS (Relational Database Service).
What is AWS RDS?
Amazon Relational Database Service (Amazon RDS) is a managed SQL database service provided by Amazon Web Services (AWS). Amazon RDS supports an array of database engines to store and organize data and helps with database management tasks, such as migration, backup, recovery and patching.
A cloud administrator uses Amazon RDS to set up, manage and scale a relational database instance in the cloud. The service also automatically backs up RDS database instances, captures a daily snapshot of data and retains transaction logs to enable point-in-time recovery. RDS also automatically patches database engine software
To enhance availability and reliability for production workloads, Amazon RDS enables replication. An admin can also enable automatic failover across multiple availability zones with synchronous data replication.
An AWS user controls Amazon RDS via the AWS Management Console, Amazon RDS APIs or the AWS Command Line Interface.
Amazon RDS Database Instances
A database administrator can create, configure, manage and delete an Amazon RDS instance, which is a cloud database environment, along with the compute and storage resources it uses. Depending on which database engine an admin chooses, he or she can spin up multiple databases or schemas.
Amazon RDS limits each customer to a total of 40 database instances per account. AWS imposes further limitations for Oracle and SQL Server instances -- a user can only have up to 10 of each.
Amazon RDS Database Engines
There are six database engines which RDS provides, and they are:
RDS Database commercial, Open source, Cloud-native
RDS for MySQL -- compatible with the MySQL open source relational database management system
RDS for PostgreSQL -- compatible with the PostgreSQL open source object-relational database management system
RDS for MariaDB -- compatible with MariaDB, a community-developed offshoot of MySQL
RDS for SQL Server -- compatible with Microsoft SQL Server, a relational database management system
RDS for Oracle Database -- compatible with several editions of Oracle Database, including multiple bring-your-own-license and license-included versions
Amazon Aurora -- compatible with MySQL and PostgreSQL, a proprietary AWS relational database engine.
Benefit of RDS
Reduced Administration Burden:
Using RDS, you can easily deploy the database from project conception to production.
There is no need to install any database software and provide the infrastructure.
AWS automatically installs the latest software patches to the RDS instance which you have launched.
Cost-effective:
You just pay for what you use, and nothing more. No upfront payment is needed, just the monthly usage payment.
Security:
Using AWS Key Management Service (KMS), you can create encryption keys for maintaining security and authorized access for your database.
High Availability and Durability:
The automated recovery feature of RDS enables point-in-time recovery for your database instance.
Multi-AZs provides high availability and durability across the globe.
Scalability:
It just takes a few minutes to scale your infrastructure up or down, and you can scale up to a maximum of 32 vCPUs and 244 GiB.
Free Tier:
AWS gives you a free tier usage of Amazon RDS for 750 hours/month for 12 months.
How to configure RDS?
Open AWS management console and click on Services and click on RDS
Click on Create Database
Select Standard core or Easy Create and then Select Engine Options
Select version and then click on Production/Dev/Test/Free Tier
Put DB instance name and put credential of DB
Select DB instance size and then select storage type and allocated Storage and enable storage autoscaling and put storage threshold
Select database authentication and the click on Create database.
 In this article, we will see about AWS RDS (Relational Database Service). What is AWS RDS? Amazon R...){kind=link}
0 comments
Please leave your comments...... Thanks