Introduction
Geo-replication is one of the very useful features in the Azure databases. It can protect & backup our data from failures in the database. In a real-world scenario, companies store a large amount of user data in a cloud database and it runs in our nearest region. Unfortunately, some disaster caused in the data center at that time can cause our database to fail during business time. This problem can be solved by using the Geo-replication feature in the database.
Geo-replication is used to create a secondary database for the primary database in another region. If the primary database fails, Azure can automatically switch to a secondary database. Now our business runs without any interruptions.
By reading this article, you will learn about how to configure a Geo-replication in Azure SQL database.
Read my previous articles in Azure SQL,
Prerequisites
-
Azure cloud account
-
Edge (or) Other browsers
-
Stable Internet Connection
-
Minimum knowledge in Database
-
Azure SQL server & database
Step 1
Step 2
Go to your database Dashboard and then select the “Geo-Replication” option in the settings section from the left pane. In this page, the Primary database is displayed as a blue-colored mark on the map, and the green color marks an available zone for creating a secondary database for replication.
Step 3
Scroll down and select the nearest zone from the target list. My primary database runs in “South India”. Now I am selecting a replication region as “West India”.
Step 4
After selecting the target region, it automatically opens the “create secondary page”. On this page, click the “Target Server” option and then click “Create a new server”.
On the right side, the “Create new server” pane has opened. After filling all credentials to your target server, click the “Select” button.
Step 5
Your target server is selected. Afterward, click on the “Ok” button to deploy it to the target server.
Step 6
Now you can wait 2 minutes to deploy and seed our data from your primary database.
It displays an initializing status in the secondaries list from the bottom of the map.
Step 7
After initializing, it starts the seedling stage. In this stage, copy the data from the primary server to the target server.
Step 8
After Seeding, our target server is ready in “Readable” status. At the top of the map, the page displays that both database servers are connected.
Step 9
Go to the Azure Dashboard and select “All resources”.
Step 10
In the “All resource” page, our target server is listed on this page. Then, click the” Target server name”.
Summary
Finally, we have successfully created Geo-replication for Azure databases.