Join the community today
Become a Member

Beta Branch add mariadb_upgrade_check_versionlock function in 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Oct 16, 2020.

  1. eva2000

    eva2000 Administrator Staff Member

    54,113
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    11:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    add mariadb_upgrade_check_versionlock function in 123.09beta01


    - Only applies to centmin.sh menu option 11
    - Function for centmin.sh menu option 11 based major MariaDB server version upgrades to check if MariaDB yum packages are yum version locked by system administrator. If yum versionlock is in place, it will prevent centmin.sh menu option 11 based MariaDB major version upgrades as yum will not be able to find the MariaDB yum packages to update to the new version.
    - This function checks if MariaDB and Galera yum packages are version locked and if so, version unlock them to allow for upgrades. This function will not re-lock them after update though due to the updated yum packages maybe having a different yum package name which may not properly lock the package or only lock some of the updated yum packages - leading to some packages being locked and others being unlocked which will make yum update command probably fail otherwise. So leave it to system admin to determine what yum packages they want to re-lock after updates via centmin.sh menu option 11 check for version locked MariaDB & Galera yum packages

    example on centmin.sh menu option 11 submenu option 7 for MariaDB 10.2 to 10.3 major upgrade routine, if yum versionlock detected for MariaDB & Galera yum packages is detected, the newly added mariadb_upgrade_check_versionlock function will auto unlock them first to allow MariaDB 10.3 upgrade to proceed and you'll see message like below

    Code (Text):
    *************************************************
    
    detected the following MariaDB server yum package yum versionlocks:
    
    *************************************************
    MariaDB-backup-10.2.34-1.el7.centos
    MariaDB-client-10.2.34-1.el7.centos
    MariaDB-common-10.2.34-1.el7.centos
    MariaDB-compat-10.2.34-1.el7.centos
    MariaDB-devel-10.2.34-1.el7.centos
    MariaDB-server-10.2.34-1.el7.centos
    MariaDB-shared-10.2.34-1.el7.centos
    galera-25.3.28-1.rhel7.el7.centos
    *************************************************
    
    removing MariaDB yum versionlocks for updates...
    
    *************************************************
    Loaded plugins: fastestmirror, priorities, versionlock
    Deleting versionlock for: 0:MariaDB-backup-10.2.34-1.el7.centos.*
    Deleting versionlock for: 0:MariaDB-client-10.2.34-1.el7.centos.*
    Deleting versionlock for: 0:MariaDB-common-10.2.34-1.el7.centos.*
    Deleting versionlock for: 0:MariaDB-compat-10.2.34-1.el7.centos.*
    Deleting versionlock for: 0:MariaDB-devel-10.2.34-1.el7.centos.*
    Deleting versionlock for: 0:MariaDB-server-10.2.34-1.el7.centos.*
    Deleting versionlock for: 0:MariaDB-shared-10.2.34-1.el7.centos.*
    Deleting versionlock for: 0:galera-25.3.28-1.rhel7.el7.centos.*
    versionlock deleted: 8


    Continue reading...

    123.09beta01 branch