(Chris Travers) Dependency inversion is the idea that interfaces should depend on abstractions not on specifics. According to Wikipedia, the principle states:

(Stephane Combaudon) MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many people misunderstand the real added value of this new feature. I heard people think that with replication checksums, data integrity between the master an

(Jeff Frost) Since slony doesn’t automatically add tables to replication for you, sometimes it’s handy to double check that everything is being replicated. If your slony cluster is named “sample” then you would have a slony schema named “_sample”. As such, you can query against the sl_table and sl_

(Jorgen Loland) When MySQL gets a query, it is the job of the optimizer to find the cheapest way to execute that query. Decisions include access method (range access, table scan, index lookup etc), join order, sorting strategy etc.

(Chris Travers) As far as interfaces go, we are talking specifically about functional interfaces (UDF’s, or “User Defined Functions”, and stored procedures). Raw interfaces like SQL queries have very different profiles of issues.

(Ike Walker) MySQL uses the concept of SQL_MODE to “define what SQL syntax MySQL should support and what kind of data validation checks it should perform”. This post is about one of those modes, ONLY_FULL_GROUP_BY, and why I use it.

(Gavin Towey) There’s a pretty common MySQL recipe for performance that if you want to efficiently scan through lots of rows in small chunks that LIMIT with OFFSET is right out.

(Stephane Combaudon) Some time ago, I had to convert all tables of a database from MyISAM to InnoDB on a new server. The plan was to take a logical dump on the master, exporting separately the schema and the data, then edit the CREATE TABLE statements to ensure all tables are created with InnoDB, an

(Gregory Steulet) During one of my last MySQL mission, I encountered a “security error” with mysqldump. The mission was about migrating a MySQL database from one box to another MySQL version and from Windows to Linux with different users.

(Ronald Bradford) Many users of MySQL install and use the standard directories for MySQL data and binary logs. Generally this is /var/lib/mysql.