You are here: Home / Debian GNU/Linux / Servers / MySQL


by Pierre-Yves Landuré last modified Jul 02, 2013 10:37

Posts helping to setup a MySQL server on Debian GNU/Linux

  • Install and setup MySQL on Debian

    MySQL is a lightweight database management system. It is particularly suited to manage simple databases storing a large number of records. This is the preferred database management system for Web applications.

  • Ease MySQL server administration with mysql-tools

    mysql-tools is a script written with the intent to ease and automate the daily administration tasks of a MySQL server. This howto describe howto to install and use it.

  • Setup a regular analyze and optimization / defragmentation of MySQL tables

    With the flow of inserts and deletes, the MySQL tables performances can drop. Regularly optimize and analyze MySQL tables allow to rebuild the indexes and limit the disk space used by MySQL on the server.

  • Optimize MySQL on Debian

    The performances of a MySQL server are greatly dependant of the hardware where it is hosted. The hard drive latency, the available memory and the processor computation power are the main parameters of the equation. This howto help you to adjust MySQL server settings to the hardware where it is hosted.

  • Install the database firewall GreenSQL on Debian

    GreenSQL is a proxy server preventing SQL injections. Once inserted between the MySQL server and the application using a database, it protect the database from malicious attacks. This howto ease its installation on Debian GNU/Linux.

  • MySQL tips and tricks

    Various tips on the use and debugging of MySQL.

  • Install Pinba MySQL engine on Debian

    Pinba is a MySQL engine engineered to collect statistical data. Its main usage is to collect performance informations on PHP applications.

  • Setup master/slave replication between two MySQL servers

    This howto ease the setup of data replication from a MySQL master server to a MySQL slave server.