Lemmy.world has been down between 02:00 UTC and 05:45 UTC. This was caused by the database spiking to 100% cpu (all 32 cores/64 threads!) due to inefficient queries been fired to the db very often.
I’ve collected the logs and we’ll be checking how to prevent this. (And what caused this)
Instances should be divided more into groups of Communities. So they theoretically don’t grow infinitely, only as high as the “group” if communities grows. Ex. An NBA or Sports instance containing /c/NBA /c/NFL /c/NHL and all the related teams. Or similar to the programming.dev instance all being programming and development. While these would grow it would grow at a much slower rate than everything in one instance and be much more maintainable.
Of course this is somewhat of a social construct so everyone has to be in agreement with how to handle this and move accordingly, which won’t happen.
Long-term long-term for federation there has to be a distributed computing solution that allows the users to contribute to hosting.