Funny you should ask...
Question - Try our new tool to upgrade your old MariaDB server from Plesk UI
Make sure to take a full backup of your server before running that tool!
So the database sounds like it's being stopped (but not gracefully) since you noted that you have to start the service up again and there are no logs about shutdown. Check the messages log and you might find that it's being sacrificed by the OOM killer.
This may not be an error caused by too many connections but rather a corrupt table or database causing the database service to restart. Check your database log and see if it's causing the entire database service to crash/restart frequently.
@Sebahat.hadzhi are you able to provide a more official confirmation as to the updated approach above?
Additionally, are we correct in assuming that this precludes the use of older (PHP 7) versions?
Before you go through the effort of building the server, it's possible that this is still just a compromised site issue. Keep in mind that one tactic used by perpetrators today is to keep running a PHP file such that even when the file itself it deleted, it still executes, thereby "living" in...
The latest Plesk PHP package appears to include ImageMagick 3.8.0 for PHP 8.1-8.4 however there is a caveat and that is to use it, the EPEL one must be removed via yum.
So running the following command should remove EPEL's ImageMagick:
# yum remove ImageMagick
Once the process is complete...
You're welcome!
It's not directly a Plesk issue per say but they could add better support/documentation for handling CMS platforms on Nginx-only scenarios which would shortcut the aggravation that you went through.
Sebahat's solution would work if requests were proxied to Apache while Mow...
A bit extreme but I can understand the sentiment and indeed with all of these constant license costs increases coupled with "you asked for it" (but really nobody asked for it) features, it would seem that PHP 8.4 could be shipped a little more expeditiously or at least open a transparent dialog...