All geek questions in one place

SQL Azure - synchronous replication to a second database?

I consider the Azure SQL database as a potential solution for the project. One of the requirements is HA between data centers (i.e., the database must have a backup system running on a separate site that is ready to accept the load if the master fails and is immediately compatible with the master). It appears that SQL Azure can replicate data between sites asynchronously using either synchronization groups or a periodic export / import process.

My question is, is there a way to do this, am I missing? Is it possible, for example, to set up a regular instance of SQL Server (running on IAAS) in standby mode and somehow introduce a synchronously replicated master-slave relationship to the Azure SQL database operating in the main data center?

thanks,

Scott.

+4
source share
2 answers

The SQL database (called Azure SQL) has three replicas in the data center. As far as I know, it is not replicated between data centers.

Can I use SQL Server (in an IaaS virtual machine) with database mirroring? See http://msdn.microsoft.com/en-us/library/jj870960.aspx .

+2
source

The recent development - Support for Microsoft Active-Geo Replication for SQL data base allows users to create up to four readable secondary databases in any Azure region. If active geo-replication is enabled, all transactions are transferred to a database in your main region, where they are constantly replicated to databases in other regions.

This feature is currently only supported for Premium Tier databases .

+3
source

Source: https://habr.com/ru/post/1497176/

More articles:


All Articles