NOSQL Databases
- Almost all the nosql databases offer
- Horizontal scaling
- flexible schemas
- faster responses
- Types:
- Document Database: records will be stored in json formats (MongoDB)
- Key value stores: stores the data in the form of keys and values (etcd and Redis)
- Wide Column Database: Used majorly for analytics (Cassandra)
- Graph Databases: this is about data with relation between records (neo4j)
- AWS offers nosql databases as a service
-
What databases does AWS Offers
Database as a Service
- Pros:
- AWS offers Database as Service where as a user we do manage our database, permissions to database, backup schedules, replications
- most of the activities are simplified
- Cons:
- less control
- costs explode if we select wrong options.
- Generally database as service will not support all version, rather supports few stable and latest versions.
RDS
- this is relational database offering as a service
- To Create database in RDS we need to understand the following (refer to classroom video)
- RDS needs a vpc, subnet group and security group
- To connect to database we can use Azure Datastudio Refer Here
-
Create a mysql rds db instance
- Create one db subnet group
- Create a mysql security group to open 3306 port to anyone
- Now create rds instance (refer class room video for screenshots)
