Robert Kaye on LiveJournal's backend.
Brad Fitzpatrick wrote an excellent explanation of LiveJournal's backend in the #124 issue of LinuxJournal.
Now Robert Kaye has an excellent article – on his impressions of that backend and where MusicBrainz fits into the cycle.
Highly recommended reading for geeks. Marketing guys and gals stay away.