Koozali.org: home of the SME Server

Contribs.org Forums => Koozali SME Server 10.x Contribs => Topic started by: jameswilson on April 26, 2024, 01:10:22 PM

Title: preferred mariadb/mysql version
Post by: jameswilson on April 26, 2024, 01:10:22 PM

Using the contrib to have multiple versions which is going to be best for speed for website use.
I aonly ask as i already have added 5.7.24 but wonder (in my limited knowledge) if adding another is a bad idea.

Anyhow thanks for the wonderful project

James

Title: Re: preferred mariadb/mysql version
Post by: Jean-Philippe Pialasse on April 26, 2024, 02:44:21 PM

you should stick with the need of your apps. If they need let’s say mariadb 10.5 then use the contrib. If they are fine with mariadb 5.5 then stick with it as migration will be easier to next SME.
For the moment we do not have any process to restore contrib provided database, so this implies a manual process to push the dump to your new db after migration, and decide in which one.

The hardware of your server could impose a limit ik the number of process running, but nowadays even if you only have a version only, systemd is designed to run multiple instance of the same service. so the model now is less one sever to serve all apps, but one mariadb server per app.
you do not have to move this way and this is mot the current direction we take, but this is to put in perspective.

Title: Re: preferred mariadb/mysql version
Post by: jameswilson on April 26, 2024, 06:10:30 PM

Thanks JP
Im staying with mysql 57

Thanks