MariaDB

From Gentoo Wiki
Jump to:navigation Jump to:search

MariaDB is an enhanced, drop-in MySQL replacement.

In Gentoo, dev-db/mariadb is the default package for items that depend on virtual/mysql.

Installation

USE flags

USE flags for dev-db/mariadb An enhanced, drop-in replacement for MySQL

backup Build mariadb-backup which supports SST and hot backup of InnoDB, Aria and MyISAM including compression and encryption
bindist Flag to enable or disable options for prebuilt (GRP) packages (eg. due to licensing issues)
columnstore Build the ColumnStore storage engine
cracklib Support for cracklib strong password checking
debug Enable extra debug codepaths, like asserts and extra output. If you want to get meaningful backtraces see https://wiki.gentoo.org/wiki/Project:Quality_Assurance/Backtraces
extraengine Add support for alternative storage engines (Archive, CSV, Blackhole, Federated(X), Partition)
galera Enables galera replication
innodb-lz4 Enables lz4 compression methods for InnoDB/XtraDB
innodb-lzo Enables lzo compression methods for InnoDB/XtraDB
innodb-snappy Enables snappy compression methods for InnoDB/XtraDB using app-arch/snappy
jdbc Enable the CONNECT engine to access foreign databases via JDBC
jemalloc Use dev-libs/jemalloc for memory management
kerberos Add kerberos support
latin1 Use LATIN1 encoding instead of UTF8
mroonga Add support for the Mroonga engine for interfacing with the Groonga text search
numa Enable NUMA support using sys-process/numactl (NUMA kernel support is also required)
odbc Add ODBC Support (Open DataBase Connectivity)
oqgraph Add support for the Open Query GRAPH engine
pam Enable the optional PAM authentication plugin for the server
perl Add optional support/bindings for the Perl language
profiling Add support for statement profiling (requires USE=community).
rocksdb Add support for RocksDB; a key/value, LSM database optimized for flash storage
s3 Build the S3 storage engine
selinux !!internal use only!! Security Enhanced Linux support, this must be set by the selinux profile or breakage will occur
server Build the server program
sphinx Add suport for the sphinx full-text search engine
sst-mariabackup Add tools needed to support the mariabackup SST method
sst-rsync Add tools needed to support the rsync SST method
static !!do not set this during bootstrap!! Causes binaries to be statically linked instead of dynamically
systemd Enable use of systemd-specific libraries and features like socket activation or session tracking
systemtap Build support for profiling and tracing using dev-debug/systemtap
tcmalloc Use the dev-util/google-perftools libraries to replace the malloc() implementation with a possibly faster one
test Install upstream testsuites for end use.
xml Add support for XML files
yassl Enable SSL connections and crypto functions using the bundled yaSSL

Emerge

Install dev-db/mariadb:

root #emerge --ask dev-db/mariadb

Preliminary configuration

Gentoo MariaDB package maintainers provide setup assistance for MariaDB through the configuration option in the ebuild. Before starting the service, pass the --config option to create the database directories, set proper permissions, and assist in creating an setting a secure root password (Note - this is for the MariaDB root user account, which is not the same as the operating system's root user account!):

root #emerge --config dev-db/mariadb

Be sure to save the database root user's password in a secure enclave for safe keeping!

Preliminary configuration troubleshooting

Note
When configuring MariaDB on a system with localhost as its hostname, the "Your machine must NOT be named localhost" error is produced. The following steps will allow configuration by changing the hostname.

In the event MariaDB configuration fails due to localhost as hostname, update the system hostname variable to a name other than localhost in /etc/conf.d/hostname:

root #sed -i 's/localhost/larry/g' /etc/conf.d/hostname

Restart the hostname service:

root #rc-service hostname restart

Then, run the configuration command:

root #emerge --config dev-db/mariadb

Service

OpenRC

To have MariaDB start automatically at boot, add it to the default runlevel:

root #rc-update add mysql default

If MariaDB is ready to start, then start the service:

root #rc-service mysql start

systemd

For MariaDB versions less than 10.1:

root #systemctl enable --now mysqld.service

For MariaDB versions greater than or equal to 10.1.8:

root #systemctl enable --now mariadb.service
Note
MariaDB 10.1.8 includes a unit named mariadb.service that uses notify instead of a script to check if the system is alive.

Configuration

In-database configuration

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

user $mysql -u root -p -h localhost
Enter root password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 86415
Server version: 5.5.32-MariaDB-log Source distribution

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

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.

Troubleshooting

Compiling against libmariadb.so

Beginning with MariaDB 10.2, a new LGPL client library is included.

With MariaDB 10.2.8, the server and client headers were separated. This causes compilation errors in some programs which previously relied on server features.

MYSQL_SERVER_VERSION

One example is MYSQL_SERVER_VERSION. A quick fix can be:

#if defined MARIADB_CLIENT_VERSION_STR && !defined MYSQL_SERVER_VERSION
  #define MYSQL_SERVER_VERSION MARIADB_CLIENT_VERSION_STR
#endif

Ultimately, MYSQL_SERVER_VERSION should be removed and the MYSQL_VERSION_ID integer be used in it's place for version identification.

See also

  • MySQL/Startup_Guide — outlines basic instructions for users on setting up and using MySQL on Linux.
  • PostgreSQL — a free and open source relational database management system (RDBMS).

External resources