Slide 73
Slide 73 text
ポジションベースのレプリケーションやバイナリログを使ったロールフォワー
ドをしても
+-----+-------+
| num | val |
+-----+-------+
| 1 | one | <--- 552f89cd-aded-11e9-9af8-0201a32caf75:548870, bin.000017の235~528
| 2 | two | <--- 552f89cd-aded-11e9-9af8-0201a32caf75:548871, bin.000017の528~821
| 3 | three | <--- 552f89cd-aded-11e9-9af8-0201a32caf75:548872, bin.000017の821~1116
+-----+-------+
mysql80> CHANGE MASTER TO .., master_log_file = 'bin.000017', master_log_pos = 821;
+-----+-------+
| num | val |
+-----+-------+
| 1 | one | <--- 552f89cd-aded-11e9-9af8-0201a32caf75:548870, bin.000017の235~528
| 2 | two | <--- 552f89cd-aded-11e9-9af8-0201a32caf75:548871, bin.000017の528~821
| 3 | three | <--- 552f89cd-aded-11e9-9af8-0201a32caf75:548872, bin.000017の821~1116 <-- 再実行が抑止される
+-----+-------+
72/77