MySQL 5.7 support

DirectAdmin Support

Administrator
Staff member
Joined
Feb 27, 2003
Messages
8,965
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

Verified User
Joined
Apr 13, 2018
Messages
5
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
1,041
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,965
"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
 

dudek888

Verified User
Joined
Jun 21, 2009
Messages
27
Location
Szczecin / Poland
Hello,

now servers with CustomBuild 2.0.0 rev.2352 FreeBSD 11.3 x.64 downloading the package for MySQL 5.7.27 but upgrade does not end correctly.
On some servers ended with:

Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed
Done mysql-5.7.27-freebsd11.3-x86_64.

On other servers upgrade ended with:

This installation of MySQL is already upgraded to 5.6.45, use --force if you still need run to run mysql_upgrade
Done mysql-5.7.27-freebsd11.3-x86_64.

In both cases the symlink /usr/local/mysql points to the directory /usr/local/mysql-5.6.45-freebsd11.3-x86_64 instead of the directory /usr/local/mysql-5.7.27-freebsd11.3-x86_64 (wich is created).


Regards
 

smtalk

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,504
Location
LT, EU
May you create a ticket on this? Was it an upgrade from MySQL 5.6?
 
Top