Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted September 12, 20168 yr 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
September 12, 20168 yr 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.
September 13, 20168 yr Author 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?
September 13, 20168 yr Author 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?
September 13, 20168 yr 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
September 13, 20168 yr Author 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?
September 13, 20168 yr 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.
September 13, 20168 yr Author 2 hours ago, Jim M said: MariaDB is basically MySQL, there is nothing to interact with differently from an application standpoint. Excellent, thanks Jim
Archived
This topic is now archived and is closed to further replies.