Skip to content

Commit 8a90ac8

Browse files
20230726 Update active-geo-replication-overview.md
1 parent 6fe2561 commit 8a90ac8

1 file changed

Lines changed: 3 additions & 3 deletions

File tree

azure-sql/database/active-geo-replication-overview.md

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,8 @@ title: Active geo-replication
33
description: Use active geo-replication to create readable secondary databases of individual databases in Azure SQL Database in the same or different regions.
44
author: rajeshsetlem
55
ms.author: rsetlem
6-
ms.reviewer: wiassaf, mathoma
7-
ms.date: 10/04/2022
6+
ms.reviewer: wiassaf, mathoma, arvindsh
7+
ms.date: 07/26/2023
88
ms.service: sql-database
99
ms.subservice: high-availability
1010
ms.topic: conceptual
@@ -111,7 +111,7 @@ To ensure that your application can immediately access the new primary after geo
111111
112112
## <a name="configuring-secondary-database"></a> Configure geo-secondary
113113

114-
Both primary and geo-secondary are required to have the same service tier. It's also strongly recommended that the geo-secondary is configured with the same backup storage redundancy, [compute tier](./service-tiers-sql-database-vcore.md#compute) (provisioned or serverless) and compute size (DTUs or vCores) as the primary. If the primary is experiencing a heavy write workload, a geo-secondary with a lower compute size may not be able to keep up. That causes replication lag on the geo-secondary, and may eventually cause unavailability of the geo-secondary. To mitigate these risks, active geo-replication reduces (throttle) the primary's transaction log rate if necessary to allow its secondaries to catch up.
114+
Both primary and geo-secondary are required to have the same service tier. It's also strongly recommended that the geo-secondary is configured with the same backup storage redundancy, [compute tier](./service-tiers-sql-database-vcore.md#compute) (provisioned or serverless) and compute size (DTUs or vCores) as the primary. If the primary is experiencing a heavy write workload, a geo-secondary with a lower compute size may not be able to keep up. That causes replication lag on the geo-secondary, and may eventually cause unavailability of the geo-secondary. To mitigate these risks, active geo-replication reduces (throttles) the primary's transaction log rate if necessary to allow its secondaries to catch up.
115115

116116
Another consequence of an imbalanced geo-secondary configuration is that after failover, application performance may suffer due to insufficient compute capacity of the new primary. In that case, it is necessary to scale up the database to have sufficient resources, which may take significant time, and requires a [high availability](high-availability-sla.md) failover at the end of the scale up process, which may interrupt application workloads.
117117

0 commit comments

Comments
 (0)