What is the best architecture? Mysql multi BD or single?

2

We are currently working with web software that is going to 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 centralizing database and user router, all in Mysql. But today I have CPU and Memory bottleneck 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 one, ie 1 BD for each client that comes in (more or less 50 MB daily growth) or if I hang everything in just one database. Windows Server, .net, BD Mysql

Thank you very much for the help.

    
asked by anonymous 25.10.2017 / 20:50

0 answers