Re: Horizontal scalability/sharding

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Horizontal scalability/sharding
Дата
Msg-id CAA4eK1Kut2-W2f4k+Cyk+k_9q8kSprtBAuBmawQnm7B5Jf7ong@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Horizontal scalability/sharding  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Horizontal scalability/sharding  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
On Thu, Sep 3, 2015 at 8:28 AM, Bruce Momjian <bruce@momjian.us> wrote:
>
> On Wed, Sep  2, 2015 at 07:50:25PM -0700, Joshua Drake wrote:
> > >Can you explain why logical replication is better than binary
> > >replication for this use-case?
> > >
> >
> > Selectivity?
>
> I was assuming you would just create identical slaves to handle failure,
> rather than moving selected data around.
>

Yes, I also think so, otherwise when the shard goes down and it's replica
has to take the place of shard, it will take more time to make replica
available as it won't have all the data as original shard had. 


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Horizontal scalability/sharding
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: GIN pending clean up is not interruptable