Database
mysql - online index creation Paid 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.
Choosing a postgres operator Paid Members Public
This post describes my journey on the selection of the postgres operator that matches our demand.
When fstrim stalls your I/O subsystem Paid 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.
postgres - database has no actual collation version, but a version was recorded Paid 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.
postgres - upgrading postgres with timescaledb running in a container Paid 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.
Moving an elasticsearch index to another node Paid 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
Running postgres in kubernetes with hugepages Paid 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.
Migrating zabbix from mysql to timescaledb - migration Paid 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.
