xyzulu
If you need MariaDB to restart automatically on any failure and ensure persistence, you can set this up with a systemd override file. However, be cautious with such changes to avoid issues like infinite restart loops if a persistent error causes repeated failures.
What Enhance is doing now follows standard practices used by professional control panels like cPanel and DirectAdmin and should not be changed.
What really should be done is to address the root cause of the failures through proper resource allocation, MySQL optimization, and preventing long, inefficient queries from killing your server. And if that’s already done, then adding more RAM to the server is the next step.