Re: Merge a sharded master into a single read-only slave

From: Kevin Goess <kgoess(at)bepress(dot)com>
To: Sébastien Lorion <sl(at)thestrangefactory(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Merge a sharded master into a single read-only slave
Date: 2014-06-02 16:52:47
Message-ID: CABZkbxjGr084unwXjrzPTp5imbX+wrpaxOu2VkEgp8LYvpWexQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> So my conclusion is that for now, the best way to scale read-only queries
for a sharded master is to
> implement map-reduce at the application level.

That's the conclusion I would expect. It's the price you pay for sharding,
it's part of the deal.

But it's also the benefit you get from sharding. Once your read traffic
grows to the point that it's too much for a single host, you're going to
have to re-shard it all again *anyway*. The whole point of sharding is
that it allows you to grow outside the capacities of a single host.


In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sébastien Lorion 2014-06-02 18:47:40 Re: Merge a sharded master into a single read-only slave
Previous Message Arup Rakshit 2014-06-02 15:38:00 Re: How can I select rows by comparing an array data type column with multiple values ?