Regional subdomains on Drupal. How is it better?

Question

PHP

There is an online store. A pair of regions (domain + subdomain).
What is the best way to organize the work of Drupal?
Do subdomains on one mysql database or on different ones for each region? For example, through the domain variable

module - how's the idea? That is, as multilingualism, only for our task.

Answer 1

The drupal.org/project/domain module has everything you need. Specifically, you need the Domain Content module included in this set , which allows you to set for each node belonging to a specific domain, this node will not be displayed on other domains. Multisayting with joined tables for this case, it makes no sense to fence.

Answer 2

I understand correctly that you will have this:
moskow.site.ru
spb.site.ru
vrn.site.ru?
Determine the pros and cons for yourself, which will give you one or the other solution. For example, with separate databases, in the event that one of the databases of any region falls, users can be temporarily directed to the domain of the nearest region with a working database.

Answer 3

You most likely need to use a mixed method.
If the sites have something in common, then the tables should be common.
For example, for users, most likely, there will be a common table, and for others - a separate database.
More details habrahabr.ru/post/133086/ below in section 2.b.