Discover Centmin Mod today
Register Now

MariaDB MariaDB 10.6 support on Centminmod

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by happyhacking, Nov 29, 2021.

  1. happyhacking

    happyhacking New Member

    28
    7
    3
    Apr 23, 2021
    Ratings:
    +15
    Local Time:
    6:20 AM
    1.19.10
    MariadDB 10.4.18
    Hi, i would like to know if there is an upgrade path to MariaDB 10.6 from 10.4 in centminmod or if this will supported in the near future, since 10.6 is the current stable series of MariaDB.

     
  2. eva2000

    eva2000 Administrator Staff Member

    47,843
    10,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,957
    Local Time:
    10:20 PM
    Nginx 1.21.x
    MariaDB 10.x
  3. happyhacking

    happyhacking New Member

    28
    7
    3
    Apr 23, 2021
    Ratings:
    +15
    Local Time:
    6:20 AM
    1.19.10
    MariadDB 10.4.18
    Thank you so much for your kindly answer, didnt know all this implications for upgrading which causes on me, another question: It would be easier to implement MariaDB 10.6 plus centminmod from a clean host install ? Or Can i install MariaDB 10.6/Percona Server prior to installing centminmod ? Im figuring this out since i’ll have to prepare about 11 servers for the first time setup, and want to have the latest software since they will be supported on remaining life of centos 7.9
     
  4. eva2000

    eva2000 Administrator Staff Member

    47,843
    10,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,957
    Local Time:
    10:20 PM
    Nginx 1.21.x
    MariaDB 10.x
    The comments I made regarding upgrading apply to fresh installs too - meaning if you use MariaDB 10.4, 10.5 or 10.6 out of the box it's one way with less chance of cleanly switching to non-MariaDB versions if you ever decide to. Meaning if you want to switch to Oracle MySQL 8 down the road in future or switch away from Centmin Mod, you'd have to stick with MariaDB.

    With MariaDB 10.3, there's more a chance of being able to switch so keeps your options open. Also performance regressions in MariaDB 10.4+ do exist so you could have less performance than MariaDB 10.3 for some work loads. Hence, why I like to wait for MariaDB folks to sort that out.

    Latest versions aren't always best when it comes to MariaDB - examples see issues for MariaDB 10.4 https://community.centminmod.com/threads/anyone-using-mariadb-10-4-8-on-live-and-busy-site.18327/
     
  5. eva2000

    eva2000 Administrator Staff Member

    47,843
    10,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,957
    Local Time:
    10:20 PM
    Nginx 1.21.x
    MariaDB 10.x
    Not really. Centmin Mod installs MariaDB from official MariaDB YUM repo not CentOS own YUM version and then automatically does tests are initial install time to auto optimise MariaDB MySQL settings in /etc/my.cnf based on the detected server's CPU, memory and disk performance information. This optimises MariaDB MySQL for server specs but still leaves optimisations for web apps to your own choices. But it's one reason why Centmin Mod performs way better than other LEMP stacks out of the box and in general even without web app specific optimisations as the basic auto optimised defaults are better.
     
  6. happyhacking

    happyhacking New Member

    28
    7
    3
    Apr 23, 2021
    Ratings:
    +15
    Local Time:
    6:20 AM
    1.19.10
    MariadDB 10.4.18
    Wow, its too many variables to evaluate, thanks for the time to explain them; then, would you recommend to stay with MariaDB 10.3 for performance and compatibility?
     
  7. eva2000

    eva2000 Administrator Staff Member

    47,843
    10,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,957
    Local Time:
    10:20 PM
    Nginx 1.21.x
    MariaDB 10.x
  8. happyhacking

    happyhacking New Member

    28
    7
    3
    Apr 23, 2021
    Ratings:
    +15
    Local Time:
    6:20 AM
    1.19.10
    MariadDB 10.4.18
    Following your advice i did use a clean install of centos 7.9 then installed Centminmod with MARIADB_INSTALLTENTHREE='y' and it failed to run MariaDB 10.3 with this error:

    Code:
    [root@731661 ~]# systemctl status mariadb.service
    ● mariadb.service - MariaDB 10.3.32 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf, openfileslimit.conf, protecthome.conf
       Active: failed (Result: exit-code) since Tue 2021-12-07 03:33:10 UTC; 14s ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
      Process: 19971 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
      Process: 19702 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
      Process: 19699 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
     Main PID: 19971 (code=exited, status=1/FAILURE)
       Status: "MariaDB server is down"
    
    I did this twice using another server with the same result, but when i use MARIADB_INSTALLTENFOUR='y' everything works as usual.
     
  9. eva2000

    eva2000 Administrator Staff Member

    47,843
    10,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,957
    Local Time:
    10:20 PM
    Nginx 1.21.x
    MariaDB 10.x