Azure SQL Failover Groups

• Failover is making the secondary database primary in the cases of failure.
• Refer Here for failover steps.

Azure SQL Pricing Model

• DTU:

  • Database Tranasaction Unit:
    • Each DTU reprsents cpu,ram and storage
    • To estimate number of DTUs required for your on-premise Database, use Calculator from here

• vCore:

  • Measured in vCores

• Refer Here for resource limits and also use Azure Pricing Calculator.

Azure SQL for mySQL and Postgres

• Create AZure SQL for mySQL and Postgres
• For Replication, Refer Here
• Refer Here

Exercise

• Create Azure SQL Single Database.
• Create a Read Replication of this Database
• Create a failover group.