MyBB Community Forums

I think he use a very expensive own server.

(2010-03-19, 01:57 AM)labrocca Wrote: [ -> ]My biggest forum is 2.1 GB in size with about 3 million posts.

Holy crap. Seriously?

HF is on 3 servers with one dedicated strictly for the database.

But that's not because of the database size, that's because of the massive concurrent connections right? I don't want the OP to get confused and think that big DBs require their own server unless they are getting a lot of active connections.

You can't get a massive database without massive traffic. They are not mutually exclusive.

Not really my point, but ok.

Wow, thanks you guys!

Well technically I know of one site larger than HF that is running on one server.

http://forum.yugiohcardmaker.net/index.php

But he doesn't get attacked probably nearly as much as I do and I know HF is more active. I'll pass his post numbers in just 2-3 months.

My database is right now doing 360 queries per second on average. I'll probably need a slave MySQL server soon to seperate the reads and writes.

http://ncaabbs.com/ = 5.1 million posts
http://forum.yugiohcardmaker.net/index.php = 3.8 million posts
http://www.hackforums.net/ = 2.9 million posts
http://www.forumbebas.com/forum.php = 1.2 million posts

Hostgator is my suggestion.
Do NOT use anything like Sitefrost! Slicehost & Linode are quite good.