Erwin |
06-07-2006 04:43 AM |
Quote:
Originally Posted by alexi
Erwin, just curious why did you decide to implement the one monster server database solution as opposed to the master slave concept?
I'm trying to figure out where I want to go right now, do I want a huge DB server like quad dual operon's or 2 dual opteron servers.
|
I don't like the idea of separating writes to the master and reads to a slave, so what I've done is run a master db server, and have a slave replicating only forum, post, thread, user and shoutbox, and running search and IP searches off this slave, as well as shoutbox reads - this offloads a LOT of the load off the master db server and prevents the master from being slowed down.
|