MySQL主从复制


MySQL主从复制

 



FLUSH TABLES WITH READ LOCK;
UNLOCK TABLES;

server-id=1
log-bin=mysql-bin
binlog_do_db=test

GRANT REPLICATION SLAVE ON *.* to 'test'@'10.0.0.6' identified by '123456';

change master to master_host='10.0.0.7',
master_port=3306,
master_user='slave',
master_password='XeDUMevzoigvx3c7',
master_log_file='master-bin.000001',
master_log_pos=0;

start slave

show slave status