MariaDB / MySQL

MariaDB is the successor to MySQL after Oracle went a bit crazy on it. MariaDB is more updated, more secure and generally the logical successor to MySQL. And it's 100% compatible.

Installing MariaDB is easy:

emerge mariadb

The Gentoo guide says it all, but i want to ensure that the database is actually stored on the RAID array and not on the Gentoo root folder.

This is configured in /etc/mysql/mariadb.d/50-distro-server.cnf, find and change the following line:

datadir                                         = /data/mysql

move the folder to somewhere under /data/.

After editing this file, run the first time configuration, so before starting it, run:

emerge --config dev-db/mariadb