Database
Migrating zabbix from mysql to timescaledb - database setup Paid Members Public
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 Paid Members Public
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 Paid Members Public
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 Paid Members Public
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 Paid Members Public
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 Paid Members Public
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 Paid Members Public
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 Paid Members Public
This series covers migrating a zabbix database from mysql to timescaledb. In this post we're preparing the databases for the migration.
