July 31st, 2001

laid back

LJ and multiple SQL back-end boxes

Can anyone point me to some documentation as to how LiveJournal scales out to multiple back-end SQL servers? Is there some kind of data partitioning (e.g. by user)? If so, how does a feature like 'Friends' that seemingly needs to query the entire back end get implemented? If not, is there some kind of replication scheme (e.g. master and slave database servers?) How is load balancing amongst the database servers achieved? In this world, is there any plan for the point when LiveJournal gets big enough that it is physically impossible for all the data to be stored on one SQL server, or for all the write load to go through one SQL server?
  • fut0n

SimpleLJ 0.1 - Released

Well here is yet another LJ client. Its written in C and is for the UNIX console.
It supports multiple journals, and a few prop_ options (mood and music heh).
I originally wrote it for my own personal use and to get some much needed coding
practice. Another friend pushed me to release it, I mean.. What the hell right?

Anyways, you can get it here.

I appreciate any and all comments, suggestions, etc..
Roland, The Gunslinger

WANTED: Programming Experience

Let's say we have a subject. This subject wants to help lj. Assume Subject has no programming knowledge, no cash, but an eagerness to learn and some spare hours a week. Where should our querent start his quest for knowledge that will eventually help the lj community? Should he start with a VBASIC or C compiler that someone will recommend (freeware, of course; reember, he's poor)? Or should he skip basic languages and just jump into web programming with the assistance of one of the finer webtutorials?

This is a chance for dev to take stock of who's working on what, to see what is needed. It's also a chance for people reading dev to see what they can do to help.

Please take this thread seriously, and refer to as many on-line references as you'd like/as you can. I already have three or so paid accounts, and I'm a bit tired of support, but I'd still like to help. I'd like to look at the source code and at least have an idea what the fsck is going on so I can make better suggestions and more articulate and accurate answers in support.

My thanls,
  • Current Music
    STP - Crackerman