Hi,
novnov wrote:
OK, this has been very informative and I'd like to thank the three of you.
Asynchronous replication to readonly slaves is something I will look into.
I've never touched posgtres replication; and Scott mentioned that he was not
familiar with PGCluster, so there must be some ot
Hello
We plProxy to split our database into partitions. See Kristo's blog's about
that at http://kaiv.wordpress.com/.
For replication we use Londiste in SkyTools package. SkyTools contains
several more scripts that are useful when buildin large and complex systems
running on large number of serve
OK, this has been very informative and I'd like to thank the three of you.
Asynchronous replication to readonly slaves is something I will look into.
I've never touched posgtres replication; and Scott mentioned that he was not
familiar with PGCluster, so there must be some other replication syst
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/08/07 19:58, novnov wrote:
> You're right, that's not how I understood your partitioning question. I'd not
> be eager to implement that kind of split in the db, though I can see that
> it's an example of how to spread the load around.
>
> But ba
On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
> But basically, it seems that the answer to one of my questions is that there
> is currently no way with postgres to spread a single database over multiple
> servers, ala a loadbalanced apache cluster, where requests are forwarded to
> different boxes.
You're right, that's not how I understood your partitioning question. I'd not
be eager to implement that kind of split in the db, though I can see that
it's an example of how to spread the load around.
But basically, it seems that the answer to one of my questions is that there
is currently no wa
On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
>
> Yes the trx would be akin to banking operations.
>
> This is good: "Can you partition your data to multiple servers?" That's kind
> of my question! I've not dealt with RAC, data partitioning, any of those
> topics; just haven't had exposure. But sin
Yes the trx would be akin to banking operations.
This is good: "Can you partition your data to multiple servers?" That's kind
of my question! I've not dealt with RAC, data partitioning, any of those
topics; just haven't had exposure. But since you're asking me if the data
can be partitioned to d
On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
>
> Yes, I realize that scaling must be a large and complicated topic. And that
> PostgresSQL is not as scaleable as Oracle etc.
Depends on how we're defining scalability. :)
I didn't explicitly say that RAC will outscale postgresql. It's just
one ap
Yes, I realize that scaling must be a large and complicated topic. And that
PostgresSQL is not as scaleable as Oracle etc.
I know after reading your post that Postgres cannot match RAC. I'm still not
sure if Postgres can operate a database from more than one box, at all. If
it can, how? I mean is
On 9/8/07, novnov <[EMAIL PROTECTED]> wrote:
>
> What happens when a database needs to scale beyond a single server? Is this
> something PostgreSQL can do?
>
> Further, does a database need to be designed differently if it's going to be
> used on more than one server? I know there are many issues t
What happens when a database needs to scale beyond a single server? Is this
something PostgreSQL can do?
Further, does a database need to be designed differently if it's going to be
used on more than one server? I know there are many issues that might effect
a database's ability to scale; but sp
12 matches
Mail list logo
