Answer the question
In order to leave comments, you need to log in
2 sites from different hosts from one database. How to be?
Greetings. Please point me in the right direction.
Task: There is a site-shop. Divided into regional subdomains: different prices, SEO, etc., that's not the point. Located on Russian hosting. Now the company wants to enter the Belarusian market. And according to the law, it is necessary that the site be located on Belarusian hosting. We buy white domain. We copy the site. But what about the db? Changes in db rus. site should be displayed in white, and vice versa. DB on postgresql. Open a database on one server and climb there from another? The solution is not very good in my opinion. There is no master replica out of the box in postgresql. You can set up bucardo, but no experience. Maybe there are other solutions?
Answer the question
In order to leave comments, you need to log in
We do not touch the main database - for the Belarusian site we make a front that makes requests to the API of the main site.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question