> vBulletin is MySQL and tries to reduce database load through denormalisation of the data. The posts table has the username repeated every time a post was made

Just in case an unexperienced developer reads that. Don't do it. If you expect high read loads, better invest your time in learning/thinking about caching, fragment caching, russian doll caching and invalidating these caches. Memcached or Redis come to my mind.