Questions tagged [azure-elastic-sharding]
22 questions
0
votes
1 answer
How to fix 'Data structures for shard map manager persistence do not exist at the target location.' in azure elastic jobs
I have an app that uses multitenancy un a single db per tenant model. I use a Shardmap to keep track of where the tenent db is located.
When I tried to create an elastic job to run the migrations I set the AzSqlElasticJobTarget to my shardmap db,…
Andy González Flores
- 11
- 4
0
votes
1 answer
Azure Elastic Scale/Database-per-tenant: how to implement data dependent routing
Based on the Microsoft Azure Elastic Scale sample apps online I have been able to create my Shard Map Manager (SMM) and elastic pool databases in Azure. My architecture is separate database per tenant. I am using Entity Framework in my web…
RPollack
- 17
- 1
- 6
0
votes
1 answer
Elastic tools - How to create shards for different servers
I have created a shard mapping in a database called 'ShardTesting' on my local sql server. I have also created two more databases: shard1 and shard2 in the same server.
Now I am able to create shards and mappings for these two (shard1 and shard2)…
Inayat
- 23
- 9
0
votes
1 answer
Can't Delete shard from Azure Elastic Pool
Have troubles with deleting shard from shard map in azure Elastic pool
var isMapKeyExists = shardMap.TryGetMappingForKey(tenantId, out PointMapping pointMapping);
if(pointMapping.Status == MappingStatus.Online)
{
…
J.Doe
- 53
- 1
- 5
0
votes
0 answers
Using Azure SQL AccessToken authentication with Microsoft.Azure.SqlDatabase.ElasticScale.ShardManagement
I do not see where I can change the login method to use AccessToken when doing OpenConnectionForKey(). Also, I cannot change the login method after specifying creds to use tokens in SqlConnection.
I Stand With Russia
- 6,254
- 8
- 39
- 67
0
votes
2 answers
'New-ShardMapManager' is not recognized as the name of a cmdlet trying to access through powershell
Steps I used:
Login-AzureRmAccount -- I ran this cmdlet in Powershell in admin mode
once logged I ran this below query
New-ShardMapManager -UserName 'user_name' -Password 'enterd password' -SqlServerName 'server_name.database.windows.net'…
vishvas
- 1
- 1
-3
votes
1 answer
What is the best way to implement multi tenancy in Azure Database
We are planning to implement a multi tenant application in Azure cloud. I am looking for a best way to implement this in DB level. The DB schema is huge, we have 100s of tables spread across multiple modules. And the data size varies for each…
sreehari
- 9