Relational Database Service – RDS
Relational Database Service (RDS), a web service, makes it easier to create, manage, and scale a relational data base in the cloud.
RDS offers a cost-effective, resizable capacity to an industry-standard relational data base and handles common database administration tasks like hardware provisioning, patching, patching, and backing up.
RDS features and benefitsCPU, memory storage, and IOPs are all scaleable independently.
Manages backups, software patches, automatic failure detection, recovery, and other tasks.
Automated backups can also be made as needed. Manual backups can also be made as required. Backups can be used for restoring a database. The RDS restore process works reliably, efficiently, and is highly reliable.
High availability, with a primary instance as well as a synchronous secondary instance that can be failover seamlessly in the event of a problem.
Provides elasticity and scalability through the ability to use Read Replicas to increase scaleability.
Supports MySQL, MariaDB and PostgreSQL.
Supports IAM users and permissions to restrict who has access the RDS database service
You can further protect your databases by putting them into a VPC and using SSL for data transit and encryption for data at rest.
It is a managed service so shell (root ssh), access to DB instances is not available. This restricts access to system procedures and tables that have advanced privileges.
DB Instanceis a fundamental building block of RDS
It is a cloud-based database environment that is isolated
Each DB instance runs a DB Engine. AWS currently supports MySQL and MariaDB, PostgreSQL as well as Oracle and Microsoft SQL Server & Aurora DB engine.
Accessible via AWS command-line tools or RDS APIs.
The DB instance class determines the computation and memory capacities of a DB instances. This can be chosen according to the needs
Three storage types are supported: Provisioned IOPS and General Purpose (SSD), which have different performance and prices.
Each DB instance is assigned a unique DB instance identifier. This is a customer-supplied number that must be unique for each customer in an AWS region. It uniquely identifies the DB instances when interacting with AWS CLI commands and the RDS API.
Each DB instance can house multiple user-created databases, or an Oracle database with multiple schemas.
For better control, can be hosted in an AWS VPC environment
These highly available data centers are known as regions. They house Availability ZonesAWS resources in different parts of the world.
Each AZ is designed to isolate other AZs from failures and provide low-latency, inexpensive network connectivity to other Arizonas in the same area.
DB instances can be hosted in multiple AZs. This is called a MultiAZ deployment.
Primary DB instance is synchronized across AZs to the standby replicate
Data redundancy, failover support, elimination of I/O freezes, minimization of latency spikes during system back-ups.
Security Groupssecurity group controls access to a DB instance by allowing access only to the specified IP addresses ranges or EC2 instances
DB Parameter GroupsA DB Parameter Group contains engine configuration values that can apply to one or more DB instances with the same type of instance type
Help define configuration values specific for the selected DB Engine, such as: max_connections, force_ssl , autocommit
Supports default parameter group, which can’t be edited.
Supports custom parameter groups, to override values
Supports dynamic and static parameter groupschanges to dynamic parameter groups are applied immediately (regardless of whether apply immediately is set).
Relational Database Service – RDS