Hypothetical question

singularsyzygy

Hi there,

I was wondering, how much space would ~10 million posts and 1 million users (10 posts per user) work out at?

I am wondering about space in this case and how scalable this is.

Thanks and kind regards,

luceos

The only bottleneck I can think of is the database. Luckily Flarum is built on top of Laravel and as such supports more scalable solutions than MySQL, also with some proper caching you might come very far.

Davis

luceos database caching possibly but not a response cache like vagrant. Because the API data is eager most requests come with client specific data making it uncachable. The list of discussions is also client specific so it cannot be cached either.

luceos

Davis then it would be a matter of putting up a good master-slave replication setup and different web nodes behind load balancing.

singularsyzygy

Thanks for the answers, but it didn't really answer my question.

The reason I asked, is if I were to use a VPS like digital ocean, with a smallish VM, would it fit the bill for a long time? or would storage be a concern? Performance I can work out, by creating additional VM's and delegating certain roles (DB, reverse proxy, fail-over, etc), increasing resources etc, but my concern is storage. As storage costs per GB.

Even if I were to go physical, how much HDD's should I get? Can I use SSD's (more expensive, less space, but higher performance), or stay with HDD (cheap, and more space, but lower performance)? Will 4TB be enough for the long term, or can I stick it out with just 512GB for another couple of million posts/users?

How much storage would 10 million posts with 1 million users (10 posts per user) work out at?

Maybe I should've elaborated in my first post ?

Kulga

singularsyzygy That now needs the average size of a post and user

On one of my forums, my average post is 946 bytes and user is 877 bytes.

so..

10,000,000 X 946 + 1,000,000 X 877 = 10337000000 bytes

Which is about 9.8GB if I did it right.

singularsyzygy

Kulga Thank you! ? that is exactly what I was looking for. So I can technically stick with 100GB for roughly 100 million posts and 10 million users, if I stick to the ratio of 10 posts per user. That will last quite a long time. Very nice

Thanks once again ?