#Adventureworkslt database mysql how to

The Active Geo-Replication is now available on all the three tiers (Basic, Standard and Premium), but this wasn’t always the case. Usually, in a planned maintenance, great care is taken to synchronize the actions to avoid losing data, but in an unplanned failover, some data may inevitably be lost. If you have a failure on the primary location, your data will be safe on another location, and you can easily keep the service running with the newly promoted Primary replica. Active Geolocation also allows you to change roles to keep the database highly available: you can avoid planned downtime by promoting a secondary to primary when a planned maintenance is imminent. By taking advantage of it, users that are connecting to the database from another geographic location might have a readable replica in a location that is closer to them, which would give them the best possible performance from the application. The Active Geo-Replication can be used as a Disaster Recovery and High Availability solution, thanks to its capability to maintain four readable replicas. The primary database and its four replicas are kept in sync through an asynchronous mechanism that may lead to some data loss in certain circumstances. If you are familiar with the High Availability and Disaster Recovery options for an on-premises installation of SQL Server, the Active Geo-Replication is very similar to the AlwaysOn Availability Groups. What is Active Geo-Replication?Īs already mentioned, Active Geo-Replication is a Business Continuity feature for SQL Database that allows the addition of up to four secondary replicas of your database spread in regions of your choice.

#Adventureworkslt database mysql how to

This article is divided into different sections that show you everything from how to set up the Active-Geo Replication from zero to how to maintain it.

We will approach the configuration by using the Azure Portal, but there are other ways to do it. We will show how to select those option within the Active Geo-Replication that align closest to the requirements specified in your BC plan: On this article we will take a look on how to configure and deal with the BC options that are available on Azure SQL Database. The Business Continuity (BC) plan is one of the most important ways of tying down and agreeing the importance of a system to the business, and determining whether you are running a mission-critical database. Whatever the nature of your database server, your data has to be as readily available as the business expects it to be. SQL Database: How to Configure Active Geo-Replication - Simple Talk Skip to content