Re: Anything "time" critical on www.postgresql.org VM?

Lists: pgsql-www
From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-www(at)postgresql(dot)org
Subject: Anything "time" critical on www.postgresql.org VM?
Date: 2004-09-26 19:30:10
Message-ID: 20040926162636.K22056@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www


I'd like to setup hot failover for that VM, so that if the server it is
running on goes down, it will auto-come back up on a second server. So
far, the finest I can get the replication granularity is 15 minutes, so
there is the potential of 15 minutes worth of 'data' to be lost on a crash
...

As I believe that most (if not all?) of the stuff on that VM is pretty
static as far as files, and there is no email over there, I can't think of
any reason *not* to do this for that VM ... but, I wanted to check here to
see if anyone knows of a reason that the potential lose of '15 minutes'
worth of data is a bad thing?

If not, I'll get that setup ...

I don't believe that any of the other VMs can have this setup yet, until I
can get the 'gap' reduced between replicas, since they are all dealing
with CVS in some form or another, or email ...

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664


From: Justin Clift <justin(at)postgresql(dot)org>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-www(at)postgresql(dot)org
Subject: Re: Anything "time" critical on www.postgresql.org VM?
Date: 2004-09-26 22:48:46
Message-ID: 4157474E.5000803@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

Marc G. Fournier wrote:
>
> I'd like to setup hot failover for that VM, so that if the server it is
> running on goes down, it will auto-come back up on a second server. So
> far, the finest I can get the replication granularity is 15 minutes, so
> there is the potential of 15 minutes worth of 'data' to be lost on a
> crash ...

Hi Marc,

What kind of replication is being used?

:)

Regards and best wishes,

Justin Clift


From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-www(at)postgresql(dot)org
Subject: Re: Anything "time" critical on www.postgresql.org VM?
Date: 2004-09-26 23:44:45
Message-ID: 20040926204344.C30067@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

On Mon, 27 Sep 2004, Justin Clift wrote:

> Marc G. Fournier wrote:
>>
>> I'd like to setup hot failover for that VM, so that if the server it is
>> running on goes down, it will auto-come back up on a second server. So
>> far, the finest I can get the replication granularity is 15 minutes, so
>> there is the potential of 15 minutes worth of 'data' to be lost on a crash
>> ...
>
> Hi Marc,
>
> What kind of replication is being used?

rsync right now, unless you know of something better that works under
FreeBSD? I'd love to find something more 'real time', but haven't been
able to find anything that could be run on an existing server ...

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664


From: Justin Clift <justin(at)postgresql(dot)org>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-www(at)postgresql(dot)org
Subject: Re: Anything "time" critical on www.postgresql.org VM?
Date: 2004-09-27 08:06:11
Message-ID: 4157C9F3.9020302@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

Marc G. Fournier wrote:
> On Mon, 27 Sep 2004, Justin Clift wrote:
<snip>
>> Hi Marc,
>>
>> What kind of replication is being used?
>
> rsync right now, unless you know of something better that works under
> FreeBSD? I'd love to find something more 'real time', but haven't been
> able to find anything that could be run on an existing server ...

Oh well, it sounds like it'll have to do.

They use rsync here too for file based syncronisation. It get's bitched
and moaned about, but "does the job".

Regards and best wishes,

Justin Clift