Re: In the belly of the beast (MySQLCon)

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Alan Hodgson <ahodgson(at)simkin(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: In the belly of the beast (MySQLCon)
Date: 2008-04-18 18:30:18
Message-ID: 4808E8BA.1060709@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

Joshua D. Drake wrote:
> On Fri, 18 Apr 2008 13:54:52 -0400
> Geoffrey <lists(at)serioustechnology(dot)com> wrote:
>
>> What about the:
>>
>> 8.1 -> slony -> 8.3
>> switch users to 8.3 databases
>>
>> solution.
>
> Is it? What is your transactional velocity? How long will the initial
> sync transaction have to run? You know vacuum isn't working while
> that transaction is open right? Are you going to have to setup up a
> dozen different replicated sets in order to get it done?
>
> Slony works in "some" cases it does not work in all nor the most
> critical (in terms of large sets with minimal downtime requirement).

I don't know that slony is the answer. It was more of a question then
an answer. We are hoping to use that solution to migrate from 7.4.19 to
8.3.1. The primary reason is to reduce downtime.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Brad Nicholson 2008-04-18 18:30:58 Re: Joshua Drake's "What MySQL Can Learn From PostgreSQL" talk at MySQL Con 2008
Previous Message Andrew Sullivan 2008-04-18 18:16:28 Re: Joshua Drake's "What MySQL Can Learn From PostgreSQL" talk at MySQL Con 2008

Browse pgsql-general by date

  From Date Subject
Next Message Paul Boddie 2008-04-18 18:33:48 Re: Which Python library - psycopg2 or pygresql?
Previous Message Rodrigo Gonzalez 2008-04-18 18:30:17 Re: Upgrade 8.3