MySQL vs MariaDB: MariaDB is a drop-in replacement for MySQL. That means that all data and table definition files are all compatible with MariaDB. All filenames, binaries, paths, ports, sockets – should remain the same, all MySQL connectors are compatible with MariaDB (PHP, Perl, Python, Java…)
Recent versions of cPanel allow administrators the option of hosting a MySQL server on a separate box, which can help decrease resource usage from high-activity MySQL databases. Setting up the remote database server is easy.
Keeping MySQL on the server up to date is essential for the efficiency of codes . There are times when we just cannot let cPanel handle an upgrade because we may end up having our databases not working properly after an upgrade. So, therefore we need to do upgrades of MySQL manually.