Is it possible to add selector for different mysql versions?
The user can choose mysql 5.5 or 5.6
This is a very useful update
Ryan Leadenham commented
This would be an amazing feature. Particularly on cPanel/WHM because they did not add support for mariadb 10.4 and 10.5 has been released and it looks like they have no plans to implement it. I'd prefer CL was in control of it.
In response to David, I would do it like he described. I'm not sure if mariadb/mysql has the ability to store data in different locations per database, but if it does, it would be nice if the data was in the user's home directory. If not, it's not a deal breaker. As far as transferring data between versions goes, I probably would never do that because the reason I'd want the selector is so I can code new projects toward the newest version without having to upgrade other user's and worry about them breaking. Being able to upgrade at all is a bonus over being stuck with a version forever like we are with cPanel.
How would you implement this yourself if you would do it manually? Would you run two different versions of mysql and do a mysqldump between them? CageFS has a socket file to mysql so that could probably point to the correct version mysql.. but to move the data between them without downtime and locking could be difficult depending on which engine the users tables are using.