Configuring high availability to the Hyperscale tier of Azure SQL Database
Azure SQL Database in the Hyperscale tier supports databases with up to 100 TB of storage size, compared to the 4 TB offered in the General Purpose and Business Critical tiers. In addition to supporting large databases, the Hyperscale tier offers high-availability capabilities too, with the three following types of replica:
- Geo-replica: Allows the creation of asynchronous replicas in the same or a different region, allowing users to have a read-only copy of the database
- High-availability replica: Acts as a hot standby server, offering automatic failover
- Named replica: Allows the creation of replicas with a different database name from the primary database, mainly used for supporting read scale-out scenarios
Both high-availability and named replicas are configured on synchronous mode, and can be created in the same location as a primary database.
In this recipe, we will configure...
