```{index} репликация, ошибки
```


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

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

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

GRANT REPLICATION SLAVE 
  ON *.* 
  TO replication_user;
```

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

```mysql
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:

```mysql
SHOW SLAVE STATUS;
```

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

```mysql
CHANGE MASTER TO MASTER_LOG_POS = 0;
```