Menu
I have read that SQL Server cannot scale horizontally. is this true?
I am planning a high traffic website and looking a for a database that can scale out easily across multiple servers.
780
Horizontal scaling refers to adding or removing databases in order to adjust capacity or overall performance, also called "scaling out". Sharding, in which data is partitioned across a collection of identically structured databases, is a common way to implement horizontal scaling.
Horizontal Scaling is DifficultSharding data across nodes is difficult. Achieving high availability is difficult. Handling distributed transactions is difficult. And synchronizing time across nodes is difficult.
In horizontal scaling (“scaling out”), you get the additional capacity in a system by adding more instances to your environment, sharing the processing and memory workload across multiple devices. A useful analogy for understanding this distinction is to think about scaling as if it were upgrading your car.
Scaling horizontally is the same as scaling by adding more machines to a pool or resources — but instead of adding more power, CPUs, or RAM, you scale back to existing infrastructure. Horizontal scaling allows you to scale your data with more resources than you can add resources using vertical scaling.
No, it's not true.
SQL server can scale horizontally, using partitioning
127
More recently, SQL 2012 has more options for horizontal scaling.
http://robtiffany.com/building-microsoft-meap-scaling-out-sql-server/
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
