(Shlomi Noach) I fully agree with Morgan’s An argument for not using mysqldump. This post does not come to contradict it, but rather shed a positive light on mysqldump.

(Sheeri Cabral) MySQL events have been in GA for 2 years. Events are not used as much as I would like — often organizations will have cron jobs or scheduled tasks to perform ETL, maintenance and small aggregation tasks. For example, a website that shows how many users are logged in might update a

(Andrew Morgan) A few months ago, I posted a walkthrough of how to extend MySQL Enterprise Monitor in order to monitor MySQL Cluster. The great news is that as of MySQL Enterprise Monitor 2.3 (available from Oracle E-Delivery since 1st November) this functionality is included in the core product and

(Shlomi Noach) Revision 208 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision:

(Robert Eisele) The biggest challenges of today’s web development are performance, scalabilty, rapid development and maintainability of the source code. Usually one quickly sets on abstraction models such as MVC, which poor covers the above mentioned requirements for today’s development.

(Ronald Bradford) There are three simple practices that can improve general INSERT throughput. Each requires consideration on how the data is collected and what is acceptable data loss in a disaster.

Backups may seem like a complicated subject, but they can be simplified into one multi variable question. What $DATA is so important that you don’t feel you could be missing it for $TTR and you can’t lose more than $RPO of it?

(Chris Schneider) Knowing how to index a schema based on the queries using the system is a great skill to have. In the majority of the systems I have worked on, the schema is always updated and changed based on the needs and focus of the application. That said, it can be somewhat difficult to keep u

(Giuseppe Maxia) A few days ago I saw an article about Semi-Synchronous Replication in MySQL 5.5. It asks questions, and doesn’t give answers beyond gut feeling. So I thought that I would do some practical testing of this new feature.

(Johan Andersson) From MySQL Cluster 7.1.9 (not yet released) it is possible to get better stats on disk data tables. In fact, the statistics makes it possible to tune the DiskPageBufferMemory parameter (similar to innodb_bufferpool), in order to avoid disk seeks.