Here at FreshSites, we believe in using the best software for the requirements, and that is why coupled with our PHP-FPM and NGINX stack (see our earlier articles!) we use MariaDB server as our database server of choice.
MariaDB is an open-source fork of the MySQL (MySequel) server which is published under the GNU General Public License. MariaDB was founded and is still developed by Michael Widenius one of the original developers of MySQL server. He started the MariaDB project after concerns over the commercialisation of the MySQL project when it was acquired by Sun Microsystems and later, Oracle Corporation.
MariaDB, or MySQL as you'll still commonly hear it called, is the database storage system for the majority of PHP database-driven sites - with it being one of the WordPress hosting requirements, it was a no brainer for us to use the latest technology.
All of our hosting servers, whether they are shared cPanel hosting or Managed WordPress hosting, as a rule of thumb will be running the latest stable release of MariaDB server (at the time of writing, that is 10.4).
All of our hosting platforms allow you full access to your MySQL databases hosted on our MariaDB-Server backend. We allow access using phpMyAdmin (a web-based database management interface), Linux Command line for the more advanced users amongst us, and of course, by your PHP scripts using the PHP-MySQL library.
Absolutely - here at FreshSites we believe that keeping your data safe should be one of our top priorities, and for that reason, we back up every individual database once per night, and save them on our off-site backup platform in case you ever need them restored.
On our Managed hosting platform, we retain every database for a minimum of 30 days, whilst our shared platform benefits from a generous 7 days worth of backups included in the cost!