Database
Moving an elasticsearch index to another node
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
Running postgres in kubernetes with hugepages
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.
Migrating zabbix from mysql to timescaledb - migration
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.
Migrating zabbix from mysql to timescaledb - database setup
This part continues our mysql to timescaleDB migration. We prepare our target database and add some helpers on the source to create a resumable process.
Rocketchat fails after upgrade with index error
Upgrading rocketchat to version 5.0 resulted in some minor issues that prevented the system from starting - both are related to the database and can easily be fixed.
Forever growing zabbix database
Starting with zabbix 6.0 some new featuers have been added - for example audit logging. This post shows downsides / limitations of audit logging on this release and how to avoid negative impact of this.
upgrade postgres with timescaledb
Upgrading postgres can be a challenging task, because databases are mostly in use. Having extensions like timescaledb introduces even more complexity. This guide shows a fast way to upgrade a postgres database with timescaledb.
Exchange database fails with serious I/O error
Running exchange servers there's a slight chance that the database growth results in a state where the filesystem cannot allocate anymore segments. Let's fix this.