[Kentaurus]

Originally Posted by psico

Hola Kentaurus!! La sigo en ingles para que nos entiendan todos

I'm the owner of www.psicofxp.com a spanish forum with 200.000 users, 2.4 MM posts, 2800 users online on peak hours and 100.000+ visits per day (unique ips).
I have 2 DB servers (1 Master and 1 Slave) and 4 Webservers in a load balance solution provided by the hosting, the load balance solution is caching the static content so I don?t need to implement an image server. The slave DB server had 2 more roles: memcached and nfs server (all the php files resides in this server).

I?m very interested in your custom solution to archive old posts, can you explain me how you did that? Or at least help me somehow?

Tnx in advance!

Ismael Briasco

It's was custom programmed, I run two separate forums with two separate licenses. Each week I archive all the posts that are older than 3 months to the "backup" or "archive" forum. That means copying data from the thread and post tables, and from the dependent tables as well (attachment, editpost, deletelog, etc). Sorry, it was a custom solution and I don't have it available for sharing since it was customized for my site (and making it generic for any forum is not really a possibility).

With this, I can run two different mysql servers, one for the archive and one for the main forum, in different servers. And I can load balance with a little more flexibility. I can implement rules for deactivating the archive without deactivating the main forums... I just can manage them separately.

Also, the mysql load went down by a lot, leaving 4M posts in a single mysql table makes joins a little painful. it was faster to just leave the 200-300,000 posts that people want to read and check everyday, and the rest is in an archive, still accesible, but you cannot longer reply, and if the archive loads 5 times slower... it doesn't matter to me because that's not the active users.