Database

mysql - online index creation Members Public

This post shows how easy it is to alter tables (in this example index creation) online to keep your sql database uninterrupted and clients online.

Daniel Nachtrub
Daniel Nachtrub
Database

Choosing a postgres operator Members Public

This post describes my journey on the selection of the postgres operator that matches our demand.

Daniel Nachtrub
Daniel Nachtrub
Kubernetes

When fstrim stalls your I/O subsystem Members Public

On one of our systems we had issues that - once a week - the I/O subsystem stalled and causes issues on database operations.

Daniel Nachtrub
Daniel Nachtrub
Database

postgres - database has no actual collation version, but a version was recorded Members Public

Upgrading a major postgres version using containers with different C libraries caused me some headaches because I go an error "database has no actual collation version, but a version was recorded" - and I did not fix it. At least I can give a hint on why it happend and how you could avoid it.

Daniel Nachtrub
Daniel Nachtrub
Container

postgres - upgrading postgres with timescaledb running in a container Members Public

Uprading postgres with timescaledb caused me some issues related to the collation. After some retries I've found a reliable way to doing the upgrade. This post describes the steps to be done.

Daniel Nachtrub
Daniel Nachtrub
Database

Moving an elasticsearch index to another node Members Public

When hosting a multinode elasticsearch cluster, you might run in some state where indices are not equally balanced across your nodes, until one of them starts crying about high disk usage while other nodes are barely occupied - exactly this happened in one of our customers environment. In order to

Lorenz Maier
Lorenz Maier
Database

Running postgres in kubernetes with hugepages Members Public

To run postgres in a container on nodes with huge pages enabled requires you to configure the container accordingly. This post shows how to do this on kubernetes/openshift.

Daniel Nachtrub
Daniel Nachtrub
Container

Migrating zabbix from mysql to timescaledb - migration Members Public

This series describes how to migrate a mysql database to timescaledb - use case is to migrate a zabbix application database. This part handles the migration and switchover of the server environment up to completion of the migration.

Daniel Nachtrub
Daniel Nachtrub
Database