YD惠州厂建standby的过程

zhgc

1. 看主数据库的配置
server-id=101
slave-skip-errors=1
expire_logs_days=30
重启数据库生效


2.权限
grant replication slave on *.* to 'repl'@'192.168.0.109' identified by 'repl';
flush privileges;



3. 导出数据

mysqldump -h192.168.0.18 -uroot -p????? --master-data --single-transaction --routines --triggers --max_allowed_packet=100M --all_databases --ignore-table=sfc.r_test_data_t --ignore-table=sfc.r_mac_used_t > "D:/yd_20200320.sql"


4.安装standy
参考http://www.nagomes.com/disc/forum.php?mod=viewthread&tid=174&highlight=my.ini


5.配置stdandy
server-id=103  
slave-skip-errors=1062,1146,1032

重启生效

6.配置参数
stop slave;
change master to
master_host='192.168.3.45',
master_user='repl',
master_password='repl',
master_log_file='log.000004',
master_log_pos=2910;


7. 导入数据
source xxx.sql




8. 打开同步
start slave

9.查看同步状况

show slave status;