Tweet
Tweet

Slide 1

Slide 1 text

Continuous Restore΁ͷಓ

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

͸͍

Slide 4

Slide 4 text

who are you

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

about Cyberagent

Slide 7

Slide 7 text

game

Slide 8

Slide 8 text

pigg

Slide 9

Slide 9 text

blog

Slide 10

Slide 10 text

Community

Slide 11

Slide 11 text

MySQL͍ͬͺ͍࢖ͬͯΔΑ

Slide 12

Slide 12 text

͸͍

Slide 13

Slide 13 text

agenda

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

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

Slide 16

Slide 16 text

Έͳ͞·

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

ྫ͑͹

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

΋͘͠͸

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

ͳ͍͔ (ʈТʈ) ⊃ɹ㱬

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

ͦΜͳ͜ΜͳͰ

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

͜Μͳࣄ΋͋Ζ͏͔ͱ

Slide 27

Slide 27 text

΍ͬͯͯΑ͔ͬͨ BACKUP

Slide 28

Slide 28 text

Ͱ΋

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

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

Slide 32

Slide 32 text

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

Slide 33

Slide 33 text

ࣦഊͨ͠ΒͲ͏͠Α

Slide 34

Slide 34 text

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

Slide 35

Slide 35 text

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

Slide 36

Slide 36 text

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

Slide 37

Slide 37 text

ࣗಈԽͪ͠Ό͍ͳyo

Slide 38

Slide 38 text

Ͳ͏࣮ݱ͔ͨ͠

Slide 39

Slide 39 text

Backup·ͰͷྲྀΕ

Slide 40

Slide 40 text

No content

Slide 41

Slide 41 text

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

Slide 42

Slide 42 text

ϦετΞ·ͰͷྲྀΕ

Slide 43

Slide 43 text

No content

Slide 44

Slide 44 text

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

Slide 45

Slide 45 text

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

Slide 46

Slide 46 text

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

Slide 47

Slide 47 text

΋͏ͪΐͬͱߟ͑Δ

Slide 48

Slide 48 text

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

Slide 49

Slide 49 text

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

Slide 50

Slide 50 text

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

Slide 51

Slide 51 text

Ͳ͜·Ͱ΍Δ͔

Slide 52

Slide 52 text

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

Slide 53

Slide 53 text

ͭ·Γʁ

Slide 54

Slide 54 text

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

Slide 55

Slide 55 text

֬ೝ߲໨ɺԿ͕͋Δ͔ͳʔ • ςʔϒϧഁଛ͕ͳ͍ࣄ • ςʔϒϧͷத਎͕Ұக͍ͯ͠Δ͜ͱ • ςʔϒϧఆ͕ٛҰக͍ͯ͠Δ͜ͱ • index͕Ұக͍ͯ͠Δ͜ͱ mysqlcheck --all-databases CHECKSUM TABLE hogehoge SHOW CREATE TABLE hogehoge SHOW INDEXES FROM hogehoge

Slide 56

Slide 56 text

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

Slide 57

Slide 57 text

No content

Slide 58

Slide 58 text

No content

Slide 59

Slide 59 text

No content

Slide 60

Slide 60 text

No content

Slide 61

Slide 61 text

No content

Slide 62

Slide 62 text

No content

Slide 63

Slide 63 text

No content

Slide 64

Slide 64 text

No content

Slide 65

Slide 65 text

No content

Slide 66

Slide 66 text

No content

Slide 67

Slide 67 text

• stop Replication • pre_checksum • checksum table,show create table,show indexes from • backup • start Replication • restore • diff pre_checksum • mysqlcheck

Slide 68

Slide 68 text

ͨͩ

Slide 69

Slide 69 text

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

Slide 70

Slide 70 text

ͷͰ

Slide 71

Slide 71 text

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

Slide 72

Slide 72 text

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

Slide 73

Slide 73 text

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

Slide 74

Slide 74 text

No content

Slide 75

Slide 75 text

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

Slide 76

Slide 76 text

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

Slide 77

Slide 77 text

࢖ͬͯΈͨॴײ

Slide 78

Slide 78 text

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

Slide 79

Slide 79 text

ࠓޙ

Slide 80

Slide 80 text

ෆ҆఺ɺվળ఺ • check߲໨΋ͬͱ٧ΊΕΔؾ͕͢Δ • ϚαΧϦ௖͚Ε͹خ͍͠Ͱ͢(;д) • ͿͬͪΌ͚·ͩ̏Service͙Β͍Ͱ͔͠Քಇͯ͠ͳ͍ • ͲΜͲΜ௥Ճ͍ͯ͘͠ • ·ͩ100GB͙Β͍·Ͱͷ༰ྔͷrestore͔ͯ͠͠ͳ͍ • ༰ྔ૿͖͑ͯͨΒࠓͷcheckͩͱऴΘΒͳ͍ؾ͸ͯ͠Δ

Slide 81

Slide 81 text

·ͱΊ

Slide 82

Slide 82 text

Backup୲อʹΑΓ

Slide 83

Slide 83 text

շదͳDBഁյϥΠϑΛʂ

Slide 84

Slide 84 text

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