Howtos helping to setup a MariaDB // MySQL server on Debian GNU/Linux
mysql-tools is a shell script automating database and user management from command-line for MySQL and MariaDB. This post describe how to install it and give some usage examples.
This howto is tested on: Debian 10.0 Buster Requirements This howto requires: a MySQL or MariaDB server, as described by Install MariaDB (MySQL) on Debian. This howto recommends: Adjusting the filesystem mount options, as described by Adjust filesystem options for MariaDB (MySQL). Environment setup Configuration Enable MySQL binary log to Read more…
The filesystem where MariaDB (MySQL) datadir is stored (“/var/lib/mysql” by default) should be mounted with theses options: noatime : disable the update of files access time. Limit I/O load generated by MySQL disk accesses. nodiratime : disable the update of folders access time. barrier=1 : Reduce risks of data loss Read more…
Tuning Primer is a tool helping to tune the performances of a MariaDB (MySQL) server. This howto is tested on: Debian 10.0 Buster Requirements This howto requires: a MySQL or MariaDB server, as described by Install MariaDB (MySQL) on Debian. Installation Install the software’s requirements: Install the software: Usage Wait Read more…
This howto is tested on: Debian 10.0 Buster Requirements This howto requires: a MySQL or MariaDB server, as described by Install MariaDB (MySQL) on Debian. the MariaDB sys schema, as described by Install the MariaDB sys schema on Debian. Environment setup Installation Install the software: Performance schema Enable the database Read more…
The MariaDB sys schema is a collection of views, functions and procedures to help MariaDB administrators get insight in to MariaDB Database usage. This howto is tested on: Debian 10.0 Buster This howto is tested with these versions of MariaDB: 10.3.28 Requirements This howto requires: a MySQL or MariaDB server, Read more…
This howto is tested on: Debian 10.0 Buster Requirements This howto requires: a MariaDB (MySQL) server, as described by Install MariaDB (MySQL) on Debian. Backup Manager, as described by Install Backup Manager on Debian. Settings Initialize the settings associative array: Set the name of the MySQL account to be created Read more…
MariaDB is a lightweight (compared to Oracle or PostgreSQL) database management system. It is designed to manage simple databases with a big number of records. MariaDB is mainly used to store websites Content Management Systems data. MariaDB is a free software fork of MySQL.
The performances of a database server are greatly dependent of its hosting hardware. Disk latency, available memory and processor computing power are the main parameters of the equation. This howto help you adjust a MariaDB (or MySQL) server settings to its hosting hardware. This howto is tested on: Debian 10.0 Read more…