Live data from Hacker News

Ask HN: I built a site that just went ridiculously viral. What do I do now?

news.ycombinator.com

51–60 of 195 posts

Re: Ask HN: I built a site that just went ridiculously viral. What do I do now?

#51
post #19

Earlier quoted context omitted.

It's a site where you can ask people to describe you, in three words.

I am not sure how long it is going to last. i mean you will run out of friends to write about, Isn't it?

then it starts suggesting people. apply it to more than people. then it starts suggesting more than people. you get the picture.

Re: Ask HN: I built a site that just went ridiculously viral. What do I do now?

#52
EDIT: HN doesn't render that code very nicely, here's a pastie: http://pastie.org/1416631

Hi there, your home page is very simple, render it in plain HTML and post the signup to queue.php.

In queue.php put:

The cache table should just be a PK cache_id and a text field (or perhaps mediumtext). I've suggested using a database instead of a filesystem based cache because, if you're doing this quickly, doing it using MySQL means you're less likely to run into file permissions or security problems.

Then you're at least capturing everyone's information whilst you figure out how to scale.

Re: Ask HN: I built a site that just went ridiculously viral. What do I do now?

#57
Where is your current bottleneck? mysql? check your slow query log, turn on the log-queries-not-using-indexes, do a quick analysis of those to see if you have queries that aren't using an index or queries that can be optimized. Probably 90% of the scaling problems are database issues.

The quick solution is to scale up your current linode package, however, I think you might find that your traffic is going to peak and will wane next week after everyone has gone back to school/work and is out of the holiday mindset at which point you can scale back.

Put in a throttle - /proc/loadavg

Limit it to X signups per hour, asking them to check back next hour. Collect email and notify when they can sign up. Point them at a facebook page, ask them to like the page, do announcements when the next 'batch' of users is able to sign up.

If you want some help analyzing the slow query logs and/or the normal logs, email me a url of a .gz/.bz2 of a reasonable snippet at hnusername@hnusername.com.

Since you're running nginx, consider doing an alias and use proxy caching. I would doubt your static files are causing too many issues, but, if you can cache computationally expensive pages a little, that can help.

Re: Ask HN: I built a site that just went ridiculously viral. What do I do now?

#58
post #11

I recently built a Facebook application that approached the same kind of growth. Sites like this typically see eCPM between $0.10 and $0.30 for advertising. So you're looking at around $30/day revenue right now. Consider switching to EC2. This will allow you to easily scale up to a more powerful server if growth continues or down to a less powerful one if traffic tapers off. Depending on how you set things up, a comm…

New Feature Idea if it's not already in the works: threewords.me places (foursquare?). would leverage current users engagement to tag locations with a dead simple description. could keep users coming back, provide utility(value)to businesses, and make you some more money. email me (mw63214@gmail.com) if you want more ideas, although it seems you have your hands full as it is. Good Luck!

Re: Ask HN: I built a site that just went ridiculously viral. What do I do now?

#59
post #37

short term: heroku long term: app engine (just port it to webapp framework)

Why?

Heroku in the short term b/c you wrote it in rails and you can easily scale it up or down based on virality.

App engine after that b/c it should be fairly easy to port and it's an extremely headache-free way to host an app. Now that they have always on instances, it's very fast and scales efficiently and effortlessly.

Re: Ask HN: I built a site that just went ridiculously viral. What do I do now?

#60
post #39
post #11

I recently built a Facebook application that approached the same kind of growth. Sites like this typically see eCPM between $0.10 and $0.30 for advertising. So you're looking at around $30/day revenue right now. Consider switching to EC2. This will allow you to easily scale up to a more powerful server if growth continues or down to a less powerful one if traffic tapers off. Depending on how you set things up, a comm…

Would it be possible to see your Facebook app? I'm curious to see what traits these fast growing apps have in common in person.

2 words: self-interest.
Post reply on HN