(SQLHJALP) Explain…. It is a very simple command that I feel is one of the most overlooked commands by new MySQL users. It is also a very valuable command available for MySQL.

(Danil Zburivsky) MySQL Replication is a powerful tool and it’s hard to find a production system not using it. On the other hand debugging replication issues can be very hard and time consuming. Especially if your replication setup is not straightforward and you are using filtering of some kind.

(Robert Hodges) Earlier this month I published an article on this blog describing the system of record approach to multi-master replication. As mentioned in that article my colleagues and I at Continuent have been working on improving Tungsten to make system of record design patterns easier to impl

(Peter Zaitsev) Dealing with MySQL you might need to deal with RAID recovery every so often. Sometimes because of client lacking the proper backup or sometimes because recovering RAID might improve recovery, for example you might get point in time recovery while backup setup only takes you to the po

(Domas Mituzas) MySQL is needlessly slow at accepting new connections. People usually work around that by having various sorts of connection pools, but there’s always a scale at which connection pools are not feasible.

(Peter Zaitsev) Core file can be quite helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially with recent Linux distributions which have security features to prevent core files to be dumped by setuid processes (and MySQL Server is most commonly ran changing user from “roo

(Johan Andersson) We regularly receive questions from our user community with regards to which AMIs to use when deploying database clusters on Amazon EC2.

(Nilnandan Joshi) There are two filesort algorithms in MySQL for sorting and retriving select queries results.

(André Araujo) Yesterday I was discussing with a fellow DBA about ways to check the status of existing and/or past RMAN jobs. Good backup scripts usually write their output to some sort of log file so, checking the output is usually a straight-forward task.

(Tony Darnell) MySQL provides you with a nice utility for creating a backup of your databases. From the mysqldump documentation page: “The mysqldump client is a backup program originally written by Igor Romanenko.