Database
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.
Triggering elasticsearch ilm step manually
Elasticsearch provides an index lifecycle management that will handle traversal of indices through a whole bunch of lifecycle steps. Sometimes you might want to give the ILM a small tap and move to a specific step manually. This guide will explain how this can be done.
The one when compatible foreign keys are incompatible
Upgrading our ghost blog ran into issues migrating the database schema. Foreign keys failed with "Referencing column and referenced column in foreign key constraint are incompatible.". Let's fix it.
Migrating zabbix from mysql to timescaledb - setting up environment
This series covers migrating a zabbix database from mysql to timescaledb. In this post we're preparing the databases for the migration.
Migrating zabbix from mysql to timescaledb - introduction
Depending on the size of your zabbix environment, you might want to migrate from mysql to timescaledb. This guide will show how this can be done.
