RDS = Relational Database Service
What is a database?
![](http://shuaib.ca/wp-content/uploads/2020/05/image-38-1024x367.png)
![](http://shuaib.ca/wp-content/uploads/2020/05/image-39-1024x303.png)
Non Relational Database
- DynamoDB (No SQL DB)
![](http://shuaib.ca/wp-content/uploads/2020/05/image-40-1024x409.png)
![](http://shuaib.ca/wp-content/uploads/2020/05/image-41-1024x777.png)
Data Warehousing
OLTP vs OLAP
- RedShift (Amazon’s OLAP)
![](http://shuaib.ca/wp-content/uploads/2020/05/image-42-1024x439.png)
Elasticache
- Webservice that makes it easy to deploy, operate and scale an in-memory cache in the cloud.
- improves the performance of web-applications by retrieving data from cache.
Elasticache supports two in-memory caching ingines
Memcached
sss
Redis
sss
Hands-On RDS
- login into AWS Console and from Services menu under Databases select RDS
- Click on Create Database
- Select Easy Create or Standard Create
![](http://shuaib.ca/wp-content/uploads/2020/05/image-43-1024x802.png)
- Select MySQL
- Select Version
- Select Templates
![](http://shuaib.ca/wp-content/uploads/2020/05/image-44-1024x291.png)
- Note: Aurora is not available in Free tier
- Fill the Settings
![](http://shuaib.ca/wp-content/uploads/2020/05/image-45-1024x803.png)
- Select Instance Type
![](http://shuaib.ca/wp-content/uploads/2020/05/image-46-1024x391.png)
- Select DB Size
![](http://shuaib.ca/wp-content/uploads/2020/05/image-47-1024x637.png)
- Select Availability and Durability
![](http://shuaib.ca/wp-content/uploads/2020/05/image-48-1024x284.png)
- Select Connectivity options
![](http://shuaib.ca/wp-content/uploads/2020/05/image-49-1024x938.png)
- Select database authentication
![](http://shuaib.ca/wp-content/uploads/2020/05/image-50-1024x382.png)
- See the Estimated Monthly Cost
![](http://shuaib.ca/wp-content/uploads/2020/05/image-51-1024x380.png)
- Click on Create Database
Creating EC2 Instance
- Create a new EC2 instance, with Bootstrap script. (Script runs at boot strap. in a sequence).
![](http://shuaib.ca/wp-content/uploads/2020/05/image-52-1024x360.png)
- Following is the bootstrap script:
![](http://shuaib.ca/wp-content/uploads/2020/05/image-53-1024x173.png)
- Connect.php :
![](http://shuaib.ca/wp-content/uploads/2020/05/image-54-1024x175.png)
- Hit Add Storage . Keep it as is
![](http://shuaib.ca/wp-content/uploads/2020/05/image-55-1024x167.png)
- Select Security Group
![](http://shuaib.ca/wp-content/uploads/2020/05/image-56-1024x185.png)
- From RDS, go to instance. If its available, get its End Point. (Endpoints are URLs not IP addresses anymore).
- When the EC2 instance becomes available, paste its URL in browser.
![](http://shuaib.ca/wp-content/uploads/2020/05/image-57.png)