hi, I am looking for a horizontal DB scale out solution so that we don't need to use SQL server replication anymore as it is slow. how can Azure DB service help us ?
While the target is everyone only update their information on the SQL server in their own zone, e.g. in europe, asia and united state, later on near real time, all record merge back to ALL SQL server in our cloud.
we want to see if this solution can help us to get ride of SQL server replication problem across a long long distinance.
Sth like Amazon RDS is offering/
any possible way using Azure for that?
I don't think that elastic pools or scaling up/out answer OP's question.
OP seems to want a replication scheme with complex topology, and that has never (AFAIK) been easily supported on Microsoft platforms. What Microsoft has ever encouraged is everyone updating a central database *first*, which might then do selective replication (or log shipping, etc) down to regional servers.
I am not aware of just what features Azure may currently offer in that direction.
Josh is obviously correct. I didn't mean to imply that elastic jobs provide the equivalent capabilities to the one you are describing - but that they provide an alternative approach to scaling out
- Edited by Marcin PolichtMVP Tuesday, March 21, 2017 11:35 AM
Could you please share more details about why replication is too slow in this scenario? Azure SQL Data Sync is another option here to replace replication when you are hosting databases in Azure SQL Database (PaaS). But it won't be faster then replication. You can find more information about Data Sync here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-sql-data-sync
I'm also wondering what is the Amazon RDS offering you mentioned. As I know, RDS only offer adding read-only replicas to scale out horizontally. If that's what you are looking for, you can also add active geo-replication in Azure SQL Database. See the following document for more details:
" I'm also wondering what is the Amazon RDS offering you mentioned."
RDS is horizontal scale out, once you made a change it replicate across the world for you.
"As I know, RDS only offer adding read-only replicas to scale out horizontally."
no. mulit master.