Join the community today
Register Now

MariaDB 10.11

Discussion in 'AlmaLinux 8 & Rocky Linux 8 Beta Testing' started by duderuud, Jun 20, 2023.

  1. duderuud

    duderuud Premium Member Premium Member

    215
    76
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +163
    Local Time:
    7:58 AM
    1.25 x
    10.6
    Hi @eva2000, MariaDB 10.11 is out for a few months now and is the latest LTS version.

    Would it be possible to add 10.11 to CMM?

     
  2. eva2000

    eva2000 Administrator Staff Member

    52,784
    12,080
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,607
    Local Time:
    3:58 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Eventually, yes, but haven't gotten around to specific MariaDB 10.11 testing and going through all it's relevant documentation/changes etc :)

    Coincidentally, the last web page I was reading prior to this reply was MariaDB documentation and MariaDB Jira bug tracker :D

    My MariaDB Jira bug tracker filter for MariaDB 10.4, 10.5, 10.6 and 10.11 regression bugs :)

    upload_2023-6-20_18-19-16.png

    I have to be me familiar with each version's changes and deprecated features and outstanding bugs and regressions.

    For example, just new options added between versions would be

    so new variables and even changes to the existing default variable's values can change how MariaDB performs and behaves from 10.6, 10.7, 10.8, 10.9, 10.10 and 10.11 onwards. I've already discovered a few changes from MariaDB 10.7-10.10 that will impact 10.11 defaults compared to pre-10.6.
     
  3. duderuud

    duderuud Premium Member Premium Member

    215
    76
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +163
    Local Time:
    7:58 AM
    1.25 x
    10.6
    Quite a lot of changes, that's a bummer.
    But thanks for the hard work!
     
  4. duderuud

    duderuud Premium Member Premium Member

    215
    76
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +163
    Local Time:
    7:58 AM
    1.25 x
    10.6
    Any updates?
     
  5. eva2000

    eva2000 Administrator Staff Member

    52,784
    12,080
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,607
    Local Time:
    3:58 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    None right now. EL8+ development is a priority :)
     
  6. buik

    buik “The best traveler is one without a camera.”

    1,982
    517
    113
    Apr 29, 2016
    Flanders
    Ratings:
    +1,644
    Local Time:
    7:58 AM
    Now with 10.11, we are some versions ahead. What is the status on MariaDB increasingly choosing its own path. And specifically the compatibility vs. MySQL?
     
  7. eva2000

    eva2000 Administrator Staff Member

    52,784
    12,080
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,607
    Local Time:
    3:58 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Oracle MySQL and MariaDB MySQL have diverged a lot since their respective versions 8.0 vs 10.4+. However, performance isn't just about what you use but how you use it. So if you stick with MariaDB MySQL and understand what each major version releases bring feature wise and configuration settings wise, it should not be a problem for most folks. Unless they have a specific MySQL web app that only supports/gurantees to work with Oracle MySQL 8.0
     
  8. duderuud

    duderuud Premium Member Premium Member

    215
    76
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +163
    Local Time:
    7:58 AM
    1.25 x
    10.6
    Saw the announcement so tried to update to 10.11 but it's only a placeholder for now, bummer :)

    Guess it's coming soon, that is a good thing!
     
  9. rdan

    rdan Well-Known Member

    5,439
    1,396
    113
    May 25, 2014
    Ratings:
    +2,185
    Local Time:
    1:58 PM
    Mainline
    10.2
    10.11 seems very stable for, been using it since 1st week of May.

    upload_2024-7-5_21-34-32.png
     
  10. duderuud

    duderuud Premium Member Premium Member

    215
    76
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +163
    Local Time:
    7:58 AM
    1.25 x
    10.6
    Good to hear. I'm waiting for CMM support because I don't want to install/compile it manually.
     
  11. eva2000

    eva2000 Administrator Staff Member

    52,784
    12,080
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,607
    Local Time:
    3:58 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    You don't need to compile MariaDB manually. Centmin Mod installs MariaDB via MariaDB YUM RPMs. So technically the normal YUM RPM upgrade tasks can be done manually - just you have to 100% aware of what variables and options if any are deprecated between MariaDB major versions and/or the impact of changes to default values for variables and/or changes if how a variable functions and how it all impacts your existing MariaDB MySQL installation. For example MariaDB 10.11 has renamed some of the variable names, so if you used the old ones, MariaDB MySQL will not start up. One example [MDEV-7567] rename slow queries variables - Jira

    MariaDB pre-10.11.1 variables
    Code (Text):
    mysqladmin var | tr -s ' ' | egrep 'min_examined_row_limit|slow_query_log|slow_query_log_file|long_query_time'
    | long_query_time | 1.000000 |
    | min_examined_row_limit | 0 |
    | slow_query_log | OFF |
    | slow_query_log_file | /var/lib/mysql/slowq.log |
    

    Centmin Mod <10.6 set relevant variables from this example that will change
    Code (Text):
    cat -n /etc/my.cnf | egrep 'min_examined_row_limit|slow_query_log|slow_query_log_file|long_query_time'
        66  slow_query_log=0
        67  long_query_time=1
        68  slow_query_log_file=/var/lib/mysql/slowq.log
    


    So imagine having to read all documentation and JIRA bug tracker relevant regression/bugs from MariaDB 10.6, 10.7, 10.8, 10.9, 11.0, 11.1, 11.2, 11.3, 11.4 for such changes and account for them and then test for all possible upgrade steps.

    So yes 140.00beta01 will add eventually have MariaDB 10.11 non-LTS and MariaDB 11.4 LTS support. Testing behind private flag for now as I have to make sure any deprecated variables between MariaDB major versions are accounted for in the automated upgrade routines to ensure MariaDB MySQL server survives and can start back up after upgrade. MariaDB is one of those that newest isn't always the best as there are many cases of performance regressions and feature regressions in the past, so always good to let some time go by for folks to iron them out :)

    Code (Text):
    --------------------------------------------------------
    --------------------------------------------------------
         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). MariaDB 10.4.x to MariaDB 10.5.x YUM upgrade
    10). MariaDB 10.5.x to MariaDB 10.6.x LTS YUM upgrade
    11). MariaDB 10.6.x to MariaDB 10.11.x YUM upgrade
    12). MariaDB 10.6.x to MariaDB 11.4.x LTS YUM upgrade
    13). MariaDB 10.11.x to MariaDB 11.4.x LTS YUM upgrade
    14). Back to Main menu
    --------------------------------------------------------
    Enter option [ 0 - 14 ]
    --------------------------------------------------------
    


     
  12. duderuud

    duderuud Premium Member Premium Member

    215
    76
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +163
    Local Time:
    7:58 AM
    1.25 x
    10.6
    Thanks for the info...gives me cold feet so I hold it off for now ;)