Continuous Restoreへの道

MySQL Casual Talks vol.7 でしゃべった奴

Transcript

1. Continuous Restore΁ͷಓ
2. MySQLCasualͳͷʹ Casual͡Όͳͯ͘ࢮʹͦ ͏Ͱ͢
3. ͸͍
4. who are you
5. ͍Θͳ͕͔͚Δ @kakerukaeru ΏͱΓΠϯϑϥԂࣇʹ͋ AmebaεϚϗϓϥοτϑΥʔϜ໘౗ݟΔϚϯ Amebaը૾഑৴Ϛϯ ࠷ۙྑ͘৮ͬͯΔσʔλετΞ͸Cassandra ΦΤʔʔ!!!!ɹʊʊ_ ɹɹɹ ʊʊ_ʗɹɹ ʋ ɹɹ ʗɹ ʗɹʗ˶ʋ| ɹɹ/ (ƅ)/ɹʗ /
6. about Cyberagent
7. game
8. pigg
9. blog
10. Community
11. MySQL͍ͬͺ͍࢖ͬͯΔΑ
12. ͸͍
13. agenda
14. • ܧଓతΓ͢ͱ͋΍ͬͯΈͨ • Ͳ͏࣮ݱ͔ͨ͠ • BackupϚσ • RestoreϚσ • ΋͏ͪΐͬͱߟ͑Δ • ࢖ͬͯΈͨॴײ • ࠓޙ
15. ܧଓత Γ͢ͱ͋΍ͬͯΈͨ
16. Έͳ͞·
17. ෆ҆ʹͳͬͨ͜ͱ͸͋Γ ·ͤΜ͔
18. ྫ͑͹
19. Slaveશ୆Ͱແݶ࠶ىಈ SlaveҰؾʹ୤མ1 1 ͱ͋ΔDeleteจൃߦˠmysqldམͪΔˠmysqldsafeܦ༝Ͱ্͕ΔˠϨϓϦ࠶։ͰDeleteจൃߦˠmysqldམͪΔˠmysqldsafe(ry
20. ΋͘͠͸
21. ͓͹͔ͪΌΜ͕ ຊ൪DBͰDROP DATABASE2 2 ࡢ೔ຊ౰ʹ͋ͬͨࣄ݅
22. ͳ͍͔ (ʈТʈ) ⊃ɹ㱬
23. ͋Δͱ͢Δ͡ΌΖʁ (ʈТʈ) ⊃ɹ㱬
24. ͦΜͳ͜ΜͳͰ
25. ʊਓਓਓਓਓਓʊ ʼɹ MySQL܈ɹʻ ʼɹ ಥવͷࢮ ɹʻ ʉY^Y^Y^Y^Yʉ
26. ͜Μͳࣄ΋͋Ζ͏͔ͱ
27. ΍ͬͯͯΑ͔ͬͨ BACKUP
28. Ͱ΋
29. ͜Εຊ౰ʹrestoreग़དྷΔͷʁ
30. ΋͠ग़དྷͳ͔ͬͨΒͲ͏͠Α͏ɾɾɾ
31. ࢒Γ͸Ϛελʔ͚ͩɾɾɾ
32. ՔಇதͷϚελʔ͔Β σʔλൈ͖ग़͢ࣄʹɾɾɾ
33. ࣦഊͨ͠ΒͲ͏͠Α
34. ͜Μͳෆ҆ʹ೰·͞Εͳ͍ͨΊʹ
35. Backupͷਖ਼౰ੑʁͷ୲อΛ͓͖͍ͯͨ͠
36. Ͱ΋ɺखͰຖճ֬ೝ͢Δͷ͸ɾɾɾ
37. ࣗಈԽͪ͠Ό͍ͳyo
38. Ͳ͏࣮ݱ͔ͨ͠
39. Backup·ͰͷྲྀΕ
41. Backup • backup༻slave • backup༻server • backup_serverΑΓ • ఆظxtrabackup • ਵ࣌binlog_sync
42. ϦετΞ·ͰͷྲྀΕ
44. Restore • APIܦ༝Ͱinstance࡞੒ • chef-soloʹͯmysql_setup • BackupαʔόΑΓ࠷৽ͷsnapshotͱbinlogΛసૹ • test-serverͰrestoreॲཧ • instance࡟আ
45. ͜ΕͰRestoreͷ୲อ͕ग़དྷͨ
46. ͍ͭͳΜͲ͖αʔό͕ࢮ ΜͰ΋େৎ෉ _(ˇωˇʯ㲃)_ ţźō…
47. ΋͏ͪΐͬͱߟ͑Δ
48. ԿΛ΋ͬͯϦετΞ׬ྃͱ͢Δ͔
49. ۭͬΆͷςʔϒϧ͕ Restore͞Εͯ΋ҙຯͳ͍
50. ͳͷͰRestoreͷਖ਼౰ੑʁ ΋୲อͯ͋͛͠Α͏
51. Ͳ͜·Ͱ΍Δ͔
52. backup༻ͷSlaveͱ restore͞ΕͨDBͷ੔߹ੑΛߟ͑Δ
53. ͭ·Γʁ
54. BackupલͱRestoreޙͷ֬ೝ߲໨ʹ diff͕ͳ͍͜ͱΛ֬ೝ
55. ֬ೝ߲໨ɺԿ͕͋Δ͔ͳʔ • ςʔϒϧഁଛ͕ͳ͍ࣄ • ςʔϒϧͷத਎͕Ұக͍ͯ͠Δ͜ͱ • ςʔϒϧఆ͕ٛҰக͍ͯ͠Δ͜ͱ • index͕Ұக͍ͯ͠Δ͜ͱ mysqlcheck --all-databases CHECKSUM TABLE hogehoge SHOW CREATE TABLE hogehoge SHOW INDEXES FROM hogehoge
56. ͜ΕΛ౿·্͑ͨͰcheckͷྲྀΕ
67. • stop Replication • pre_checksum • checksum table,show create table,show indexes from • backup • start Replication • restore • diff pre_checksum • mysqlcheck
68. ͨͩ
69. ຖճ͜ͷchecksumΛྲྀ͢ͱ ͕͔͔࣌ؒΓ͗͢Δ
70. ͷͰ
71. ࣮ࡍͷӡ༻Ͱ͸̎छྨʹ෼͚͍ͯ·͢
72. • ຖճ࣮ߦ • ςʔϒϧഁଛ͕ͳ͍ࣄ • िҰcheck • ςʔϒϧഁଛ͕ͳ͍ࣄ • ςʔϒϧͷத਎͕Ұக͍ͯ͠Δ͜ͱ • ςʔϒϧఆ͕ٛҰக͍ͯ͠Δ͜ͱ • index͕Ұக͍ͯ͠Δ͜ͱ
73. ͜ΕͰdataͷਖ਼౰ੑ΋ ͋Δఔ౓୲อͰ͖͔ͨͳ
75. Θ͊ɺಈ͍ͯΔ ͭͳ͗ࠐΈͯ͠શମͰಈ͍ͨͷ͸͍͖ͭͬ͞
76. ҆৺ͯ͠৸ΕΔ ( ˘ω˘ ) ţźō…
77. ࢖ͬͯΈͨॴײ
78. ਖ਼௚ࡢ೔Քಇ࢝͠Ίͨ͹͔͔ͬͩΒ·ͩײ૝ͳ͍ খཻͳ΋ͷ͔Βେཻͳ΋ͷ·Ͱ༷ʑͳαʔϏε͕ཚཱͯ͠Δঢ় گͰɺ̍αʔϏεͣͭrestoreग़དྷΔ͔ͷ֬ೝΛ৺Թ·Δख࡞ۀ Ͱ֬ೝ͠ͳͯ͘΋ྑ͘ͳͬͨͱ͍͏ਫ਼ਆతͳ҆Β͗Λಘͨɻ ͋ͱɺ͜Ε͙Β͍ͷ༰ྔͩͱRestoreʹͲΕ͙Β͍ͷ͕͔͔࣌ؒ Δ͔ͱ͔͕෼͔ͬͨΓͯͪ͠ΐͬͱָ͍͠
79. ࠓޙ
80. ෆ҆఺ɺվળ఺ • check߲໨΋ͬͱ٧ΊΕΔؾ͕͢Δ • ϚαΧϦ௖͚Ε͹خ͍͠Ͱ͢(;
    д
    ) • ͿͬͪΌ͚·ͩ̏Service͙Β͍Ͱ͔͠Քಇͯ͠ͳ͍ • ͲΜͲΜ௥Ճ͍ͯ͘͠ • ·ͩ100GB͙Β͍·Ͱͷ༰ྔͷrestore͔ͯ͠͠ͳ͍ • ༰ྔ૿͖͑ͯͨΒࠓͷcheckͩͱऴΘΒͳ͍ؾ͸ͯ͠Δ
81. ·ͱΊ
82. Backup୲อʹΑΓ
83. շదͳDBഁյϥΠϑΛʂ
84. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠