Planning to upgrade Mysql

Issues related to software problems.
bala2066
Posts: 2
Joined: 2016/11/17 05:29:42

Planning to upgrade Mysql

Postby bala2066 » 2016/11/17 05:37:44

I am planning to upgrade Mysql 5.0 to Mysql 5.6 in CentOS 5.11.There are so many applications running on the server like mail server,webserver.Will this upgrade impact and of the applications running.Any dependencies will be there?... Points to note before upgrade? Kindly share your thoughts and advice on this.

User avatar
TrevorH
Forum Moderator
Posts: 21170
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: Planning to upgrade Mysql

Postby TrevorH » 2016/11/17 07:45:04

My thought is that if you are going to go to the effort of migrating to a newer mysql then you would be better off investing that effort in migrating to a newer CentOS. CentOS 5 goes End of Life in March next year - less than 5 months time. After that there will be no more security updates for it and it will become progressively less and less safe to run. Why not take this opportunity to plan your migration to CentOS 7 (EOL date 2024) or CentOS 6 (EOL 2020).
CentOS 5 died in March 2017 - migrate NOW!
Full time Geek, part time moderator. Use the FAQ Luke

bala2066
Posts: 2
Joined: 2016/11/17 05:29:42

Re: Planning to upgrade Mysql

Postby bala2066 » 2016/11/18 04:32:59

Thank you Trevor for the response,Our office is running completely on outdated OS such as Xp for desktops,CentOS 5 and MS 2003 for servers.I have initiated request to upgrade the entire infrastructure. Will there be any dependencies in upgrading Mysql for time being.

aks
Posts: 2498
Joined: 2014/09/20 11:22:14

Re: Planning to upgrade Mysql

Postby aks » 2016/11/20 16:59:33

Will this upgrade impact and of the applications running.


Possibly. How do the apps interact with the DB?

Any dependencies will be there?


In what way? Dependencies of the application(s)? Well that's the responsibility of the application(s). What do you mean?

Points to note before upgrade?


Make 100% sure you have a backup that you can restore of the application(s) data.