Scaling Livejournal using MySQL
brad (LiveJournal founder), seems to have made a kickass presentation about LJ at MySQL Users Conference. If your work involves databases and load-balancing , then you *must* check out his slides. Jeremy has a nice write-up on the talk as well.
I put up the ljimages thingy on my site. Its ADDICTIVE.
LJImages is khool! (Admire your ideas dude!)
Mindblowing talk by. Simply WOW.
yes, didn’t know u r with yahoo.
What is the algorithm behind ljimages? you grab recent pictures of your friends or a community?
It more like – there is a site http://rtns.org/ljimages/ – and happened to find it. It can be attributed to either the existense of very good search engines OR a good social network.
The above comment was posted by the dumbest idiot known to mankind. 🙂
*sorry*
then i must have misunderstood his post.
The site is mine and I write the script. But the Idea is not mine. Livejournal offers an API ( http://www.livejournal.com/stats/latest-img.bml ). I just pick the stuff and display the images on a single page.
Cool 🙂
I was browse the homepages, besides mine, and I found http://puggy.symonds.net/~kalyan/. Yours?
yep. its my old site before I got myself a domain name. I used to maintain it in my college days.
I see 🙂
Oh, I was just wodering, how the hell could you be using the latest posts RSS…:-)
Possible…
http://www.livejournal.com/stats/latest-rss.bml + reg-exps + Perl/PHP could do the trick as well I guess…
Re: Possible…
Of course it’s possible. But the latest-rss file would be huge to handle. At one time, it was around 400kB.
Re: Possible…
The rss file is just filled with links to the images. So the file itself is less then 10kb.
Re: Possible…
You mean the file generated using the script, right? But, processing the latest-rss file would take longer than the latest-img file…much longer.
thanks for the slides link – its rather interesting (not to mention useful – we use mysql rather extensively, and in fairly similar ways to what the slides describe)