10.20.6.30 - Slave Database
Code: Select all
pico /etc/mysql/mysql.conf.d/mysqld.cnf
Code: Select all
bind-address = 127.0.0.1
Code: Select all
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
Code: Select all
binlog_do_db = newdatabase
binlog_do_db = newdatabase2
Code: Select all
sudo service mysql restart
Code: Select all
mysql -u root -p
GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
in 10.20.6.30 a.k. the slave
Code: Select all
pico /etc/mysql/mysql.conf.d/mysqld.cnf
Code: Select all
server-id = 2
relay-log = /var/log/mysql/mysql-relay-bin.log
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = newdatabase
binlog_do_db = newdatabase2
Code: Select all
sudo service mysql restart
CHANGE MASTER TO MASTER_HOST='10.20.6.29',MASTER_USER='slave_user', MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000001';
Code: Select all
START SLAVE;
SHOW SLAVE STATUS\G
Code: Select all
SLAVE STOP;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
SLAVE START;