News for hackers. Stuff that matters.
Re:Scaling to 100k Users by Kiro on Wednesday February 05, 2020 @02:18PM (#22250096)
Yeah, it really depends on the kind of app. My app with a couple of hundred thousand users runs on a single $5 Digital Ocean droplet with standard PHP and MySQL.
Re:Scaling to 100k Users by leeoniya on Wednesday February 05, 2020 @04:17PM (#22251066)
> My app with a couple of hundred thousand users

per year? per month? per day? simultaneously? doing what?

it matters.

i ask this as someone who runs a $40/mo Linode with a debian/nginx/node/mysql stack that's definitely 20x over-provisioned for an e-commerce site with 10k daily visitors, 15 simultaneous backend users (reporting, order-entry, CRM, analytics) and 0 caching tricks. i could easily run the site on any 5 year old laptop with an SSD and 8GB RAM.

normalize/de-normalize when needed, understand and hand-write efficient SQL queries (ditch ORMs), choose small/fast libs carefully (or write your own), and you can easily serve 100k users per day on a single cheap VPS with no orchestration/replication/hz-scaling bullshit. definitely can't say the same about 200k simultaneous users - that would need proper hardware, but can still be a single server.

Monoliths Are the Future: https://news.ycombinator.com/item?id=22193383

Re:Scaling to 100k Users by sgtfrankieboy on Wednesday February 05, 2020 @06:10PM (#22251860)
>(ditch ORMs)

Depends on which ORM you use I think. Basic ORMs like Dapper in .NET just map your SQL query result to a object model.

Re:Scaling to 100k Users by sk5t on Thursday February 06, 2020 @01:46AM (#22253968)
Dapper's a "micro-ORM" and quite lightweight. Usually folks intend ORM to refer to Hibernate or Entity Framework, maybe ActiveRecord, etc.
Re:Scaling to 100k Users by Scarbutt on Wednesday February 05, 2020 @05:50PM (#22251748)
hand-write efficient SQL queries (ditch ORMs)

Raw SQL strings or a query builder?

Re:Scaling to 100k Users by leeoniya on Wednesday February 05, 2020 @09:24PM (#22252944)
doesnt matter. query builders are negligible overhead.
Re:Scaling to 100k Users by neillyons on Wednesday February 05, 2020 @05:08PM (#22251451)
What is the e-commerce site?
Re:Scaling to 100k Users by leeoniya on Wednesday February 05, 2020 @09:19PM (#22252919)
i'm working on a blog post about the tech choices & stack. maybe it'll make it to the front page in a month or two - that'll be a good stress test!
Re:Scaling to 100k Users by Demiurge on Wednesday February 05, 2020 @05:16PM (#22251513)
Are you offering a free stress test? :)
Re:Scaling to 100k Users by clementmas on Wednesday February 05, 2020 @06:45PM (#22252086)
Same thing here, TravelMap.net has 100k+ users (total), handles photo uploads and runs on a simple droplet with PHP and JS.

I guess it depends on the daily traffic.

Re:Scaling to 100k Users by jiux on Wednesday February 05, 2020 @07:49PM (#22252480)
Do you mind sharing more details on how you store and manage these photo uploads? Are you leveraging NFS or cloudfront + S3 at all?
Re:Scaling to 100k Users by wackget on Wednesday February 05, 2020 @02:38PM (#22250284)
Wow, what's your app?