Re: Multi Master Replication

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Multi Master Replication
Дата
Msg-id CAOR=d=1daWHDKLga=xL=450Xv7NuGn7mF4Pab8kDYc3CBvTMcA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multi Master Replication  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: Multi Master Replication
Список pgsql-general
On Wed, Dec 18, 2013 at 10:25 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:

> On Thu, Dec 19, 2013 at 7:12 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:

>> When people start talking multi-master replication my first response
>> is to ask what problem you're trying to solve. Sometimes MM Rep IS the
>> answer. But quite often it's not the best one for your problem. So to
>> OP I'd ask what problem they're trying to solve.

> Yes that's actually the right approach, multi-master replication is
> often cited as a marketing term for a fantastic technology that can
> solve a lot of problems, which could be solved with a couple of
> Postgres servers using a single-master, multiple-slave approach, or by
> simply design a system that can do data sharding among a set of
> Postgres servers to achieve some kind of write scalability.

Sharding with plproxy is pretty easy and can scale hugely.


В списке pgsql-general по дате отправления:

Предыдущее
От: Bob Futrelle
Дата:
Сообщение: Installed postgres.app 9.3.1.0. pgadmin doesn't appear to see it
Следующее
От: Amit Langote
Дата:
Сообщение: Re: unexpected pageaddr error in db log