For a better design for your solution when using active geo-replication, you have to consider the following key points:
- Replication between a primary database and a secondary database is asynchronous, which means that the data will be committed to the primary database before being replicated to the secondary database.
- Primary and secondary databases must have the same service tier (Basic, Standard, Premium, or Premium RS).
- Although it is technically valid to have lower Database Transaction Units (DTUs) in the secondary database than the primary, it is not recommended to do so, because that would increase the replication lag for apps with intensive write operations.
- When replicating databases from within ...