Koozali.org: home of the SME Server

preferred mariadb/mysql version

Offline jameswilson

  • *
  • 791
  • +0/-0
    • Security Warehouse, trade security equipment
preferred mariadb/mysql version
« 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

Offline Jean-Philippe Pialasse

  • *
  • 2,852
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: preferred mariadb/mysql version
« Reply #1 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.

Offline jameswilson

  • *
  • 791
  • +0/-0
    • Security Warehouse, trade security equipment
Re: preferred mariadb/mysql version
« Reply #2 on: April 26, 2024, 06:10:30 PM »
Thanks JP
Im staying with mysql 57

Thanks