Table of Contents
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
Configuration
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
Input and remember your root password!
Startup
Start the service and set it on boot:
rc-update add mysql default /etc/init.d/mysql start
Management
It's a good idea to create a separated database and user for each service you are oging to use with MariaDB. These instructions are not exaustive but only a quick reference:
Login to the MariaDB
mysql -u root -p -h localhost
Creating a database with user
create database DATABASE_NAME; grant all privileges on DATABASE_NAME.* TO 'USER_NAME'@'localhost' identified by 'PASSWORD'; flush privileges;