Databases
Databases servers installation guides for 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 I wrote with the goal to ease and automate the regular 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 and setup PostgreSQL on Debian
PostgreSQL is a powerfull database management system. It can be seen as an free and open-source Oracle. One of its functionalities is the geolocation data storage. This howto ease the installation of PostgreSQL server on Debian.
-
Ease PostgreSQL server administration with pgsql-tools
pgsql-tools is a script I wrote with the goal to ease and automate the regular administration tasks of a PostgreSQL server. This howto describe howto to install and use it.
-
Install Memcached on Debian
Memcached is a key/value database server easing the cache of objects in memory. It is largely used by some PHP CMS (Wordpress, Drupal, Prestashop, ...) for it bring a visible performance boost on server with available RAM. This howto ease the installation of Memcached on Debian
-
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.
