配置Mysql主從服務(wù)實現(xiàn)實例

server-id=1
log-bin=master-bin
log-bin-index=master-bin.index

create user backup;
GRANT REPLICATION SLAVE ON *.* TO 'backup'@'192.168.%.%' IDENTIFIED BY 'mysql';

server-id=2
relay-log-index=slave-relay-bin.index
relay- log=slave-relay-bin

service mysqld restart

change master to master_host='192.168.91.128',
master_port=3306,master_user='backup',master_password='mysql',
master_log_file='master-bin.000001',master_log_pos=0;

start slave;

SHOW MASTER STATUS;

SHOW slave STATUS \G;

show variables like 'server_id';