MariaDB

MariaDB An enhanced, drop-in replacement for MySQL.

In Gentoo, is the default package for items that depend on.

Emerge
Install :

Service

 * OpenRC:
 * To have the database(s) started automatically at boot, add it to the default runlevel:




 * If the database is configured, start the service:




 * Systemd:


 * With MariaDB < 10.1
 * With MariaDB >= 10.1.8
 * As of MariaDB 10.1.8, it includes a notify based unit to use instead a script to check if the system is alive.
 * As of MariaDB 10.1.8, it includes a notify based unit to use instead a script to check if the system is alive.

Preliminary configuration
Gentoo MariaDB package maintainers will help you set up MariaDB through the configuration option in the ebuild.

The configuration will create a database, set proper permissions, and assist you in creating a secure root password (this is for the MariaDB root account, which is not related to the Linux root account).

In-database configuration
When the database is set up and running, connect to MariaDB using the client application.

Custom options
Beginning with MariaDB 10.2, the configuration file my.cnf, includes a single directive to include /etc/mysql/mariadb.d and all files located within. Gentoo includes a file for server settings and one for client settings. Create your own files in this directory and they will be added together in alphabetical order. The base configuration accepts almost all the defaults and only tweaks paths. Tune your server to your liking.

External resources

 * MariaDB official documentation
 * MariaDB VS MySQL features
 * MariaDB VS MySQL compatibility
 * Moving from MySQL