upgrade from version 5.0.45

upgrade from version 5.0.45

am 30.03.2010 15:36:45 von Marco Baiguera

Hello everyone,
i am quite new to mysql and i recently begin to work with a company
who is using mysql 5.0.45 in production.
i think this version is too old and would like to upgrade to the most
recent 5.0.xx

my os is CentOS release 5.3.

is it safe to simply use "yum upgrade mysql" ?

are there any important differences i should be aware of between
5.0.45 and 5.0.77 ?
any diffferences in password encoding etc. ?

the db is properly backed up and replicated on two 5.0.77 slaves.

thank you
Marco

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: upgrade from version 5.0.45

am 01.04.2010 09:54:45 von dilipkumar.parikh

Hey if you are using any archive engines in your existing database then
please use (5.0.8x) if not then u can upgrade to 5.1.45 (stable).

Thanks,
Dilipkumar

-----Original Message-----
From: ing.baiguera@gmail.com [mailto:ing.baiguera@gmail.com] On Behalf
Of Marco Baiguera
Sent: Tuesday, March 30, 2010 7:07 PM
To: mysql@lists.mysql.com
Subject: upgrade from version 5.0.45

Hello everyone,
i am quite new to mysql and i recently begin to work with a company
who is using mysql 5.0.45 in production.
i think this version is too old and would like to upgrade to the most
recent 5.0.xx

my os is CentOS release 5.3.

is it safe to simply use "yum upgrade mysql" ?

are there any important differences i should be aware of between
5.0.45 and 5.0.77 ?
any diffferences in password encoding etc. ?

the db is properly backed up and replicated on two 5.0.77 slaves.

thank you
Marco

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Ddilipkumar.parikh@eds.c om


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: upgrade from version 5.0.45

am 05.04.2010 05:17:29 von Rob Wultsch

On Tue, Mar 30, 2010 at 6:36 AM, Marco Baiguera
wrote:
> Hello everyone,
> i am quite new to mysql and i recently begin to work with a company
> who is using mysql 5.0.45 in production.
> i think this version is too old and would like to upgrade to the most
> recent 5.0.xx
>
> my os is CentOS release 5.3.
>
> is it safe to simply use "yum upgrade mysql" ?
>
> are there any important differences i should be aware of between
> 5.0.45 and 5.0.77 ?
> any diffferences in password encoding etc. ?
>
> the db is properly backed up and replicated on two 5.0.77 slaves.
>
> thank you
> Marco
>
I would not simply upgrade. I would upgrade the test environment first
and have the development team sign off that there were no bad effects
caused by the upgrade.

The first version of 5.0 that I think is particularly useable and not
buggy is 5.0.67. I suggest that this is worth the upgrade.

In theory there are not significant differences between 5.0 versions
after GA other that bug fixes. I *do not* trust this.



--
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: upgrade from version 5.0.45

am 05.04.2010 06:29:11 von Walter Heck

Depending on the "seriousness" of your environment you can read the
changelogs and upgrade if you don't see any showstoppers. I have
hardly ever seen any problems with minor version upgrades of mysql.
Of course what Rob says is true, and it is a good idea to test things
out in a test environment first. But I know many environment where it
is "okay" to just run the upgrade, as long as it is a minor version
upgrade. I guess it depends on the type of production environment you
are running in.

be careful though!

Walter

On Mon, Apr 5, 2010 at 11:17, Rob Wultsch wrote:
> On Tue, Mar 30, 2010 at 6:36 AM, Marco Baiguera
> wrote:
>> Hello everyone,
>> i am quite new to mysql and i recently begin to work with a company
>> who is using mysql 5.0.45 in production.
>> i think this version is too old and would like to upgrade to the most
>> recent 5.0.xx
>>
>> my os is CentOS release 5.3.
>>
>> is it safe to simply use "yum upgrade mysql" ?
>>
>> are there any important differences i should be aware of between
>> 5.0.45 and 5.0.77 ?
>> any diffferences in password encoding etc. ?
>>
>> the db is properly backed up and replicated on two 5.0.77 slaves.
>>
>> thank you
>> Marco
>>
> I would not simply upgrade. I would upgrade the test environment first
> and have the development team sign off that there were no bad effects
> caused by the upgrade.
>
> The first version of 5.0 that I think is particularly useable and not
> buggy is 5.0.67.  I suggest that this is worth the upgrade.
>
> In theory there are not significant differences between 5.0 versions
> after GA other that bug fixes. I *do not* trust this.
>
>
>
> --
> Rob Wultsch
> wultsch@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dlists@o=
lindata.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: upgrade from version 5.0.45

am 05.04.2010 07:44:22 von Jesper Wisborg Krogh

Be aware that if it is an unpatched version of 5.0.77, then there is
a bug related to name_const (http://bugs.mysql.com/bug.php?id=42014)
that can cause serious problems (infinite server crashes if it
happens in a replication thread). Redhat/CentOS have applied the
patch, but other sources might still have that bug.

Jesper

On 05/04/2010, at 2:29 PM, Walter Heck - OlinData.com wrote:

> Depending on the "seriousness" of your environment you can read the
> changelogs and upgrade if you don't see any showstoppers. I have
> hardly ever seen any problems with minor version upgrades of mysql.
> Of course what Rob says is true, and it is a good idea to test things
> out in a test environment first. But I know many environment where it
> is "okay" to just run the upgrade, as long as it is a minor version
> upgrade. I guess it depends on the type of production environment you
> are running in.
>
> be careful though!
>
> Walter
>
> On Mon, Apr 5, 2010 at 11:17, Rob Wultsch wrote:
>> On Tue, Mar 30, 2010 at 6:36 AM, Marco Baiguera
>> wrote:
>>> Hello everyone,
>>> i am quite new to mysql and i recently begin to work with a company
>>> who is using mysql 5.0.45 in production.
>>> i think this version is too old and would like to upgrade to the
>>> most
>>> recent 5.0.xx
>>>
>>> my os is CentOS release 5.3.
>>>
>>> is it safe to simply use "yum upgrade mysql" ?
>>>
>>> are there any important differences i should be aware of between
>>> 5.0.45 and 5.0.77 ?
>>> any diffferences in password encoding etc. ?
>>>
>>> the db is properly backed up and replicated on two 5.0.77 slaves.
>>>
>>> thank you
>>> Marco
>>>
>> I would not simply upgrade. I would upgrade the test environment
>> first
>> and have the development team sign off that there were no bad effects
>> caused by the upgrade.
>>
>> The first version of 5.0 that I think is particularly useable and not
>> buggy is 5.0.67. I suggest that this is worth the upgrade.
>>
>> In theory there are not significant differences between 5.0 versions
>> after GA other that bug fixes. I *do not* trust this.
>>
>>
>>
>> --
>> Rob Wultsch
>> wultsch@gmail.com
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?
>> unsub=lists@olindata.com
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=jesper@noggin.com.au
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: upgrade from version 5.0.45

am 05.04.2010 08:09:46 von Rob Wultsch

On Sun, Apr 4, 2010 at 9:29 PM, Walter Heck - OlinData.com
wrote:
> Depending on the "seriousness" of your environment you can read the
> changelogs and upgrade if you don't see any showstoppers. I have
> hardly ever seen any problems with minor version upgrades of mysql.
> Of course what Rob says is true, and it is a good idea to test things
> out in a test environment first. But I know many environment where it
> is "okay" to just run the upgrade, as long as it is a minor version
> upgrade. I guess it depends on the type of production environment you
> are running in.
>
> be careful though!
>
> Walter
>

Not everything that gets changed is in the change log. In particular
there was a memory leak that I had (...still have...) to deal with
that got fixed without any note in the change log.

http://www.maatkit.org/doc/mk-upgrade.html is your friend.


--
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org