Mysql大数据备份及恢复
复制mysql> show binlog events; +------------------+------+----------------+-----------+-------------+-----------------------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +------------------+------+----------------+-----------+-------------+-----------------------------------------------------------------------------------+ | mysql-bin.000001 | 4 | Format_desc | 1 | 123 | Server ver: 5.7.13-log,数据 Binlog ver: 4 | | mysql-bin.000001 | 123 | Previous_gtids | 1 | 154 | | | mysql-bin.000001 | 154 | Anonymous_Gtid | 1 | 219 | SET @@SESSION.GTID_NEXT= ANONYMOUS | | mysql-bin.000001 | 219 | Query | 1 | 316 | createdatabase test1 | | mysql-bin.000001 | 316 | Anonymous_Gtid | 1 | 381 | SET @@SESSION.GTID_NEXT= ANONYMOUS | | mysql-bin.000001 | 381 | Query | 1 | 525 | use `test1`; createtable tb1(id intprimarykey auto_increment,namevarchar(20)) | | mysql-bin.000001 | 525 | Anonymous_Gtid | 1 | 590 | SET @@SESSION.GTID_NEXT= ANONYMOUS | | mysql-bin.000001 | 590 | Query | 1 | 663 | BEGIN | | mysql-bin.000001 | 663 | Table_map | 1 | 713 | table_id: 108 (test1.tb1) | | mysql-bin.000001 | 713 | Write_rows | 1 | 758 | table_id: 108 flags: STMT_END_F | | mysql-bin.000001 | 758 | Xid | 1 | 789 | COMMIT /* xid=10 */ | | mysql-bin.000001 | 789 | Anonymous_Gtid | 1 | 854 | SET @@SESSION.GTID_NEXT= ANONYMOUS | | mysql-bin.000001 | 854 | Query | 1 | 927 | BEGIN | | mysql-bin.000001 | 927 | Table_map | 1 | 977 | table_id: 108 (test1.tb1) | | mysql-bin.000001 | 977 | Write_rows | 1 | 1026 | table_id: 108 flags: STMT_END_F | | mysql-bin.000001 | 1026 | Xid | 1 | 1057 | COMMIT /* xid=11 */ | | mysql-bin.000001 | 1057 | Rotate | 1 | 1104 | mysql-bin.000002;pos=4 | # 此处为日志轮换事件，执行flush logs引起的亿华云备份 +------------------+------+----------------+-----------+-------------+-----------------------------------------------------------------------------------+ 17 rowsinset (0.00 sec) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.高防服务器