Re: Upgrading from 5.0.32 via a replication chain and bug 24432

2009-09-09 Thread Per Jessen 
David Harrison wrote:

> Hi all,
> 
> I've got a quite large database (23G) that is running on a 5.0.32
> version of MySQL.  I really want to upgrade out of 5.0.32 to the
> latest version of 5.1 (or even 5.4) but a straight mysql_upgrade of
> the database takes long enough that I'd have serious down-time issues
> (last time I benchmarked the upgrade it came in at over day).

This may or may not be useful, but I've just upgraded from 5.0.51 to
5.1.36, which took about 6 hours using mysqldump+reload - the database
is about 20Gb. 


/Per Jessen, Zürich


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Upgrading from 5.0.32 via a replication chain and bug 24432

2009-09-09 Thread David Harrison 
Hi all,

I've got a quite large database (23G) that is running on a 5.0.32
version of MySQL.  I really want to upgrade out of 5.0.32 to the
latest version of 5.1 (or even 5.4) but a straight mysql_upgrade of
the database takes long enough that I'd have serious down-time issues
(last time I benchmarked the upgrade it came in at over day).

To try and work around this I wanted to set up binary replication from
my current database (as master) to a new database.  This has meant
that I have run across bug #24432
(http://bugs.mysql.com/bug.php?id=24432) which means that replication
is broken from my current version to versions above 5.0.34.

The bug listing includes the following replication table:

  master  (-inf, 5.0.23)[5.0.24, 5.0.34]  [5.0.36,+inf)
slave
(-inf, 5.0.23)BUG#20188 both bugs, no error   BUG#20188
[5.0.24, 5.0.34]  this bug, no errorno bugthis bug, no error
[5.0.36, +inf)no bugthis bug, error   no bug

which seems to indicate to me that there's no way out of the version
I'm running aside from a mysql_upgrade.

Does anyone have experience of this bug, or of any options I have that
wouldn't require a significant outage ?

Cheers
Dave

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org