Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Craig Dunn (listscodenation.net)
Date: Tue Mar 24 2009 - 08:38:05 CDT
Baron Schwartz wrote:
> If you can't take downtime, I'd go the slave route.
> You should certainly test your application to make sure 5.1's
> differences (data types, syntax, etc) don't cause problems. Otherwise
> you're risking getting badly stuck and having to downgrade to 4.1
> again in a crisis.
> If you dump and reload, you don't need to go to 5.0 first. That is
> only for in-place upgrades with mysql_upgrade, which I would not do
> anyway because of the file format changes. I would dump and reload.
Sorry I wasn't very clear there - testing will all be done in a QA
environment before anything is cut over, what I'm after is a way of
switching from 4.1 to 5.1 as quickly as possible when we come to do the
live stuff. Looks like replication may work from what you are saying.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql