mysql master slave搭建

[mysqld]
log-bin = master-bin
log-bin-index = master-bin.index
server-id = 1

CREATE USER repl_user;

GRANT REPLICATION SLAVE ON *.* TO repl_user IDENTIFIED BY ‘123456‘;

[mysqld]
server-id = 2
relay-log-index = slave-relay-bin.index
relay-log slave-relay-bin

CHANGER MASTER TO
MASTER_HOST = ‘master-1‘,
MASTER_PORT = 3306,
MASTER_USER = ‘repl_user‘,
MASTER_PASSWORD = ‘123456‘;

START SLAVE;