Below are some parameters I found to improve the speed of my ZFS volumes. zfs set xattr=sa <poolname> zfs set acltype=posixacl <poolname> zfs set compression=lz4 […]
GlusterFS Performance improvements
Here is a list of parameters I found over time to improve the speed of my GlusterFS instances. gluster volume set <volname> config.global-threading on gluster […]
How to GlusterFS to a new hostname
While it is rather easy to change the hostname of the Linux box the GlusterFS is sitting, Gluster might not be so kind. Good thing […]
Prevent SSH connection from timing out
In case you are plagued by SSH connections dying in the worst moments and the following waiting period, here might be the solution to your […]
Verify all users eMail-Adress over GitLab Rails console
With the release of GitLab 13.2 I ran into a serious issue when logging in. The issues behaviour was, that I would only get an […]
Get random entries in MySQL and MariaDB
If you want to get a random value (or more than one) from a MariaDB or MySQL database, you can accomplish this quite easy. All […]
Certbot challenge behind reverse proxy
To fulfil the certbot HTTP-01 challenge for receiving a Let’s Encrypt certificate you need to have a document root that is reachable from the internet. […]
Why is varchar(255) not varchar(255)?
Working on a clients question, I stumbled over an issue with replication and mixed character sets. I was asked, wether it is possible to replicate […]
Multiple web sites behind one domain
Edit the site config of the Apache web server. You can find them under /etc/apache2/sites-available/ (If they are not there, I am sorry, but Google […]
How changing the table definition can break your replication
MySQL replication has become quite sturdy over the years, but there are some things it still does not like. One of this is changing the […]