(Chris Travers) Dependency inversion is the idea that interfaces should depend on abstractions not on specifics. According to Wikipedia, the principle states:
Tag: Open Source
Replication checksums in MySQL 5.6
(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
Finding unreplicated tables and sequences in slony with check_postgres and nagios
(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_
DBT-3 Q3: 6 x performance in MySQL 5.6.10
(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.
Building SOLID Databases: Interface Segregation, or Keep Stored Procedures Simple
(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.
Why I Use ONLY_FULL_GROUP_BY
(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.
Efficient Partial Table Scans
(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.
Unexpected problem with triggers and mysqldump
(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
Mysqldump issue – SELECT command denied to user
(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.
The MySQL symlink trap
(Ronald Bradford) Many users of MySQL install and use the standard directories for MySQL data and binary logs. Generally this is /var/lib/mysql.
