Results 1 to 6 of 6

Thread: MySQL 5.7 support

  1. #1

    MySQL 5.7 support

    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

  2. #2
    Join Date
    Apr 2018
    Posts
    2
    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 )

  3. #3
    Join Date
    Mar 2018
    Posts
    60
    Nice to hear. 1 year ago I was written about MySQL 5.7 support

  4. #4
    Join Date
    May 2008
    Posts
    747
    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.

  5. #5
    Join Date
    Jul 2018
    Posts
    3
    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?

  6. #6
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    12,274

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •