Re: MySQL 5.5 goes GA Release
Re: MySQL 5.5 goes GA Release
- Subject: Re: MySQL 5.5 goes GA Release
- From: Kieran Kelleher <email@hidden>
- Date: Thu, 16 Dec 2010 14:55:40 -0500
There are important steps to follow.... and the details are here:
http://dev.mysql.com/doc/refman/5.5/en/upgrading.html
High level upgrade overview:
- Slaves should always be upgraded before masters. A master should never be a higher version than a slave.
General Steps I follow:
1) Check release notes for changes that are incompatible with old version (config options, etc.) and address those first by changing the my.cnf options file or making a new version of my.cnf ready to drop in after the upgrade.
2) Backup ((a) make a copy of the mysql dir (including the data dir) and/or (b) do a mysql dump and/or (c) freeze a slave)
3) Shutdown server
4) Install the new version
5) my.cnf changes if applicable
6) Start new version
4) Run the mysql_upgrade script (very important! - many people don't do this and think their database is 'broken'!)
5) Restart mysql server (to make sure startup options work after the upgrade script)
Personally, if I am responsible for a 24/7 mysql server, we upgrade all slaves first. This can be done way in advance and will give you confidence in the upgrade process and the reliability of the new version.
Then at some point, we promote a specific slave to be the master and switch all apps to point to that.
We can then upgrade the original master at our convenience and if that machine is the preferred higher-performance machine, then we can promote that back to being master after the upgrade and lose a few minutes of production.
HTH, Kieran
On Dec 16, 2010, at 12:22 PM, Paul D Yu wrote:
> Is there a best practice for upgrading MySQL servers? I've killed my previous databases the last few times I've upgraded.
>
> Paul
> On Dec 16, 2010, at 9:44 AM, Kieran Kelleher wrote:
>
>> For all MySQL users (that excludes you Chuck ;-) )
>>
>> http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html
>>
>> Of note:
>>
>> - InnoDB is now the default table type ...... finally, I no longer have to beat people for unknowingly using MyISAM.
>>
>> - Improved scalability and performance on multi-core CPUs.
>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden