Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is this possible either out of the box or using additional tools or frameworks?

I'm looking to set up at least two simultaneously active machines to better understand how high scalability for databases works. Sites like Facebook must use multiple nodes to service their massive volume of queries and updates, correct?

If I've missed any useful resources in my Googling, even links would be appreciated.

share|improve this question

migrated from stackoverflow.com Jun 20 '11 at 9:54

This question came from our site for professional and enthusiast programmers.

3 Answers 3

up vote 0 down vote accepted

SQL Server only supports active-passive clustering. It does not offer anything that is comparable to Oracle RAC or IBM PureScale. Therefore it is not possible to have several active database instances.

For query type applications it is possible to clone the same database several times. For update-type workloads it might be possible to partition the data set and allow only one active node to update the corresponding "partition" of data. Partition as described in the last sentence has nothing to do with the partitioning functionality it describes node-ownership of data.

But generally if such a requirement needs to be supported it is better to switch to a product that supports the functionality (like Oracle RAC). The above solutions simply do not scale well in terms of development time and manageability.

share|improve this answer

Check this post by MVP and Microsoft Certified Master Brent Ozar:
http://www.brentozar.com/archive/2011/06/scaling-sql-server-growing-out/

It boils down to replication, and it's not simple.

share|improve this answer

This will be possible with special design (distributed partitioned views) and a business layer which take care where to send the query. There is a reference design with bwin.com With distributed partitioned views it is possible to make the update on any node but (without modifications on upper layers) but I recommend doing this modification to get optimal performance.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.
{"cc_re__cc_re__cc_by_sa_3_0": ["sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com?utm_source=stackoverflow.com&amp;utm_medium=site-ui&amp;utm_campaign=footerlink\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2014 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a>                   with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2014.11.22.2040\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Server Fault works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </nosc"], "copyright__copyright__copyright": ["This will be possible with special design (distributed partitioned views) and a business layer which take care where to send the query. There is a reference design with bwin.com With distributed partitioned views it is possible to make the update on any node but (without modifications on upper layers) but I recommend doing this modification to get optimal performance.\n\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service."]}