Difference between revisions of "MariaDB"

From ArchWiki
Jump to: navigation, search
(mariadb IS mysql. Put a redirection)
(15 intermediate revisions by 8 users not shown)
Line 1: Line 1:
[[Category:Daemons and system services]]
[[Category:Database management systems]]
MariaDB is a reliable, high performance and full-featured database server which aims to be an 'always Free, backward compatible, drop-in' replacement of the [[MySQL]] Server. It is distributed under the GPLv2 license.
Started as a fork of MySQL by Widenius (creator of both servers), MariaDB is a project developed by the open source community under the technocracy model. Monty Program Ab, who employees most of the original core MySQL developers, is currently the main steward for the project.
MariaDB is kept up to date with the latest MySQL release from the same branch. A merge from the main MySQL branch is done for every new MySQL release or when there is some critical bugfix applied to the main branch.
The intent also being to maintain high fidelity with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exacting matching with MySQL APIs and commands.
== Installation ==
=== Without having MySQL installed ===
Install the {{Pkg|mariadb}} package from the [[Official Repositories|community repository]].
After installing, you should create the system tables in the 'mysql' database directory.  Generally, this should do the job:
# mysql_install_db --user=mysql
{{Note| If you experience errors or you want more information about it, read the official [[http://kb.askmonty.org/v/installing-system-tables-mysql_install_db documentation]]}}
Now you should be able to start/stop the server
# /etc/rc.d/mariadbd start
It is recommended to secure the installation, using the provided tool:
# mysql_secure_installation
To start MariaDB automatically at boot, edit /etc/rc.conf and add the mariadbd daemon:
# DAEMONS=(... mariadbd ...)
Or if using [[systemd]], mariadb >= 5.5.25-3 has a service unit:
# systemctl enable mysql.service
Note that the original MySQL might not provide this service if you ever decide to revert to it.
{{Note| The recommended way to start MariaDB on Linux is with  [[http://kb.askmonty.org/v/mysqld_safe mysqld_safe]], for replacement convenience it is not the default script}}
== Configuration ==
As some [[AUR helpers]], there is no need of learning anything new in order to obtain the same (generally increased) functionality.
If you are new to MySQL, read first the [[MySQL]] page on this wiki.

Latest revision as of 10:51, 26 May 2013

Redirect to: