My forum, TalkBass.com, has over 10 million posts and 175,000 members. I've hung on to vBulletin 3.6 for years now, and I've been delaying the VB 4 upgrade for obvious reasons. Anticipating the release of the big-board search product for XF, I wanted to start playing around with conversion.
TalkBass runs on a classic 3-server config (www, mysql, and mysql replication). I used the replication server as a sandbox for this conversion. Using a dumped copy of our DB, I started the VB 3.6 import process. I am extremely impressed by the import process. The ability to come back to resume the import in progress is superb. As is the ability to import selected assets (polls, reputation, etc).
Importing our private messages took several hours. It took 60 hours to import 700,000 threads (10 mil posts). Now, our replication server does not have the RAID 10 array or processors that our live DB server has, so I anticipate about 20 hours will be shaved off the thread import time when we do the real thing. This still leaves a 40-hour import though, so TalkBass will have to be offline for a whole weekend during the live convert.
After completing the import, XF proceeded to rebuild caches. When rebuilding thread cache, it quit with an error (out of memory). Guess I'll have to increase the PHP memory limit and try again.
More to come
See the converted test forum at http://www.talkbass.com/xen/index.php?categories/bass-guitar-forums.53/
44.9 KB Views: 31