Re: In the belly of the beast (MySQLCon)

Geoffrey wrote:
> Joshua D. Drake wrote:
>> On Fri, 18 Apr 2008 14:30:18 -0400
>> Geoffrey <lists@serioustechnology.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