MariaDB Upgrade

Discussion in 'General' started by Fernando Azevedo, Sep 9, 2021.

  1. Fernando Azevedo

    Fernando Azevedo New Member

    Hi All,

    I am running the Ubuntu perfect server with MariaDB 10.1.48. One of my clients needs MariaDB 10.2.29 (or higher). Questions:
    1. Is it supported by ISPConfig 3? (I am running the latest stable version)
    2. Assuming it is supported, how can I upgrade MariaDB? I have tried 'apt update && apt upgrade´but it does not update/upgrade MariaDB.

    Thanks in advance!

    Fernando
     
  2. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    What version is your Ubuntu server?

    ISPConfig only supports the version that is shipped with your OS. Upgrading it manually is possible but may cause problem(s) since it is not supported.

    However, upgrading your OS may allow you to upgrade your MariaDB to 10.3 which I think is the default version for Ubuntu 20.04.

    The steps are backup, make sure your backup works, upgrade Ubuntu to 20.04, follow its Perfect Server Tutorial, force update ISPConfig reconfiguring all services.

    Well at least that is what I think the best way to upgrade your MariaDB.
     
    Jesse Norell likes this.
  3. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    ISPConfig supports mariadb > 10.1 and you can use without any problems a different mariadb version. Just ignore "ISPConfig only supports the version that is shipped with your OS" as long as the new version is compatible (10.4 works, 10.5 should work, too).

    To upgrade mariadb (no need to upgrade the os) on Ubuntu (should be similar on Debian):
    Code:
    apt install software-properties-common dirmngr
    apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'
    
    CODENAME=`lsb_release -c -s`
    echo "deb [arch=amd64] http://ftp.igh.cnrs.fr/pub/mariadb/repo/10.4/ubuntu $CODENAME main
    deb-src http://ftp.igh.cnrs.fr/pub/mariadb/repo/10.4/ubuntu $CODENAME main
    " > /etc/apt/sources.list.d/MariaDB.list
    
    apt update
    apt upgrade
    apt install mariadb-server mariadb-client
    
    mkdir -p /etc/systemd/system/mysql.service.d
    Add to /etc/security/limits.conf
    Code:
    mysql soft nofile 65535
    mysql hard nofile 65535
    
    Create /etc/systemd/system/mysql.service.d/limits.conf with this content:
    Code:
    [Service]
    LimitNOFILE=infinity
    [code]
    
    run [code] 
    systemctl daemon-reload
    service mysql restart
    
     
    Jesse Norell, madmucho and ahrasis like this.
  4. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    I would also want to upgrade to latest version of MariaDB especially after reading the above reply but having read other threads regarding the same, I would stop myself from doing so.

     
  5. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    It's up to you. I run mariadb 10.4 on most of my servers updated as described above.
     
    ahrasis likes this.

Share This Page