I'm developing a Real-Time game which should hold thousands of players in real-time. What would be the best server structure for this?
My idea was using 2 server clusters - one for the Server End (all the computing side) and one for the Database end, where a load balancer is "responsible" for each of the clusters. One main server will receive the requests from the users and send back the IP address of the relevant server that the user can work this.
The database cluster will use database replication for consistency between the databases.
I'm using .NET + MSSQL for the game.