Upgrade MariaDB 10.4 to 10.6 problems

[agasar]

Hello

Upgrade MariaDB 10.4 to 10.6 problems

MariaDB 10.4 - 10.4 - 10.6

I have updated in order. It didn't cause any problems.

Currently not doing Backup. I am encountering the following issues while making a backup. I get the same issue with all hosting backups and hizbir sites are not backing up.

The problem I got

Error while backing up database xxxx_xxxx
mysqldump error output: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'xxxx_xxxx'': Cannot load from mysql.proc. The table is probably corrupted (1728)

Error while backing up database xxxx_xxxx
mysqldump error output: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'xxxx_xxxx'': Cannot load from mysql.proc. The table is probably corrupted (1728)

 

[Active8]

Your database is crashed, try to fix (backup first)

mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --auto-repair  --optimize --all-databases

 

[agasar]

"CloudLinux 8"
I use. I did the following operations, the following operation solved the backup problem. Run the following in order.

ATTENTION: It is absolutely necessary to take a backup before performing these operations.

I ran the following codes in order, it solved my backup problem.

/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb105
/usr/share/lve/dbgovernor/mysqlgovernor.py --install

/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb106
/usr/share/lve/dbgovernor/mysqlgovernor.py --install

 

[Zhenyapan]

oh, of course! it's separate case - cloudlinux has own issues.

 

[agasar]

Is it useful to use "cloudlinux"? I've been using it for years. That's how they keep us busy.

I wonder if every hosting company uses "cloudlinux". Is it necessary to use it?

 

[Zhenyapan]

I wonder if every hosting company uses "cloudlinux". Is it necessary to use it?

it allows to separate users, to prevent overload, also isolate scrypts. As I know ProPack don't allow to manage Mysql limits like mysqlgovernor.
Also cloudlinux provides own patches for old PHP etc.. - if you don't need extended features or old stuff - ProPack will be enough.