MyQL 5.1 or 5.5

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

MyQL 5.1 or 5.5

decorior
Hi,

Does anybody have any feeling over which is the better version to go with?


Deco
#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: MyQL 5.1 or 5.5

Jonathan Guthrie-3
Unequivocally go 5.5 - no reason to stay with 5.1.


On 2012-03-05, at 10:43 PM, deco rior wrote:

> Does anybody have any feeling over which is the better version to go with?

Jono

----------------------------
Jonathan Guthrie
[hidden email]
LassoSoft Inc.

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: MyQL 5.1 or 5.5

Jonathan Guthrie-3
Argh, darned auto-correct. What I meant was that if you have a choice, just skip 5.1 go straight for 5.5.

On 2012-03-05, at 10:45 PM, Jonathan Guthrie wrote:

> Unequivocally go 5.5 - no reason to stay with 5.1.

Jono

----------------------------
Jonathan Guthrie
[hidden email]
LassoSoft Inc.

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: MyQL 5.1 or 5.5

Wade Maxfield
On 6/03/2012, at 4:47 PM, Jonathan Guthrie wrote:

> Argh, darned auto-correct. What I meant was that if you have a choice, just skip 5.1 go straight for 5.5.
>
> On 2012-03-05, at 10:45 PM, Jonathan Guthrie wrote:
>
>> Unequivocally go 5.5 - no reason to stay with 5.1.
>
> Jono


I'd suggest not doing that.

If you are going to go 5.5, upgrade to 5.1 first, then upgrade to 5.5 checking mysql_upgrade after each step.

 - Wade

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: MyQL 5.1 or 5.5

Jonathan Guthrie-3
Interesting - Wade did you come across some issues?
I didn't have problems going from 5.0 to 5.5 on several servers, but I did run the upgrade, perhaps the upgrade dealt with any 5.0-5.1 changes?

On 2012-03-05, at 10:52 PM, Wade Maxfield wrote:

> On 6/03/2012, at 4:47 PM, Jonathan Guthrie wrote:
>
>> Argh, darned auto-correct. What I meant was that if you have a choice, just skip 5.1 go straight for 5.5.
>>
>> On 2012-03-05, at 10:45 PM, Jonathan Guthrie wrote:
>>
>>> Unequivocally go 5.5 - no reason to stay with 5.1.
>>
>> Jono
>
>
> I'd suggest not doing that.
>
> If you are going to go 5.5, upgrade to 5.1 first, then upgrade to 5.5 checking mysql_upgrade after each step.
>
> - Wade

Jono

----------------------------
Jonathan Guthrie
[hidden email]
LassoSoft Inc.

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: MyQL 5.1 or 5.5

Wade Maxfield
On 6/03/2012, at 4:58 PM, Jonathan Guthrie wrote:

> Interesting - Wade did you come across some issues?
> I didn't have problems going from 5.0 to 5.5 on several servers, but I did run the upgrade, perhaps the upgrade dealt with any 5.0-5.1 changes?
>

I've hit some minor issues on the 5.0 -> 5.1 upgrade that I'm still working through. Mainly on my monitoring and maintenance processes. I haven't yet gone through my .cnf files yet to bring them up to the new standards.

I did have to do some repairing and even dumping and reloading of tables after the 5.1 upgrade, at the prompting of the upgrade script.

But it's mainly that I've been following the release notes and they suggest that you should always upgrade to each major release without missing a step.

 - Wade

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: MyQL 5.1 or 5.5

stevepiercy
In reply to this post by Jonathan Guthrie-3
It's what MySQL recommends.
http://dev.mysql.com/doc/refman/5.5/en/upgrading.html

     As a general rule, to upgrade from one release series to
another, you
     should go to the next series rather than skipping a series.
To upgrade
     from a release series previous to MySQL 5.1, upgrade to
each successive
     release series in turn until you have reached MySQL 5.1,
and then proceed
     with the upgrade to MySQL 5.5.

It does not elaborate upon the specific reason, but it would be
reasonable to assume that changes in one upgrade might not be
included in subsequent upgrades, especially concerning the
storage of data.

--steve


On 3/5/12 at 10:58 PM, [hidden email] (Jonathan Guthrie) pronounced:

>Interesting - Wade did you come across some issues?
>I didn't have problems going from 5.0 to 5.5 on several
>servers, but I did run the upgrade, perhaps the upgrade dealt
>with any 5.0-5.1 changes?
>
>On 2012-03-05, at 10:52 PM, Wade Maxfield wrote:
>
>>On 6/03/2012, at 4:47 PM, Jonathan Guthrie wrote:
>>
>>> Argh, darned auto-correct. What I meant was that if you have a choice, just skip 5.1
>go straight for 5.5.
>>>   On 2012-03-05, at 10:45 PM, Jonathan Guthrie wrote:
>>>
>>>> Unequivocally go 5.5 - no reason to stay with 5.1.
>>>   Jono
>>
>>
>>I'd suggest not doing that.
>>
>>If you are going to go 5.5, upgrade to 5.1 first, then upgrade to 5.5 checking
>mysql_upgrade after each step.
>>
>>- Wade
>
>Jono
>
>----------------------------
>Jonathan Guthrie
>[hidden email]
>LassoSoft Inc.
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy               Web Site Builder              
Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: MyQL 5.1 or 5.5

Ke Carlton-3
I imagine it's predominate the update tables routines that a version
dependant...

Ke

On 6 March 2012 04:10, Steve Piercy - Web Site Builder
<[hidden email]>wrote:

>
> It does not elaborate upon the specific reason, but it would be reasonable
> to assume that changes in one upgrade might not be included in subsequent
> upgrades, especially concerning the storage of data.
>
> --steve
>
>
#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>