mysql 双主集群故障修复

mysqldump -uroot -p'密码' --single-transaction --master-data=2 -A > 
/root/20250626/all_database.sql 2>/root/20250626/mysqldump_warnings.log

stop slave;
reset slave all;

change master to master_host='10.215.11.200',
master_port=3306,
master_user='repl',master_password='repl密码',
master_log_file='binlog.000**',master_log_pos=*****;
start slave;
show slave status\G

show variables like '%time_zone%'
SELECT @@global.time_zone, @@session.time_zone;