From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Geoffrey <lists(at)serioustechnology(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 18:59:34 |
Message-ID: | 20080418185934.GB572@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general |
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.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2008-04-18 19:04:51 | Re: In the belly of the beast (MySQLCon) |
Previous Message | Alan Hodgson | 2008-04-18 18:57:38 | Re: In the belly of the beast (MySQLCon) |
From | Date | Subject | |
---|---|---|---|
Next Message | Bayless Kirtley | 2008-04-18 19:00:17 | No server after starting |
Previous Message | Alan Hodgson | 2008-04-18 18:57:38 | Re: In the belly of the beast (MySQLCon) |