Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 02-22-2019 03:49:48

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Upgrading Our Server MySQL 5.6 to 5.7

cPanel has reported that we should upgrade from MySQL 5.6 to 5.7 as per instructions at

https://documentation.cpanel.net/displa … DB+Upgrade

Please can you confirm that K9.03 will be OK with that.

Thanks.

Last edited by sdn (02-22-2019 03:50:10)


Simon

Offline

 

#2 02-22-2019 08:39:11

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Upgrading Our Server MySQL 5.6 to 5.7

Yes, no problem - also it will work on Maria DB if they want you to go that route.


Nick Hendler

Offline

 

#3 02-24-2019 07:14:45

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Upgrading Our Server MySQL 5.6 to 5.7

OK thanks. Is Maria a better choice than mySQL and if so would we need to create or alter the current DB?

We also tried to move up to PHP 7.2 but mcrypt is not installed as standard in that version so we have gone back to 7.1. Will running K9 installer correct that or is there a different solution? This question is academic since 7.1 seems to work perfectly well.

Do you think it is worth turning on PHP-FPM? I tried both and could see no noticeable difference.

I see that the DB is about a tenth of the size that it was in CCP8. I assume you have done a considerable amount of optimisation as we have not changed much.

On a slightly different subject, do .js files in the public directory need to be set at 755 or can they run at 644 permission?

Last edited by sdn (02-25-2019 04:06:36)


Simon

Offline

 

#4 02-25-2019 08:00:13

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Upgrading Our Server MySQL 5.6 to 5.7

OK thanks. Is Maria a better choice than mySQL and if so would we need to create or alter the current DB?

I'm not sure if Maria is a better choice than MySQL.  It seems to be the new/popular choice, but I don't really see much difference for what our program does with the db.

We also tried to move up to PHP 7.2 but mcrypt is not installed as standard in that version so we have gone back to 7.1. Will running K9 installer correct that or is there a different solution? This question is academic since 7.1 seems to work perfectly well.

The solution there would be to install mcrypt with PHP 7.2 when you install that PHP verison. 

Do you think it is worth turning on PHP-FPM? I tried both and could see no noticeable difference.

PHP-FPM offers no real advantage unless you're using any of the PHP-FPM additional features in your webserver setup (advanced logging, etc).

I see that the DB is about a tenth of the size that it was in CCP8. I assume you have done a considerable amount of optimisation as we have not changed much.

Yes, we did.  Thanks for noticing! The majority of the size difference you're noticing is in the sessions table, which was highly optimized. 

On a slightly different subject, do .js files in the public directory need to be set at 755 or can they run at 644 permission?

You can run those at 644, no problem.  We recommend both config.php files be set to 640 (read/write by owner only), and the .php files in the /public and /public/utilities directories should be set to 755 (executable).  Besides those requirements, you can adjust anything else as necessary.


Nick Hendler

Offline

 

#5 02-27-2019 13:56:12

sppars
Member
Registered: 01-25-2006
Posts: 301

Re: Upgrading Our Server MySQL 5.6 to 5.7

Would an upgrade from MySQL 5.6 to 5.7 (or Maria DB) be okay for versions 6 and 8 as well?

Offline

 

#6 02-28-2019 07:59:57

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Upgrading Our Server MySQL 5.6 to 5.7

sppars wrote:

Would an upgrade from MySQL 5.6 to 5.7 (or Maria DB) be okay for versions 6 and 8 as well?

Maybe, but I cannot say for sure.  When we readied K9 to use Maria we had to do a couple of things to make sure everything would run 100%.  This included decreasing the length of all VARCHAR columns to 180, as Maria has overhead on those (V6-V8 have some VARCHARs set at 250).  Also, I believe a few encoding changes were made.  I'm not sure if not having those changes would keep V6-V8 from running on Maria, but it should be OK.  If I recall, we had at least one beta tested running Maria before we modded the software to support it better.  I would say you're probably OK, but be cautious and backup.


Nick Hendler

Offline

 

Board footer