GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO repl@`%` IDENTIFIED BY 'repl';
flush privileges;
# for master-slave architecture
log_bin=mysql-bin
server_id=10
SHOW MASTER STATUS\G
log_bin = mysql-bin
server_id = 2
relay_log = /var/lib/mysql/mysql-relay-bin
log_slave_updates = 1
read_only = 1
CHANGE MASTER TO MASTER_HOST='mysql',
MASTER_USER='repl',
MASTER_PASSWORD='repl',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=0;
SHOW SLAVE STATUS\G
START SLAVE;
replicate_wild_do_table = test.%