danforth danf0rth

## CHEATSHEET.MD

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                danf0rth
                / CHEATSHEET.MD
            
            
              Last active
              June 11, 2021 08:11
            
              
                MariaDB master/slave replication
              
          
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


## hosts-passwords.txt
1.2.3.4	secret-pass
123.14.144.42	another-pass