My forums at http://forumserver.twoplustwo.com
upwards of 600 people (heading towards 700) during peak hours. I
find that if I don't prune inactive threads back beyond about
2.5 months that the database server moves as fast as molasses.
I'd like to be able to keep more threads active but I can't
under the current configuration.
At the moment I have a database server and a separate web server
(which also serves up advertisements). MySQL has been tuned for
the loads the forum puts on it.
I'm considering adding a second database server and slaving it
to the first server. The idea would be that all inserts and
updates would be done to the main server which would then mirror
them to the slave server. Selects would be done on either server
on a more or less random basis.'
This is a non-trivial change and I'm wondering if anyone here
has been down this (or an alternate viable path) already?