BrainwreckedTech: Made TOC float left

2019-12-11T08:11:52Z

Made TOC float left

← Older revision		Revision as of 04:11, 11 December 2019
Line 1:		Line 1:
	[[Category:Database]]		[[Category:Database]]
	<div style="float:~~right~~; margin-~~left~~:0.5em; margin-bottom:0.5em;">__TOC__</div>		<div style="float:left; margin-right:0.5em; margin-bottom:0.5em;">__TOC__</div>

	MariaDB is a fork of MySQL, a multi-threaded multi-user relational database management system that aims for drop-in compatibility with MySQL. MySQL was developed by Swedish company MySQL AB in 1995, acquired by Sun Microsystems in 2008, and in turn acquired by Oracle Corporation in 2010. Due to the conflict of interest between MySQL and Oracle DB, as well as the community's distrust of Oracle (compounded by lack of response from Oracle during the Sun acquisition), Monty Widenius forked MySQL into MariaDB.		MariaDB is a fork of MySQL, a multi-threaded multi-user relational database management system that aims for drop-in compatibility with MySQL. MySQL was developed by Swedish company MySQL AB in 1995, acquired by Sun Microsystems in 2008, and in turn acquired by Oracle Corporation in 2010. Due to the conflict of interest between MySQL and Oracle DB, as well as the community's distrust of Oracle (compounded by lack of response from Oracle during the Sun acquisition), Monty Widenius forked MySQL into MariaDB.

BrainwreckedTech: Created page.

2019-12-09T00:17:30Z

Created page.

New page

[[Category:Database]]
<div style="float:right; margin-left:0.5em; margin-bottom:0.5em;">__TOC__</div>

MariaDB is a fork of MySQL, a multi-threaded multi-user relational database management system that aims for drop-in compatibility with MySQL. MySQL was developed by Swedish company MySQL AB in 1995, acquired by Sun Microsystems in 2008, and in turn acquired by Oracle Corporation in 2010. Due to the conflict of interest between MySQL and Oracle DB, as well as the community's distrust of Oracle (compounded by lack of response from Oracle during the Sun acquisition), Monty Widenius forked MySQL into MariaDB.

MariaDB is a middle ground (of sorts) between SQLite's easier setup and lesser performance and resiliency, and PostgreSQL's increased capabilities and complexity.

= Prerequisites =

* If using BTRFS, disable Copy-On-Write for the {{ic|datadir}}.
* If using ZFS, create a dataset for the {{ic|datadir}} using {{ic|1=-o recordsize=8K -o primarycache=metadata -o logbias=throughput}}.

= Required Packages =

{{bc|sudo pacman -Syu mariadb}}

= Configuration =

== Data Directory ==

If you want to put your databases somewhere other than the default {{ic|/var/lib/mysql}}:

{{bc|
sudo mkdir <dir>
sudo chown -R mysql:mysql <dir>
}}

== tmpfs for tmpdir ==

The directory used by MariaDB for storing temporary files is named tmpdir. For example, it is used to perform disk based large sorts, as well as for internal and explicit temporary tables.

Create the directory with appropriate permissions:

{{bc|
sudo mkdir -pv <dir>
sudo chown mysql:mysql <dir>
}}

Find the id and gid of the mysql user and group:

{{hc|$ id mysql|2=
uid=27(mysql) gid=27(mysql) groups=27(mysql)}}

Add to your {{ic|/etc/fstab}} file.

{{hc|/etc/fstab|2=
...
tmpfs /srv/sqltmp tmpfs rw,noatime,gid=27,uid=27,size=100M,mode=0750 0 0
...
}}

{{note|1=If you are using ZFS, add<tt> x-systemd.after=zfs-mount.service </tt>to the list of mount options}}

== Configuration File ==

{{hc|/etc/my.cnf.d/server.cnf|2=
...
[mysqld]
datadir=/srv/mdb
skip-networking
tmpdir=/srv/mdb/tmp
innodb_file_per_table=1
innodb_file_format=Barracuda
# ZFS-specific
skip-innodb_doublewrite
innodb_use_native_aio=0
innodb_use_atomic_writes=0
...
}}

{{note|1=The<tt> skip-networking </tt>option means the database will be unavailable over TCP. Local programs that need access must use the UNIX socket.}}

== Initial Setup ==

{{bc|<nowiki>sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=<dir></nowiki>}}

== Start the Server ==

{{bc|sudo systemctl enable --now mariadb}}

== Security Settings ==

{{bc|sudo mysql_secure_installation}}

Create a user:

{{hc|$ mysql -u root -p|2=
MariaDB> CREATE USER '<user>'@'localhost' IDENTIFIED BY '<password>';
MariaDB> GRANT ALL PRIVILEGES ON <database>.* TO '<USER>'@'localhost';
MariaDB> FLUSH PRIVILEGES;
MariaDB> quit
}}

MariaDB - Revision history

BrainwreckedTech: Made TOC float left

BrainwreckedTech: Created page.