MySQL
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.