Continuous Restoreへの道

Transcript

1. 1.

   Continuous Restore΁ͷಓ

2. 2.

   MySQLCasualͳͷʹ Casual͡Όͳͯ͘ࢮʹͦ ͏Ͱ͢

3. 3.

   ͸͍

4. 4.

   who are you

5. 5.

   ͍Θͳ͕͔͚Δ @kakerukaeru ΏͱΓΠϯϑϥԂࣇʹ͋ AmebaεϚϗϓϥοτϑΥʔϜ໘౗ݟΔϚϯ Amebaը૾഑৴Ϛϯ ࠷ۙྑ͘৮ͬͯΔσʔλετΞ͸Cassandra ΦΤʔʔ!!!!ɹʊʊ_ ɹɹɹ ʊʊ_ʗɹɹ ʋ

   ɹɹ ʗɹ ʗɹʗ˶ʋ| ɹɹ/ (ƅ)/ɹʗ /
6. 6.

   about Cyberagent

7. 7.

   game

8. 8.

   pigg

9. 9.

   blog

10. 10.

    Community

11. 11.

    MySQL͍ͬͺ͍࢖ͬͯΔΑ

12. 12.

    ͸͍

13. 13.

    agenda

14. 14.

    • ܧଓతΓ͢ͱ͋΍ͬͯΈͨ • Ͳ͏࣮ݱ͔ͨ͠ • BackupϚσ • RestoreϚσ • ΋͏ͪΐͬͱߟ͑Δ

    • ࢖ͬͯΈͨॴײ • ࠓޙ
15. 15.

    ܧଓత Γ͢ͱ͋΍ͬͯΈͨ

16. 16.

    Έͳ͞·

17. 17.

    ෆ҆ʹͳͬͨ͜ͱ͸͋Γ ·ͤΜ͔

18. 18.

    ྫ͑͹

19. 19.

    Slaveશ୆Ͱແݶ࠶ىಈ SlaveҰؾʹ୤མ1 1 ͱ͋ΔDeleteจൃߦˠmysqldམͪΔˠmysqldsafeܦ༝Ͱ্͕ΔˠϨϓϦ࠶։ͰDeleteจൃߦˠmysqldམͪΔˠmysqldsafe(ry

20. 20.

    ΋͘͠͸

21. 21.

    ͓͹͔ͪΌΜ͕ ຊ൪DBͰDROP DATABASE2 2 ࡢ೔ຊ౰ʹ͋ͬͨࣄ݅

22. 22.

    ͳ͍͔ (ʈТʈ) ⊃ɹ㱬

23. 23.

    ͋Δͱ͢Δ͡ΌΖʁ (ʈТʈ) ⊃ɹ㱬

24. 24.

    ͦΜͳ͜ΜͳͰ

25. 25.

    ʊਓਓਓਓਓਓʊ ʼɹ MySQL܈ɹʻ ʼɹ ಥવͷࢮ ɹʻ ʉY^Y^Y^Y^Yʉ

26. 26.

    ͜Μͳࣄ΋͋Ζ͏͔ͱ

27. 27.

    ΍ͬͯͯΑ͔ͬͨ BACKUP

28. 28.

    Ͱ΋

29. 29.

    ͜Εຊ౰ʹrestoreग़དྷΔͷʁ

30. 30.

    ΋͠ग़དྷͳ͔ͬͨΒͲ͏͠Α͏ɾɾɾ

31. 31.

    ࢒Γ͸Ϛελʔ͚ͩɾɾɾ

32. 32.

    ՔಇதͷϚελʔ͔Β σʔλൈ͖ग़͢ࣄʹɾɾɾ

33. 33.

    ࣦഊͨ͠ΒͲ͏͠Α

34. 34.

    ͜Μͳෆ҆ʹ೰·͞Εͳ͍ͨΊʹ

35. 35.

    Backupͷਖ਼౰ੑʁͷ୲อΛ͓͖͍ͯͨ͠

36. 36.

    Ͱ΋ɺखͰຖճ֬ೝ͢Δͷ͸ɾɾɾ

37. 37.

    ࣗಈԽͪ͠Ό͍ͳyo

38. 38.

    Ͳ͏࣮ݱ͔ͨ͠

39. 39.

    Backup·ͰͷྲྀΕ

40. 40.

    None
41. 41.

    Backup • backup༻slave • backup༻server • backup_serverΑΓ • ఆظxtrabackup •

    ਵ࣌binlog_sync
42. 42.

    ϦετΞ·ͰͷྲྀΕ

43. 43.

    None
44. 44.

    Restore • APIܦ༝Ͱinstance࡞੒ • chef-soloʹͯmysql_setup • BackupαʔόΑΓ࠷৽ͷsnapshotͱbinlogΛసૹ • test-serverͰrestoreॲཧ •

    instance࡟আ
45. 45.

    ͜ΕͰRestoreͷ୲อ͕ग़དྷͨ

46. 46.

    ͍ͭͳΜͲ͖αʔό͕ࢮ ΜͰ΋େৎ෉ _(ˇωˇʯ㲃)_ ţźō…

47. 47.

    ΋͏ͪΐͬͱߟ͑Δ

48. 48.

    ԿΛ΋ͬͯϦετΞ׬ྃͱ͢Δ͔

49. 49.

    ۭͬΆͷςʔϒϧ͕ Restore͞Εͯ΋ҙຯͳ͍

50. 50.

    ͳͷͰRestoreͷਖ਼౰ੑʁ ΋୲อͯ͋͛͠Α͏

51. 51.

    Ͳ͜·Ͱ΍Δ͔

52. 52.

    backup༻ͷSlaveͱ restore͞ΕͨDBͷ੔߹ੑΛߟ͑Δ

53. 53.

    ͭ·Γʁ

54. 54.

    BackupલͱRestoreޙͷ֬ೝ߲໨ʹ diff͕ͳ͍͜ͱΛ֬ೝ

55. 55.

    ֬ೝ߲໨ɺԿ͕͋Δ͔ͳʔ • ςʔϒϧഁଛ͕ͳ͍ࣄ • ςʔϒϧͷத਎͕Ұக͍ͯ͠Δ͜ͱ • ςʔϒϧఆ͕ٛҰக͍ͯ͠Δ͜ͱ • index͕Ұக͍ͯ͠Δ͜ͱ mysqlcheck

    --all-databases CHECKSUM TABLE hogehoge SHOW CREATE TABLE hogehoge SHOW INDEXES FROM hogehoge
56. 56.

    ͜ΕΛ౿·্͑ͨͰcheckͷྲྀΕ

57. 57.

    None
58. 58.

    None
59. 59.

    None
60. 60.

    None
61. 61.

    None
62. 62.

    None
63. 63.

    None
64. 64.

    None
65. 65.

    None
66. 66.

    None
67. 67.

    • stop Replication • pre_checksum • checksum table,show create table,show

    indexes from • backup • start Replication • restore • diff pre_checksum • mysqlcheck
68. 68.

    ͨͩ

69. 69.

    ຖճ͜ͷchecksumΛྲྀ͢ͱ ͕͔͔࣌ؒΓ͗͢Δ

70. 70.

    ͷͰ

71. 71.

    ࣮ࡍͷӡ༻Ͱ͸̎छྨʹ෼͚͍ͯ·͢

72. 72.

    • ຖճ࣮ߦ • ςʔϒϧഁଛ͕ͳ͍ࣄ • िҰcheck • ςʔϒϧഁଛ͕ͳ͍ࣄ • ςʔϒϧͷத਎͕Ұக͍ͯ͠Δ͜ͱ

    • ςʔϒϧఆ͕ٛҰக͍ͯ͠Δ͜ͱ • index͕Ұக͍ͯ͠Δ͜ͱ
73. 73.

    ͜ΕͰdataͷਖ਼౰ੑ΋ ͋Δఔ౓୲อͰ͖͔ͨͳ

74. 74.

    None
75. 75.

    Θ͊ɺಈ͍ͯΔ ͭͳ͗ࠐΈͯ͠શମͰಈ͍ͨͷ͸͍͖ͭͬ͞

76. 76.

    ҆৺ͯ͠৸ΕΔ ( ˘ω˘ ) ţźō…

77. 77.

    ࢖ͬͯΈͨॴײ

78. 78.

    ਖ਼௚ࡢ೔Քಇ࢝͠Ίͨ͹͔͔ͬͩΒ·ͩײ૝ͳ͍ খཻͳ΋ͷ͔Βେཻͳ΋ͷ·Ͱ༷ʑͳαʔϏε͕ཚཱͯ͠Δঢ় گͰɺ̍αʔϏεͣͭrestoreग़དྷΔ͔ͷ֬ೝΛ৺Թ·Δख࡞ۀ Ͱ֬ೝ͠ͳͯ͘΋ྑ͘ͳͬͨͱ͍͏ਫ਼ਆతͳ҆Β͗Λಘͨɻ ͋ͱɺ͜Ε͙Β͍ͷ༰ྔͩͱRestoreʹͲΕ͙Β͍ͷ͕͔͔࣌ؒ Δ͔ͱ͔͕෼͔ͬͨΓͯͪ͠ΐͬͱָ͍͠

79. 79.

    ࠓޙ

80. 80.

    ෆ҆఺ɺվળ఺ • check߲໨΋ͬͱ٧ΊΕΔؾ͕͢Δ • ϚαΧϦ௖͚Ε͹خ͍͠Ͱ͢(;
    д
    ) • ͿͬͪΌ͚·ͩ̏Service͙Β͍Ͱ͔͠Քಇͯ͠ͳ͍ • ͲΜͲΜ௥Ճ͍ͯ͘͠ •

    ·ͩ100GB͙Β͍·Ͱͷ༰ྔͷrestore͔ͯ͠͠ͳ͍ • ༰ྔ૿͖͑ͯͨΒࠓͷcheckͩͱऴΘΒͳ͍ؾ͸ͯ͠Δ
81. 81.

    ·ͱΊ

82. 82.

    Backup୲อʹΑΓ

83. 83.

    շదͳDBഁյϥΠϑΛʂ

84. 84.

    ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠