Jun 102016
 
 Posted on: June 10, 2016  Posted by  Add comments

In the last blog post we learned the basic concepts of Active Geo Replication, in this blog we’ll see how to configure Active Geo Replication using Azure portal. We’ll go step-by-step and see each and every step in detail. Let’s begin.

A few things to note:

  1. Please make a note, that you must be the subscription owner or a co-owner in order to create a secondary database & configure Geo replication.
  2. The secondary database will have the same name as primary database.
  3. Your secondary database will have the same service level as your primary database.
  4. You can choose the readability of your secondary database, it can be either readable or non-readable.
  5. You can also configure active Geo replication for your elastic databases.

 

Steps to configure Active Geo replication using Azure Portal

Select the appropriate database from SQL Databases blade & choose Geo-Replication option under the settings head.

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

Once you Select Geo-Replication option, this will open Geo-Replication blade which shows a graphical representation of world map showing Azure data center regions and also recommends based on the primary database region, like in my case the recommended region is East Asia.

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

Apart from recommended region it also lists down all other available regions where the SQL Database feature is available and can be selected as a secondary region.

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

It is always suggested to go-ahead with the recommendations but if you want you can also select any other available region as your secondary region. In my case I selected North Europe as secondary region.

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

Once a region has been selected you can configure the rest of the settings like secondary target server, service tier etc. I already have a SQL Server in North Europe region which can be selected for this purpose.

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

Once all the settings are done azure will start seeding the database between both the regions & the map will show dots travelling from primary to secondary region. The seeding time depends upon the size of the data.

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

 

 

Once the seeding completes the secondary database will be available for failover and readable workload (if it is configured to be readable) & the data replication will begin.

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

The secondary SQL Database blade will show the geo-replicated role as secondary, please refer the screenshot below.

How to configure Active Geo Replication using Azure portal

How to configure Active Geo Replication using Azure portal

With this you’ve learned how to configure active Geo replication using azure portal.

Hope you got answer to your questions! Happy Learning!

feel free to leave a comment. 🙂

Thanks,
Sarabpreet Singh Anand
Subscribe now to get latest Tips\blog posts in your Inbox

Motivate me by giving compliments\comments

error: Content is protected !!