Distribute Database in 5 Different Server

Nikunj Satasiya

8y1.2k

I Actually I want to distribute my database in 5 different servers and use it for signal web application. If i can explain in brief then at a time server getting large no of request from client side i.g server getting 100 request at time but i want to distribute this request in 5 different server 20 request to server1, 20 request to server 2 and so on. Anyone Can please help me ? how can i do this ? Any suggestion from your side ? currently i m using MSSQL server 2012.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Chand8y ago
You don't need 5 database servers. One DB server is more than enough and one Web Server. As a matter of fact, you can simply use separate VMs on a single server to manage the both. It is more than enough. You should have minimum 16GB of RAM on the DB server. If your traffic is too much, you can use a load balancer and have a same server configuratin. If you don't know how to configure servers and infra, you may want to look into cloud, such as Azure or AWS. They are much easier to setup without doing much work.
+3
Nitin Sontakke8y ago
I am not an expert on the subject, so you can safely ignore what I am saying.

Typically, under these circumstances, an extensive stress testing needs to be done to conclude without doubt that the database layer is the one which causing contention. Has this study already been done and have you identified that the SQL Server is the bottleneck beyond doubt? If not, I suggest you do that first.

More often than not, it is the web-server which is the problem and not the database server. On Windows server level you get configurable solutions from Microsoft itself about to how to configure the load balacing on Server Farm.

You will then need to take care of session state as well.

You might distribute the database on 5 servers, but is this the read only database. If not, how are going to manage the replication? Is some delay in data refresh acceptable? You will have to come to answer to these question before you take any further step in that direction.

Hope it helps!
0