MariaDB replica setup
MariaDB uses asynchronous replication based on binary logs (binlog). Master (source) writes changes to the binary log, slave (replica) reads the binlog from the master and replays events locally. Replication is one-way by default (master to slave). Master configuration Configure MariaDB by editing /etc/my.cnf.d/mariadb-server.cnf [mysqld] server-id=1 log_bin=binlog binlog_format=ROWbind-address =...
Preparing the SQL database in SpamAssassin
Official SQL queries Choosing the right perl DataBase Interface (DBI) module DBD::mysql (github) DBD::MariaDB (github) Depending on whether you use MySQL or MariaDB, and if you use MySQL things depend also on the version, you have to install DBD::mysql or DBD::MariaDB perl DBI module. Other connectors...
Dovecot vpopmail-auth driver removal. Migrating to the SQL driver
Those who are still using the Dovecot's vpopmail auth driver should consider a migration to another backend, as on January 4, 2021 dovecot-2.3.13 was released and the vpopmail auth driver removed (more info here). I'll show below how to support domain aliases...
Setting up and upgrading MySQL 5.x
More info here: http://dev.mysql.com/ I have tested the following guide when installing mysql 5.6, 5.5, 5.1, 5.0 version. At the time I'm writing the latest stable version is 5.6.10. Installing from source More info here: http://dev.mysql.com/doc/refman/5.6/en/installing-source-distribution.html Download: http://dev.mysql.com/downloads/mysql/#downloads You may want to install from source when...
