Upgrade MySQL 5.5 to 5.6
Hi All...
I'm having a bit of an issue with server settings as we are creating a new cPanel instance on our server in order to run Magento 2 for a client... Everything has gone ok up until we have had to update MySQL from 5.5 to 5.6... There is only one other site on this server and it's running Magento 1.9.1 which supports 5.6 but this is a production site which we cannot afford to go down for any length of time and while doing my research I have found lots of conflicting information about this update... To compound this we also have an ODBC connection running to link the 1.9 site to Filemaker Pro...
What I would like to know is has anyone performed this upgrade via WHM and if so did you run into any issues? If so how did you rectify them?
Has anyone run similar software and upgraded MySQL from 5.5 to 5.6?
And finally does anyone have any knowledge about ODBC connections and server versions (I can't seem to get hold of the developer who created this link and knowledge of this is above my pay grade ;-) )...
Thanks in advance for your assistance...
D
-
Hello @Duncan Eagles, I haven't seen many reports of problems from customers upgrading from MySQL version 5.5 to MySQL version 5.6, but the best way to know for sure is to perform the upgrade in a development environment. Do you have access to a spare server? If not, many providers offer low-cost VPS rentals that work well for this purpose. With an extra server, you could install CentOS and utilize a trial cPanel license for testing. Then, transfer a copy of the account to the development server and perform the upgrade to MySQL 5.6 to make sure everything works as expected in a non-production environment. Thank you. 0 -
Thanks for getting back to me Michael... Unfortunately the client that requires this isn't that happy about having to pay out for another server so I was wondering if the backup system in WHM will allow them to roll back if this does cause issues? I've spoken to their ODBC developer who thinks that the upgrade shouldn't cause issues and the version of Magento running supports 5.6. so in theory everything should be fine but there are a too many "should" statements going on for me to feel truly comfortable with this... 0 -
Hello @Duncan Eagles, Downgrading to an older major MySQL version (e.g. 5.6 to 5.5) isn't supported in cPanel & WHM, so once you upgrade to version 5.6 you won't be able to revert. Thank you. 0 -
I've recently upgraded from 5.5 -> 5.6 -> 5.7 and except that as always performance became worse, I did have issues with 5.6 -> 5.7 but not with upgrading to 5.6. The main issue I recall is that it doesn't allow empty / undefined values anymore when inserting / replacing entries. That's a problem if you (or whoever made the software) doesn't always set all values and doesn't have default values either. So in a production environment at least I suggest you set a default value for every field in your DB just in case. It can't do harm. 0 -
Thanks for you replies... The client has stated that he's happy to just go for it as the information available seems to point to it being fine but before I push the button this weekend I was wondering is there a way that I can take a full backup of the current server configuration so if it does all go belly up i can just reinstall and re-import with the current settings? I can see that there's a way to import a cpmove file (that I'm assuming would contain all relevant current settings) but cannot see how to create one?? Thanks again... 0 -
If you want to have a hope of reverting the old MySQL back, you have to shut mysql down, make a backup of the /var/lib/mysql folder somewhere when start mysql back up and upgrade it. If you have to revert, you will have to manually remove the mysql packages, put your backup of the /var/lib/mysql folder back, set cpanel back to the version you actually want to install and then reinstall the old version. This is tricky and can cause problems which is why its generally not advised. 0
Please sign in to leave a comment.
Comments
7 comments