1

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.

2

Re: Start of several MySQL servers by one machine. And whether it is necessary?

And the program code for each organization the? Then separate servers all.
If the program one - that is possible and in one basis all to store, but with safety is worse.
Better it is finite to everyone the server then also the program will be identical to all.

3

Re: Start of several MySQL servers by one machine. And whether it is necessary?

Whether

danilka37 wrote:

Further I plan to connect about 100 organizations

It is supposed each of the organizations to give access at connection level to MySQL?
If is not present, enough one  and to space apart all objects under circuits.

4

Re: Start of several MySQL servers by one machine. And whether it is necessary?

VladRost, implementation for each organization different, and the interaction interface identical at all.

5

Re: Start of several MySQL servers by one machine. And whether it is necessary?

miksoft, No, access only at application.
The matter is that can be for 5 seconds of 10-20 requests from the different organizations.
And if they are in different circuits on one DB, also port at them identical. Also it turns out they cannot be simultaneously connected all, since port one. And each time at request to a DB to create object of connection it it is very expensive, from the point of view of productivity.
It is necessary to me that all organizations have been connected simultaneously. Too expensive  them in runtime.
Therefore or all in one circuit, or on different DB on different ports.

6

Re: Start of several MySQL servers by one machine. And whether it is necessary?

danilka37 wrote:

Also it turns out they cannot be simultaneously connected all, since port one.

From what it? And how your way a Web server work with hundreds simultaneous connections?
Strictly speaking, the port is absolutely not necessary, if application local.

7

Re: Start of several MySQL servers by one machine. And whether it is necessary?

Whether

danilka37 wrote:

there Can be any problems  productivity if in  there will be 1000 tables?

Is not present.

danilka37 wrote:

I tend  to the server for each organization since it easier to scale more.

.

danilka37 wrote:

a question how to make:

the Server - one. A DB - one. Tables - 11, i.e. 10 plus the table of the organizations. Well and in those 10 plus . A field - FK on the organization.

danilka37 wrote:

can be for 5 seconds of 10-20 requests from the different organizations.

Here so far as concerns 10-20 THOUSAND requests a SECOND - then there will be productivity questions. And the loading specified by you - fie and to pound.

8

Re: Start of several MySQL servers by one machine. And whether it is necessary?

Akina;
Thanks!!!)