AWS Database Services
- Data Services of AWS
Service Models
- Physical:
- Completely owned by Amazon
- users have no control
- Infrastructure
- Create ec2 machines and install databases
- Require DBA
- OS patching, DB patching, networking is users responsibility
- This is often referred as unmanaged
- Pros:
- Full control of DB
- Any version can be installed
- Cons:
- Administrative Efforts are huge
- Platform
- Create database platform (mysql/maria/Aurora, postgres/Aurora, SQL server, Oracle)
- Minimal DBA activities
- NO need of any patching. Users need to maintain only data
- This is often referred as Managed Database Services
- Pros:
- Administrative Efforts are minimal
- Cons:
- Specific list of databases/versions are supported.
RDS (Relational Database Services)
- This is managed Service for Relational Databases
- RDS supports
- mysql
- mariadb
- SQL Server
- Oracle
- Postgres
- RDS introduces
- Aurora for mysql
- Aurora for Postgres
- RDS automates
- Backup/Restore
- Failover
- Replications
- DBAs are required for Query Performance Tuning. Amazon gives necessary tooling support.
AWS Marketplace Images
- These are AMIs (Amazon Machine Images) with Preinstalled Databases.
- But rest of the activites as shown below are user responsibilities.
- License Mangement
- Backup/Restore
- Failover
- Replications
- It is not recommended to use Marketplace for supported Databases.
- It is used to create only unsupported Databases.
- In the below image, IBM DB2 is shown as the marketplace iamge
Create a free tier mysql rds instance
- Database => mysql
- Database instance type => db.t2.micro
- Select template => Free Tier
