One great thing about microservice architectures is that different services can use different database technologies. For example, an online store may use MariaDB to persist purchases, Redis for caching a complex catalogue, Elasticsearch for fulltext searches against...
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created in the future. But developers find this really annoying: listing the...
Do you want to improve your application’s and database server’s performance? Of course one of the most important things to do is to optimise the most impacting queries. You have various ways to find them, depending on what exactly you mean by “most impacting”....
Any comparison involving at least one NULL operand will return NULL. This is an implicit characteristics of NULL. But sometimes developers write too verbose conditions to handle NULL. For example when they want to consider NULLs equal they...
It is very important to understand Cassandra consistency levels, to choose the best balance between speed and consistency. In this article I’ve put some quick notes for persons who are new to Cassandra, and some good practices that in my opinion it’s better to...
Cassandra 4.0 GA was released on 26th July 2021. It's a great version, with lots of new features and optimisations! But... what happens to the older versions? Last time I checked, some months ago, apparently some old versions users would need to upgrade quickly,...
To automate deployments and administration, we need non-interactive programs. This is because we want to be able to apply something like an Ansible playbook, or a Puppet manifesto, and see the changes propagating to any number of remote host. If we had to manually...
Do you get this error when applications try to establish a connection to Cassandra? 2019-08-10 14:03:51,698 ERROR [com.datastax.driver.core.Cluster] (Production Cluster-reconnection-0) Authentication error during reconnection to 10.0.10.10/10.0.10.10:9042,...
MariaDB 10.6 went Generally Available (production ready)! The first GA version is 10.6.3, released on 6th July 2021. I've made a quick test and I want to put my own thoughts and comments here. For more details, take a look at the Changes and Improvements in MariaDB...
MariaDB introduced ignored Indexes in version 10.6. The feature is substantially very similar to MySQL Invisible Indexes (docs), introduced in version 8.0. Here we'll see how to use Ignored Indexes drop indexes in production with a reasonable risk. See our MariaDB...
