Re: In the belly of the beast (MySQLCon)

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, 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 19:05:51
Message-ID: 4808F10F.6050507@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

Alvaro Herrera wrote:
> Geoffrey wrote:
>> Joshua D. Drake wrote:
>>> On Fri, 18 Apr 2008 14:30:18 -0400
>>> Geoffrey <lists(at)serioustechnology(dot)com> wrote:
>>>
>>>> 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.
>>> Well :) That is why I asked the questions I did. It very well may be
>>> the answer. It might not. For example, what size is your database? How
>>> many transactions per hour are you doing?
>> We have 13 separate databases, not terribly large, my WAG would be that
>> our largest database might have 30 million rows. I couldn't honestly
>> tell you how many trans/hour we are doing without doing a little
>> research.
>
> I find it pretty unlikely that Slony would be unable to help you upgrade
> here. Obviously you can upgrade one database at a time.
>
> Also, mostly it's not the database size what's a concern, but rather the
> size of the largest table.

Well, we have done some extensive testing and it seems feasible. We've
got more testing to do, so we've not decided. We hope to use slony to
replicate the data in order to have a hot spare solution as well.

--
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

Browse pgsql-advocacy by date

  From Date Subject
Next Message Geoffrey 2008-04-18 19:08:45 Re: In the belly of the beast (MySQLCon)
Previous Message Joshua D. Drake 2008-04-18 19:04:51 Re: In the belly of the beast (MySQLCon)

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2008-04-18 19:08:45 Re: In the belly of the beast (MySQLCon)
Previous Message Joshua D. Drake 2008-04-18 19:04:51 Re: In the belly of the beast (MySQLCon)