(Sean Hull) DRBD is a Linux project to provide a real time distributed filesystem. Part two of this series will dig deep into a real-world installation example. We’ll use Sun’s virtualbox software to create a couple of VMs, then configure those VMs with DRBD, and finally install and test MySQL run

(Kristopher Wilson) Another cool feature I’ve recently discovered in PostgreSQL, although one available and documented for a long time, is table inheritance, which works almost exactly like object inheritance in object oriented programming. This simply means that you can have tables inheriting colum

(Simon Mudd) Normally I like to use the OS’s package manager to manage the software on my system. This ensures that things are done consistently. When managing MySQL I’d also like to manage all my instances the same way. That makes life easier for me but also for my fellow DBAs and sysadmin colleagu

(Robert Hodges) Software-as-a-Service (Saas) is one of the main growth areas in modern database applications. This topic has become a correspondingly important focus for Tungsten, not least of all because new SaaS applications make heavy use of open source databases like MySQL and PostgreSQL that T

(Mark Callaghan) I have written about the new support for group commit in the InnoDB plugin and the lack of support for it in the binlog. I will attempt to describe how commit is done for MySQL 5.1 and the InnoDB plugin. The current code can limit performance depending on your workload. I think it i

(Rob Gravelle) A cross tabulation query, or cross tab for short, is used to display the calculation of a sum, average, count, or other type of total on two or more fields. The results are then presented in a table format in which one field is displayed down the left side of a matrix (row headings) a

(Jack Wallen) I have covered MySQL in a number of ways so far. You can read how to administer your MySQL database with MySQL Workbench (see my article “Complete database administration package MySQL Workbench“), MySQL Administrator (see my article “Creating a database with MySQL Administrator“), MyS

(Gavin Towey) This is a solution that I’ve seen a few people have trouble with now, so I want to make more people aware of it:

(Giuseppe Maxia) Several people have suggested a more flexible approach at mysqldump output in matter of user privileges.

(Michael McLaughlin) Alas, poor ereg() I abused you well. PHP 5.3 has deprecated ereg() and now we must move forward with preg_match(). Along with that change, somebody asked me to show how to upload images to the file system as opposed to the database. Personally, I think they should be stored in t