DB Wiki

set persist server_id = 2;

service mysql restart
systemctl restart mysql

create user 'repl'@'ubuntu-slave' identified by 'ipswich';
grant replication slave on *.* to 'repl'@'ubuntu-slave';

flush tables with read lock;

show master status;
+---------------+----------+--------------+------------------+-------------------+
| File          | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+---------------+----------+--------------+------------------+-------------------+
| binlog.000011 |      904 |              |                  |                   |
+---------------+----------+--------------+------------------+-------------------+

mysqldump -uroot -p --all-databases --master-data --add-drop-database > ubuntu-master.dmp
unlock tables;
mysql -uroot -p < ubuntu-master.dmp

mysql> CHANGE MASTER TO
       ->     MASTER_HOST='ubuntu-master',
       ->     MASTER_USER='repl',
       ->     MASTER_PASSWORD='welcome123',
       ->     MASTER_LOG_FILE='binlog.000011',
       ->     MASTER_LOG_POS=904;
	
mysql> start slave;

mysql> show slave status\G

mysql> stop slave
mysql> stop slave io_thread  (Stop reading events from the Master Binary Log)
mysql> stop slave sql_thread (Stop reading events from the Slave Relay Log)