Database
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.
Maintenance mode on elasticsearch clusters
Running elasticsearch means that you'll need to perform maintnance on the nodes from time to time. This guide will describe steps that should be done when performing maintenance operations on an elasticsearch cluster.
