(Johan Andersson) There are some bug reports on the auto-discovery protocol in MySQL Cluster.

(Leo Hsu and Regina Obe) We have covered this briefly before, but its an important enough concept to cover again in more detail.

(Justin Swanhart) The Kickfire column store and SQL chip combine to achieve database performance never before seen in a small footprint and power efficient database appliance, or in any other relational database to date for that matter.

(Andrew Morgan) As many people are aware, the best performance can be achieved from MySQL Cluster by using the native (C++) NDB API (rather than using SQL via a MySQL Server). What’s less well known is that you can improve the performance of your NDB-API enabled application even further by ‘batching

(Ronald Bradford) There is a very simple test to show MySQL replication in action and to also better understand the basics of MySQL Replication. With a configured MySQL environment we can run the following test on your MySQL master, and monitor the MySQL slave.

(Giuseppe Maxia) A few months ago, Brian Aker invited me to have a look at Gearman, saying that I could find interesting combinations with MySQL Proxy. I did not forget, and I kept thinking about interesting ways of using it. The first idea that I managed to apply is not related to Proxy, but to a p

(Rob Gravelle) In the ”Write MySQL Queries Using HeidiSQL 4” article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. The latest version adds many enhancements and new features, one of which is an editor for creating stored procedures

MySQL Server (starting from v 5.0), as Oracle and SQL Servers, allows creating stored procedures and functions.

(Jonathon Coombes) I came across a situation recently where I was asked if it was possible to edit a binary log to remove a part of it to restore onto a slave server. Now the choice of doing something like a hexedit did not seem appealing, and the more experienced might suggest that it is simply a m

(Giuseppe Maxia) Among the many outstanding bugs for MySQL, there is one that has sparked a fierce discussion, not only in the bug report itself, but also in blogs, forums, mailing lists. Bug #19027: MySQL 5.0 starts even with Fatal InnoDB errors was neglected for long time, until finally it got fi