D
D
Denis A.2017-02-06 16:45:19
PostgreSQL
Denis A., 2017-02-06 16:45:19

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

2 answer(s)
D
Denis A., 2017-02-08
@myphpscript

set up bucardo in the end

A
Artyom Innokentiev, 2017-02-06
@artinnok

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 question

Ask a Question

731 491 924 answers to any question