(Fernando Laudares) In my last post, “A closer look at the MySQL ibdata1 disk space issue and big tables,” I looked at the growing ibdata1 problem under the perspective of having big tables residing inside the so-called shared tablespace.

(Gerry Narvaja) Replication has been one of the most popular MySQL features since it made its way into the application more than a decade ago. However, as replication implementations became more complex over time, some limitations of MySQL’s original replication mechanisms started to surface.

(Gavin Towey) We’ve all heard the hype. MySQL 5.6 is packed with amazing new features that address all our database problems. 5.6 deals with replication and HA and performance and monitoring and security and features. It just may cure cancer.

(Mark Riddoch) Here we take a look at how one of the example filters supplied with the MaxScale 1.0 beta can answer that simplest of profiling questions – “Which of my database queries run within the MySQL server for the longest time?”.

(Jean-François Gagné) The other day, I was discussing high availability (HA) with other people. The discussion was going in the direction of, as the application was only using INSERT … ON DUPLICATE KEY UPDATE (ODKU) and traffic could be replayed, promoting a slave in case of the failure of the ma

(Anders Karlsson) We all know that in general it’s a bad idea to have columns values contain too much “hidden” information, and in particular for primary keys, this is a big no-no, although I know that not everybody agrees here.

(Ivan Cachicatari) I’m using Redmine to manage projects and bug reports, I was needing a daily report with spent time by user on each project, nothing complicated, but I wanted a cross-reference result like Excel dynamic tables. As we know, MySQL doesn’t support dynamic cross-reference queries but I

(Ulf Wendel) The MySQL replication and load balancing plugin for PHP, PECL/mysqlnd_ms, aims to make using a cluster of MySQL servers instead of a single server as transparent as possible. Should you ever want to migrate your PHP app from a single MySQL server to any kind of MySQL cluster, install PE

(Andriy Lysyuk) The unDROP for InnoDB tool can used to recover corrupt MySQL database. In this post we will show how to repair MySQL database if its files became corrupted and even innodb_force_recovery=6 doesn’t help.

(Tony Darnell) There are several ways to upgrade MySQL. In this post, we will use a combination of shell scripts and the mysqldump application to export our MySQL data, and then re-import it back into the upgraded version of MySQL.