我为 nopCommerce 做出贡献，并且希望为 sql azure 提供支持。
我理解，如果您决定使用 sql azure，它一定是出于正确的原因，主要是分片、可扩展性和高可用性。我想避免为 nopCommerce 启用 sql azure，如果它只是要做 sql server 可以做的事情。
因此，下一步是定义分片如何发生。 nopCommerce 有一个典型的数据库，其中包含客户、产品、类别、订单等。您将如何设计分片以允许良好/自动扩展（更多数据库）。
我似乎找不到一种逻辑方法来跨 n 个数据库分发数据。
我是 sql azure 的初学者，所以如果我找错了树，请告诉我。任何帮助将不胜感激。
I contribute to nopCommerce and I am looking to provide support for sql azure.
I understand that if you decide to use sql azure, it must be for the right reasons, mainly sharding, scalability, and high availability. I want to avoid enabled sql azure for nopCommerce if it is just going to do exactly what sql server can do.
So the next step would be to define how the sharding would happen. nopCommerce has a typical database with customers, products, categories, orders, etc. How would you design the sharding to allow for great/automatic scaling out (more dbs).
I can't seem to find a logical way to distribute the data across n-databases.
I am a beginner when it comes to sql azure, so let me know if I am barking up the wrong tree. Any help would be greatly appreciated.
发布评论
评论（2）
SQL Azure 不仅仅用于分片；它还用于分片。许多客户使用没有分片的 SQL Azure。仅当您的应用程序可扩展性目标需要时，才应考虑分片。分片实际上很复杂，并且无论您采取什么方式都会施加一定的限制。换句话说，仅在需要时才将分片技术与 SQL Azure 结合使用。
如果您正在考虑数据联合，请查看 我的博客文章提供了一些关于如何准备的见解。
SQL Azure is not just for sharding; many customers use SQL Azure without sharding. You should consider sharding only if your application scalability objectives require it. Sharding is actually complex and imposes certain limitations, regardless of the path you take. In other words, use sharding techniques with SQL Azure only if you need it.
If you are considering data federation, take a look at my blog post which provides some insights into how to prepare for it.
你需要看看联邦。我很快在 Google 上搜索了几个链接
http://blogs.msdn.com/b/cbiyikoglu/archive/2011/01/18/sql-azure-federations-robust-connectivity-model-for-federated-data.aspx
<一href="http://vincentlauzon.wordpress.com/2011/02/05/sql-azure-federation-automating-your-database-partitioning-sharding/" rel="nofollow">http://vincentlauzon.wordpress。 com/2011/02/05/sql-azure-federation-automating-your-database-partitioning-sharding/
http://blogs.msdn.com/b/cbiyikoglu/archive/2010/10/30/building-scalable-database-solution-in-sql-azure-introducing-federation-in-sql-天蓝色.aspx
You need to look at Federations. A couple of links I quickly Googled
http://blogs.msdn.com/b/cbiyikoglu/archive/2011/01/18/sql-azure-federations-robust-connectivity-model-for-federated-data.aspx
http://vincentlauzon.wordpress.com/2011/02/05/sql-azure-federation-automating-your-database-partitioning-sharding/
http://blogs.msdn.com/b/cbiyikoglu/archive/2010/10/30/building-scalable-database-solution-in-sql-azure-introducing-federation-in-sql-azure.aspx