Introduction to Amazon RDS
Amazon RDS is fully managed , scale-able, easy to setup and operate relational database service in the cloud. You can focus more on your application rather than taking care of hardware provisioning, database setup, patching and backups. Amazon RDS support six database engines.
RDS Benefits & Features
- Manage backups, software patching, automatic failure detection and recovery.
- CPU, memory, storage, and IOPS can be scaled independently
- Support automated and manual backup. Backups can used to restore a database.
- There are primary instance and synchronous secondary instance that can be failovered to seamlessly when a problem occurs.
- Its can protected by IAM Role, VPC.
- using SSL for data in transit and encryption for data in rest
- Shell access to DB instance are not provided.
- Can be interact from AWS RDS Management console, CLI, Programmatic interfaces which includes SDKs, Libraries in different languages and RDS API.
- DB Instance
- Basic building block of RDS.
- DB instance runs a db engine. There are 6 db engine as mentioned above.
- Three types storage Magnetic, General Purpose SSD, Provisioned IOPS
- each DB instance has a DB instance identifier, It uniquely identifies the DB instance when interacting with the Amazon RDS API and AWS CLI command.
- Each db instance can host multiple database or single oracle database with multiple schemes.
- Regions and Availability zone
- DB instances can be hosted in several AZs, an option called a Multi-AZ deployment.
- Primary DB instance is synchronously replicated across AZs to the standby replica
- Security Groups
- It is the way to controls access to the db instance , can specify ip address, ec2 or range of ip
- DB Parameter Groups
- DB parameter group contains engine configuration values that can be applied to one or more DB instances of the same instance type
- DB Option Groups
- Some DB engines offer tools that simplify managing the databases and making the best use of data.
- Amazon RDS makes such tools available through option groups for e.g. Oracle Application Express (APEX), SQL Server Transparent Data Encryption, and MySQL memcached support.
- Pricing are based on instance class ( Micro, large, xtralarge etc.)
- Billed by instance running time
- Storage capacity provisioned for the DB instance is billed per GB per month.
- If the provisioned storage capacity is scaled within the month, the bill will be pro-rated.
- I/O request per month
- Depends on Backup Storage
- Depends on Data Transfer
- Reserved db instance can purchased
You may calculate RDS COST HERE