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.
Is there a new connection link? Failed to fetch http://ftp.igh.cnrs.fr/pub/mariadb/repo/10.4/ubuntu/dists/focal/InRelease Could not resolve 'ftp.igh.cnrs.fr' W: Some index files failed to download. They have been ignored, or old ones used instead.
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.
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
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.
