Репликация в режиме master-slave

Создаём пользователя в master:

CREATE USER 'replication_user'@'%' 
  IDENTIFIED BY 'new_Secret_password';

GRANT REPLICATION SLAVE 
  ON *.* 
  TO replication_user;

Далее на slave вводим:

CHANGE MASTER TO
  MASTER_HOST='10.0.0.14',
  MASTER_USER='replication_user',
  MASTER_PASSWORD='new_Secret_password',
  MASTER_PORT=3306,
  MASTER_USE_GTID = current_pos,
  MASTER_CONNECT_RETRY=30;

SET GLOBAL read_only = ON;

START SLAVE;

Проверка состояния MySQL:

SHOW SLAVE STATUS;

Если возникает fatal error 1236:

CHANGE MASTER TO MASTER_LOG_POS = 0;