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.
  6. McLure

    McLure Member

  7. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    Probably the server is temporarily offline. Anyway, try to open a new thread especially when the thread is already years old and your issue is not directly related.
     
  8. Mateus Magen

    Mateus Magen New Member

    I did this:

    curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-10.11" --skip-maxscale
    apt install mariadb-server mariadb-plugin-provider-lz4 mariadb-plugin-provider-snappy libmariadb3 mysql-common

    Also use 10.6, is LTS too

    Working normaly
     
    ahrasis likes this.
  9. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    The one downloaded directly from mariadb repo and the one shipped with the OS repo are too different package, so far that I understand, thus I think each repo will patch and provide 10.6 differently though both may be named LTS version too.

    I also don't think many will be needing a bleeding edge LTS version or otherwise for mariadb but those who need it may head to https://mariadb.org/download/?t=repo-config to set proper latest LTS repo, because otherwise, you might need to write your own custom script to keep updating, your custom update, which you do not have to, if you set proper repo.

    Those who keep the default mariadb shipped with the OS, are more relaxed, since it will be updated together when update and upgrade command are run in their ISPConfig server.
     

Share This Page