From: | Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk> |
---|---|
To: | |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 7.4? |
Date: | 2003-02-28 09:49:08 |
Message-ID: | Pine.LNX.4.44.0302280942570.4305-100000@RedDragon.Childs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 27 Feb 2003, Andrew Sullivan wrote:
> On Thu, Feb 27, 2003 at 02:21:23PM -0700, Ed L. wrote:
> >
> > Unfortunately, dbmirror does go through all the iterations, even if
>
> So does dbmirror keep a copy of the row somewhere? Doesn't that add
> a lot to i/o?
>
> A
>
>
Ok we seam to have quite a lot of talk about replication options
here.
I need to implement one sooner or later....
Which is best seams to be on requirments and not much else. So
perhaps a list of whats currently available, its requirements and what it
is best for would be good on the web site. Here are my requirements.
1> MultiMaster (Database involves quite a lot of writes)
2> 24 x 7 operation so one server must be able to cope while the other
vacuums, backups etc,
3> Consistant all machines that are up must look the same when in master
usage.
The problem as far as I can see with sycronse systems is that they
can't cope with down time and that in my book is the primary reason for
having replication.
Peter Childs
P.S. A Hot Spare might actually be the best answer.... `
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-02-28 09:59:16 | Re: Few Simple Questions |
Previous Message | Arjen van der Meijden | 2003-02-28 09:24:44 | Re: phpBB2 slow on postgres vs mysql ? |