MySQL 5.7 Upgrade

Because MySQL 5.7 is not a "Generally Available Release" yet, it's still a "Milestone Release", meaning it is to be considered a beta release. The newest Current Generally Available Release of MySQL is 5.6.x http://dev.mysql.com/downloads/mysql/
 
As 5.7 went GA today, what's the timeline for Custombuild inclusion? The faq doesn't mention it right now, despite PHP 7 being available since RC1.
 
Looks like they've dropped the generic rpms... so it gets a bit messy (and huge) to manage it in CB/files1 as it's about 500 meg of rpms per OS type... 32-bit, 64-bit, multiplied by el5, el6, el7, so that's roughly 3 gig per version (not impossible, but quite a lot of data)
We'll have to decide if we'll move CB to use their "MySQL yum repo", which might make life easier anyway... or just download straight from a MySQL mirror via CB, instead of files.da (which might have a tendency to break if they change mirror names).
So, not sure yet.

John
 
They're also offering architecture-independent repositories for all other major distros now though: Debian 7+8/Ubuntu 12/14/15 for example.

Seems like a good idea to just let CustomBuild install the proper apt/yum bindings for the given platform and use that?

(to be honest I never understood why DirectAdmin doesn't distribute its own packages via apt/yum to begin with, would make this all so much easier, and more manageable to server admins - just use custombuild as a front-end to select specific package combinations from apt.directadmin.com)

Another option is to use redirects - http://files.directadmin.com/debian/mysql/5.7.9/latest.tar could just redirect 303 to http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-server_5.7.9-1debian8_amd64.deb-bundle.tar, that way you can just keep a central list of redirects, which you could autocheck by cron using HEAD requests against breakage. Those links seem rather 'perma' though.
 
Last edited:
Any updates on this? I'm planning rollout of a new server 'soonish' when PHP7 is officially stable, and would like to go MySQL 5.7 in one go if possible.
 
We're still on the fence about how we're going to do it. I'll discuss with Martynas.
Worst case (and for now) you'd just install MySQL normally, and upgrade to 5.7 via rpms, followed by the mysql_upgrade command.

John
 
We're still on the fence about how we're going to do it. I'll discuss with Martynas.
Worst case (and for now) you'd just install MySQL normally, and upgrade to 5.7 via rpms, followed by the mysql_upgrade command.

John

Why not add MariaDB as an alternative to MySQL?
It supports mysql databases plus it's an improvement over the standard mysql.
 
Is there an estimate or roadmap available for the support of Mysql 5.7? Knowing if the support is going to take another month, an half year or a full year or even more would help me a lot.
 
Ah well. Guess DirectAdmin should officially encourage MariaDB over MySQL then - which wouldn't be all bad!
 
Back
Top