Planet MariaDB Server
CPU efficiency for MariaDB, MySQL and Postgres on TPROC-C with a small server
I started to use TPROC-C from HammerDB to test MariaDB, MySQL and Postgres and published results for MySQL and Postgres on small and large servers. This post provides more detail…
Active-Active MySQL Group Replication Best Practices
In MySQL Group Replication (MGR) or Group Replication, an active-active configuration allows multiple group members to accept concurrent write transactions. These writes are coordinated through a consensus-based group communication system…
Active-Active MySQL Group Replication Best Practices
In MySQL Group Replication (MGR) or Group Replication, an active-active configuration allows multiple group members to accept concurrent write transactions. These writes are coordinated through a consensus-based group communication system…
Running pgBackRest with pg_tde: A Practical Percona Walkthrough
Not every PostgreSQL installation requires encryption at rest. However, for organizations mandating strict data protection and privacy standards, it is often non-negotiable. When security policies are this rigorous, you need…
I Built an AI That Impersonates Me on Slack, and It Was Disturbingly Easy
I spend a lot of time in Slack. Most people in tech do. It’s where a lot of “work” happens such as quick questions, async decisions, the “hey can you…
The first rule of database fight club: admit nothing
I am fascinated by tech marketing but would be lousy at it.A common practice is to admit nothing — my product, project, company, idea is perfect. And I get it…
Multi-Tenant, Multi-Cloud Logical and Bi-Directional Replication Deep Dive
Before we dive deep into the fascinating world of PostgreSQL Logical and Bi-Directional Replication (BDR), let’s take a quick moment to look at multi-tenancy and multi-cloud strategies. Setting the stage…
Multi-Tenant, Multi-Cloud Logical and Bi-Directional Replication Deep Dive
Before we dive deep into the fascinating world of PostgreSQL Logical and Bi-Directional Replication (BDR), let’s take a quick moment to look at multi-tenancy and multi-cloud strategies. Setting the stage…
Row Deletion Jobs Done Right
I am continuing my blog post series on using indexes — or tables — as queues. In this post, I cover Row Deletion Jobs (I do not call these purge jobs, to avoid confusion…
Row Deletion Jobs Done Right
I am continuing my blog post series on using indexes — or tables — as queues. In this post, I cover Row Deletion Jobs (I do not call these purge jobs, to avoid confusion…
PostgreSQL 18 OIDC Authentication with Ping Identity using pg_oidc_validator
PostgreSQL 18 introduced native OAuth 2.0 authentication support, marking an important step towards modern, centralized identity-based access control. However, since every identity provider implements OpenID Connect (OIDC) slightly differently, PostgreSQL…
The “bus factor” risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite
Features and performance are important when choosing databases, but so it is the “bus factor” risk
Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries)
I am starting a blog post series on using indexes — or tables — as queues. I had this series in the back of my mind for some time. This started a few years…
Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries)
I am starting a blog post series on using indexes — or tables — as queues. I had this series in the back of my mind for some time. This started a few years…
Hardening MySQL: Practical Security Strategies for DBAs
MySQL Security Best Practices: A Practical Guide for Locking Down Your Database Introduction MySQL runs just about everywhere. I’ve seen it behind small personal projects, internal tools, SaaS platforms, and…