Amazon Computer Services
AWS Relation Database Services
AWS Relation Database Services (RDS) is a fully managed relational database service from Amazon. RDS makes it easier for enterprises and developers who want to use a relational database in the cloud without investing much time and resources in managing the environment.
AWS RDS supports six database engines: Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server.
Advantages of Amazon RDS
The advantages of Amazon RDS as follows:
- It’s a fully managed service, which automatically manages backups, software and OS patching, automatic failover, and recovery.
- It also allows taking a manual backup of the database as a snapshot. Snapshots of a database can be used to restore a database as and when required.
- RDS provides fine-grained access control with the help of AWS IAM.
Components of Amazon RDS
Amazon RDS components are as follows:
Each Amazon RDS engine can generate an instance with at least one database in it. Each instance can have multiple user-created databases. Databases names must be specific to an AWS account and are known as DB instance identifier.
Each DB instance is a constructing structure and a separated environment in the cloud. These databases can be accessed using the same tools that are used to access standalone databases hosted in a data centre.
Each DB engine has its version. With the help of a DB parameter group, DB engine parameters can be configured. These parameters help to set DB instance performance.
One DB parameter group can be shared among the same instances types of the same DB engine and version. These sets of allowed parameters vary according to the DB engine and its version. It is recommended to create individual DB parameter groups for each database to have a legacy to fine-tune as per business need each of them individually.
When you choose an RDS instance type, it determines how many CPUs and memory is allocated to it. The most suitable instance type can be selected based on the performance need. Each DB instance can store a minimum of 5 GB and a maximum of 6 TB.
Region and AZs
AWS hosts its computing resources in data centres, spread across the Globe. Each geographical location where the data centres are located is called a region. Each region comprises multiple distinct locations that are called AZs. Amazon creates AZs in isolated locations such that a failure in one AZ does not impact other AZs in the region.
AZs are interconnected with low-latency network connectivity within a region. When we launch an application in multiple AZs, it provides us with high availability and protects us from the failure of an AZ.
Security groups act as a firewall. They control access to an RDS DB instance, by determining the enabled source port, protocol and IPs. Three types of the security group can be connected with Amazon RDS DB instances: DB security groups, VPC security groups, and EC2 security groups.
DB option groups
DB options groups are utilized to configure RDS DB engines. With the help of the DB option groups, some of the DB engines can provide additional features for data management, database management, and can also offer other security features.
RDS supports DB options group for MariaDB, Microsoft SQL Server, MySQL, and Oracle. Before creating an RDS instance, it is recommended to develop DB option groups.