Skip site navigation (1) Skip section navigation (2)

Re: How many Cluster database on a single server

From: "d(dot)davolio(at)mastertraining(dot)it" <d(dot)davolio(at)mastertraining(dot)it>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How many Cluster database on a single server
Date: 2011-10-21 06:57:48
Message-ID: 4EA117EC.7000406@mastertraining.it (view raw or flat)
Thread:
Lists: pgsql-performance
Thanks everybody for the suggestions. Now I have a better idea on which 
direction proceed. When we will have some results we will post again to 
share.
Thanks again!


On 10/19/2011 05:13 PM, Kevin Grittner wrote:
> "d(dot)davolio(at)mastertraining(dot)it"<d(dot)davolio(at)mastertraining(dot)it>  wrote:
>
>> We are thinking to use the Streaming Replica feature to keep in
>> sync a number of little DB servers around the net. The replica
>> should happen on one or more centralized servers. I didn't tested
>> the replica personally bus as I can see, it syncs the whole
>> Cluster DB. So, on the centralized server(s), we will have perfect
>> copies of the Cluster Databases. We sure need to test this
>> configuration but first of all I was wondering if there are known
>> drawbacks.
>
> We do something very much like this with about 100 standby database
> clusters on a single machine.  We don't have any illusion that we
> could switch to one of these for a normal production load and have
> good performance with all of these competing for resources -- it's
> primarily to confirm that the PITR backup process is working and
> staying up to date, and to provide a quick source for a copy to a
> standby production server.
>
> The one thing I would strongly recommend is that you use a separate
> OS user as the owner of each cluster's data directory (and, of
> course, to run the cluster's service).  We didn't initially do this,
> and had problems on recovery when the server crashed.  If you search
> the archives you can probably dig up all the details on why this is
> an issue and why separate users is a good solution; but really, this
> is important.
>
> -Kevin


In response to

pgsql-performance by date

Next:From: Anthony PresleyDate: 2011-10-21 23:39:46
Subject: 8.4.4, 9.0, and 9.1 Planner Differences
Previous:From: kzsoltDate: 2011-10-20 20:10:11
Subject: Re: Heavy contgnous load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group