Category Archives: Uncategorized

Webapp Scalability woes…getting your MYSQL database to run fast & clean

8 Replies

This post is for the techies & geeks.

Just sharing this wonderful resource, that’s currently one of the most popular slide decks on slideshare. This is a presentation on MySQL tuning, from somebody who works at MYSQL. Titled “15 Ways to Kill your MYSQL peformance“, it’s a straight-from-the-pits, hands on presentation on how to get the best from your MYSQL databse.

If you work at a web startup, there’s a 95% chances that you are using MYSQL as your database. Its also likely that you still haven’t got to the stage, where a database administrator has become a necessity; this job is being done by your coders. This presentation could come in handy. From my experience of running a large, fast growing consumer internet website, getting your database to run fast, clean & efficient is a serious bottleneck to scalability of your website and hence your business. The good news is that scalability problems afflict you only when you get to a threshold; the bad news is that scalability (unlike the act of building your webapp) is largely experiential in nature, and there is little substitute to having somebody on your team who has done this before. Or you might need to learn from scratch.

My tech team found this presentation very useful, so thought of sharing it here for the benefit of others. Do let me know what you thought of this…..

initRIA… first event for Rich Internet Application hackers in India

2 Replies

initRia_1198149680787.pnginitRIA is a tech event for Rich Internet Application hackers that took place last weekend in Bangalore. Surprisingly enough, this was the first time (in India) the RIA folks were getting together for a common event. On more ocassions than one, we’ve thought of putting together something like this in Delhi, but Bangalore beat us to it! Though the event wasn’t publicised much and I learnt of it through the blogosphere once it was over.

initRIA was organised by the Bangalore Flex usergroup and the venue was HoneyWell. Check out these blog posts for how the event fared and for the photos on flickr.

RIA technologies have played a huge role in web2.0. The engaging graphical interfaces and the intuitive user interactions that we take for granted in the web2.0 world are possible due to client side advances that happened as rich technologies came to the fore post 2002-03. One of the huge problems that I see in the RIA space (and I have a fair bit of experience) is the availability of talent. No, this goes beyond the generic manpower shortage that the IT industry faces. RIAs are completely an acquired skill; fresh Indian software graduates are unexposed to this during their engg courses, unless they learnt it themselves. Added to it is this insanely nonsensical belief that frontend engineering (using technologies like Flash, Flex, Javascript etc) is more of a designer’s job and may not be as “hardcore” an engg skill to acquire as server side technologies like Java, .net, C, C++ etc. What this finally means is that some of the smartest, brightest software brains that this country produces never thinks of front-end engineering as a chosen career alternative. And this factor feeds into the lacking design sensitivity that afflicts most Indian software development teams.

Hope initRIA will be a catalyst in greater experience sharing about rich client engineering and how they are built. Next time this happens (whenever, wherever) I’m attending.

Related: pipesCamp, an unconference for Yahoo Pipes developers is taking place in Chennai on 23rd Dec. This is the blogpost announcing the event and here’s the wiki where you can signup.