Biapy Help Desk
  • Debian GNU/Linux
    • System Installation guides for system administration software on Debian GNU/Linux (backup, security, …)
      • SetupSetting up a new Debian GNU/Linux system.
      • SecuritySecurity enhancing software for Debian GNU/Linux.
      • SoftwareVarious command line software for Debian GNU/Linux.
      • XenHowtos about the Xen virtualization solution.
      • OVHHowtos about OVH dedicated server hosting solutions.
    • Servers Servers installation guides (HTTP, Email, Jabber, …).
      • Apache 2Apache 2 installation and configuration howtos for Debian.
      • HTTPHTTP servers installation guides for Debian GNU/Linux.
      • PHPHowtos helping to setup a PHP server.
      • MariaDB // MySQLHowtos helping to setup a MariaDB // MySQL server on Debian GNU/Linux
      • DatabasesDatabases servers installation guides for Debian GNU/Linux.
      • E-MailsE-Mails servers installation guides for Debian GNU/Linux. IMAP, SMTP, …
      • SyslogHowtos to setup Rsyslog and Syslog-NG system events logs management softwares.
      • MiscellaneousVarious servers installation guides for Debian GNU/Linux.
    • Web applications Installation guides of Web applications (Drupal, Wordpress, Tiny Tiny RSS, Piwik, …).
      • AdministrationWeb applications easing system administration.
      • BitTorrentWeb frontends for BitTorrent download tools. This applications are designed to setup a seed-box.
      • Bookmarks managementInstallation guides for bookmarks management web applications.
      • Content syndication // RSSHow to install content syndication Web tools. This include RSS feed readers and planets.
      • Files managementHow to install files management Web tools.
      • MiscellaneousInstallation guides for web applications that fits in none of the other categories.
      • MonitoringTools for monitoring servers state.
      • StatisticsHow to install statistics related web tools.
  • Ubuntu GNU/Linux
    • SoftwareHowtos helping installing third party software on Ubuntu GNU/Linux
    • SystemHowtos for setting up problematic hardware on Ubuntu GNU/Linux.

MariaDB // MySQL

Howtos helping to setup a MariaDB // MySQL server on Debian GNU/Linux

MariaDB // MySQL

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.

By Pierre-Yves Landuré, 2 yearsMarch 31, 2021 ago
MariaDB // MySQL

Enable MariaDB (MySQL) binary log on Debian

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…

By Pierre-Yves Landuré, 2 yearsMarch 31, 2021 ago
MariaDB // MySQL

Adjust filesystem options for MariaDB (MySQL)

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…

By Pierre-Yves Landuré, 2 yearsMarch 31, 2021 ago
MariaDB // MySQL

Install Tuning Primer on Debian

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…

By Pierre-Yves Landuré, 2 yearsMarch 31, 2021 ago
MariaDB // MySQL

Install MySQLTuner on Debian

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…

By Pierre-Yves Landuré, 2 yearsMarch 31, 2021 ago
MariaDB // MySQL

Install the MariaDB sys schema on Debian

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…

By Pierre-Yves Landuré, 2 yearsMarch 31, 2021 ago
Backups

Backup MariaDB (MySQL) databases with Backup Manager on Debian

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…

By Pierre-Yves Landuré, 2 yearsMarch 31, 2021 ago
MariaDB // MySQL

Install MariaDB (MySQL) on Debian

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.

By Pierre-Yves Landuré, 2 yearsMarch 31, 2021 ago
MariaDB // MySQL

Optimize MariaDB / MySQL on Debian

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…

By Pierre-Yves Landuré, 2 yearsMarch 19, 2021 ago
Recent Posts
  • Install Shaarli link sharing service on Debian
  • Install biapy-downloader on Debian
  • Ease MySQL / MariaDB server administration with mysql-tools
  • Enable MariaDB (MySQL) binary log on Debian
  • Adjust filesystem options for MariaDB (MySQL)
Recent Comments
  • Pierre-Yves Landuré on Reset a USB device on Debian
  • Marc Ballat on Reset a USB device on Debian
Meta
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

  • Howtos for Debian & Ubuntu GNU/Linux
  • Latest posts
Hestia | Developed by ThemeIsle
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT