MariaDB master/slave replication

CHEATSHEET.MD

• install mariadb-backup package on both servers
• mariadb-backup --backup --stream | ssh user@slave-host-ip 'cat > xbstream.mb' or xtrabackup --backup --stream=xbstream | ssh root@1.2.3.4 'xbstream -x -C /var/backups/mysql' with xtrabackup
• mbstream -x xbstream.mb -C /var/backups/mysql
• mariadb-backup --prepare --target-dir /var/backups/mysql
• rm -rf /var/lib/mysql/* && cp -r /var/backups/mysql/* /var/lib/mysql/
• chown -R mysql:mysql /var/lib/mysql
• service mysql start
• use your replication user to start replication