Good evening.
I'm creating a system in PHP that, say, resembles a virtual mall (several "stores" and each store with its products).
For this I need to store data from users, stores, companies, products, schedules, days, orders, payments, etc, etc and such.
In addition to all this user interface, there would still be the HelpDesk layer, administration (by stores), system administration, settings, analytics, statistics, and so on.
So my question is the following, in terms of performance x organization, does it make up for me to separate these layers into separate databases?
For example, a main database with the essential tables (users, stores, products ...) and other banks with the helpers (statistics, helpdesk and etc).
Considering that it will be common to query between banks (find a user when saving a ticket in the helpdesk and etc).
Is this feasible? Does it affect performance (all banks on the same server)? Can anyone who has done this tell me about their experience?
Thank you.