SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Single DB shared across multiple servers
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

A1Friend4u
Starting Member

1 Posts

Posted - 01/21/2013 :  08:05:56  Show Profile  Reply with Quote
This is completely new game application being developed and I want the design to be highly scalable. As each user's score changes (increases or decreases by certain number) it will be updated to the server. In turn Server will reply with "list of nearest 50 users" to that score. This is planned to happen in not less than 1 minute per user.

Thus if DB table is indexed on score, we can say single write and 50 reads will happen per minute by each user. Now lets assume I've 50 "connection servers" and around 20K users are connected to each "connection server". All those "connection servers" in turn querying single DB Server. So it is effectively queuing all the (50*20000) millions of requests to single DB Server. Which obviously cannot complete all those requests in a minute.

Hence, I am looking if is it possible to have *multiple* servers sharing *single* database? So that it will enable me to distribute my queries across multiple database servers. If this is not possible, how can this be achieved?

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 01/21/2013 :  11:08:17  Show Profile  Visit jackv's Homepage  Reply with Quote
It is technically possible to achieve this architecture via Linked servers or Open Query. But the target database is owned ultimately by one database server. Also the target db will still have to fulfill all the transactional rules such as locking , commit , rollback etc.
This is an archiectural design issue - so needs some planning from the outset
There are some large organisation who are using sql server - for example myspace.com has over 4 million concurrent users using vafrious techniques : such as data dependant routing , caching tier ,service broker


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000