2
We are currently working with a web software that is going to the market with great acceptance. It receives many partner interfaces and generates a lot of content for each table. In the past we chose to create a database for each client, and a centralized database and user router, all in Mysql. But today I have CPU neck and Memoria on a good server, and we are hanging only 20 clients. My question is whether the model we adopted in the past is the best, ie 1 BD for each client who enters (more or less 50 MB daily growth) or if I hang everything in just one database. Windows Server, Application . net, BD Mysql
Thank you so much for your help.
Edilson before the situation exposed, taking into account that its application has good acceptance in the market, in my point of view the best solution when it comes to architecture, is to keep everything in a single database, but to use load balancing, a suggestion would be to use for example GCP (Google Cloud Platform), which will offer you a very robust service including backup and automatic scalability.
– Raphael Godoi