### ON MASTER

```
$ yum install mariadb-server
$ systemctl restart mariadb
$ systemctl enable mariadb
$ mysql_secure_installation
```

On /etc/my.cnf, add
```
server_id=1
log-basename=master
log-bin
```

```
$ systemctl restart mariadb
$ mysql -u root -p
MariaDB [(none)]> STOP SLAVE;
MariaDB [(none)]> GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' IDENTIFIED BY '123';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> FLUSH TABLES WITH READ LOCK;
MariaDB [(none)]> SHOW MASTER STATUS;
+--------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--------------------+----------+--------------+------------------+
| mariadb-bin.000001 | 460 | | |
+--------------------+----------+---------

```

Keep session on, don’t logout. Open new terminal and dump the db to file:

```
$ mysqldump --all-databases --user=root --password --master-data > masterdatabase.sql
```

Back on the previous ternimal:

```
MariaDB [(none)]> UNLOCK TABLES;
```

Copy the dump file to slave server

```
$ scp masterdatabase.sql root@slave.server.com:/root/
```



### ON SLAVE

```
$ yum install mariadb-server
$ systemctl restart mariadb
$ systemctl enable mariadb
$ mysql_secure_installation
```

On /etc/my.cnf, put server_id=2. Then import the copy from the master database.

```
$ mysql -u root -p < masterdatabase.sql
$ systemctl restart mariadb
$ mysql -u root -p
MariaDB [(none)]> STOP SLAVE;
MariaDB [(none)]>
CHANGE MASTER TO
  MASTER_HOST='master.server.com',
  MASTER_USER='slave',
  MASTER_PASSWORD='mypassword',
  MASTER_PORT=3306,
  MASTER_LOG_FILE='mariadb-bin.000001',
  MASTER_LOG_POS=460,
  MASTER_CONNECT_RETRY=10;

MariaDB [(none)]> SLAVE START;
MariaDB [(none)]> SHOW SLAVE STATUS\G;
```