????3. Xtrabackup
???????????????????????percona??????????????Xtrabackup??ù????????????????????????+?????????????????innodb????????????ibd?????????????????redo log??仯??append????????????????????????ibd????????У?ibd???????????д”??”?????????????????????????????prepare??Σ?Xtrabackup??????????innodb??????????????????????????????????????μ?????????δ????????????????????????myisam?????innodb??????????????????flush tables with lock?????????????????????Щ????仯????????????binlogλ?????????????????????????redo log??????
?????????????????￡?

????????mysql?в??????????myisam?????innobackup????????????????????????????????mysql??????????????flush tables with read lock????????????κβ??(????select)?????????????????У???????????????κβ??(????select)??????????????????г????????flush tables with read lock??У???????hang???????flush tables with read lock??????????????????????У???????????????￡?????????????flush tables with read lock?????????????????????????á?
??????????????????????????Ч???????
????1. ????????myisam???
????2. Xtrabackup??????–rsync??????????rsync???????????????????
???????????????????￡?

???????????????????+????+?????????????????????????????
???????????????????????????????????????佫?????????????ü???????????????????????????????????????????????redo log?????????????????????oò??????????
????4. mysqlbinlog 5.6
???????????е???????????????????????????????????mysqldump??mydumper?????snapshot?????????????Xtrabackup????????????????????point in time??????????????binlog????binlog????????????????????
????????????mysql 5.6???????????????binlog?????
????<code>mysqlbinlog --raw --read-from-remote-server --stop-never</code>
????????α???mysql??????????binlog???????????????????????????????????????binlog???????????á?????????????????????mysql??????????????????????????????????????ò???blackhole???????????binlog?????????????????????????????blackhole???????????????????????????blackhole?????????????????????????????????????????л??????????????С?
?????????
???????С??binlog????????5.6??????????????ú??????????????????????????????????????????????ε???????????3????Ρ??????????ε????????????????binlog??????????????????????????????????3??5???binlog???????????????????????????????????
????blackhole???????binlog??????????????????????binlog?????????????????棬?????????e???????????????Ч????????binlog?????
???????
????????????????????????????????????????????????????????????????á????滮??????????????????????????????????????????????????????????????????
????????t???????????Xtrabackup??????????blackhole????binlog???????????????????Ч??????????????±???????