(Peter Zaitsev) I recently worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade scenario which can cause surprises. Master and few slaves need to be upgraded. It is a shared database used by tons of applications written by many peopl

(Andrew Morgan) MySQL Replication is incredibly simple to get up and running and this (short) post steps you through it.

(depesz) Foreign keys are known for couple of things, but speeding up your system is not one of them. But sometimes, having them in place lets you make queries significantly faster.

(Chris Schneider) MySQL Enterprise Monitor was highlighted during “MySQL Sunday” at the Oracle Open World conference this past month. Given the ease of implementation and helpful GUI tools, MySQL Enterprise Monitor provides almost instant benefits for any MySQL shop.

Often we make some sketches of the database we plan to create on a blackboard or a sheet of paper before we actually design its structure on computer. After that we discuss the entities we’ve got, normalize them and repeat these actions several times. As a result we get a completely approved databas

(Ronald Bradford) Announced at MySQL Sunday was the Release Candidate edition of MySQL 5.5.6. Also noted by Geert where he points out the default storage engine is now InnoDB.

(Jason Gilmore) Whether you host your website and database internally or you use a hosting provider, it is of paramount importance that you institute a rigorous backup policy. If you’re using MySQL, several easily implementable options are at your disposal. This article introduces one such option by

(Shane Bester) I’ll try to pass on some basic knowledge about those confusing stack traces we sometimes see in the mysql error logs. What can you tell from them, what are they useful for, and how to validate them?

(Sachin Khosla) MySQL queries are usually written once and then wrapped in class functions to minimize code repetition. This article lists the 10 queries used most often in MySQL.

(Markus Winand) There was an interesting index related performance problem on Stack Overflow recently. The problem was to check an input string against a table that holds about 2000 prefix patterns (e.g., LIKE ‘xyz%’). A fast select is needed that returns one row if any pattern matches the input str