Ease MySQL / MariaDB server administration with mysql-tools
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.
Servers installation guides (HTTP, Email, Jabber, …).
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…
nginx-tools is a command-line tool easing and automating the daily administration of a NGINX server on Debian. This howto describe its installation and usage.
NGINX is a high performance HTTP server allowing for load balancing. It allow to serve a great number of visitors while using less CPU and RAM than Apache2.
Being notified quickly of errors triggered on a server allow for a quick resolution of problems on a production site. This guide set up a e-mail notification of PHP errors.
PHP messages are often stored in the HTTP server logs. It is easier to watch for security issues when PHP errors are sent to a central location. This guide use syslog to store PHP messages in “/var/log/php.log”.
OPcache improves PHP performance by storing precompiled script bytecode in shared memory, thereby removing the need for PHP to load and parse scripts on each request. This guide describe its installation on Debian.
APCu is a user data cache extension for PHP. It is used by many PHP applications to improve their performances.
Debian’s initial PHP configuration is a very good start. This guide provides adjustments improving upon it.
Memory limit, upload file size, quotes management, etc. are all PHP configuration options which change is required by various Web applications during their installation. This howto provides a command-line tool to automate the edition of PHP global settings.
PHP-FPM is an greatly enhanced FastCGI mechanism for PHP. It greatly raise the performances of PHP sites. This howto help you to setup this software on Debian.
Apache 2 is a robust server with many features. This guide tightens the security of an Apache 2 server by applying basic settings.
a2tools is a command-line tool easing and automating the daily administration of a Apache 2 server on Debian. This howto describe its installation and usage.
Apache is one of the most used HTTP server worldwide. It is known for is configurability and modularity. a very popular HTTP server. This guide helps you deploy an Apache 2 HTTP server on Debian GNU / Linux.
Creating a SSL certificate is a unavoidable step of the setup of a encrypted connexion (HTTP, IMAP, FTP, etc.). This guide describe how to generate a valid SSL / TLS certificate.