(David Holoboff) Yes, it has been a while since my last post. Still in the midst of MySQL ecosystem, and enjoying it tremendously. I thought I would make this post as it relates to a topic that has some varied results in the online world, and I would like to kick start this blog again.

(Miguel Angel Nieto) In the MySQL world, we’re used to playing in the MySQL Sandbox. It allows us to deploy a testing replication environment in seconds, without a great deal of effort or navigating multiple virtual machines. It is a tool that we couldn’t live without in Support.

(Todd Farmer) MySQL 5.7 makes secure connections easier with streamlined key generation for both MySQL Community and MySQL Enterprise, improves security by expanding support for TLSv1.1 and TLSv1.2, and helps administrators assess whether clients are connecting securely or not with new visibility in

(Øystein Grøvlen) While EXPLAIN shows the selected query plan for a query, optimizer trace will show you WHY the particular plan was selected. From the trace you will be able to see what alternative plans was considered, the estimated costs of different plans, and what decisions was made during quer

(Daniel van Eeden) I think SQL is a very simple language, but of course I’m biased.

(Morgan Tocker) A modern MySQL server contains a lot of useful meta-data in information_schema and performance_schema, which can help bring visibility into what is happening inside of your database server. However, sometimes this data is quite fine grained and needs finessing in order to get to that

(Jean-François Gagné) MySQL 5.6 introduced replication crash safety for single-threaded replication. I already blogged about this, more information can be found in Better Crash-safe replication for MySQL. To benefit from single-threaded crash safe replication, you need to:

(João Osorio) I’ve tried out Idera’s MySQL Query Explorer, a free tool and I found it easy to use and simple to setup. The only improvement that can be suggested is to add, on the technical requirements page, that your MySQL instance (MySQL Server version 5.5 and newer) must be running with the perf

(Cédric Bruderer) Most of you know, that it is possible to synchronize MySQL and MariaDB servers using replication. But with the latest releases, it is also possible to use more than just two servers as a multi-master setup.

(Rob Gravelle) The MySQL 5.7.7 JSON Lab release introduced a native JSON datatype, which opened the door for handling JSON data in ways that were previously impossible. In the Working with JSON Data in MySQL 7 tutorial, I presented a general overview of the new functions that were introduced to make