Azure的联盟是德precated。我有哪些选择？ [英] Azure Federations are Deprecated. What are my options?

问题描述

背景：

我们有一个应用程序，其中的主要实体是一个客户。在这个应用中的所有信息，从客户开始。我们认为这将是非常好的，如果我们可以用这个某种分区。我们与Azure的SQL数据库作为后端的设计服务。

We have an application where the main entity is a customer. All information in this applications starts from the customer. We thought it would be really nice if we can use this for some kind of partitioning. We designed the service with Azure SQL Database as a backend.

我们的表看起来像这样（只相关的部分留给简洁）：

Our tables look like this (only the relevant part is left for brevity):

TABLE dbo.Orders
(
     CustomerId INT NOT NULL DEFAULT( FEDERATION_FILTERING_VALUE( 'FEDERATION_BY_CUSTOMER' ) ),
     OrderId INT NOT NULL,
     ....,
     CONSTRAINT PK_Orders PRIMARY KEY CLUSTERED ( CustomerId, OrderId )
) FEDERATED ON ( FEDERATION_BY_CUSTOMER = CustomerId );

现在这使我们能够做一些疯狂的事情。我们的切入点所有SQL相关的东西总是包含以下命令第一：

Now this allowed us to do some crazy things. Our entry points to all SQL related stuff always contains the following command first:

USE FEDERATION GroupFederation( FEDERATION_BY_CUSTOMER = 1 ) WITH RESET, FILTERING = ON

在此情况下，这个语句：

In this case this statement:

SELECT * FROM Orders

或

INSERT INTO Orders ( OrderId ) VALUES ( 10 );

将工作没有问题，仅在给定客户的数据的工作。 CustomerID列将始终从系统功能FEDERATION_FILTERING_VALUE推断;

will work without a problem, working only on the data of the given customer. The CustomerId COLUMN will always be inferred from the system function FEDERATION_FILTERING_VALUE;

现在，我们可以有我们在单个数据库中所有客户的没有问题，他们会从彼此分离。如果在未来某个时候，其中一人有太大了，我们可以在特定的客户ID分裂联邦和我们没有改变任何东西在我们的code来支持它。

Now we could have all our customer in a single database without a problem, and they would be isolated from each other. If sometime in the future, one of them got too big, we could SPLIT the federation at that particular customer ID and we don't have to change anything in our code to support it.

哎呀，我们可能在分离联合会数据库和服务每一位客户使用也不会知道它一个单一的东西。

Heck, we could have each customer in separated federation database and the service using it wouldn't know a single thing about it.

我们很高兴与我们的解决方案，我认为我很聪明想出它。直到最近，当微软宣布，他们正在去precating蔚蓝联合会与都上来了新的Azure数据库版本功能。了解更多关于它这里和<一个href=\"http://blogs.msdn.com/b/windowsazure/archive/2014/04/24/azure-sql-database-introduces-new-service-tiers.aspx?CommentPosted=true#commentmessage\">here.

We were very happy with our solution and I thought I was very clever coming up with it. Not until recently when Microsoft announced that they are deprecating the azure federations feature with the new azure database editions that are coming up. Read more about it here and here.

我希望你看我的问题。你觉得我的替代品？您是否使用天青联合会和你打算怎么转型？

I hope you see my problem. What do you think my alternatives are? Do you use Azure Federations and how are you going to transition?

感谢您。

推荐答案

我们已经看到，自拆分解决方案通常会导致对可扩展性，灵活性和性能，更好的结果相比，联合会。你可以找到这里联合会和自定义分片的更多信息： http://msdn.microsoft .COM / EN-US /库/ dn495641.aspx 。这是在宣布与Windows Azure中的SQL数据库的Web版和商业版一起退休联合会的部分原因。

We have seen that custom sharding solutions typically lead to better results regarding scalability, flexibility, and performance as compared to Federations. You can find more information about Federations and custom sharding here: http://msdn.microsoft.com/en-us/library/dn495641.aspx. This is part of the reason for the announcement to retire Federations together with the Web and Business Editions in Windows Azure SQL Database.

我建议你寻找到自我分片作为替代。有在<一个由CAT团队围绕自身拆分的模式在去年发表了很好的指导href=\"http://social.technet.microsoft.com/wiki/contents/articles/17987.cloud-service-fundamentals.aspx\" rel=\"nofollow\">http://social.technet.microsoft.com/wiki/contents/articles/17987.cloud-service-fundamentals.aspx ，而更像是这种材料将很快到来。

I would encourage you to look into self-sharding as an alternative. There was good guidance published last year by the CAT team around self-sharding patterns at http://social.technet.microsoft.com/wiki/contents/articles/17987.cloud-service-fundamentals.aspx , and more material like this will be coming shortly.

随时与我联系，以讨论您迁移现有的应用程序联合会替代品。我在Azure数据库产品团队的一部分，你可以在torsteng达到我（在）microsoft.com

Feel free to reach out to me to discuss your alternatives for migrating your existing Federations application. I am part of the Azure DB product team and you can reach me at torsteng(at)microsoft.com

谢谢，

托斯滕

这篇关于Azure的联盟是德precated。我有哪些选择？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！