MySQL配置主从数据库
log-bin=hui
server-id=1
service mysqld restart
server-id=2
service mysqld restart
mysql -uroot -p
create user 'repl'@'%' identified with mysql_native_password by 'Hui199845.';
grant replication slave on *.* to 'repl'@'%';
flush privileges;
flush tables with read lock;
show master status;
mysqldump --all-databases > dbdump.db -uroot -p
scp root@192.168.240.71:~/dbdump.db .
mysql < dbdump.db -uroot -p
unlock tables;
mysql> change master to
-> master_host='192.168.240.71',
-> master_user='repl',
-> master_password='Hui199845.',
-> master_log_file='hui.000002',
-> master_log_pos=438;
start slave;
show slave status\G
stop slave;