M
M
Max2017-02-20 11:57:06
PostgreSQL
Max, 2017-02-20 11:57:06

Is it possible to set up 1 slave for multiple masters in Postgresql?

Colleagues, good time of day.
there is a task - a certain (significant) number of PostgreSQL master nodes at remote points, it is necessary to raise a similar number of slaves in the data center to them. It is clear that raising a lot of individual Postgres servers is not very efficient. Those. there is a desire to raise 1 (2-3) server in the data center and replicate data there. Found that multi-slave configurations are possible.
But the question is - what will happen when the remote master stops working? I will need to be on this server in the data center at the same time a slave for a bunch of servers - and a master for 1 (2-3, etc.). Those. 1 physical server must be both master and slaves at the same time. Partitioning at the Postgres DB/Cluster level?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
ky0, 2017-02-20
@MaxDukov

Multi-slave is when one master has several slaves.
I don’t see anything particularly inefficient in individual slaves, except for some overhead in RAM.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question