Re: [Ilugc] mysql upgrade 5.1.73 to 5.5.46

[Arun Khan]

On Thu, Oct 22, 2015 at 6:50 PM, Ajeesh Kannan  wrote:
>
> My serve is using the following bin files.
>
> ]# rpm -qa | grep mysql
> mysql-5.1.73-3.el6_5.x86_64
> mysql-libs-5.1.73-3.el6_5.x86_64
> mysql-server-5.1.73-3.el6_5.x86_64
> mysql-devel-5.1.73-3.el6_5.x86_64
>
> So I need to replace all these bin files with matching 5.5 binary file ?
>

What do you mean by replace?

Use your distro's package manager to upgrade your MySQL packages.
Some one has already mentioned Percona; they build RPM/DEB packages
for all the major distributions out there.

*Before* doing this exercise on your production server, I would
strongly recommend that you carry out exercise on a prototype server
(using a copy of your production data) and make sure you work out all
the kinks (if any) in the upgrade process.   Since it is production, I
would suggest do not go beyond 5.6.x.  It has been vetted in the field
whereas 5.7 (not released yet) may still have some quirks post
release.

-- Arun Khan
___
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
ILUGC Mailing List Guidelines:
http://ilugc.in/mailinglist-guidelines

Re: [Ilugc] mysql upgrade 5.1.73 to 5.5.46

[P.R.Karthik]

Hi,

1) Shutdown the MySQL and have a backup of data directory.
2) Replace the MySQL binary files.
3) start the MySQL server with the old data directory.
4) Run the mysql_upgrade to fix the internal tables.

Go with mysql 5.1 to MySQL 5.5. Then move on to MySQL 5.6. MySQL 5.7 will
be GA by next week.

Consider using Percona Server if there is a heavy need and client accepts.
You can also try MariaDB 5.5 if you need more benefit from the Optimizer.

Regards,
KarthiK.P.R

On Wed, Oct 21, 2015 at 12:43 PM, Arun Khan  wrote:

> On Tue, Oct 20, 2015 at 11:26 PM, Ajeesh Kannan 
> wrote:
> > Hi,
> >
> > Is there any good document to refer mysql server upgrade from 5.1.73 to
> > mysql 5.5.46.
> >
>
> Don't know about docs but take *backup* of your data before attempting
> the upgrade!
>
> Off the cuff - why stop at 5.5.46?  GA 5.6.x is also available from
> Percona's site and 5.7, with performance improvement (claimed by
> Oracle), is set to be released in a month or so.
>
> IIRC, MySQL site has release notes and/or docs for upgrades.  I would
> suggest you do the migration in smaller steps  i.e. 5.1 to 5.2 and so
> forth.
>
> -- Arun Khan
> ___
> ILUGC Mailing List:
> http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
> ILUGC Mailing List Guidelines:
> http://ilugc.in/mailinglist-guidelines
>
___
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
ILUGC Mailing List Guidelines:
http://ilugc.in/mailinglist-guidelines

Re: [Ilugc] mysql upgrade 5.1.73 to 5.5.46

[Ajeesh Kannan]

On Thu, Oct 22, 2015 at 6:50 PM, Ajeesh Kannan 
wrote:

>
>
> On Thu, Oct 22, 2015 at 4:40 PM, P.R.Karthik  wrote:
>
>> Hi,
>>
>> 1) Shutdown the MySQL and have a backup of data directory.
>> 2) Replace the MySQL binary files.
>> 3) start the MySQL server with the old data directory.
>> 4) Run the mysql_upgrade to fix the internal tables.
>>
>> Go with mysql 5.1 to MySQL 5.5. Then move on to MySQL 5.6. MySQL 5.7 will
>> be GA by next week.
>>
>> Consider using Percona Server if there is a heavy need and client accepts.
>> You can also try MariaDB 5.5 if you need more benefit from the Optimizer.
>>
>> Regards,
>> KarthiK.P.R
>>
>> On Wed, Oct 21, 2015 at 12:43 PM, Arun Khan  wrote:
>>
>> > On Tue, Oct 20, 2015 at 11:26 PM, Ajeesh Kannan <
>> ajeeshbkan...@gmail.com>
>> > wrote:
>> > > Hi,
>> > >
>> > > Is there any good document to refer mysql server upgrade from 5.1.73
>> to
>> > > mysql 5.5.46.
>> > >
>> >
>> > Don't know about docs but take *backup* of your data before attempting
>> > the upgrade!
>> >
>> > Off the cuff - why stop at 5.5.46?  GA 5.6.x is also available from
>> > Percona's site and 5.7, with performance improvement (claimed by
>> > Oracle), is set to be released in a month or so.
>> >
>> > IIRC, MySQL site has release notes and/or docs for upgrades.  I would
>> > suggest you do the migration in smaller steps  i.e. 5.1 to 5.2 and so
>> > forth.
>> >
>> > -- Arun Khan
>> > ___
>> > ILUGC Mailing List:
>> > http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
>> > ILUGC Mailing List Guidelines:
>> > http://ilugc.in/mailinglist-guidelines
>> >
>> ___
>> ILUGC Mailing List:
>> http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
>> ILUGC Mailing List Guidelines:
>> http://ilugc.in/mailinglist-guidelines
>>
>
>
> Thank you Karthik,
>
> My serve is using the following bin files.
>
> ]# rpm -qa | grep mysql
> mysql-5.1.73-3.el6_5.x86_64
> mysql-libs-5.1.73-3.el6_5.x86_64
> mysql-server-5.1.73-3.el6_5.x86_64
> mysql-devel-5.1.73-3.el6_5.x86_64
>
> So I need to replace all these bin files with matching 5.5 binary file ?
>
>
Or i would need to replace each and every files.

~]$ rpm -ql mysql-5.1.73-3.el6_5.x86_64
/usr/bin/msql2mysql
/usr/bin/my_print_defaults
/usr/bin/mysql
/usr/bin/mysql_config
/usr/bin/mysql_find_rows
/usr/bin/mysql_waitpid
/usr/bin/mysqlaccess
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump


-- 
With Regards,
Ajeesh B.Kannan
___
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
ILUGC Mailing List Guidelines:
http://ilugc.in/mailinglist-guidelines

Re: [Ilugc] Mysql Upgrade

[Ashok Gautham]

On 10/20/09, Rajesh Kumar ras.kuma...@gmail.com wrote:
   I have been using mysql 5.0 version in ubuntu 8.10. I would
 like to upgrade mysql 5.1.28 if it is possible how to upgrade the mysql 5.1
 in my ubuntu system
https://help.ubuntu.com/community/UbuntuBackports

---
Ashok `ScriptDevil` Gautham
___
To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with 
unsubscribe password address
in the subject or body of the message.  
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc