1 Magento CMS, with multiple stores and multiple servers, is that possible?

[abdallahal9ef7]

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.

Thank you,

[infogetpage875]

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.

[infomochigc53f]

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.

[luciamartyce72]

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.

[ibtisamdev8aef]

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:

• Install Magento on one main server that will act as the central admin and backend.
• Configure multiple websites and stores in Magento's configuration. Each website/store can have separate domains, branding, etc.
• On additional servers, install Magento with only the front-end codebase. Do not install the admin portion.
• Configure each front-end server to use the central Magento database for the main website. But have separate databases for each additional store's data.
• Set up table prefixing in Magento to isolate each store's data in the shared database.
• Configure content synchronization or replication between the stores' individual databases and the main DB.
• In Magento config, set different database connections for each website/store pointing to the separate databases.
• Allow only the main backend Magento admin URL. Restrict admin access on the front-end servers.
  
  With this setup, you have a centralized Magento backend and admin panel managing multiple stores with their own separate databases. The key is configuring table prefixing and separate database connections for each website.