MySQL and MariaDB provide different ways to concatenate strings. Including ways to deal with NULLs.
How to add ProxySQL to our MySQL/MariaDB environment, and have it monitored by PMM. Docker allows to do this in minutes, for testing purposes.
Testing PMM as a monitoring solution for MySQL and MariaDB involves installing a lot of stuff. Let’s see how to so this in minutes with Docker.
When you write stored procedures in MySQL or MariaDB, one of the missing features is an ARRAY type. But actually, it is possible to create arrays by using the JSON type. This article explains how to work with JSON arrays.
MySQL and MariaDB don’t allow optional parameters for stored procedures, nor procedures accepting any number of parameters. However, these features can be emulated by passing JSON documents. Let’s see how.
Changing triggers in production is problematic, because for a short time triggers will be missing, or inconsistent with each other. This article proposes a solution to resolve the problem.