binglog实时备份-20201020

 
  1.  
mysql>  grant replication slave on *.* to 'log_backuper' @'localhost' identified by '123456';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    15
Current database: *** NONE ***
 
Query OK, 0 rows affected, 2 warnings (0.58 sec)
 
  1.  
[root@localhost ~]# mkdir /data/back/binlog_backup
  1.  
[root@localhost ~]# mysqlbinlog --raw --read-from-remote-server --stop-never --host localhost --port 3306 -ulog_baker -p123456 log-bin.000021
 
 
  1. 启用gtid复制时，备份二进制日志 报错
[root@localhost run]# mysqlbinlog --raw --read-from-remote-server --stop-never --host localhost --port 3306 -uroot -p123456 log-bin.000031mysqlbinlog: [Warning] Using a password on the command line interface can be insecure.
ERROR: Got error reading packet from server: Cannot replicate anonymous transaction when @@GLOBAL.GTID_MODE = ON, at file /data/my3306/log/binlog/log-bin.000070, position 154.; the first event 'log-bin.000031' at 4, the last event read from '/data/my3306/log/binlog/log-bin.000070' at 219, the last byte read from '/data/my3306/log/binlog/log-bin.000070' at 219.
 
创建时间：2021-12-22 09:20
넶浏览量：0
ꄴ前一个： 无
ꄲ后一个： 无