Songstuff Posted September 12, 2016 Share Posted September 12, 2016 Hi I am at the point of having to contemplate upgrading the versions of PHP and MySQL my server is running. MySQL will work but it is already below the recommended version. The version of PHP the server is running is the minimum recommended. The server in question is Amazon AWS running Amazon Linux. Current versions are: PHP 5.6.24 MySQL 5.5.51 With a number of possible versions to upgrade to, and it being a pain in the ass to upgrade (especially MySQL) I wanted to upgrade to the recommended versions of each. Additionally, can anyone recommend a specific upgrade process? What is the safest way to do it? What sort of downtime should I expect? Cheers John Link to comment Share on other sites More sharing options...
Joy Rex Posted September 12, 2016 Share Posted September 12, 2016 MySQL 5.6 for certain, and if you are running IPS 4.1.x (or plan to), then PHP 7, but only after upgrading to IPS 4. Link to comment Share on other sites More sharing options...
IveLeft... Posted September 12, 2016 Share Posted September 12, 2016 PHP 7.0.10 I'd switch to MariaDB 10.1.7 Both run IPS very well Link to comment Share on other sites More sharing options...
Songstuff Posted September 13, 2016 Author Share Posted September 13, 2016 I am already running IPB4. PHP7 sounds good. Is it an easy enough conversion to MariaDB? I am guessing I can run MariaDB and MySQL 5.5 in parallel to fascilitate porting? Link to comment Share on other sites More sharing options...
Songstuff Posted September 13, 2016 Author Share Posted September 13, 2016 having just read on the mariaDB the realtionship between the two, I am guessing that running them in parallel will not be possible. Would you recommend doing a mysql version upgrade and then upgrading again to maria db, conevrting to mariadb 5.5 and then upgrading to the latest mariadb, or exporting tables and privileges uninstalling mysql, installing mariadb and then importing the mysql tables? Link to comment Share on other sites More sharing options...
ASTRAPI Posted September 13, 2016 Share Posted September 13, 2016 Don't make easy things to do difficult The simplest method follows these steps: Update your software repositories list with the MariaDB repos Update your Linux package manager with the new repos Stop MySQL Install MariaDB with your package manager Go back to work because you're done Link to comment Share on other sites More sharing options...
Songstuff Posted September 13, 2016 Author Share Posted September 13, 2016 13 hours ago, ASTRAPI said: Don't make easy things to do difficult The simplest method follows these steps: Update your software repositories list with the MariaDB repos Update your Linux package manager with the new repos Stop MySQL Install MariaDB with your package manager Go back to work because you're done Oh wow, so it takes care of the version upgrade? Excellent. I am guessing upgrade PHP first. Do I need to install a MariaDB version of invision or is that seemless too? Link to comment Share on other sites More sharing options...
Jim M Posted September 13, 2016 Share Posted September 13, 2016 15 minutes ago, Songstuff said: Oh wow, so it takes care of the version upgrade? Excellent. I am guessing upgrade PHP first. Do I need to install a MariaDB version of invision or is that seemless too? MariaDB is basically MySQL, there is nothing to interact with differently from an application standpoint. Link to comment Share on other sites More sharing options...
Songstuff Posted September 13, 2016 Author Share Posted September 13, 2016 2 hours ago, Jim M said: MariaDB is basically MySQL, there is nothing to interact with differently from an application standpoint. Excellent, thanks Jim Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.