Posted by ullu on July 9, 2010 at 4:06pm
Hello Team,
I have heard about database latency, when we have a seperate DB server. But a lot of people are using them nevertheless.
We can also have a single server with 16 GB or More then that RAM.
Some says dedicated server are always good some says more RAM on same server, I am confused.
Which one would be better? Please suggest.
Thank You.
Comments
check the connection line it
check the connection line it must be 1gb/s
Edit: i mean 1gb/s the connection line between webserver and mysqlserver
and 1gb/s internet connection can't say no
It really depends on your
It really depends on your bottleneck and budget.
A database will generally run faster with more RAM and more dedicated processing, which will counteract some of the loss to network latency. As ddorian mentioned, using a 1gb/s network connection will have a significant impact over a 100mb/s link as well in reducing latency, and if you're saturating that much pipe you probably need more than a single server anyways.
Often RAM is the quickest and easiest thing to upgrade. With more RAM the database can cache more data, allowing it to potentially return results faster, or use less processing resources. If you're suffering high CPU load, it is more difficult to determine whether you should upgrade to a single larger system for all applications or purchase a second smaller system to divide the work.
You just need to be aware
You just need to be aware that simply sticking more RAM into the box probably won't do very much. You'll need to re-tune MySQL's settings to match your available resources.
--
Dave Hansen-Lange
Director of Technical Strategy, Advomatic.com
Pronouns: he/him/his