Welcome to Centmin Mod Community
Register Now

MariaDB Official MariaDB 10.3 YUM repo EOL May 25, 2023

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Apr 22, 2023.

  1. eva2000

    eva2000 Administrator Staff Member

    51,742
    11,946
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,438
    Local Time:
    9:43 PM
    Nginx 1.25.x
    MariaDB 10.x
    MariaDB LTS series - Stable (GA) Date/End-of-life
    • 10.11 16 Feb 2023/16 Feb 2028
    • 10.6 6 Jul 2021 6/Jul 2026
    • 10.5 24 Jun 2020/24 Jun 2025
    • 10.4 18 Jun 2019/18 Jun 2024
    • 10.3 25 May 2018/25 May 2023

    CentOS 7.x MariaDB



    Centmin Mod 124.00stable and 130.00beta01 on EL7 systems for CentOS 7.x operating systems use MariaDB's official YUM repo version of MariaDB 10.3.x. This version will be end of life according to MariaDB's official maintenance policy on May 25, 2023 - so a little over a month from now. MariaDB won't be providing updates for this version after May 25, 2023. So the quickest solution is to update to MariaDB 10.4+ via MariaDB's official YUM repo system via centmin.sh menu option 11.

    AlmaLinux 8 / Rocky Linux 8 MariaDB



    Centmin Mod 130.00beta01's private beta tested code for EL8 systems like AlmaLinux 8 and Rocky Linux 8 supported operating system as at September 27, 2022 onwards, switched from official MariaDB YUM repo provided MariaDB 10.3 which has support ending May 25, 2023 to native EL8 Appstream module provided MariaDB 10.3 version which has extended support until May 2029. So technically for EL8 OS users, you can stick with MariaDB 10.3 branch version until May 2029 if you want. Though Centmin Mod EL8 OS users can also update to MariaDB 10.4+ via MariaDB's official YUM repo system via centmin.sh menu option 11.

    Why MariaDB 10.3 still?




    I've stuck with MariaDB 10.3 as long as I can due to MariaDB 10.4+ moving further away from being a 100% drop-in compatible MySQL (Oracle) server so features or changes in MariaDB 10.4+ may not allow an easy downgrade to other MySQL server versions or forks or make importing non-MariaDB MySQL data from Oracle or Percona MySQL into MariaDB 10.4+ go smoothly. Details at MariaDB - Interesting look at what's new in MariaDB 10.4. This isn't much of an issue you only ever plan on using MariaDB MySQL i.e. MariaDB 10.3 to 10.4 to 10.5 to 10.6 and don't intend to switch to Oracle MySQL or Percona MySQL versions.

    Also MariaDB 10.4+ had a history of performance regressions.

    Install Centmin Mod with MariaDB 10.4+ Defaults



    If you are installing new Centmin Mod installations and want to default MariaDB 10.4+ or higher versions out of the box, you can do that by overriding centmin.sh menu defaults via creating or editing your persistent config file /etc/centminmod/custom_config.inc and directory BEFORE initial Centmin Mod install and placing the appropriate override variables in place.

    For instance

    To install MariaDB 10.6 default set in your persistent config file /etc/centminmod/custom_config.inc the following:
    Code (Text):
    MARIADB_INSTALLTENTHREE='n'
    MARIADB_INSTALLTENFOUR='n'
    MARIADB_INSTALLTENFIVE='n'
    MARIADB_INSTALLTENSIX='y'
    

    Or to install MariaDB 10.5 default set in your persistent config file /etc/centminmod/custom_config.inc the following:
    Code (Text):
    MARIADB_INSTALLTENTHREE='n'
    MARIADB_INSTALLTENFOUR='n'
    MARIADB_INSTALLTENFIVE='y'
    MARIADB_INSTALLTENSIX='n'
    

    Or to install MariaDB 10.4 default set in your persistent config file /etc/centminmod/custom_config.inc the following:
    Code (Text):
    MARIADB_INSTALLTENTHREE='n'
    MARIADB_INSTALLTENFOUR='y'
    MARIADB_INSTALLTENFIVE='n'
    MARIADB_INSTALLTENSIX='n'
    

    Once the persistent config file override variables are set, proceed to install Centmin Mod on a fresh OS system.

    What's the plan for the future?



    After May 25, 2023 I'll have to decide on what to do.
    • Do I update from 124.00stable to newer 124.10stable release and make MariaDB 10.4 the default?
    • For 130.00beta01 do I update to MariaDB 10.4 default for CentOS 7 installs and also do the same for EL8 installs to default to MariaDB 10.4 official which is EOL on June 18, 2024 next year or stick with MariaDB 10.3 via native EL8 AppStream which is supported until May 2029?
     
  2. rdan

    rdan Well-Known Member

    5,434
    1,395
    113
    May 25, 2014
    Ratings:
    +2,181
    Local Time:
    7:43 PM
    Mainline
    10.2
    10.6.x is very stable for several large forums I manage.
     
  3. deltahf

    deltahf Premium Member Premium Member

    576
    259
    63
    Jun 8, 2014
    Ratings:
    +475
    Local Time:
    7:43 AM
    Good to know. XenForo 2.2 I presume?

    I've been on 10.4 for a while now with no issues but might consider upgrading.
     
  4. rdan

    rdan Well-Known Member

    5,434
    1,395
    113
    May 25, 2014
    Ratings:
    +2,181
    Local Time:
    7:43 PM
    Mainline
    10.2
    Yes all 2.2.x.
     
  5. duderuud

    duderuud Premium Member Premium Member

    196
    71
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +150
    Local Time:
    1:43 PM
    1.25 x
    10.6
    I'm running 10.6 without issues too.

    Also a large forum (30mln+ posts).
     
  6. Itworx4me

    Itworx4me Active Member

    289
    27
    28
    Mar 14, 2017
    Ratings:
    +47
    Local Time:
    4:43 AM
    Nginx 1.25.X
    MariaDB 10.6.X
    @eva2000 if I am on 10.3 and want to move to 10.6. How would I do that? I tried through the control panel but I get this message when trying to perform the upgrade:

    Code (Text):
    Place holder for now until MariaDB 10.4.x is ready to be added
    10.4 officially supported until June 2024
    https://mariadb.com/kb/en/changes-improvements-in-mariadb-104/
    
    Discussions https://community.centminmod.com/tags/mariadb-104/
     
  7. eva2000

    eva2000 Administrator Staff Member

    51,742
    11,946
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,438
    Local Time:
    9:43 PM
    Nginx 1.25.x
    MariaDB 10.x
    Did you read the instructions in the linked thread ;)

    For Centmin Mod 130.00beta01 and upgrades for MariaDB 10.5 & 10.6
    Code (Text):
    ENABLE_MARIADBTENFIVEUPGRADE='y'
    ENABLE_MARIADBTENSIXUPGRADE='y'
     
  8. eva2000

    eva2000 Administrator Staff Member

    51,742
    11,946
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,438
    Local Time:
    9:43 PM
    Nginx 1.25.x
    MariaDB 10.x
  9. Matt

    Matt Well-Known Member

    906
    409
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +658
    Local Time:
    12:43 PM
    1.5.15
    MariaDB 10.2
    Successfully upgraded a few servers from 10.3 to 10.6 this morning. Thanks for all your continued work on this @eva2000 (y)
     
  10. eva2000

    eva2000 Administrator Staff Member

    51,742
    11,946
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,438
    Local Time:
    9:43 PM
    Nginx 1.25.x
    MariaDB 10.x
    Great to hear, all the way to MariaDB 10.6 :)
     
  11. deltahf

    deltahf Premium Member Premium Member

    576
    259
    63
    Jun 8, 2014
    Ratings:
    +475
    Local Time:
    7:43 AM
    Feeling kind of silly... I can't seem to figure out how to do a 10.4 to 10.6 upgrade on 124.00stable?

    My /etc/centminmod/custom_config.inc file looks like this but I'm not seeing anything new in the option #11 menu.

    Code (Text):
    PHP_PGO='y'
    ENABLE_MARIADBTENFIVEUPGRADE='y'
    ENABLE_MARIADBTENSIXUPGRADE='y'
    
     
  12. eva2000

    eva2000 Administrator Staff Member

    51,742
    11,946
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,438
    Local Time:
    9:43 PM
    Nginx 1.25.x
    MariaDB 10.x
    Once you enable the 2 10.5 and 10.6 variables, you just go through each centmin.sh menu option 11 upgrade options for 10.4 to 10.5 and then go through 10.5 to 10.6 as outlined at https://community.centminmod.com/threads/mariadb-10-1-upgrades-to-mariadb-10-2-10-3-and-10-4.17793/

    In future once I add MariaDB 10.7+ support to get to MariaDB 10.11, you would need to do the same, update from 10.6 to 10.7, 10.7 to 10.8, 10.8 to 10.9, 10.9 to 10.10, and finally 10.10 to 10.11! You can't really skip major version updates as it successively updates and changes your MariaDB MySQL system tables so you need all those changes.
     
  13. deltahf

    deltahf Premium Member Premium Member

    576
    259
    63
    Jun 8, 2014
    Ratings:
    +475
    Local Time:
    7:43 AM
    That's where I am getting confused. I don't see the 10.4 to 10.5 options appearing in the menu on 124.00stable after including those variables. :( I feel like there must something simple I'm overlooking...

    Code (Text):
    root ~ $ cat /etc/centminmod/custom_config.inc
    PHP_PGO='y'
    ENABLE_MARIADBTENFIVEUPGRADE='y'
    ENABLE_MARIADBTENSIXUPGRADE='y'
    
    root ~ $ centmin
    /usr/local/src/centminmod ~
    
    --------------------------------------------------------
         Centmin Mod Menu 124.00stable centminmod.com
    --------------------------------------------------------
    1).  Centmin Install
    2).  Add Nginx vhost domain
    3).  NSD setup domain name DNS
    4).  Nginx Upgrade / Downgrade
    5).  PHP Upgrade / Downgrade
    6).  XCache Re-install
    7).  APC Cache Re-install
    8).  XCache Install
    9).  APC Cache Install
    10). Memcached Server Re-install
    11). MariaDB MySQL Upgrade & Management
    12). Zend OpCache Install/Re-install
    13). Install/Reinstall Redis PHP Extension
    14). SELinux disable
    15). Install/Reinstall ImagicK PHP Extension
    16). Change SSHD Port Number
    17). Multi-thread compression: zstd,pigz,pbzip2,lbzip2
    18). Suhosin PHP Extension install
    19). Install FFMPEG and FFMPEG PHP Extension
    20). NSD Install/Re-Install
    21). Data Transfer (TBA)
    22). Add Wordpress Nginx vhost + Cache Plugin
    23). Update Centmin Mod Code Base
    24). Exit
    --------------------------------------------------------
    Enter option [ 1 - 24 ] 11
    --------------------------------------------------------
    
    --------------------------------------------------------
         MariaDB MySQL Upgrade & Management Sub-Menu
    --------------------------------------------------------
    0). Regenerate New MySQL Root User Password (local server)
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
    5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
    6). MariaDB 10.1.x to MariaDB 10.2.x YUM upgrade
    7). MariaDB 10.2.x to MariaDB 10.3.x YUM upgrade
    8). MariaDB 10.3.x to MariaDB 10.4.x YUM upgrade
    9). Back to Main menu
    --------------------------------------------------------
    Enter option [ 0 - 9 ]
    
     
  14. eva2000

    eva2000 Administrator Staff Member

    51,742
    11,946
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,438
    Local Time:
    9:43 PM
    Nginx 1.25.x
    MariaDB 10.x
    MariaDB 10.5 and 10.6 only supported in Centmin Mod 130.00beta01 only ;)