Hi everyone, I’m building a cloud service for an application.
It is my plan to run all the databases on one large cluster (on digital ocean). Each of my users could have multiple small databases on the cluster.
Does it matter that there can be millions (even billions) of small 10 or 100 mb? databases ? The names of the databases would be unique hashes
Should I bother creating more than 1 cluster? No one will ever need to manually administer any of the databases or tables. Some of them may be small, some big. but mostly small. my plan was to just specify the database to use with each query.
besides that, I was hoping it would just work
Am I creating a bottleneck of some kind?
Thanks for any thoughts.