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