(Daniel Kowalewski) In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL.

(Guilhem Bichot) Here is the second in a series of posts about CTEs, a new feature of MySQL 8.0, available in this Labs release. The first post ended with:

(Alexander Rubin) This blog discusses the gradual end of MyISAM in MySQL.

(Rob Gravelle) Without question, one of the most common tasks performed by Database Administrators (DBAs) is identifying and weeding out duplicate values in tables. The trouble is, what constitutes a duplicate is not universal across datasets.

Graphs are important, as they’re your window onto your monitored systems. ClusterControl comes with a predefined set of graphs for you to analyze, these are built on top of the metric sampling done by the controller. Those are designed to give you, at first glance, as much information as possible ab

(Ståle Deraas) Just as you use a database like MySQL to store your application data, MySQL must also store its meta data (schema names, table definitions etc) somewhere. Traditionally this meta data storage has been split between many different locations (.FRM, .PAR, .OPT, .TRN and .TRG files).

(David Bennett) This blog post discusses how to use MySQL shell securely from Bash.

(jdduncan) How does an application configure its database connection? I find this to be a pretty interesting question. As the application moves from a developer’s workstation to a test harness, then to staging, and on to production, the database connection properties can change each time

(Catalin Besleaga) In MySQL 5.7 we introduced JSON functionality into the MySQL Server. This work included the introduction of a JSON data type, virtual columns and a set of approximately 20 SQL functions that allow you to manipulate and search JSON data on the server side.

(Vitor Oliveira) A previous blog post exposed the main factors affecting Group Replication performance, which was followed by another that showed the scalability of both single-master and multi-master throughput.