Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Does Microsoft support implementing Database Sharding using Sql Server 2008 R2 (any edition). From my limited understanding of it, I think, we could probably implement it using Sql Server Express. But I was not sure if Microsoft supports it or not.

Database Sharding Resource Link

Other than Distributed Partitioned Views, Data-Dependent Routing, what other options are available for Scale-out? (Peer-to-Peer Transactional Replication, Federated DB?)

Please share any URL that describe any implementation architectures in detail.

Thanks,
_UB

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

+1 to gbn. It's worth mentioning that SQL Azure does support sharding (federations) if you were considering other options.

http://social.technet.microsoft.com/wiki/contents/articles/1926.how-to-shard-with-sql-azure.aspx

share|improve this answer
    
Thank you, this is useful. –  UB01 May 15 '12 at 14:25
add comment

No, SQL Server doesn't support sharding. SQL Server scales up not out.

This applies to RDBMS in general:

  • CAP theorem says you can have at most 2 of C, A and P.
  • RDBMS are ACID compliant which is the point of using them

The "C" in both acronyms is "Consistency" and sharding sacrifices "Consistency"
So generally sharding and consistency are mutually exclusive

There are exceptions (more or less) of course. Some examples:

  • Oracle RAC which is expensive and tricky
  • MySQL cluster which is not Consistent
share|improve this answer
    
Thank you. From what I know, there are some options available to scale out with Sql Server. I can't recollect the details, but it is possible. In database Sharding, Consistency is not impossible. There is lot of architectural planning that is needed though. I have not heard of CAP theorem, but I will read the article. –  UB01 May 15 '12 at 14:18
    
I didn't say not impossible, but it isn't generally done. For scale out, see dba.stackexchange.com/a/7454/630 –  gbn May 15 '12 at 14:27
    
Thank you, it is useful. Though the answer is not what I would like to see, it is what it is. –  UB01 May 15 '12 at 15:18
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.