Master上授权从库:


grant replication slave on *.* to slave1@ip identified by 'password';

逻辑备份:


mysqldump --single-transaction --master-data database -uroot -pp[......]

Read more