MariaDB

From ArchWiki
Revision as of 21:05, 28 March 2011 by Rodrigo.gadea (talk | contribs) (Created page with "Category:Daemons and system services (English) Category:Database management systems (English) Category:HOWTOs (English) {{i18n|MariaDB}} MariaDB is a reliable, high ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

This template has only maintenance purposes. For linking to local translations please use interlanguage links, see Help:i18n#Interlanguage links.


Local languages: Català – Dansk – English – Español – Esperanto – Hrvatski – Indonesia – Italiano – Lietuviškai – Magyar – Nederlands – Norsk Bokmål – Polski – Português – Slovenský – Česky – Ελληνικά – Български – Русский – Српски – Українська – עברית – العربية – ไทย – 日本語 – 正體中文 – 简体中文 – 한국어


External languages (all articles in these languages should be moved to the external wiki): Deutsch – Français – Română – Suomi – Svenska – Tiếng Việt – Türkçe – فارسی

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.


As some AUR helpers, there is no need of learning anything new in order to obtain the same (generally increased) functionality

It includes the XtraDB storage engine as a replacement for InnoDB.

Installation

Without having MySQL installed

Install the [mariadb https://aur.archlinux.org/packages/mariadb] package from AUR

After installing, you should create the system tables in the 'mysql' database directory:

# https://aur.archlinux.org/packages/mariadb/

Then restart MySQL:

# /etc/rc.d/mysqld restart

To start MySQL automatically at boot, edit /etc/rc.conf and add the mysqld daemon:

DAEMONS=(... mysqld ...)

Configuration

Once you've started the MySQL server, you probably want to add a root account in order to maintain your MySQL users and databases. This can