Our howtos are automated. Once the settings are provided, everything else is automatic and should provide you quickly with a working system.
Our howtos are designed to be used by copy/pasting lines of shell code in your terminal. No manual file edition needed.
Our howtos and associated tools are saving your time. We provide free and open source scripts to manage quickly Apache 2, NGINX, MySQL/MariaDB configuration.
Shaarli is a single user link sharing service. It stores its data on filesystem and does not need a database server. It is a very light solution of a single user working alone outside of Read more…
biapy-downloader is a script created to automate the downloading of software’s latest versions. It find the URL of the latest version of the software, download its content and, if needed, extract it. This guide describe Read more…
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 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 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 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 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 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 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.
Backup Manager store its backups archives on the local disk. To prevent data loss in case of hardware failure, it is recommended to create a backup copy of the archives on a remote host. This Read more…
SFTP is a protocol allowing for secure file transfers over SSH. This guide describe how to setup SFTP only accounts on a SSH server.