(Roland Bouman) Today, I received an email from a user of the udf_init_error UDF (which resides in the lib_mysqludf_udf library). The purpose of this UDF is to generate an error condition, which can be used to abruptly terminate a trigger or stored procedure.

(Mark Willium) MySQL database is a registered product of sun Microsystems. It is platform independent in nature that means a database administrator can install MySQL database on different operating systems like windows, Linux, and others.

(Alejandro Gervasio) In this MySQL database engine comparison article, we look at the features offered by MyISAM and InnoDB.

(Baron Schwartz) It seems to be a popular misconception that mk-slave-prefetch is designed to keep a MySQL replica server “warm” and ready to serve production traffic in case the master is demoted or fails. This is not what mk-slave-prefetch does. It’s related, and easy to confuse, but its purpose i

(Robert Hodges) Multi-master database systems that span sites are an increasingly common requirement in business applications. Yet the way such applications work in practice is not quite what you would think from accounts of NoSQL systems like Cassandra or SQL-based systems like Oracle RAC.

(Gerry Narvaja) While testing Yoshinori Matsunobo’s MHA agent I found that although the wiki has a very complete documentation, it was missing a some details.

(Jørgen Løland) When EXPLAIN shows that a table is accessed using the [eq_]ref access type, we’re used to look at the ref column to see where MySQL gets the value to look up from.

(Shlomo Priymak) This is a post about a super quick-and-dirty way to create a histogram in MySQL for numeric values.

(Robert Hodges) A previous article on this blog described Tungsten parallel replication using on-disk queues. On-disk queues are now more or less finished, and I just closed the covering issue for the feature.

(Mark Callaghan) I have more performance results for a feature enforces the maximum number of concurrent queries an account may run.