|Source Repository:||Repository:Gentoo Portage Tree|
Summary: An enhanced, drop-in replacement for MySQL
Latest InnovationsThis news item documents the latest innovations now available under Funtoo Linux.
MariaDB is a drop in replacement for MySQL.
Mariadb's executable is /usr/bin/mysql
Mariadb's init script is /etc/init.d/mysql
# emerge dev-db/mariadb
First Run & Lock Down
Mariadb requires configuration upon instillation.
To deploy Mariadb:
# emerge --config dev-db/mariadb
# rc-service mysql restart # mysql_secure_installation
The binary logs are used for database replication and they are enabled by default in
One can disable binary logs by creating custom configuration file under
/etc/mysql/mariadb.d/ and name it e.g.
75-local.cnf with content:
The status of the binary logs can be inspected by the dev-db/phpmyadmin (package not on wiki - please add) or by the SQL command:
SHOW BINARY LOGS;
Binary log can be all removed:
RESET MASTER only if you don't use replication at all or if the server is configured as master first time!
Unmaintained binary log files will grow in count and size and they can consume considerable disk space (in my case it was more than 2 GB). Then
one can purge old files by the
PURGE BINARY LOGS SQL command. It can be used in two manners:
PURGE BINARY LOGS TO 'mariadb-bin.000036';
PURGE BINARY LOGS BEFORE '2017-08-24 11:13';
Purging old logs can be automated by the
expire-logs-days configuration option, with number of days to keep logs.
Log's file name can be configured by the
log-bin options. If not configured, the default
numbered extension will be used.
The default (unconfigured) log's file name was changed in time. The older MariaDB versions was using
mysql-bin and even older setups was
using hostname in name. It is safe to remove the old files, because they are not used by server more.