MySQL 5.7 support

DirectAdmin Support

Administrator
Staff member
Joined
Feb 27, 2003
Messages
8,919
Hello,

We're please to announce that all DirectAdmin and CustomBuild 2.0 now support MySQL 5.7.

Related changes done to DirectAdmin to support it:
https://www.directadmin.com/features.php?id=1840

It was actually added back in DA 1.52.0 (October 2017), while DA 1.53.0 is the current version, but wasn't announced right away to give time for proper testing, which seems to all check out now :)

MAKE SQL BACKUPS BEFORE UPGRADING :) see below.

CustomBuild 2.0 should automatically set the mysql_milestone_16=1 directadmin.conf value for you, so as long as CB2 does the upgrade, you should be fine.

To do the upgrade from an older MySQL version to MySQL 5.7, run:
Code:
cd /usr/local/directadmin/custombuild
./build set mysql 5.7
./build set mysql_inst mysql
./build set mysql_backup yes
./build update

#make a backup that wont be overwritten, rename the folder
./build mysql_backup
mv mysql_backups mysql_backups.`date +%F`

./build mysql
./build php n
service httpd restart
Related guide:
https://help.directadmin.com/item.php?id=240

If you're running MariaDB, then switching to MySQL might not be 100% straightforward, as higher versions of MariaDB cannot be directly switched over. But (for example), if you're running a working MariaDB 5.5, then switch to MySQL 5.5, then switch to MySQL 5.7.

John
 

Hosted Power

New member
Joined
Apr 13, 2018
Messages
4
I must agree, we've been using 5.7 since a few months now and it's very stable. Furthermore it's fast as hell (certainly after our optimizations :D )
 

wattie

Verified User
Joined
May 31, 2008
Messages
991
Location
Bulgaria
Switching from MariaDB 10+ to MySQL 5.6+ is possible through creating backups with third party app like Phpmyadmin. But yes, it's a slow and painful process which is not recommended.

Personally I'll stay with MariaDB as I support the more free software world.
 

dantgal

Verified User
Joined
Jul 11, 2018
Messages
5
Hi!

Tried but:

Code:
Attempting to compile a package from source...
Downloading		mysql-5.7.23.tar.gz...
--2018-09-26 15:39:43--  http://files6.directadmin.com/services/custombuild/mysql/mysql-5.7.23.tar.gz
Resolving files6.directadmin.com (files6.directadmin.com)... 2001:16e8:1:c:62:148:174:106, 62.148.174.106
Connecting to files6.directadmin.com (files6.directadmin.com)|2001:16e8:1:c:62:148:174:106|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2018-09-26 15:39:43 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql-5.7.23.tar.gz does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2018-09-26 15:39:43--  http://69.162.69.58/services/custombuild/mysql/mysql-5.7.23.tar.gz
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2018-09-26 15:39:44 ERROR 404: Not Found.
I have newest DA and custombuild. How to solve this problem?
 

DirectAdmin Support

Administrator
Staff member
Joined
Feb 27, 2003
Messages
8,919
"Cannot find mysql-5.7.27 package for installation"
On all FreeBSD 11.3 64-bit servers.
Please try:
Code:
./build set mysql_force_compile yes
as there are no pre-packed binaries for FreeBSD 11, so it should be auto-compiling... hence if not, forcing it might be what you need. FreeBSD 12 does have the binaries.

John
 
Top