Topic: Start of several MySQL servers by one machine. And whether it is necessary?
I write application on Java. operations from a DB I use Hibernate. With SQL a sign it is not enough.
Now application works with one organization for which there is a DB from 10 tables.
Further I plan to connect about 100 organizations, for each of them will be a DB approximately from 10 tables
And here a question how to make:
For each organization to make the server on the port (for example 3307,3308,3309 etc.)
Or to push all tables in one .
Whether there can be any problems productivity if in there will be 1000 tables?
I tend to each organization since it easier to scale more.