Para CentOS 8, AlmaLinux 8/9:
# Backup Completo
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all_databases_10.3.sql
cp -r /var/lib/mysql /var/lib/mysql_backup_10.3
systemctl stop mariadb ou systemctl stop mysqld
# Atualizar para MariaDB 10.4
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.4
yum clean all
yum update MariaDB-server MariaDB-client MariaDB-compat MariaDB-shared
systemctl start mariadb ou systemctl start mysqld
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
systemctl stop mariadb ou systemctl stop mysqld
# Backup Completo
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all_databases_10.4.sql
cp -r /var/lib/mysql /var/lib/mysql_backup_10.4
# Atualizar para MariaDB 10.5
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.5
yum clean all
yum update MariaDB-server MariaDB-client MariaDB-compat MariaDB-shared
systemctl start mariadb ou systemctl start mysqld
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
systemctl stop mariadb ou systemctl stop mysqld
# Backup Completo
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all_databases_10.5.sql
cp -r /var/lib/mysql /var/lib/mysql_backup_10.5
# Atualizar para MariaDB 10.6
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.6
yum clean all
yum update MariaDB-server MariaDB-client MariaDB-compat MariaDB-shared
systemctl start mariadb ou systemctl start mysqld
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
# Atualizar Plesk
plesk bin service_node --update local
plesk sbin packagemng -sdf
Para Cloudlinux:
# Backup Completo
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all_databases_10.3.sql
cp -r /var/lib/mysql /var/lib/mysql_backup_10.3
# Instala o Governor
yum install governor-mysql
# Atualizar para MariaDB 10.4
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb104
/usr/share/lve/dbgovernor/mysqlgovernor.py --install
systemctl start mysqld
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
systemctl stop mysqld
# Backup Completo
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all_databases_10.4.sql
cp -r /var/lib/mysql /var/lib/mysql_backup_10.4
# Atualizar para MariaDB 10.5
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb105
/usr/share/lve/dbgovernor/mysqlgovernor.py --install
systemctl start mysqld
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
systemctl stop mysqld
# Backup Completo
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all_databases_10.5.sql
cp -r /var/lib/mysql /var/lib/mysql_backup_10.5
# Atualizar para MariaDB 10.6
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb106
/usr/share/lve/dbgovernor/mysqlgovernor.py --install
systemctl start mysqld
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
systemctl stop mysqld
# Atualizar Plesk
plesk bin service_node --update local
plesk sbin packagemng -sdf