AWS RDS

Read – Replica

• Overview
  
• We will an RDS instance which is primary instance, we can add a read replica which helps in
  • distributing the load
  • Reducing downtime

Multi-AZ

• Overview
  
• We will have master and standby instance and failover is automatic
  

Multi-AZ Cluster

• Overview
  

Aurora

• Amazon offers aurora databases for mysql and postgres
• Amazon’s claim Aurora delivers up to 5x the performance of MySQL and 3x that of PostgreSQL without requiring changes to most applications

Azure Microsoft SQL Server

• Azure offers Microsoft Server in 3 services
  • Azure SQL
  • Azure SQL VM
  • Azure SQL Managed Instances

Create an azure sql database

• Refer Here
  
• Purchasing models
  • DTU:
    • Basic
    • Standard
    • Premium
  • vCore:
    • General purpose
    • Hyperscale
    • Business Critical