Learn about Centmin Mod LEMP Stack today
Register Now

MariaDB Anyone using MariaDB 10.4.8 on live and busy site?

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by rdan, Sep 18, 2019.

  1. eva2000

    eva2000 Administrator Staff Member

    44,684
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,792
    Local Time:
    9:54 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    yeah MariaDB for last few major versions hasn't been offering up benchmarks as much like they use to unfortunately

    Given how troublesome 10.4 has been, I'd recommend folks hold off of 10.5 until it's gone through at least 20+ minor revision releases and maybe even more given now they have a big plate of work to do for so many major versions they have now.

    MariaDB 10.4+ and higher seem one way upgrades not too easy to downgrade or switch to earlier versions or between forks like Oracle MySQL and Percona MySQL. Personally, I'd probably be sticking with MariaDB 10.3 for much longer.
     
  2. Xon

    Xon Active Member

    170
    61
    28
    Nov 16, 2015
    Ratings:
    +223
    Local Time:
    7:54 PM
    1.15.x
    MariaDB 10.3.x
    And importantly, is this comparing 10.4 to 10.5 or 10.3 to 10.5, Cos 10.4 has some painful performance regressions.
     
  3. negative

    negative Active Member

    397
    49
    28
    Apr 11, 2015
    Ratings:
    +95
    Local Time:
    2:54 PM
    1.9.10
    10.1.11
    But 10.5 still has them, hasn't it ?
     
  4. negative

    negative Active Member

    397
    49
    28
    Apr 11, 2015
    Ratings:
    +95
    Local Time:
    2:54 PM
    1.9.10
    10.1.11
    But 10.5 still has them, hasn't it ?
     
  5. skringjer

    skringjer Member

    144
    17
    18
    Apr 21, 2019
    Ratings:
    +31
    Local Time:
    4:54 PM
    I am on Mariadb 10.3, i guess i can not upgrade to 10.4 or 10.5 right? Because my databases wont work.
     
  6. eva2000

    eva2000 Administrator Staff Member

    44,684
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,792
    Local Time:
    9:54 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Centmin Mod 123.09beta01 and higher support MariaDB 10.4 optional upgrades and eventually will for MariaDB 10.5 MariaDB - MariaDB 10.1 upgrades to MariaDB 10.2, 10.3 and 10.4. but 10.3 is default for stability. The problem is early MariaDB 10.4 and even recent releases have performance regressions which folks may or may not notice (discussed in this thread).

    For stable performance, MariaDB 10.3 seems to be the one to use right now. Haven't tested MariaDB 10.5 yet and 10.4 limited tests myself. I've also got far future plans to support Oracle MySQL/Percona MySQL 8.0.x series too which like MariaDB 10.4/10.5, are not drop-in backwards compatible so choosing any of these would/may be one way upgrade/switches.

    An example switch script for a paid client of mine wanting to switch Centmin Mod over to Oracle MySQL 8 out of the box
    Code (Text):
    ./switch-mysql8.sh
    
    Usage:
    
    switch-mysql8.sh backup
    switch-mysql8.sh check
    switch-mysql8.sh swap
    

    Check for backups prior to swapping MariaDB 10.3 YUM packages for Oracle MySQL 8.0 YUM packages
    Code (Text):
    ./switch-mysql8.sh swap
    
    No backup completion file found at /home/mariadb-to-mysql8-backups
    
    Did you backup your MariaDB MySQL databases first ?
    

    Code (Text):
    mysqladmin  Ver 8.0.18 for Linux on x86_64 (MySQL Community Server - GPL)
    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Server version          8.0.18
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 1 hour 4 min 5 sec
    
    Threads: 2  Questions: 12278  Slow queries: 0  Opens: 347  Flush tables: 3  Open tables: 267  Queries per second avg: 3.193
    
     
  7. skringjer

    skringjer Member

    144
    17
    18
    Apr 21, 2019
    Ratings:
    +31
    Local Time:
    4:54 PM
    This would be awesome, Centmin is always providing the best solutions, thanks eva
     
  8. negative

    negative Active Member

    397
    49
    28
    Apr 11, 2015
    Ratings:
    +95
    Local Time:
    2:54 PM
    1.9.10
    10.1.11
    Kindly waiting that feature on centminmod then :( oracle mysql would be perfect solution.
     
  9. negative

    negative Active Member

    397
    49
    28
    Apr 11, 2015
    Ratings:
    +95
    Local Time:
    2:54 PM
    1.9.10
    10.1.11
    How apply that
    optimizer_use_condition_selectivity=1 parameter ? run the command on mysql service at command line ?
     
  10. eva2000

    eva2000 Administrator Staff Member

    44,684
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,792
    Local Time:
    9:54 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    add it to your /etc/my.cnf under the [mariadb-10.4] group and then restart MariaDB 10.4 mysql server

    FYI, newer 123.09beta01 and higher builds MariaDB 10.4 upgrade routines already have that set by default i.e.
    Code (Text):
    [mariadb-10.4]
    #innodb_file_format = Barracuda
    innodb_default_row_format = dynamic
    innodb_file_per_table = 1
    # performance regressions
    # https://jira.mariadb.org/browse/MDEV-16337
    # https://jira.mariadb.org/browse/MDEV-20697
    #join_cache_level=0
    optimizer_use_condition_selectivity=1
    
     
  11. negative

    negative Active Member

    397
    49
    28
    Apr 11, 2015
    Ratings:
    +95
    Local Time:
    2:54 PM
    1.9.10
    10.1.11
    Thank you

    and i’m still running on mariadb 10.4.8 without problem. it was problem when upgrade to 10.4.10 first, thats why i downgrade it and running well in this version.

    however, after i apply the
    optimizer_use_condition_selectivity=1 parameter, is it safe to upgrade version 10.5? My problem was queries takes long times on big tables.
     
  12. eva2000

    eva2000 Administrator Staff Member

    44,684
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,792
    Local Time:
    9:54 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Centmin Mod doesn't have MariaDB 10.5 upgrade routine in it's centmin.sh menu yet :)
     
  13. negative

    negative Active Member

    397
    49
    28
    Apr 11, 2015
    Ratings:
    +95
    Local Time:
    2:54 PM
    1.9.10
    10.1.11
    So do you advice that Upgrade version to 10.4.13 for now from 10.4.8 with optimizer parameter?

    or i Will wait The 10.5 upgrade feature :confused: