Here’s a short python script I must have knocked up some time ago – and totally forgotten – hopefully it’ll be of some use to others….Purpose: backup all MySQL databases, one in each file with a timestamp on the end

We have two databases open source environment that is very reliable, namely PostgreSQL and MySQL. Both these databases have some significant differences either, PostgreSQL is an Object Relational Database Management System (ORDBMB). While MySQL is RDMS.

Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users.

For this article I’m going to install a single (virtual) server to run a standard Ruby on Rails application. I will be using Apache2 and passenger for the webserver stack and MySQL as a database server.

Debian Linux (the underlying foundation of Ubuntu) manages the startup/shutdown of MySQL quite differently from the ways I am used to. I am a long-time user of both the MySQL binary provided by Red Hat/SuSE (along with Fedora and clones like CentOS and Oracle Enterprise Linux) and the official binary from mysql.com.

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more.

This document describes how to install a Proftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota with this setup.

If you happen to own a SPARC64 box, you’ll probably already know that even if the kernel is 64bit the userland comes from the normal SPARC Debian port, so it’s 32bit. Mysql is no exception, with all the 32bit limitations – mainly the 4GB RAM per process limit.

This tutorial covers the setup of PHP 5.3.0/Lighttpd on Debian (lenny) with imap, mysql, mysqli, sqlite3, ImageMagick and mycrypt support. For this tutorial I will assume you are logged in as root this is not advised.

This guide is for Sys Admins–or people who have a bit of Sys Admin skills. While there is a plethora of database backup products for MySQL that exist, this post is not about those products. We’ll use the built-in tools of MySQL for the backup process–it is in fact, a very simple process.

Like I wrote about last week the stable version of MySQLdb leaks memory and it will crash your long running processes. These leaks are fixed in the upcoming version – which is 1.2.3c1 currently.

In this tutorial I will describe how to install and configure MyDNS-NG and MyDNSConfig 3 on Debian Lenny. MyDNS-NG is a DNS server that uses a MySQL database as backend instead of configuration files like, for example, Bind or djbdns.

Good news, mysql-server package doesn’t suck miserably on Debian 5.0 or Ubuntu 8.10, unlike previous versions did

Why Debian? Because Debian is a popular Linux distribution vendor and has small install image file. I’ve tried to install Debian with Virtual PC, VirtualBox and VMWare and have different results on different PC.