(Robert Hodges) This article is the second in a series on data fabric design and introduces the transactional data service design pattern. The previous article in this series introduced data fabrics, which are collections of off-the-shelf DBMS servers that applications can connect to like a single

(Dathan Pattishall) Ever run into a problem where an application’s Master is accepting all the writes and the master’s slaves lags? Ever had this same problem yet the Slave has a raid array of very fast SSDs? You must be thinking to yourself, “I call BS, Dathan; a SSD drive can do crazy IOPS”. No, i

(Rob Gravelle) A few years ago, I had the opportunity to work on a system that performed full-text searches on stored documents in combination with some database key fields.

(Maciej Dobrzanski) In a world driven by computers, most companies rely on systems that are entirely built around databases. Losing data, or even as little as losing the full control over it, could bring any business down. Frequently databases hold sensitive information such as personal details, tra

(Ovais Tariq) While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3.

(Michael McLaughlin) Last October I posted an example and description of a common_lookup table. It was intended to show how common_lookup tables support drop down selections in web forms. However, it wasn’t adequate to show how they work with existing data, and the function only supported fresh quer

(Tony Darnell) In my last two posts, I wrote about setting up replication with MySQL 5.6 using Global Transaction Identifiers. Even when I set up replication “the old-fashioned way“, one thought always enters my mind – did all of the data copy over to the slave?

(Jeremy Smyth) MySQL accesses files in various places on the file system, and usually this isn’t something to worry about. For example, in a standard MySQL 5.5 installation on Ubuntu, the data goes in /var/lib/mysql, and the socket is a file in /var/run/mysqld.

(Chris Travers) Like the Single Responsibility Principle, the Open/Closed Principle is pretty easy to apply to object-relational design in PostgreSQL, very much unlike the Liskov Substitution Principle which will be the subject of next week’s post. However, the Open/Closed principle applies only in

(Michael McLaughlin) Somebody ran into a problem after reading about the MySQL CREATE statement and the AUTO_INCREMENT option. They couldn’t get a CREATE statement to work with an AUTO_INCREMENT value other than the default of 1. The problem was they were using this incorrect syntax: