With the new data privacy policies worldwide, we are trying to make sure we host our Magento stores (and its customer database) in the appropriate location, however, we still need to keep the benefit of having 1 Magento backend, which will make it easier to handle and maintain.
Can we have 1 Magento backend with multiple stores and have these stores' data hosted on different servers?
we are using Magento community edition.
This will not be possible as for one backend there will be one database and one set of tables storing user information. You can't spread the different stores' user data across different databases.
Yes it is possible, but the complexity would almost certainly far outweigh your budget, our consulting partner lets us use their clusters and effectively do the same, we have an admin server as the backend with datasets replicated across web servers and multiple Galera databases in a cluster.
There is nothing stopping the web servers, file storage, and database instance being in separate locations fed from a single admin instance, separate countries is one thing, cross continent will induce heavy latency, the performance would be unclear but we are running at 200ms TTFB and 95%/98% page load performance for products and categories, basically it would be a similar approach to CDN 'edges'.
The complexity would be how to separate the data from a business perspective, but that would require a deep-dive analysis as it would be company, site, requirement, specific.
Yes, it is possible to have one Magento backend with multiple stores hosted on different servers. This can be achieved by configuring Magento to use a multi-server architecture, where the database and web servers are separated.
To achieve this, you can use the Magento Enterprise Edition, which comes with support for multiple servers out of the box. However, if you are using the Magento Community Edition, you can still configure it to work with multiple servers by implementing a custom solution.
The basic idea is to configure the Magento stores to use different databases, each hosted on a separate server. This can be done by editing the configuration files for each store and specifying the database connection details for that store's database.
Additionally, you can use load balancing to distribute the traffic across multiple web servers. This can help improve the performance and reliability of your Magento stores.
In summary, it is possible to have one Magento backend with multiple stores hosted on different servers, but it will require some custom configuration and setup.
Yes, it is possible to have a 1 Magento backend with multiple stores that have their data hosted on separate servers. Here is an overview of how to set this up: