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 =...
Preparare il database SQL in SpamAssassin
Query SQL ufficiali Scegliere il modulo perl DataBase Interface (DBI) corretto DBD::mysql (github) DBD::MariaDB (github) A seconda che si usi MySQL o MariaDB, e se si usa MySQL le cose dipendono anche dalla versione in uso, è necessario installare il modulo perl DBI DBD::mysql o...
Running two php/mysql/mariadb versions on the same apache web server
In a web server very old applications must coexist with new ones. Usually old applications are no more mantained and still require old versions of php and mysql, while recent apps claim to use the latest features of your apache, php...
Installing mariaDB from source
Info: http://mariadb.org/ These days many different popular Linux distributions (at the time I'm writing Slackware, Fedora, Arch, OpenSuse, Gentoo among the others) are switching to mariaDB, replacing mysql as the default db server. mariaDB is a fork of mysql, created by the former ...
