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.

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.

I broke my server attempting to do some clean-up before making bigger changes. mysql would not restart, and the culprit was something like ‘apt-get purge mysql-server,’ which deleted the /etc/mysql directory .

Cherokee is a smoking hot up-and-coming web server capable of hanging with Apache while consuming exponentially less resources than its older sibling. As

For those who has forgotten or lost the password of root user in MySQL.
(Tested on Ubuntu 9.04 Jaunty Jackalope)

This tutorial shows how to set up an Ubuntu Jaunty Jackalope (Ubuntu 9.04) server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Courier POP3/IMAP, Quota, Firewall, etc.

Responding to growing demand for a professional level backup and recovery solution, Zmanda, a leading vendor for open source backup solutions, has introduced an Ubuntu server version of their Zmanda Recovery Manager (ZRM) for MySQL.

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.

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

Replication enables data from one MySQL database server (called the master) to be replicated to one or more MySQL database servers (slaves). Replication is asynchronous – your replication slaves do not need to be connected permanently to receive updates from the master, which means that updates can occur over long-distance connections and even temporary solutions [...]

Sometimes you may find the need to develop cross platform applications which make use of a database. ODBC can be a solution to your portability needs, but unfortunately it is not as easy to set up an ODBC connection on Linux as it is on Windows