/ Register

Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB Official MariaDB 10.3 YUM repo EOL May 25, 2023

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

Tags:
Previous Thread Next Thread
Loading...
  1. Apr 22, 2023 #1
    eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:55 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Apr 23, 2023 #2
    rdan

    rdan Well-Known Member

    5,439
    1,397
    113
    May 25, 2014
    Ratings:
    +2,186
    Local Time:
    6:55 PM
    Mainline
    10.2
    10.6.x is very stable for several large forums I manage.
     
  3. Apr 23, 2023 #3
    deltahf

    deltahf Premium Member Premium Member

    581
    264
    63
    Jun 8, 2014
    Ratings:
    +482
    Local Time:
    6:55 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. Apr 23, 2023 #4
    rdan

    rdan Well-Known Member

    5,439
    1,397
    113
    May 25, 2014
    Ratings:
    +2,186
    Local Time:
    6:55 PM
    Mainline
    10.2
    Yes all 2.2.x.
     
  5. Apr 24, 2023 #5
    duderuud

    duderuud Premium Member Premium Member

    220
    78
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +166
    Local Time:
    12:55 PM
    1.25 x
    10.6
    I'm running 10.6 without issues too.

    Also a large forum (30mln+ posts).
     
  6. Apr 28, 2023 #6
    Itworx4me

    Itworx4me Active Member

    299
    27
    28
    Mar 14, 2017
    Ratings:
    +48
    Local Time:
    3:55 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. Apr 28, 2023 #7
    eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:55 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Jul 20, 2023 #8
    eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:55 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  9. Jul 21, 2023 #9
    Matt

    Matt Well-Known Member

    925
    414
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +669
    Local Time:
    11:55 AM
    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. Jul 23, 2023 #10
    eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:55 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Great to hear, all the way to MariaDB 10.6 :)
     
  11. Aug 30, 2023 #11
    deltahf

    deltahf Premium Member Premium Member

    581
    264
    63
    Jun 8, 2014
    Ratings:
    +482
    Local Time:
    6:55 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. Sep 2, 2023 #12
    eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:55 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Sep 9, 2023 #13
    deltahf

    deltahf Premium Member Premium Member

    581
    264
    63
    Jun 8, 2014
    Ratings:
    +482
    Local Time:
    6:55 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. Sep 10, 2023 #14
    eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:55 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    MariaDB 10.5 and 10.6 only supported in Centmin Mod 130.00beta01 only ;)
     
Previous Thread Next Thread
Loading...

.