MariaDB 10.11

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

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



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.

 

None right now. EL8+ development is a priority

 

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

 

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 ]
--------------------------------------------------------

• Changes and Improvements in MariaDB 10.11
• Changes and Improvements in MariaDB 11.4