• MariaDB

MariaDB is intended as a drop-in replacement for MySQL. It was forked from MySQL by some of the original developers of MySQL after Oracle acquired Sun (and thus acquired MySQL), but is now developed by the MariaDB Foundation, MariaDB plc and with assistance from the broader community of Free and open source software developers. In addition to the core functionality of MySQL, MariaDB offers a rich set of feature enhancements including alternate storage engines, the Galera multi-master replication library, an Oracle compatibility layer, server optimizations, and patches.

MariaDB server installation

There are many versions of MariaDB available in the repos. Use this command to list all available versions:

pkg search mariadb | grep server

Install the version you wish (typically the latest version, replace the XXX in the command below with the desired version number listed above).

Installing the server will automatically install the client as a dependency.

sudo pkg install mariadbXXX-server

Set MariaDB server to start at boot:

sudo sysrc mysql_enable=YES

Start MariaDB server:

sudo service mysql-server start

Security hardening

Run this interactive script to perform basic security hardening of the installation.

• When asked, it's recommended to not provide a root database user password. (Accessing the server console as the root database user is done simply with sudo mariadb.)

sudo mariadb-secure-installation

Verify that MariaDB server is only accessible via localhost

$ sockstat -4 -6 | grep 3306
mysql    mariadbd   989   33 tcp4   127.0.0.1:3306        *:*

If the output lists 127.0.0.1:3306, then your server is not listening to remote connections. If *:3306 is listed, then remote connections are enabled.

Troubleshooting

Connections to localhost fail

Try connecting via the UNIX socket as specified in /usr/local/etc/mysql/my.cnf, like this:

mariadb -S /var/run/mysql/mysql.sock

Run that command as the system root user to log in as the MariaDB root user.

When using ports

To use MariaDB instead of (the default) MySQL when building ports that should depend on it, set in /etc/make.conf e.g.

DEFAULT_VERSIONS+=mysql=1011m

where '1011' refers to MariaDB version 10.11. (Other values could be e.g. '105', '106', '114' to refer to versions 10.5, 10.6, 11.4 respectively.)

Ports history

• 2010-11-17 databases/mariadb MariaDB 5.2 added by Geoffroy Desvernay (NOTE: MariaDB 5.2 has been removed from the ports tree).

• 2011-06-06 databases/mariadb-server MariaDB 5.2.5 split into a -server and -client ports

• 2012-04-20 databases/mariadb updated to 5.3 (NOTE: MariaDB 5.3 has been removed from the ports tree 2015-11-18).

• 2013-01-05 databases/mariadb55-server MariaDB 5.5 added by Alexandr Kovalenko.

• 2014-11-04 databases/mariadb100-server MariaDB 10.0 and all subsequent added by Bernard Spil

• 2016-02-13 databases/mariadb101-server

• 2017-01-15 databases/mariadb-connector-c MariaDB C Connector 2.3 later updated to 3.0

• 2017-05-28 databases/mariadb102-server MariaDB 10.2

• 2018-02-13 databases/mariadb-connector-odbc MariaDB ODBC Connector 3.0

• 2018-06-09 databases/mariadb103-server MariaDB 10.3

Upcoming

According to the current maintenance policy, MariaDB Community LTS releases from 10.5 up to and including 11.4 are supported for 5 years, whereas later LTS releases are supported for 3 years.

• 2018-11-09 Release of MariaDB 10.4
• 2019-03-31 Expected End-of-Life MariaDB 10.0
• 2020-04-11 Expected End-of-Life MariaDB 5.5
• 2020-10-17 Expected End-of-Life MariaDB 10.1
• 2022-05-23 Expected End-of-Life MariaDB 10.2
• 2023-05-25 Expected End-of-Life MariaDB 10.3

MariaDB 5.2 - 10.2

The MariaDB port was initially created by Geoffroy Desvernay. The MariaDB 5.5 port was created by Alexandr Kovalenko and the basis for the later 10.x versions created by Bernard Spil (brnrd). The port consists of a master- (-server) and slave-port (-client) as of version 5.3

Extensive patching of the cmake files was done to work around conflicts between the -client and -server ports.

MariaDB 10.3 -

This version removes the cmake patching and replaces it with @comment prefixes in pkg-plist. The only CMakeFiles.txt patching that's going on must have an accompanying issue in MariaDB JIRA.

Porting

The WITHOUT_SERVER flag for cmake isn't very stable, files move in and out. This results in install conflicts when the port is updated.

Generate clean pkg-plist

1. Disable post-install targets for both -client and -server, it deletes parts of the install tree.

2. Build the port.

3. run make makeplist and store the output.

4. compare makeplist output for -client and -server and add @comment in pkg-plist where changes are required (bear in mind the post-install target).
   ls -l $(sed -n 's|^@comment |work/stage/usr/local/|p' pkg-plist) >/dev/null

5. Update and enable post-install target.

I've found the Debian packages to be helpful in deciding what's client and what's server.

Check duplicate @comment lines

for file in `sed -n 's|^@comment ||p' pkg-plist` ; do grep "^@comment $file" ../mariadb103-client/pkg-plist ; done

or

# files marked @comment show up with a number higher than 1
grep '^@comment ' mariadb103-*/pkg-plist | cut -d: -f2 | sort | uniq -c

Things not needed on FreeBSD

Upstream issues

MDEV-11790

WITHOUT_SERVER installs server-only files Tries to address inconsistencies in the cmake files. This is a patch in the ports tree for 10.3.

MDEV-15961

Fix stacktraces under FreeBSD Fixing aarch64 builds

CategoryPorts CategoryHowTo