Database
- Database is used to store information/data generated or required by/for the application
Relational Databases
- Relational Databases store the data in the form of tables (rows and column).
- They SQL (Structured Query Language) to perform data operations
- Each table has strict structure called as schema
- Vertical Scaling is used to solve performance issues
- Horizontal Scaling requires replications
- Generally if your application has more read operations than write, create read replicas
- Structured data refers to data that can be queried
- Typical Activities in running databases on-premises
- Network setup
- Installing Operating Systems
- Installing Database Engine
- Configuring Databases
- Admin Activities
- User Management
- Backup
- Replications
- Updating OS/Databases (Patching)
NoSQL Database
- There was a need for a database to store semi-structured data, handles high volumes of data, horizontal scaling is inbuilt.
- NOSQL (Not Only SQL)
- NOSQL has 4 popular types
- NOSQL does not impose strict schema
- Generally NoSQL Databases have built in support for horizontal scaling.
- Typical Activities in running databases on-premises
- Network setup
- Installing Operating Systems
- Installing Database Engine
- Configuring Databases
- Admin Activities
- User Management
- Backup
- Replication configuration
- Updating OS/Databases (Patching)
