Database management

CloudNativePG on minicube on openSUSE Leap Micro 6

Some time ago I’ve written a small blog about how to get openSUSE Leap Micro 6 up and running. As one of the use cases for this distributions is to run container workloads, the next natural step is(…)

PostgreSQL and huge pages on Windows

Configuring the operating system for huge pages on Linux and make PostgreSQL using it is quite simple and straight forward. Here are two quite old post on how to do this, one for Debian systems, one for(…)

Simulate (Transparent Tablespace Encryption) TDE on Oracle Standard Edition

by Alexandre Nestor Introduction The Oracle database Standard Edition do not have the Transparent Tablespace Encryption (TDE) feature which is a part of ASO (Advanced Security), and ASO is availabale only on Entreprise Edition version. But encryption(…)

Time to test: PostgreSQL 17beta1 is there

It is this time of the year when a new PostgreSQL major version beta release is available for testing. PostgreSQL 17 (scheduled to be released later this year) is no exception to that: Last week, the first beta of(…)

MariaDB – Repair Replication Through DB Restore (mariabackup)

Introduction This blog is a follow-up to my previous post: MariaDB Repair Replication through DB Restore. A client recently experienced a crash on the database slave in their MariaDB cluster within their QA environment. I successfully restored the(…)

Cześć polska! SQLDay2024 in Wrocław

Welcome to the SQLDay!! With these words, the start of the event was announced punctually at 10 am. Now the question, what can we expect? A total of 59 speakers in 49 sessions will share their(…)

MariaDB – Repair Replication Through DB Restore (mysqldump)

Introduction Maintaining database replication integrity is paramount for businesses relying on databases. Replication ensures that changes made on the master database are reliably propagated to replica databases, guaranteeing data consistency and availability across the system. In this comprehensive guide,(…)

Attending SQLDay 2024 in Wrocław, Poland

Here’s a short post about a conference I’m attending right now. SQLDay is one of the biggest events in Europe dedicated to the Microsoft data platform, including databases, Big Data and Business Intelligence solutions, and advanced data(…)

A first look at openSUSE Leap Micro 6.0

Recently the openSUSE project announced the Alpha release of Leap Micro 6.0. This version of the openSUSE operating system is optimized for container workloads and edge computing. One of the cool(…)

Another file system for Linux: bcachefs (3) – Mirroring/Replicas

This is the third post in this little series about bcachefs. The first post was all about the basics while the second post introduced bcachefs over multiple(…)