[Postgres-xl-general] Replicating as well as distributing?

Mason Sharp msharp at translattice.com
Sun Jun 15 05:35:48 PDT 2014


On Fri, Jun 13, 2014 at 1:05 AM, Barosl LEE <yuki at barosl.com> wrote:

> It seems that DISTRIBUTE BY only supports either replication or
> distribution at a time. What I want to do is distributing the rows to a
> certain datanodes, while replicating them to some other datanodes.
>
> Is this kind of operation supported in Postgres-XL? Or should I replicate
> the tables manually using the built-in streaming replication feature of
> PostgreSQL?
>
>

DISTRIBUTE BY REPLICATION uses statement-based replication, typically for
fairly static data, for better read performance.

Streaming replication is used to make replicas of entire data nodes, for
redundancy as standbys for failover.

Let me know if you have any other questions.

Thanks,

Mason

TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20140615/61edcf15/attachment.htm>


More information about the postgres-xl-general mailing list