#replication master
server-id               = 1
binlog_do_db            = newdatabase
log_bin                 = /var/log/mysql/mariadb-bin
relay_log               = /var/log/mysql/relay-bin

#replication slave\master
server-id               = 2
binlog_do_db            = newdatabase
log_bin                 = /var/log/mysql/mariadb-bin
relay_log               = /var/log/mysql/relay-bin
log-slave-updates       = ON

#replication slave
server-id               = 3
binlog_do_db            = newdatabase
log_bin                 = /var/log/mysql/mariadb-bin
relay_log               = /var/log/mysql/relay-bin

GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
USE newdatabase;
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS
mysqldump -u root -p newdatabase > newdatabase.sql
UNLOCK TABLES;
CREATE DATABASE newdatabase;  #on slave
mysql -u root -p newdatabase < newdatabase.sql
CHANGE MASTER TO MASTER_HOST='172.17.0.2', MASTER_USER='slave_user', MASTER_PASSWORD='password', MASTER_LOG_FILE='mariadb-bin.000004', MASTER_LOG_POS=501;
START SLAVE
STOP SLAVE
RESET SLAVE ALL