MySQL 5.7 support

DirectAdmin Support

Administrator
Staff member
Joined
Feb 27, 2003
Messages
9,158
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
 
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 )
 
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.
 
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?
 
"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
 
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
 
May you create a ticket on this? Was it an upgrade from MySQL 5.6?
 
Hello,
Upgrading from 5.6, FBSD 11.3 :

Code:
[100%] Built target pfs_connect_attr-t
Make complete
Packaging mysql-5.7.27...
CPack: Create package using TGZ
CPack: Install projects
CPack: - Run preinstall target for: MySQL
CPack: - Install project: MySQL
CPack: Create package
CPack: - package: /usr/local/directadmin/custombuild/mysql-5.7.27/mysql-5.7.27-freebsd11.3-x86_64.tar.gz generated.
Moving mysql-5.7.27-*.tar.gz to /usr/local/directadmin/custombuild ...
Done.
Cannot find mysql-5.7.27-freebsd11-x86_64.tar.gz for installation

Code:
# ls -lha mysql-5.7.27-freebsd*.tar.gz
-rw-r--r--  1 root  wheel     0B 27 maj 14:02 mysql-5.7.27-freebsd11-x86_64.tar.gz
-rw-r--r--  1 root  wheel   487M 27 maj 14:47 mysql-5.7.27-freebsd11.3-x86_64.tar.gz
what to do?
Best regards!
 
May I ask please how I can change the download dir as it always fails with:

Cannot find mysql-5.7.31-linux-glibc2.12-x86_64 package for installation

custombuild looks for files under:


while it should be:

I tried downloading the above but each time I run the ./build mysql it downloads the wrong one.
 
Btw a short side note: There's MySQL 5.7.32 (2020-10-19, General Availability) already.
 
Back
Top