yum install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker
yum install perl-ExtUtils-MakeMaker perl-CPAN perl-CPAN perl-CPANPLUS -y
yum install perl-Config-Tiny perl-Time-HiRes Log::Dispatch
grant replication slave on *.* to 'repl'@'10.26.100.%' identified by 'yueying9sedefwwe' ;
grant replication slave on *.* to 'root'@'10.26.100.%' identified by 'yueying9sedefwwe' ;
CHANGE MASTER TO MASTER_HOST='10.26.100.51',MASTER_USER='repl', MASTER_PASSWORD='yueying9sedefwwe',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=1;
/dbdata/awdb01/bin/mysqldump --master-data=2 --single-transaction -R --triggers -A -uroot -p> /root/awdb01_all.sql
CHANGE MASTER TO MASTER_HOST='10.26.100.51',MASTER_USER='repl', MASTER_PASSWORD='yueying9sedefwwe',MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=1115
文档更新时间: 2019-12-16 06:38 作者:月影鹏鹏