Stack Overflow
Stack Overflow

Questions tagged [geo-replication]

44 questions
0
votes
0 answers

Azure Storage Account - Geo-Replication : what is the frequency of the Geo-Replication and what would be the data loss in case of failure?

I have an Azure Storage Account in WEST US and configured Geo-Replication to sync with EAST US. I want to know How often Geo-Replication sync gets executed? In case of WEST US regional failure and happen to failover to EAST US, what would be the…
One Developer
  • 99
  • 5
  • 43
  • 103
0
votes
1 answer

Enable multi region write Cosmos DB for subset of regions

Is it possible to enable multi-region write for Azure Cosmos DB only for a subset of regions? So have 5 read regions but only 3 of those as write regions for example? I'd assume this would save costs but can't find that this is possible. When I…
MJD
  • 11
  • 2
0
votes
1 answer

how to setup geo replication in event grid

In Event grid, how do we setup geo replication. as the per the documentation, it should the publisher responsibility to do the health…
Sandeepjn
  • 181
  • 1
  • 1
  • 7
0
votes
1 answer

Is it possible to add a user with login to readonly database?

I have a sql azure database which is geo-replicated. Now I want to create a user with login and grant him a permission to read data from some table in the readonly replica. But it seems like it's not possible. When I'm trying to create a user for…
Roman Koliada
  • 4,286
  • 2
  • 30
  • 59
0
votes
0 answers

Not able to login to azure webapp after for azure database failover

I have Configured Application Connection String. metadata=res://*/;provider=System.Data.SqlClient;provider connection string="data source=azuresqlfailover.database.windows.net;Initial Catalog=signagedb;User…
krishna bh
  • 81
  • 2
  • 9
0
votes
4 answers

Azure SQL Geo-Replication with .NET NHibernate sp_wait_for_database_copy_sync issue

During development of our application we have introduced Azure SQL Geo-replication to improve user experience and responsiveness in various geographical locations. Currently in testing we have two instances - a primary and secondary*, one of which…
Avgar
  • 21
  • 1
  • 1
  • 4
0
votes
1 answer

Handling external data source on Azure SQL and geo-replication

Below is my azure Set up Elastic Pool Primary (30 databases) - Active Elastic Pool Secondary (30 databases) - Read only geo-replicated. Primary pool is used by WebApp's for read and writes. All reports run on secondary. I recently had to add…
Vishal Patel
  • 130
  • 1
  • 2
  • 10
0
votes
1 answer

How does azure handles geo-replication under the hood

We have an azure web app & a db we want to replicate all over the world. So, we use Traffic manager to redirect the User to the closest hosted Web app , and with a location setting in the web app, It knows to which database it should go…
Alejandro R
  • 50
  • 1
0
votes
1 answer

Are read-only, active geo-replicated databases less performant?

We have a website hosted as an Azure App Service. It connects to a Sql Azure P1 database, which is a geo replicated secondary. We have this same website hosted on a virtual machine with Rackspace, which connects to a sql server database locally…
ShellyFM
  • 551
  • 3
  • 11
0
votes
1 answer

Azure geo-replication: Can't create a secondary server

I have an Azure SQL data base on a premium tier I try to activate Geo-replication on the preview portal. I clicked Server name on CREATE SECONDARY blade I then selected CREATE A NEW SERVER on SERVER blade I filled the form, but the OK button still…
Frédéric De Lène Mirouze
  • 545
  • 5
  • 25
0
votes
2 answers

glusterfs geo-replication - server with two interfaces - private IP advertised

I have been trying to setup a geo replication with glusterfs servers. Everything worked as expected in my test environment, on my staging environment, but then i tried the production and got stuck. Let say I have gluster fs server is on public ip…
mcblady
  • 33
  • 6
-1
votes
1 answer

Is it even possible to migrate huge SQL Server relational database to Azure replicating across multi-regions with master-master replication?

I have my DB users who frequently performs write operations from both China and US, Currently we have data on premise in the US region and are facing huge challenges as write and read operations are very slow for all users across the world having…
sai-sreenath
  • 1
  • 2
1 2
3