MySQL
(Redirected from InnoDB)
MySQL is a widely spread, multi-threaded, multi-user SQL database, developed by Oracle.
Installation
Arch Linux favors MariaDB, a community-developed fork of MySQL, aiming for drop-in compatibility.
Oracle's MySQL was dropped to the AUR: mysqlAUR.
Another fork aiming to be fully compatible is Percona Server, available as percona-server.
The InnoDB storage engine by Oracle was also forked by Percona as XtraDB. The fork is used by both MariaDB and Percona Server.
Graphical tools
- phpMyAdmin — MySQL web interface, written in PHP.
- MySQL Workbench — Unified visual tool for database architects, developers, and DBAs. Developed by Oracle and not guaranteed to work with MariaDB.
For tools supporting multiple DBMSs, see List of applications/Documents#Database tools.
Console tools
- MyCLI — A terminal client for MySQL with autocompletion and syntax highlighting.
- https://www.mycli.net || mycliAUR
Programmatic access
Docker
A docker image is available: https://hub.docker.com/_/mysql
Troubleshooting
Cannot connect to local MySQL server through socket
If running a new container fails to start, you may need to increase the ulimit. See GitHub issue for more information.