change_mysql_relay_bin_log_directory.md

change_mysql_relay_bin_log_directory.md

• Change the relay_log variable in the my.cnf to relay_log = /mnt/relay/mysql_relay_bin

• Stop mysqld

systemctl stop mysqld

• Move all relay_log to new location:

mv /var/lib/mysql/mysql_relay_bin.* /mnt/relay/
chown mysql:mysql /mnt/relay/ -R

• Start mysqld

systemctl start mysqld

• Start slave

mysql -A -e "START SLAVE"