Read this interesting retro about discords migration path from Mongo to Cassandra to now ScyllaDB.

https://discord.com/blog/how-discord-stores-trillions-of-messages