MySQL?????????ο?????????
?????danfengcao ???????[ 2016/12/23 15:20:05 ] ????????????? MySQL
????3????????sql?????????sql??????
????MySQL
????$ python binlog2sql/binlog2sql.py -h127.0.0.1 -P3306 -uadmin -p'admin' -dtest -ttbl --start-file='mysql-bin.000047' --start-pos=3346 --end-pos=3556 -B
?????????
????$ python binlog2sql/binlog2sql.py -h127.0.0.1 -P3306 -uadmin -p'admin' -dtest -ttbl --start-file='mysql-bin.000047' --start-pos=3346 --end-pos=3556 -B
?????????
????INSERT INTO `test`.`tbl`(`addtime`?? `id`?? `name`) VALUES ('2016-12-10 00:04:56'?? 4?? 'С??'); #start 3346 end 3556
????INSERT INTO `test`.`tbl`(`addtime`?? `id`?? `name`) VALUES ('2016-12-10 00:04:51'?? 3?? 'С??'); #start 3346 end 3556
????INSERT INTO `test`.`tbl`(`addtime`?? `id`?? `name`) VALUES ('2016-12-10 00:04:48'?? 2?? 'С?'); #start 3346 end 3556
????INSERT INTO `test`.`tbl`(`addtime`?? `id`?? `name`) VALUES ('2016-12-10 00:04:33'?? 1?? 'С??'); #start 3346 end 3556
????4???????sql???????л????????mysql???????????????
????$ python binlog2sql.py -h127.0.0.1 -P3306 -uadmin -p'admin' -dtest -ttbl --start-file='mysql-bin.000047' --start-pos=3346 --end-pos=3556 -B | mysql -h127.0.0.1 -P3306 -uadmin -p'admin'
????mysql> select * from tbl;
????+----+--------+---------------------+
????| id | name | addtime |
????+----+--------+---------------------+
????| 1 | С?? | 2016-12-10 00:04:33 |
????| 2 | С? | 2016-12-10 00:04:48 |
????| 3 | С?? | 2016-12-10 00:04:51 |
????| 4 | С?? | 2016-12-10 00:04:56 |
????+----+--------+---------------------+
????????????????????????????
????????????
??????????????DDL??????????????????????drop????????
????????????????????????row???£?DDL??????????????????仯?????binlog??????DDL??????binlog????????DDL???????????????DDL?????????????????????????mysql server????????DDL???????????????????xiaobin lin???????patch?????????????????????л?????????????????????????????????????????????????????????????????????????????????Щ????洢??
?????????DDL??????????????????????????????????????????????????????????????????????????????
????mysql????binlog2sql???????????????????
????????С????????????mysqlbinlog??????flashback??????????????mysql???е?flashback?????????????DML?????????????????binlog????DML?????????·??DDL?????????????????????????????????????????д????????????????????????????????????????????????????????Inception?????MySQL???????????????????????????DML????????????binlog?????????????????????DDL?????????????????????~ ?????????????slave????????????????????????slave?????????????????????????????????????????????????????????????????????????????????????
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
???mysql?????????????mysql????? distinct?÷?MySQL?н???????????з??Mysql?????????MySQL Cluster??δ????????????????ν?MySQL??????????300???????MySQL???Uber???????????????????MySql SQL??????????MySQL?????????????????λЧ?????SQL???Java???????:?????MySQL???????linux?°??mysql????MySQL ???????????????????binlog??MySQL????????????Щ??????MySQL???????Mysql???????JDBC?????mysql?????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????