backup - Vettabase

Secure Architectures for MariaDB and Galera in AWS: VPCs and Security Groups

May 13, 2025

Running any production database deployment in the cloud requires careful consideration of both performance and security. In this article, I'll share a battle-tested approach for deploying a MariaDB Galera cluster with replicas, a ProxySQL layer in front of them, and...

Handling duplicate rows in MariaDB and MySQL

May 8, 2025

Most tables have a concept of "duplicate rows", where duplicates should never be allowed. Typical examples are: We have a product table, the name column is UNIQUE. If I'll try to insert a row with a name that already exists, the product I'm trying to insert is a...

When indexes make SQL queries slower

Apr 15, 2025

During our SQL optimisation training courses, I always stress the need of understanding how databases run SQL queries internally. Which is easier and more intuitive than you'd think, anyway. But if you overlook this aspect, there is always a risk of sticking to simple...

Email

Schedule Meeting

Phone

First steps with pgBackRest, a backup solution for PostgreSQL

Email

Schedule Meeting

Phone

Quick Links

Recent Posts

Secure Architectures for MariaDB and Galera in AWS: VPCs and Security Groups

Handling duplicate rows in MariaDB and MySQL

When indexes make SQL queries slower

Policies & Licenses

Follow Us on Social Media