Return to Answer

in the article from Percona there is no mention of mysql cluster: "**MySQL replication** has: Availability and Partitioning tolerance.", read more here : http://messagepassing.blogspot.ro/2012/03/cap-theorem-and-mysql-cluster.html

Source Link

edit approved Dec 23, 2014 at 13:47

Stefan Rogin

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 clusterreplication which is not Consistent

MySQL cluster sacrifices Availability in case of node failure, and can be set to prioritize either consistency or availability

Source Link

created May 15, 2012 at 7:08

gbn

70.1k
8
165
242

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