Stack Overflow
Stack Overflow

Questions tagged [azure-elastic-scale]

Azure SQL Database Elastic Scale enables the data-tier of an application to scale out and in via industry-standard sharding practices.

Azure SQL Database Elastic Scale enables the data-tier of an application to scale out and in via industry-standard sharding practices, while significantly streamlining the development and management of your sharded cloud applications. Elastic Scale delivers both developer and management functionality which are provided through a set of .Net libraries and through Azure service templates that you can host in your own Azure subscription to manage your highly scalable applications. Azure DB Elastic Scale implements the infrastructure aspects of sharding and thus allows you to focus on the business logic of your application instead.

Source: "Get Started with Azure SQL Database Elastic Scale Preview"

60 questions
2
votes
1 answer

Should ShardMapManager and ShardMap objects be cached globally as a singleton?

I have an application with multiple Azure SQL databases sharded by a key. Every time we open a shard database connection, we retrieve the ShardMapManager and the ListShardMap: public static ShardMapManager CreateOrGetShardMapManager(string…
Code Slinger
  • 1,100
  • 1
  • 11
  • 16
2
votes
1 answer

Azure shard map manager connection pooling for single DB per customer

Does shard map manager create a single connection pool to manage all the sql connections or does it spawn a new pool for every unique connection string / shard / database in case of one db per customer scenario? An app connecting to many databases…
Ozmen
  • 43
  • 3
2
votes
1 answer

Connection Pool Management with ElasticContext EF

After following a few examples from Microsoft I've implemented an Elastic version of the DbContext that gets its connection string from the Elastic ShardMapManager dependent on the current users Tenant (or Customer) Id. This technically works and…
connectedsoftware
  • 6,987
  • 3
  • 28
  • 43
2
votes
1 answer

Hash Shard Map with SQL Azure

I've been doing some reading about sharding SQL Azure databases with Azure Elastic Scale. The article discusses two types of shard maps: List and Range. What about Hash shard maps? My application requirements are to evenly distribute data across…
kspearrin
  • 10,238
  • 9
  • 53
  • 82
2
votes
2 answers

How can I use Dapper with Elastic Scale MultiShardConnection and MultiShardDataReader?

I'm trying to parse query results returned from an Azure Elastic Scale MultiShardConnection. It doesn't look like it inherits from SqlConnection or DbConnection so the Dapper methods are not available. This make sense when you consider that it's…
Vyrotek
  • 5,356
  • 5
  • 45
  • 70
2
votes
2 answers

How to keep Redis data accurate with what's in SQL Server

I don't have experience scaling-out SQL back-end, but from what I've read so far, sharding for writes and caching for reads seem to be two of the most common practices. I'm trying to learn how eventual consistency could be minimized with the right…
Mark13426
  • 2,569
  • 6
  • 41
  • 75
2
votes
1 answer

Azure Elastic Scale: Split-Merge Tutorial - Can't Split a Shard

I followed the tutorial here I created all the things mentioned and deployed the service. I can run it properly as well. My Elastic DB currently contains ONE range shard with MinValue set to 0, and MaxValue set to Infinity (NULL). Then to actually…
Aamir
  • 1,747
  • 5
  • 26
  • 50
2
votes
2 answers

EntityFramework, Azure ElasticScale, and Table Per Type (TPT) Inheritance

If given a table structure using TPH in Entity Framework. class ContactLink { Guid Contact_Link_ID { get; set;} //pk Guid Tenant_ID { get; set;} //fk Guid Contact_ID { get; set;} //fk } class ContactLinkCustomer : ContactLink { Guid…
dustinchilson
  • 136
  • 2
  • 9
2
votes
1 answer

ShardMapManager.TryGetRangeShardMap wont retrieve the RangeShardMap

I am trying to play around with the sample app provided by Microsoft here. This works fine for creating a new database and its shards etc. But it fails when i try to connect it to an existing DB with a single shard. It has a class named…
Aamir
  • 1,747
  • 5
  • 26
  • 50
2
votes
1 answer

Azure SQL Elastic Performance Scale

I have Standard S1 SQL database which is fine for most tasks. However I have an overnight task that needs much more computing power. I am wondering if anyone has experience of using scheduling to scale up the database in terms of Service Tier and…
Jezbers
  • 815
  • 10
  • 20
2
votes
1 answer

Moving shardlet with Elastic Scale and forcing order of Reference tables copied

I would like to move a shardlet from one shard to another. I'm using the Azure Elastic Scale libraries and the provided Split/Merge/Move example. When trying to move a shardlet I keep receiving an error because the tool is copying a (reference)…
Jan_V
  • 4,244
  • 1
  • 40
  • 64
2
votes
1 answer

Split/merge shardlets which have 'nested' foreign key references

At the moment I'm busy using the Azure Elastic Scale split/merge example for an existing database of my customer. I've defined a database schema, so it's possible to do the split/merge. However, there's 1 thing which gives me errors. This is having…
Jan_V
  • 4,244
  • 1
  • 40
  • 64
1
vote
0 answers

MultiShardConnection and Entity Framework

Introduction. I have found one question and one issue related to the problem : elastic-db-tools github issue. 2015 stackoverflow question. 2015 Actually I work with multi-tenant architecture. Using latest .net core, ef core and ElasticScale. Most of…
PeterLavreniuk
  • 101
  • 1
  • 1
  • 11
1
vote
2 answers

Azure Split/Merge Service, is it still relevant?

I have managed to get the C# and db setup using ListMappings. However, when I try to deploy the split/merge tool to Azure cloud classic the service it states 'The requested VM tier is currently not available in East US for this subscription. Please…
Jeremy
  • 41
  • 6
1
vote
0 answers

Elastic Search Azure Plugin Issue

The elastic search azure plugin troubleshooting issue: I am trying to snapshot the index data from on prem to azure and am getting the same exception: { "error": { "root_cause": [ { "type":…
geethu
  • 11
  • 1
1
2
3 4