(Sheeri K. Cabral) For the past few days, I have been upgrading a few servers. We are going from Percona’s patched MySQL 5.1 to MariaDB 5.5 (the subquery optimization is excellent, and we have lots of subqueries). Our process involves upgrading a slave first, and letting it replicate for a while, an

(Shlomi Noach) Here are three security tasks I handled, which I’m happy to say were easily solved with common_schema’s views and routines (with no prior planning). Two are so easy, that I actually now integrated them into common_schema 1.3:

(Aurimas Mikalauskas) While we do have many blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really works on the h

(Shlomi Noach) Just how often do you encounter hierarchical data? Consider a table with some parent-child relation, like the this classic employee table:

(Ike Walker) I recently discovered the sync_binlog, sync_relay_log, sync_master_info, and sync_relay_log_info system variables in MySQL, and am using them to make my MySQL replication more crash safe.

(Tony Darnell) If you aren’t familiar with MySQL replication, “Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous by default – slaves need not to connected permanently to receive update

(Giuseppe Maxia) MySQL 5.6 seems to be ready for GA. I have no inside information about it, but from some clues collected in various places I feel that the release should not be far away. Thus, it’s time for some serious testing, and for that purpose I have worked at updating MySQL Sandbox with some

(Craig Kerstiens) If you missed my previous post on Understanding Postgres Performance its a great starting point. On this particular post I’m going to dig in to some real life examples of optimizing queries and indexes.

(Giuseppe Maxia) While testing MySQL 5.6, I came across some curious values for the new values used to set the crash-safe slave tables. To get safety, we need to set relay_log_info_repository and master_info_repository to ‘TABLE’.

(Leo Hsu and Regina Obe) In the last article we said you can’t have a LEFT JOIN with LATERAL. Turns out we were mistaken and YES indeed you can and when you do it is equivalent or more powerful than SQL Server’s OUTER APPLY.