Month: March 2018

MySQL master / slave replication

There are tons of tutorials about setting up master / slave replication for MySQL. Here are my own quick notes: 1. Master: /etc/mysql/my.cnf [mysqld] server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 1 max_binlog_size = 100M 2. Slave: /etc/mysql/my.cnf [mysqld] server-id = 2 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M 3. Master: granting […]

proftpd + mod_sql: solving “slow login” problem

I had a very annoying problem with proftpd, which seems a common one at first sight: slow login and the problem, that a lot of ftp clients out there have a low timeout setting configured. The problem is that googling “slow connection” or “slow login” in combination with “proftpd” led me in a totally wrong […]