I had heard 3.6 would have more support for the big boards but I'm not seeing much in the announcements, has anyone heard anything?
The new features do look fantastic!
if you read thru all the updates listed thus far, there appear to be a few that address server loading...some stuff in the signature area, and others...
however, per a thread on large forums, it's pretty much still a "toss hardware at it" solution...
I'm hoping eva2000 gets his computer/access back reliably so he can respond to my server tweak thread...
Remember that theres still things to come in 3.6 announcements - could be something major tomorrow to help :)
not a word about master/slave
not a word about master/slave
I know! I need some new hardware so I was hoping to have an answer on this to guide my purchase
not a word about master/slave
Master and slave can be done right now with 3.5.x.
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.
Remember that theres still things to come in 3.6 announcements - could be something major tomorrow to help :)
What a guess - server stuff in today's announcement :)
Better Web Server Logging for POST Requests
All vBulletin-submitted forms now include the most important data as GET data, so that web server logs are more readable. The data that is sent back via GET includes the action (“do” variable) and a unique identifier (for example, if you are adding a new thread, the forum ID where you are posting).
Improved Master / Slave Database Support
Larger boards will be able to take advantage of the improved master / slave features which identifies those queries which are safe for use on a slave server. This removes potential database errors and errors resulting from any reads that occur prior to propagation.
Link (http://www.vbulletin.com/forum/showthread.php?p=1140708#post1140708) :)
Master and slave can be done right now with 3.5.x.
No it can't. There is no current differentiation between functions that are read only, write only and read and write simultaneously. The last one screws up your board.
Yea we got master-slave!
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.
Erwin- would your opinion change now that VB says they have fixed master/slave?
I'm sure he'd actually need to see and try the code before giving an opinion on it.
well yea Zachery, if it didn't work that would probably change everyone's opinion :)