That faster one database for many sites or a separate database for each site?

Going to do high-loaded project: catalog of companies in different countries.
The main burden will be to create bots of search engines.

The sites are aimed at European countries, will work on the 1st server in the middle of Europe.

There are options:
1) One database: On the basis of the domain to choose the table prefix and work with them within a single DB
2) database for each country/site separately

What will faster work? (from the point of view of the database)
July 8th 19 at 12:25
5 answers
July 8th 19 at 12:27
Solution
I presume that the difference will not be because the server you will have one.
July 8th 19 at 12:29
Solution
The work of each individual database - specific invoice flow, which decreases when the content of all databases in one place. Content on a single server 10 virtuallock with small bases inside - resources more than their contents on a single database server.

The allocation base for each site will allow to isolate them from each other and avoid classes of resources of a neighboring site. Otherwise, the advantages in performance, you won't feel isolated if all the bases are located on the same server.

If all databases are located on an independent hardware, of course, the separation will be more productive.
July 8th 19 at 12:31
Solution
Many databases will be faster and more convenient.
July 8th 19 at 12:33
Solution
Few databases on a single server faster only if your engine tables when records are locit the entire table. And no matter what (and even if you have 10 databases of 100 GB or 1 1tr. the 10 will be faster )
July 8th 19 at 12:35
Solution
While many are already moving to microservices (which implies a different database) You want all in 1.. IMHO, not ice.
Personal opinion: don't follow trends blindly and neither should you. Can a pack of examples. - Brock_Nader commented on July 8th 19 at 12:38
Well, no one is blindly and should not be, just the monolith is harder to maintain and scale! - Alison.Bail commented on July 8th 19 at 12:41
: Not a fact: concrete is easier to maintain in a consistent structure - cleora commented on July 8th 19 at 12:44
VisualIdeas: Aha see you are a very large monolith support.. and try your monolith to another framework to rewrite or to another language.. I look at You. in General, to each his own.. - Alison.Bail commented on July 8th 19 at 12:47
: You know, I support about a hundred different sdelannyh at different times of my sites and the problem of uniformity PTS acute... - cleora commented on July 8th 19 at 12:50

Find more questions by tags MySQL