Well, under this point of view I feel a bit lucky now. Having built-in
streaming replication is a big advantage and gives me the chance to
avoid third party applications. Despite there are good solutions out
there I believe that less complexity is always better.
Plus, I would really like to avoid a
It's hard to say Robin, I'm still in testing.
At the beginning I'd say very low ... probably something between 2000
and 5000 transactions a day (even harder to imagine how this load it's
gonna be distributed within 24 hours)?!
Thanks for your reply.
On Tue, 2010-12-21 at 08:02 +, robin wrote:
After some enlightening considerations by Scott Marlowe I'm actually now
considering a streaming replication with dedicated network connection
and two different data dirs on the same storage. This would bypass the
lock issue, make replication very fast and make my life "easier" with
one reliable (r
Στις Tuesday 21 December 2010 03:23:25 ο/η sn...@email.it έγραψε:
> Hi everybody,
> I'm trying to figure out a way to setup a PostgreSQL HA cluster solution.
>
> I've done some research and I've an idea of different possible solutions,
> but I'd honestly like to implement it using CARP in a "Share
> On Mon, Dec 20, 2010 at 8:03 PM, wrote:
> >> On Mon, Dec 20, 2010 at 6:23 PM, wrote:
> > Well, I'd prefer a big single storage instead of "too many spinning
disks"
> > around mainly for maintenance reasons, to avoid replication and too much
> > network traffic.
>
> Sure, but that then makes
On Mon, Dec 20, 2010 at 8:03 PM, wrote:
>> On Mon, Dec 20, 2010 at 6:23 PM, wrote:
> Well, I'd prefer a big single storage instead of "too many spinning disks"
> around mainly for maintenance reasons, to avoid replication and too much
> network traffic.
Sure, but that then makes your single po
> On Mon, Dec 20, 2010 at 6:23 PM, wrote:
> > Hi everybody,
> > I'm trying to figure out a way to setup a PostgreSQL HA cluster
solution.
> >
> > For the record:
> > - I've already tried pgpool-II 2.x in Synchronous Multi Master
Replication
> > mode and I was satisfied by it's functionality but c
On Mon, Dec 20, 2010 at 6:23 PM, wrote:
> Hi everybody,
> I'm trying to figure out a way to setup a PostgreSQL HA cluster solution.
>
> For the record:
> - I've already tried pgpool-II 2.x in Synchronous Multi Master Replication
> mode and I was satisfied by it's functionality but concerned about
Hi everybody,
I'm trying to figure out a way to setup a PostgreSQL HA cluster solution.
For the record:
- I've already tried pgpool-II 2.x in Synchronous Multi Master Replication
mode and I was satisfied by it's functionality but concerned about having
the same data growing on several nodes
- I've
