Hints to optimise queries with a LIKE comparison
Some queries with LIKE can’t use an index. However, here you can find some hints to optimise them. Continue reading Hints to optimise queries with a LIKE comparison
A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more
Our review of MariaDB 10.9 version, released in August 2022. Continue reading A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more
How to set up AWS Audit Log plugin for MySQL 8 Community
Learn how to enable an audit log plugin on the Community version of MySQL 8 Server. Continue reading How to set up AWS Audit Log plugin for MySQL 8 Community
AlloyDB versus PostgreSQL: a performance review
What is faster: PostgreSQL or AlloyDB? Some benchmarks and a performance analysis. Continue reading AlloyDB versus PostgreSQL: a performance review
Deploying an Ansible role on a Vagrant machine
Learn how to deploy Ansible roles on a Vagrant machine, possibly using the same roles that are used in production. Continue reading Deploying an Ansible role on a Vagrant machine
A summary of MariaDB 10.8: key performance improvements
New features and performance optimisations in MariaDB 10.8 short term support release. Continue reading A summary of MariaDB 10.8: key performance improvements
3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report. Continue reading 3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
Tuning PostgreSQL Auto-vacuum
Why autovacuum is important in PostgreSQL and how to configure it properly. Continue reading Tuning PostgreSQL Auto-vacuum
How to fix git mistakes
Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continue reading How to fix git mistakes
MariaDB/MySQL: Working with MD5 or other hashes
The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continue reading MariaDB/MySQL: Working with MD5 or other hashes