(Dave Stokes) “MySQL’s JSON data type is great! But how do you index the JSON data?” I was recently presenting at the CakePHP Cakefest Conference and was asked that very question.

(Daniel Blanchard) In this blog entry I’d like to describe how you might be able to improve how MySQL performs on Windows by ensuring that you take advantage of a Windows specific configuration setting.

(Matthew Boehm) Greetings everyone! Let’s discuss a 3rd Party auditing solution to MySQL and how we can leverage MongoDB to make sense out of all of that data.

(Baron Schwartz) This isn’t really a feature we should brag about, because it’s a bug that took us a while to figure out, but we believe in sharing the bad as well as the good. There’s a lot to learn from TCP reassembly and protocol reverse engineering!

(Annamalai Gurusami) One of the challenges in storage engine design is random I/O during a write operation. In InnoDB, a table will have one clustered index and zero or more secondary indexes. Each of these indexes is a B-tree. When a record is inserted into a table, the record is first inserted i

(Rob Gravelle) Working the kinks out of stored procedures can be a truly frustrating experience. Outputting to the console works but can be a slow going process. Some IDEs, such as Visual Studio have SQL debugging capabilities, but what about the rest of us who don’t use a specialized IDE.

(Yves Trudeau) Ever since MySQL replication has existed, people have dreamed of a good solution to automatically split read from write operations, sending the writes to the MySQL master and load balancing the reads over a set of MySQL slaves. While if at first it seems easy to solve, the reality is

(Tony Darnell) In my previous post, I showed you a way to store tweets in MySQL, and then use Perl to automatically publish them on Twitter.

(Jay Janssen) It seems these days if anyone knows anything about tuning InnoDB, it’s that you MUST tune your innodb_buffer_pool_size to 80% of your physical memory. This is such prolific tuning advice, it seems engrained in many a DBA’s mind.

(Kedar Vaijanapurkar) Setting up a database backup is a primary task for database administrators and we see perl and shell scripts wrapped around few of the backup-tools in practice. With right tools things can look easy and today we shall look into one of that!