Databases in this category are some of the most popular ones in the world with good reason. The only way you can scale is to adopt a query-free architecture.
It feels tedious at first but once you develop some good habits and frameworks around denormalization it becomes easy to do that from day one.