Upgrade to MariaDB 11.4 failed to find binary

Symptoms

Upgrading to MariaDB 11.4 failed and returns the following error.

Note: The upgrade logs are stored at path "/var/cpanel/logs/mysql_upgrade.*/unattended_upgrade.log"

Service Error

(XID ju9bsn) The system could not find the “/usr/sbin/mysqld” binary 
for the “mysql” service because of an error: No such file or directory

mysql has failed. Contact your system administrator if the service does 
not automagically recover.

MariaDB did not start up after upgrade; there may be a problem in 
/etc/my.cnf. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 833.

In the upgrade log, the following error could also be returned.

Restarting mysql service.
(XID gjszvn) The “mysql” service is disabled.
MariaDB did not start up after upgrade; there may be a problem 
in /etc/my.cnf. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 833.
Failed to get MySQL version from server: STDERR: exec(/usr/sbin/mysqld) 
failed: No such file or directory

Description

MariaDB is transitioning further away from MySQL. Part of this transition includes shipping its own binaries instead of sharing the same name with MySQL. Because the symlinks to MySQL binaries are gone, this creates this failure condition.

We've opened an internal case for our development team to investigate this further. For reference, the case number is CPANEL-46405. Follow this article to receive an email notification when a solution is published in the product. 

Workaround

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Ensure the service is enabled.

   systemctl enable mariadb

3. Create a symlink for mysqld.

   ln -s /usr/sbin/mariadbd /usr/sbin/mysqld

4. Create a symlink for mysql.

   ln -s /usr/bin/mariadb /usr/bin/mysql

5. Create a symlink for mysqldump.

   ln -s /usr/bin/mariadb-dump /usr/bin/mysqldump

6. Restart the SQL service.

   /usr/local/cpanel/scripts/restartsrv_mysql