MultiCloud Classroom notes 16/Sep/2025

Database

• Databases help to store and retrieve data.
• Any data that is queryable is considered structured data.
• Transactional Data generally use Relational Databases
• A Relational Database will have tables and data is stored in tabular form with rows and columns. A Row represents a record and there can be relationships between tables
• Popular Relational Databases
  • Microsoft SQL Server
  • Oracle
  • PostgreSQL
  • mySQL
  • IBM DB2
• Onpremise database setup:
  • Select a physical or vm. Install database software (optional licensing)
  • For high availability implement replication
  • Configure periodic backups
  • Implementing Failover
  • Patching
  • Tuning
  • Storage Managment
• Cloud offers Database as a service
  • no need to install database software just select
  • HA, Read Replicas etc with one click
  • Automated Backups and gives Point in Time Recovery.
  • Failover automation is possible with HA configuration
  • Patching we need to provide schedule or preffered time cloud witll handle
  • Cloud offer necesary tools/analytics for tuning
  • Storage autoscaling.
  • We need to focus on network aspects to make the db private and accessible to specific ips or other networks.
• AWS Relational Database Offerings
  • AWS offers a Serivce called as Relational Database Service (RDS) in which you can provision, we pay for compute + licensing (only for commercial dbs)
    • mysql
    • postgres
    • oracle (licensing)
    • Microsoft sql server (licensing)
    • IBM DB2 (licensing)
    • Aurora:
      • mysql
      • Postgres
• Azure Relational Database Offerings
  • Azure offers Relational database as a service using Azure SQL, we can provision
    • Microsoft SQL Server
    • mysql
    • postgres
  • Azure offers Microsoft SQL Server in
    • Azure SQL
    • Azure SQL VMs
    • Azure SQL Managed instances
  • Azure offers other databases as vm images.