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.
sudo root shell with autocomplete
Switching user using sudo results in a limited shell without command completion. Using the right sudo command omits this limit and provides a fully fledged shell.
Change BIOSGUID in Hyper-V machines
Using templated virtual machines on hyper-v comes with some issues if you need to ensure that each VM has a unique identity. This guide will show how you'll assign a unique identity for linux VMs.
docker swarm - preserve client ip on incoming connections
Running services in docker swarm utilizes the docker swarm routing mesh which results in source nat (snat). If you need to bypass this, check out this guide.
git on windows on CA's without crl (mostly pki)
If you're working with git and are using certificates without revocation lists on windows this article shows how you can disable ssl revocation checks on git client.
Performance issue with hyper-threading
On some of our setups we had an issue with VM to VM latencies (no the same host) ranging between 1000-2000ms. This article will describe the issue and how we solved it.
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.
