Author - Federico Razzoli

A Look at MariaDB Subquery Cache

MariaDB Subquery Cache

The MariaDB subquery cache feature added in MariaDB 5.3 is not widely known. Let’s see what it is and how it works.
What is a subquery cache?
The MariaDB subquery cache optimizes the execution of correlated subqueries. Correlated subqueries refer to a value from the parent query. For example:

Shell

SELECT id FROM product WHERE price NOT IN (SELECT […]

Read more

Consul Architecture

consul

In this blog post, I’ll provide my thoughts about Consul for ProxySQL service discovery and automation.
I approached Consul recently while looking for a service discovery and configuration automation solution for ProxySQL. My colleague Nik Vyzas wrote a great post on this topic, and I suggest you read it. I wrote this article to share my first impressions […]

Read more

MariaDB 10.2 CHECK and DEFAULT clauses

MariaDB 10.2 CHECK and DEFAULT

In this blog post, we’ll look at the MariaDB 10.2 CHECK and DEFAULT clauses.
MariaDB 10.2 includes some long-awaited features. In this blog, we are going to discuss the improvements to some table definitions: the DEFAULT clause and the CHECK constraints. These clauses describe columns default values and rules for data validation.
Note that MariaDB 10.2 […]

Read more