Welcome to Centmin Mod Community
Register Now

MariaDB 10.4+ Upgrades Testing

Discussion in 'AlmaLinux 8 & Rocky Linux 8 Beta Testing' started by eva2000, Sep 23, 2022.

Thread Status:
Not open for further replies.
  1. eva2000

    eva2000 Administrator Staff Member

    51,981
    11,976
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,473
    Local Time:
    2:55 PM
    Nginx 1.25.x
    MariaDB 10.x
    The initial for Centmin Mod 130.00beta01 on EL8+ OSes is to still support MariaDB MySQL server major version release upgrades via centmin.sh menu option 11 as outlined at https://community.centminmod.com/threads/mariadb-10-1-upgrades-to-mariadb-10-2-10-3-and-10-4.17793/.


    Right now MariaDB 10.3 is the default in 130.00beta01 for out of the box installations. But you can override this version provided the appropriate hidden variable enablement flags are set first via the persistent config file /etc/centminmod/custom_config.inc for either:
    1. Initial install time or
    2. Upgrade via centmin.sh menu option 11 after initial installation.
    Both methods need testing during this beta testing too ;)

    Initial Install Default Override



    For the initial install override, you'd have the following relevant variables to set in the persistent config file /etc/centminmod/custom_config.inc BEFORE initial Centmin Mod install. Any issues with this, I'd need the initial install logs for inspection as per https://community.centminmod.com/threads/how-to-troubleshoot-centmin-mod-initial-install-issues.102/

    So for MariaDB 10.4 default
    Code (Text):
    MARIADB_INSTALLTENTHREE='n'
    MARIADB_INSTALLTENFOUR='y'
    MARIADB_INSTALLTENFIVE='n'
    MARIADB_INSTALLTENSIX='n'
    

    for MariaDB 10.5 default
    Code (Text):
    MARIADB_INSTALLTENTHREE='n'
    MARIADB_INSTALLTENFOUR='n'
    MARIADB_INSTALLTENFIVE='y'
    MARIADB_INSTALLTENSIX='n'
    

    for MariaDB 10.6 default
    Code (Text):
    MARIADB_INSTALLTENTHREE='n'
    MARIADB_INSTALLTENFOUR='n'
    MARIADB_INSTALLTENFIVE='n'
    MARIADB_INSTALLTENSIX='y'
    


    For Post Initial Install Upgrades



    For upgrading MariaDB 10.3 default after the initial install, you have the following 3 variables to be set in the persistent config file /etc/centminmod/custom_config.inc BEFORE running centmin.sh menu option 11. Any issues, I'd need the MariaDB upgrade logs for inspecting which will be automatically saved at /root/centminlogs. You can use the below outlined cminfo listlogs command to find the log name quickly.
    Code (Text):
    ENABLE_MARIADBTENFOURUPGRADE='y'
    ENABLE_MARIADBTENFIVEUPGRADE='y'
    ENABLE_MARIADBTENSIXUPGRADE='y'
    

    You can't skip major versions when upgrading. So to upgrade to MariaDB 10.6, you need to upgrade from 10.3 to 10.4, then 10.4 to 10.5 and then 10.5 to 10.6.

    cminfo listlogs



    cminfo command has many useful tools, one is the listlogs command
    Code (Text):
    cminfo listlogs

    Running this command will list all auto saved logs at /root/centminlogs in date timestamp ascending order (latest logs are listed last).

    So to find MariaDB upgrade logs from centmin.sh menu option 11 runs are easy.
    Code (Text):
    cminfo listlogs | grep mariadb
    -rw-r--r--  1 root root    63 Oct 15  2020 centminmod_123.09beta01.b603_151020-233804_mariadb_10-1-to-10-2_upgrade.log
    -rw-r--r--  1 root root   17K Oct 15  2020 centminmod_123.09beta01.b603_151020-233923_mariadb_10-1-to-10-2_upgrade.log
    -rw-r--r--  1 root root   35K Oct 16  2020 centminmod_123.09beta01.b604_161020-010547_mariadb_10-2-to-10-3_upgrade.log
    

    So centmin.sh menu option 11 run for MariaDB 10.2 to 10.3 upgrade on 123.09beta01.b604 increment version has a file name = centminmod_123.09beta01.b604_161020-010547_mariadb_10-2-to-10-3_upgrade.log located at /root/centminlogs/centminmod_123.09beta01.b604_161020-010547_mariadb_10-2-to-10-3_upgrade.log

    On AlmaLinux 8 with Centmin Mod 13000beta01 upgrade runs from centmin.sh menu option 11 for submenu options 8, 9 and 10 for 10.3 to 10.4, 10.4 to 10.5 and 10.5 to 10.6 upgrades.
    Code (Text):
    cminfo listlogs | grep mariadb
    -rw-r--r--. 1 root root   42 Sep 22 17:08 centminmod_130.00beta01.b203_220922-170805_mariadb_10-3-to-10-4_upgrade.log
    -rw-r--r--. 1 root root  31K Sep 22 17:18 centminmod_130.00beta01.b204_220922-171640_mariadb_10-3-to-10-4_upgrade.log
    -rw-r--r--. 1 root root  33K Sep 22 17:21 centminmod_130.00beta01.b204_220922-171937_mariadb_10-4-to-10-5_upgrade.log
    -rw-r--r--. 1 root root  33K Sep 22 17:24 centminmod_130.00beta01.b204_220922-172230_mariadb_10-5-to-10-6_upgrade.log
    


    To find the initial install log, it would usually be the very first entry named *_install.log in the date ascending listing.
    Code (Text):
    cminfo listlogs | grep _install.log | head -n1


    Example of centmin.sh menu option 11 MariaDB 10.3 to 10.4 to 10.5 to 10.6 final update
    Code (Text):
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.6.10-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.6.10-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 1 min 14 sec
    
    Threads: 1  Questions: 2  Slow queries: 0  Opens: 17  Open tables: 10  Queries per second avg: 0.027
    

    Code (Text):
    rpm -qa MariaDB-* galera-*
    
    MariaDB-common-10.6.10-1.el8.x86_64
    MariaDB-server-10.6.10-1.el8.x86_64
    galera-4-26.4.12-1.el8.x86_64
    MariaDB-devel-10.6.10-1.el8.x86_64
    MariaDB-compat-10.6.10-1.el8.x86_64
    MariaDB-client-10.6.10-1.el8.x86_64
    MariaDB-shared-10.6.10-1.el8.x86_64
    

    Code (Text):
    mysqlstatus
    Redirecting to /bin/systemctl status mariadb.service
    ● mariadb.service - MariaDB 10.6.10 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf, notifyaccess.conf, openfileslimit.conf, protecthome.conf
       Active: active (running) since Thu 2022-09-22 17:24:36 UTC; 7min ago
         Docs: man:mariadbd(8)
               https://mariadb.com/kb/en/library/systemd/
     Main PID: 515829 (mariadbd)
       Status: "Taking your SQL requests now..."
        Tasks: 8 (limit: 24752)
       Memory: 40.2M
       CGroup: /system.slice/mariadb.service
               └─515829 /usr/sbin/mariadbd
    
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] InnoDB: 10.6.10 started; log sequence number 1637412; transaction id 39
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] Plugin 'FEEDBACK' is disabled.
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] InnoDB: Buffer pool(s) load completed at 220922 17:24:36
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] Server socket created on IP: '0.0.0.0'.
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] Server socket created on IP: '::'.
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] /usr/sbin/mariadbd: ready for connections.
    Sep 22 17:24:36 build.domain.com mariadbd[515829]: Version: '10.6.10-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
    Sep 22 17:24:36 build.domain.com systemd[1]: Started MariaDB 10.6.10 database server.
    
     
    Last edited: Sep 23, 2022
  2. eva2000

    eva2000 Administrator Staff Member

    51,981
    11,976
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,473
    Local Time:
    2:55 PM
    Nginx 1.25.x
    MariaDB 10.x
    Made it slightly easier to test EL8 based Centmin Mod 130.00beta01 with default MariaDB 10.4+ with specific installers for it as well for testing in light of https://community.centminmod.com/threads/official-mariadb-10-3-yum-repo-eol-may-25-2023.23756/.

    Similar to https://community.centminmod.com/th...-mod-on-almalinux-8-rocky-linux-8-oses.23261/ initial installs, just specific installers for:

    MariaDB 10.4 default with PHP 8.0 default
    Code (Text):
    yum -y update
    curl -4sL https://centminmod.com/installer-el8x-mariadb10.4.sh -o installer-el8x-mariadb10.4.sh; bash installer-el8x-mariadb10.4.sh
    

    MariaDB 10.5 default with PHP 8.0 default
    Code (Text):
    yum -y update
    curl -4sL https://centminmod.com/installer-el8x-mariadb10.5.sh -o installer-el8x-mariadb10.5.sh; bash installer-el8x-mariadb10.5.sh
    

    MariaDB 10.6 default with PHP 8.0 default
    Code (Text):
    yum -y update
    curl -4sL https://centminmod.com/installer-el8x-mariadb10.6.sh -o installer-el8x-mariadb10.6.sh; bash installer-el8x-mariadb10.6.sh
    
     
Thread Status:
Not open for further replies.