mysql_first_performance_ tuning_y8

初めてのMySQLパフォーマンスチューニング

Transcript

1. ॳΊͯͷ
   .Z42-αʔόʔ
   ύϑΥʔϚϯε
   νϡʔχϯά
   ·Έ΍ͳ͓͖ !NBNZ
   
   .BZ!Z4QSJOHJO4IJCVZB
   

   View Slide

2. ࣗݾ঺հ
   Name ɹɹ ɿ·Έ΍ͳ͓͖
   Twitterɹɹ ɿ@mamy1326
   2016೥·ͰΞϓϦத৺
   2017೥͔Βຊ֨తʹ
   ɹɹɹɹɹɹɹDBɾΠϯϑϥ΁
   

   View Slide

3. ϫλγ
   Πϯϑϥ
   νϣοτσΩϧ
   

   View Slide

4. ɹ૝ఆΦʔσΟΤϯε
   ɾΞϓϦΤϯδχΞ
   ɾ%#͸ීஈ͸πʔϧͰࢀরɾૢ࡞
   ɹˠίϚϯυϥΠϯͰ%#ૢ࡞͠ͳ͍
   ɾίϯιʔϧ͸͋Μ·Γ࢖Θͳ͍
   

   View Slide

5. ߏ੒
   ⾣NZDOG
   ɹશ߲໨ͷௐࠪɾઃఆ
   ⾣ΫΤϦΩϟογϡͷଌఆ
   ⾣ϨϓϦέʔγϣϯ
   

   View Slide

6. ϓϩϩʔά
   

   View Slide

7. ɹͱ͋ΔαʔϏεͷӡ༻ঢ়گ
   िʹҰ౓
   %#αʔόʔμ΢ϯ
   ೾͕ऩ·ΔͷΛ
   ͻͨ͢Β଴ͭ
   

   View Slide

8. ɹͱ͋ΔαʔϏεͷӡ༻ঢ়گ
   %#ͷ
   -"͕௓Ͷ্͕ͬͯΔΜͰ
   ͱΓ͋͑ͣ
   8FCͷ઀ଓ਺੍ݶͯ͠
   Ͳ͏ʹ͔͍ͯͨ͠
   

   View Slide

9. ɹͱ͋ΔαʔϏεͷӡ༻ঢ়گ
   %#ͷ
   -"͕௓Ͷ্͕ͬͯΔΜͰ
   ͱΓ͋͑ͣ
   8ͷ઀ଓ਺੍ݶͯ͠
   Ͳ͏ʹ͔͍ͯͨ͠
   ౖ
   

   View Slide

10. ঢ়گ̍
    νϡʔχϯά͞Ε͍ͯͳ͍
    .Z42-
    ઐ༻αʔόʔ
    
    

    View Slide

11. ঢ়گ̎
    ࢭ·Βͳ͍
    )551ϦΫΤετ
    Ͱ΋ඵؒ̑
    
    

    View Slide

12. ঢ়گ̏
    ڊେͳϩάςʔϒϧ
    ϑϧεΩϟϯ
    º̎
    ֤ສϨίʔυ
    
    

    View Slide

13. ঢ়گ̐
    ࿈ൃ͢ΔεϩʔΫΤϦ
    ϩά͸औ͍ͬͯͳ͍
    
    

    View Slide

14. ঢ়گ̑
    ࢮΜͩΒऴΘΔϚελʔ
    εϨʔϒ͕ͳ͍
    
    

    View Slide

15. ঢ়گ̒
    .Z42-ܥ
    ੓࣏తʹ
    όʔδϣϯΞοϓͰ͖ͳ͍
    
    

    View Slide

16. ໨ࢦ͢
    .Z42-ͷઃఆΛ
    ͪΌΜͱཧղͯ͠
    ࠷దͳύϑΥʔϚϯεΛɻ
    

    View Slide

17. NZDOG
    શ߲໨ͷ
    ௐࠪɾઃఆ
    

    View Slide

18. ɹNZDOG֬ೝ
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    symbolic-lincs=0
    expire_logs_days=3
    sort_buffer=4M
    log-bin=mysql-bin
    server-id=1001
    ΄΅σϑΥϧτ ɾТɾA
    
    

    View Slide

19. ɹNZDOGઃఆํ਑
    ɾڞ༗ྖҬ͔Β
    ɹɹɹςʔϒϧݸผྖҬ΁
    ɾద੾ͳϝϞϦׂΓ౰ͯ
    

    View Slide

20. ɹNZDOGઃఆํ਑
    ɾڞ༗ྖҬ͔Β
    ɹɹɹςʔϒϧݸผྖҬ΁
    ɾద੾ͳϝϞϦׂΓ౰ͯ
    

    View Slide

21. ɹڞ༗ྖҬͱ͸
    ɾ.Z42-ͷσϑΥϧτ͸ɺ͓͖͍ͬശͷத
    ɹͰશςʔϒϧΛऔΓѻ͍ͬͯΔ
    ɾେ͖ͳςʔϒϧ΋খ͞ͳςʔϒϧ΋ಉډ
    ɾϨίʔυͰ΋ߋ৽ʹ͕͔͔࣌ؒΔ
    

    View Slide

22. ɹڞ༗ྖҬͷ࣮ྫ
    EBUBCBTF UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    

    View Slide

23. ɹڞ༗ྖҬͷ࣮ྫ
    EBUBCBTF UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    ͜ͷϑΝΠϧʹ
    શͯͷςʔϒϧͷσʔλ͕
    ه࿥͞Ε͍ͯΔ
    

    View Slide

24. ɹςʔϒϧݸผྖҬͱ͸
    ɾςʔϒϧΛ̍ͭͣͭ෼͚ͯऔΓѻ͏
    ɾେ͖ͳςʔϒϧ΋খ͞ͳςʔϒϧ΋ݸผ
    ɾߋ৽ର৅ͷςʔϒϧͷྖҬʹͷΈߋ৽͕
    ɹ͔͔ΔͨΊଞʹӨڹΛ༩͑ͳ͍
    

    View Slide

25. ɹઃఆ಺༰
    ͜Ε͚ͩʂ
    [mysqld]
    innodb_file_per_table=1
    

    View Slide

26. ͨͩ͠ɾɾɾ
    ɾNZTRM࠶ىಈ͚ͩͰ͸
    ɹطଘͷςʔϒϧʹରͯ͠͸ద༻͞Εͳ͍
    ɾ࠶ىಈޙʹ$3&"5&
    ɹ͞ΕΔςʔϒϧʹͷΈ༗ޮ
    EVNQϦετΞ͕ඞཁ
    

    View Slide

27. ɹ݁Ռ
    EBUBCBTF
    UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    WBSMJCNZTRMNBNZ
    

    View Slide

28. ɹ݁Ռ
    EBUBCBTF
    UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    WBSMJCNZTRMNBNZ
    EBUBCBTF໊Ͱ
    σΟϨΫτϦ͕࡞੒͞Ε
    ςʔϒϧ͝ͱʹ
    ϑΝΠϧ͕࡞ΒΕ͍ͯΔ
    

    View Slide

29. ɹ݁Ռ
    EBUBCBTF
    UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    WBSMJCNZTRMNBNZ
    EBUBCBTF໊Ͱ
    σΟϨΫτϦ͕࡞੒͞Ε
    ςʔϒϧ͝ͱʹ
    ϑΝΠϧ͕࡞ΒΕ͍ͯΔ
    Ώɹ͑ɹʹ
    

    View Slide

30. ɹ݁Ռ
    EBUBCBTF
    UBCMFSPXTTJ[F
    WBSMJCNZTRMJCEBUB
    WBSMJCNZTRMNBNZ
    SFQPSUςʔϒϧɹ͕
    ߋ৽͞Εͨ৔߹
    ֘౰ͷϑΝΠϧͷΈߋ৽
    

    View Slide

31. ɹNZDOGઃఆํ਑
    ɾڞ༗ྖҬ͔Β
    ɹɹɹςʔϒϧݸผྖҬ΁
    ɾద੾ͳϝϞϦׂΓ౰ͯ
    

    View Slide

32. ɹϝϞϦׂΓ౰ͯͱ͸
    ɾσʔλͱJOEFY͸
    ɹɹɹɹϝϞϦʹΩϟογϡ
    ɾద੾ͳαΠζ͸
    ɹɹɹɹ෺ཧϝϞϦͷׂ
    

    View Slide

33. ɹઃఆ಺༰
    ͜Ε͚ͩʂ
    [mysqld]
    # InnoDBͷσʔλͱindexΛΩϟογϡ͢ΔόοϑΝαΠζ
    # (ਪ঑͸෺ཧϝϞϦ8ׂ)
    innodb_buffer_pool_size=6G
    # InnoDBͷߋ৽ϩάΛه࿥͢ΔσΟεΫ্ͷϑΝΠϧαΠζ
    innodb_log_file_size=1G
    

    View Slide

34. ղઆ
    ⾣JOOPEC@CV⒎FS@QPPM@TJ[F(
    ɾσʔλͱJOEFYΛΩϟογϡ͓ͯ͘͠αΠζ
    ɾ%#αʔόʔͷ෺ཧϝϞϦ(ʹର͢Δ͓Αׂͦ
    ɾNZTRM࠶ىಈ࣌ʹׂΓ౰ͯΒΕ·͢
    ɾॻ͖ࠐΈ࣌ʹ΋ύϑΥʔϚϯε޲্͕ݟࠐ·ΕΔ
    ɹˏ.Z42-ެࣜ
    

    View Slide

35. ղઆ
    ⾣JOOPEC@MPH@pMF@TJ[F(
    ɾ*OOP%#ͷߋ৽ϩάαΠζ
    ɾDPNNJUཤྺΛه࿥͢Δ
    ɹˠ.Z42-͸DPNNJU࣌ɺ͍ͬͨΜϩάʹه࿥͞ΕΔ
    ɾϑΝΠϧ͸γʔέϯγϟϧͳͷͰɺߋ৽͕଎͍
    ɾੵΜͩDPNNJUΛॱ࣮࣍σʔλʹ൓ө͢Δ
    

    View Slide

36. ͦͷଞͷઃఆ
    ⾣εϩʔΫΤϦϩάؔ࿈
    [mysqld]
    # εϩʔΫΤϦͷग़ྗઃఆ
    slow_query_log=ON
    # εϩʔΫΤϦͱ൑ఆ͢Δඵ਺
    long_query_time=3
    # εϩʔΫΤϦͷ৔ॴ
    log-slow-queries=/var/log/slow.log
    

    View Slide

37. ͦͷଞͷઃఆ
    ⾣ΫΤϦΩϟογϡؔ࿈
    [mysqld]
    # ΫΤϦΩϟογϡ࠷େαΠζ
    query_cache_limit=16M
    # ΫΤϦΩϟογϡͰ࢖༻͢ΔϝϞϦαΠζ
    query_cache_size=512M
    # ΫΤϦΩϟογϡͷλΠϓ
    # 0:off, 1:ON SELECT SQL_NO_CACHE, 2:DEMAND SELECT SQL_CACHE
    query_cache_type=1⊠
    

    View Slide

38. NZDOGઃఆ݁Ռ
    ⾣ඵؒϦΫΤετʂ
    ⾣ϝϞϦ͕ੵ·Εͨ෼͚ͩՔಇʂ
    ⾣ςʔϒϧݸผͰߋ৽ܥ͕ૣ͘ʂ
    ⾣ΫΤϦΩϟογϡώοτʂ
    ⾣JOEFYݟ௚͠ͰεϩʔΫΤϦղফʂ
    

    View Slide

39. ɹNZDOGઃఆ·ͱΊ
    ⾣αʔϏεʹԠͯ͡ద੾ʹઃఆʂ
    ⾣σϑΥϧτμϝʂθολΠʂ
    ⾣ઃఆޙͷ਺஋͸ఆظతʹ؂ࢹʂ
    ɹˠνϡʔχϯά͸ܧଓ໋͕ʂ
    ⾣ςʔϒϧઃܭ͸ܭըతʹʂ
    

    View Slide

40. ແࣄʹɾɾɾ
    αʔϏε͕
    ӡ༻ʹ଱͑ΒΕΔΑ͏ʹ
    

    View Slide

41. ΫΤϦΩϟογϡ
    ଌఆ
    

    View Slide

42. ଌఆ
    NZDOGઃఆ͔ͯ͠Βिؒ
    ΫΤϦΩϟογϡ͕
    Ͳ͏ͳͬͨͷ͔
    

    View Slide

43. ΍Δ͜ͱ
    ΫΤϦΩϟογϡΛద੾ʹ࣋ͨͤ
    ݁ՌΛͳΔ΂͘Ωϟογϡ͔Βฦ͢Α͏
    νϡʔχϯάΛߦͬͨ
    ݁ՌΛݕূ
    ਺஋Ͱݕূ
    

    View Slide

44. ΫΤϦΩϟογϡͱ͸
    %#Λ4&-&$5ͨ݁͠ՌΛ
    ϝϞϦʹΩϟογϡ͠
    ࣍ʹಉҰͷΫΤϦͷ৔߹
    Ωϟογϡ͔Β݁ՌΛฦ͢
    

    View Slide

45. ɹઃఆ಺༰
    [mysqld]
    # ΫΤϦΩϟογϡ࠷େαΠζ
    query_cache_limit=16M
    # ΫΤϦΩϟογϡͰ࢖༻͢ΔϝϞϦαΠζ
    query_cache_size=512M
    # ΫΤϦΩϟογϡͷλΠϓ
    # 0:off, 1:ON SELECT SQL_NO_CACHE, 2:DEMAND SELECT SQL_CACHE
    query_cache_type=1⊠
    

    View Slide

46. ઃఆ஋ͷ֬ೝ
    NZTRM4)087"3*"#-&4-*,&bRVFSZ@DBDIF
    +------------------------------+-----------+
    | Variable_name | Value |
    +------------------------------+-----------+
    | have_query_cache | YES |
    | query_cache_limit | 16777216 |
    | query_cache_min_res_unit | 4096 |
    | query_cache_size | 536870912 |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    +------------------------------+-----------+
    

    View Slide

47. ઃఆ஋ͷղઆ
    ⾣IBWF@RVFSZ@DBDIFɿ:&4
    ɹΫΤϦΩϟογϡΛ
    ɹ࢖༻Մೳ͔Ͳ͏͔
    

    View Slide

48. ઃఆ஋ͷղઆ
    ⾣RVFSZ@DBDIF@MJNJUɿ
    ɹͭͷRVFSZͷ࣮ߦ݁Ռ
    ɹɹͱͯ͠
    ɹDBDIF͢Δ࠷େͷαΠζ
    

    View Slide

49. ઃఆ஋ͷղઆ
    ⾣RVFSZ@DBDIF@TJ[Fɿ
    ɹΫΤϦΩϟογϡͷ
    ɹ૯ྖҬ
    

    View Slide

50. ઃఆ஋ͷղઆ
    ⾣RVFSZ@DBDIF@UZQFɿ0/PS
    ɹ4&-&$542-@/0@$"$)&
    ɹͰ࢝·ΔΫΤϦҎ֎Ωϟογϡ
    Ωϟογϡ͔Β
    ໌ࣔతʹআ֎Ͱ͖Δ
    

    View Slide

51. ɹ൓өঢ়ଶͷݕূ
    NZTRM4)084&44*0/45"564-*,&b2DBDIF
    +-------------------------+-----------+
    | Variable_name | Value |
    +-------------------------+-----------+
    | Qcache_free_blocks | 791 |
    | Qcache_free_memory | 533156064 |
    | Qcache_hits | 1442086 |
    | Qcache_inserts | 291072 |
    | Qcache_lowmem_prunes | 0 |
    | Qcache_not_cached | 3599 |
    | Qcache_queries_in_cache | 1760 |
    | Qcache_total_blocks | 4361 |
    +-------------------------+-----------+
    

    View Slide

52. ൓ө஋ͷղઆ
    ⾣2DBDIF@IJUTɿ
    ɹΫΤϦʔ݁Ռ͕
    ɹΫΤϦʔΩϟογϡ͔Βฦ͞Εͨ਺
    ɹͭ·ΓΩϟογϡώοτ਺
    Ωϟογϡʹ͋ΔΫΤϦʔ͕
    ࢖ΘΕΔͨͼʹΠϯΫϦϝϯτ
    

    View Slide

53. ൓ө஋ͷղઆ
    ⾣2DBDIF@JOTFSUTɿ
    ɹΫΤϦʔΩϟογϡʹ௥Ճ͞Εͨ
    ɹΫΤϦʔͷ਺
    

    View Slide

54. ൓ө஋ͷղઆ
    ⾣2DBDIF@OPU@DBDIFEɿ
    ɹΩϟογϡͰ͖ͳ͍͔
    ɹRVFSZ@DBDIF@UZQFઃఆͷͨΊ
    ɹΩϟογϡ͞Εͳ͔ͬͨ਺
    ϝϞϦෆ଍ͳͲͰΩϟογϡ͞Εͳ͍
    ৔߹΋͋ΔͷͰ஫ҙ
    

    View Slide

55. ɹ݁Ռ
    ΫΤϦΩϟογϡIJU཰
    
    

    View Slide

56. ώοτ཰ͷܭࢉ
    શΫΤϦʔ
    ͷ਺Ͱ
    ΫΤϦΩϟογϡώοτ਺Λ
    আࢉ͢Δ
    

    View Slide

57. ώοτ཰ͷܭࢉ
    શΫΤϦʔ
    Ωϟογϡ͔Βฦͨ͠਺
    ʴ
    Ωϟογϡ͔Βฦͤͳ͔ͬͨ਺
    

    View Slide

58. ώοτ཰ͷܭࢉ
    Ωϟογϡ͞ΕΔͱ
    2DBDIF@JOTFSUT͕
    Χ΢ϯτΞοϓ͞ΕΔ
    Ωϟογϡʹ
    ৽نొ࿥ͨ͠஋
    

    View Slide

59. ώοτ཰ͷܭࢉ
    Ωϟογϡʹొ࿥Ͱ͖ͳ͍ͱ
    2DBDIF@OPU@DBDIFE͕
    Χ΢ϯτΞοϓ͞ΕΔ
    Ωϟογϡ͔Β
    ฦͤͳ͔ͬͨ஋
    

    View Slide

60. ώοτ཰ͷܭࢉ
    ⾣2DBDIF@IJUTɿ
    ⾣2DBDIF@JOTFSUTɿ
    ⾣2DBDIF@OPU@DBDIFEɿ
    
    
    
    ʜ
    

    View Slide

61. ɹͨͩ͠ɾɾɾ
    Ұൠతʹ
    ΛԼճͬͨΒ
    ͍Ζ͍Ζݟ௚ͨ͠ํ͕͍͍
    

    View Slide

62. ஫ҙ఺
    ʲલఏʳ
    ΫΤϦΩϟογϡ͸
    4&-&$5ʢݕࡧʣ
    

    View Slide

63. ஫ҙ఺
    ॻ͖ࠐΈ͕ଟൃ͢Δ
    ςʔϒϧʹ͸޲͔ͳ͍
    Ωϟογϡ͕ॻ͖׵ΘΔ
    

    View Slide

64. ஫ҙ఺
    ΫΤϦΩϟογϡΛ΍Ί
    ϓϩάϥϜଆͰΩϟογϡ
    NFNDBDIFEͳͲ
    

    View Slide

65. ɹΫΤϦΩϟογϡ·ͱΊ
    ⾣ϝϞϦʹԠͯ͡ద੾ʹઃఆʂ
    ⾣IJU཰Λܧଓͯ͠ܭଌʂ
    ⾣αʔϏεͷੑ࣭ΛݟۃΊΔʂ
    ⾣ܿ͘ϓϩάϥϜʹ೚ͤΔʂ
    

    View Slide

66. ϨϓϦέʔγϣϯ
    ࣮ࢪ
    

    View Slide

67. ͜͜·ͰͰɾɾɾ
    ɾӡ༻͕҆ఆ
    ɾΫΤϦΩϟογϡ
    ɹɹɹώοτ཰΋҆ఆ
    

    View Slide

68. ͔͠͠
    

    View Slide

69. ՝୊
    Ϛελʔ͕ࢮ͵ͱ
    σʔλ͕શ෦ࢮ͵
    

    View Slide

70. ෳ੡
    Ϛελʔ͔͠ͳ͍
    ݱঢ়ʹ
    εϨʔϒΛ࡞Γ
    

    View Slide

71. ෳ੡
    ϨϓϦέʔγϣϯ
    Λ࣮ࢪ͠·͢
    

    View Slide

72. ɹϨϓϦέʔγϣϯͱ͸
    ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ
    
    ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ
    ⾣.Z42-ͷඪ४ػೳͰ͓खܰ
    ⾣΄΅࣌ؒࠩͳ͠ʹಉظ
    

    View Slide

73. ߏ੒
    Ϛελʔ
    ʢ୯Ұʣ
    εϨʔϒ
    ʢʣ
    εϨʔϒ
    ʢOʣ
    ɾɾɾ
    

    View Slide

74. Ϛελʔ
    ⾣σʔλΛߋ৽͢Δଆ
    ⾣ߋ৽಺༰ΛεϨʔϒ͕औΓʹདྷΔ
    ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨஌
    ⾣ෳ਺ͷεϨʔϒΛ࣋ͯΔ
    

    View Slide

75. εϨʔϒ
    ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻
    ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ
    ⾣ϚελʔͷόΠφϦϩάΛऔಘ
    ⾣ߋ৽಺༰Λ%#ʹ൓ө
    ⾣ͭͷϚελʔͷΈ࣋ͯΔ
    

    View Slide

76. ϝϦοτ
    ⾣ࢀর 4&-&$5
    ੑೳͷ޲্
    ݕࡧॲཧ͕ॏ͍৔߹
    εϨʔϒΛࢀরܥʹͯ͠
    ෛՙ෼ࢄ
    

    View Slide

77. ϝϦοτ
    ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ
    Ϛελʔো֐ͷ৔߹
    εϨʔϒΛϚελʔʹঢ֨
    μ΢ϯλΠϜ୹ॖ
    

    View Slide

78. ϝϦοτ
    ⾣όοΫΞοϓαʔόʔ
    εϨʔϒͰόοΫΞοϓ
    ϚελʔʹӨڹͳ͘
    όοΫΞοϓऔಘ
    

    View Slide

79. ࣄલ४උ
    ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ
    ⾣ϚελʔόΠφϦϩάͷ֬ೝ
    ⾣εϨʔϒͷઃఆ֬ೝ
    

    View Slide

80. ࣄલ४උ
    ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ
    ⾣ϚελʔόΠφϦϩάͷ֬ೝ
    ⾣εϨʔϒͷઃఆ֬ೝ
    

    View Slide

81. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣ఆٛ
    ɹɾϚελʔଆʹ࡞੒
    ɹɾεϨʔϒ͔Β઀ଓ͢Δ
    ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ
    

    View Slide

82. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣࡞੒ίϚϯυ
    NZTRM NBTUFS
    $3&"5&64&3
    NZTRM NBTUFS
    `SFQM`!`<εϨʔϒͷϗετ໊>`
    NZTRM NBTUFS
    *%&/5*'*&%#:1"44803%``
    

    View Slide

83. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣ݖݶίϚϯυ
    NZTRM NBTUFS
    (3"/53&1-*$"5*0/4-"7&
    NZTRM NBTUFS
    0/50
    NZTRM NBTUFS
    `SFQM`!`<εϨʔϒͷϗετ໊>`
    

    View Slide

84. ࣄલ४උ
    ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ
    ⾣ϚελʔόΠφϦϩάͷ֬ೝ
    ⾣εϨʔϒͷઃఆ֬ೝ
    

    View Slide

85. ϚελʔͷNZDOG
    [mysqld]
    # εϨʔϒʹ௨஌͢ΔόΠφϦϩά(࣮ࡍ͸φόϦϯά͞ΕΔ)
    log-bin=mysql-bin
    # ϨϓϦέʔγϣϯ࣌ͷɺαʔόʔϢχʔΫID
    server-id=1001
    # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
    set-variable=expire_logs_days=3
    

    View Slide

86. [mysqld]
    # εϨʔϒʹ௨஌͢ΔόΠφϦϩά(࣮ࡍ͸φόϦϯά͞ΕΔ)
    log-bin=mysql-bin
    # ϨϓϦέʔγϣϯ࣌ͷɺαʔόʔϢχʔΫID
    server-id=1001
    # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
    set-variable=expire_logs_days=3
    ϚελʔͷNZDOG
    DPNNJUΛ௨஌ޙ
    εϨʔϒ͕઀ଓͯ͠औಘ
    WBSMJCNZTRM
    NZTRMCJO999999
    
    

    View Slide

87. [mysqld]
    # εϨʔϒʹ௨஌͢ΔόΠφϦϩά(࣮ࡍ͸φόϦϯά͞ΕΔ)
    log-bin=mysql-bin
    # ϨϓϦέʔγϣϯ࣌ͷɺαʔόʔϢχʔΫID
    server-id=1001
    # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
    set-variable=expire_logs_days=3
    ϚελʔͷNZDOG
    εϨʔϒ͔Βݟͨ
    Ϛελʔͷ*%
    

    View Slide

88. [mysqld]
    # εϨʔϒʹ௨஌͢ΔόΠφϦϩά(࣮ࡍ͸φόϦϯά͞ΕΔ)
    log-bin=mysql-bin
    # ϨϓϦέʔγϣϯ࣌ͷɺαʔόʔϢχʔΫID
    server-id=1001
    # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
    set-variable=expire_logs_days=3
    ϚελʔͷNZDOG
    ଟ͗͘͢͠Δͱ
    ετϨʔδѹഭ
    

    View Slide

89. ࣄલ४උ
    ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ
    ⾣ϚελʔόΠφϦϩάͷ֬ೝ
    ⾣εϨʔϒͷઃఆ֬ೝ
    

    View Slide

90. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    ⾣όΠφϦϩάͱҐஔ৘ใ
    ɹɾόΠφϦϩάϑΝΠϧͱ͸
    ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ
    ɹɾϩʔςʔτ͞ΕΔ
    ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ
    ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔
    ɹɹɹˠҐஔ৘ใΛ֬ೝ
    

    View Slide

91. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    mysql> SHOW MASTER STATUS\G
    ********* 1. row *********
    File: mysql-bin.000075
    Position: 588201136
    Binlog_Do_DB:
    Binlog_Ignore_DB:
    1 row in set (0.01 sec)
    

    View Slide

92. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    mysql> SHOW MASTER STATUS\G
    ********* 1. row *********
    File: mysql-bin.000075
    Position: 588201136
    Binlog_Do_DB:
    Binlog_Ignore_DB:
    1 row in set (0.01 sec)
    DPNNJUΛ௨஌ޙ
    εϨʔϒ͕઀ଓͯ͠औಘ
    WBSMJCNZTRM
    NZTRMCJO999999
    
    

    View Slide

93. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    mysql> SHOW MASTER STATUS\G
    ********* 1. row *********
    File: mysql-bin.000075
    Position: 588201136
    Binlog_Do_DB:
    Binlog_Ignore_DB:
    1 row in set (0.01 sec)
    ϚελʔͰ
    DPNNJU͕࣮ߦ͞Εͨ
    ϙδγϣϯ
    

    View Slide

94. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    mysql> SHOW MASTER STATUS\G
    ********* 1. row *********
    File: mysql-bin.000075
    Position: 588201136
    Binlog_Do_DB:
    Binlog_Ignore_DB:
    1 row in set (0.01 sec)
    εϨʔϒઃఆͰ࢖༻͢ΔͨΊ
    ϝϞ͓͖ͯ͠·͠ΐ͏
    

    View Slide

95. ⾣εϨʔϒΛ࡞Δࡍͷݪଇ
    ɹϚελʔΛϩοΫͯ͠EVNQ͠
    ɹಉҰͷঢ়ଶͰϦετΞͯ͠
    ɹϑΝΠϧɾϙδγϣϯΛ߹ΘͤΔ
    ࠩ෼ɾൈ͚࿙Εͳ͘
    ϨϓϦέʔγϣϯ։࢝
    ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    

    View Slide

96. ࣄલ४උ
    ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ
    ⾣ϚελʔόΠφϦϩάͷ֬ೝ
    ⾣εϨʔϒͷઃఆ֬ೝ
    

    View Slide

97. ɹɹεϨʔϒͷઃఆ֬ೝ
    mysql> SHOW SLAVE STATUS\G
    **************** 1. row ****************
    Slave_IO_State:
    Master_Host: [Ϛελʔͷϗετ໊]
    Master_User: repl
    Master_Log_File: mysql-bin.000009
    Read_Master_Log_Pos: 303456264
    Slave_IO_Running: No
    Slave_SQL_Running: No
    Seconds_Behind_Master: NULL
    Master_Server_Id: 0
    1 row in set (0.01 sec)
    

    View Slide

98. ɹɹεϨʔϒͷઃఆ֬ೝ
    ⾣4MBWF@*0@4UBUFɿۭจࣈ
    ɹεϨʔϒͷݱࡏͷεςʔλε
    ɹϨϓϦέʔγϣϯ్͕੾Ε͍ͯΔͨΊ
    ɹۭจࣈͱͳ͍ͬͯΔ
    ࣮ߦ͞Ε͍ͯΕ͹
    8BJUJOHGPSNBTUFSUPTFOEFWFOU
    

    View Slide

99. ɹɹεϨʔϒͷઃఆ֬ೝ
    ⾣.BTUFS@6TFSɿSFQM
    εϨʔϒ͔ΒϚελʔʹ
    ઀ଓ͢ΔϢʔβʔ໊
    ɹ
    ϚελʔͰ࡞੒ͨ͠ઐ༻Ϣʔβʔ
    

    View Slide

100. ɹɹεϨʔϒͷઃఆ֬ೝ
     ⾣.BTUFS@-PH@'JMFɿNZTRMCJO
     εϨʔϒ͕Ϛελʔ͔Β
     औಘ͢ΔόΠφϦϩά
     ɹ
     Քಇ͍ͯ͠ͳ͔ͬͨͷͰ
     ζϨ͍ͯΔ
     

     View Slide

101. ɹɹεϨʔϒͷઃఆ֬ೝ
     ⾣3FBE@.BTUFS@-PH@1PTɿ
     εϨʔϒͷ*0εϨου͕
     ࠷ޙʹಡΈऔͬͨҐஔ
     ɹ
     ͔͜͜ΒϨϓϦέʔγϣϯ࠶։͕ͩ
     େ͖͘ζϨ͍ͯΔ
     

     View Slide

102. ɹɹεϨʔϒͷઃఆ֬ೝ
     ⾣4MBWF@*0@3VOOJOHɿ/0
     εϨʔϒͷ*0εϨου͕
     ࣮ߦ͞Ε͍ͯͳ͍
     ɹ
     ϚελʔͷόΠφϦϩά͕ҧ͏ͷͰ
     ઀ଓͰ͖͍ͯͳ͍
     

     View Slide

103. ɹɹεϨʔϒͷઃఆ֬ೝ
     ⾣4MBWF@42-@3VOOJOHɿ/0
     εϨʔϒͷ42-εϨου͕
     ࣮ߦ͞Ε͍ͯͳ͍
     ɹ
     εϨʔϒͷ%#͕
     ߋ৽͞Ε͍ͯͳ͍
     

     View Slide

104. ɹɹεϨʔϒͷઃఆ֬ೝ
     ⾣4FDPOET@#FIJOE@.BTUFSɿ/6--
     Ϛελʔʹൺ΂ͯ
     ஗Ԇ͍ͯ͠Δඵ਺
     ɹ
     ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍
     

     View Slide

105. ɹϨϓϦέʔγϣϯखॱ
     ⾣ϚελʔͷEVNQΛऔಘ
     ⾣εϨʔϒͷNZDOGઃఆ
     ⾣εϨʔϒʹϦετΞ
     ⾣εϨʔϒઃఆมߋ
     ⾣ϨϓϦέʔγϣϯ࣮ߦ
     ⾣࣮ߦঢ়گΛ؂ࢹ
     

     View Slide

106. ɹϨϓϦέʔγϣϯखॱ
     ⾣ϚελʔͷEVNQΛऔಘ
     ⾣εϨʔϒͷNZDOGઃఆ
     ⾣εϨʔϒʹϦετΞ
     ⾣εϨʔϒઃఆมߋ
     ⾣ϨϓϦέʔγϣϯ࣮ߦ
     ⾣࣮ߦঢ়گΛ؂ࢹ
     

     View Slide

107. ɹɹϚελʔͷEVNQΛऔಘ
     ⾣ϚελʔΛϩοΫ
     mysql(master)> FLUSH TABLES WITH READ LOCK;
     Query OK, 0 rows affected (0.00 sec)
     ⾣όΠφϦϩάͱϙδγϣϯऔಘ
     mysql(master)> SHOW MASTER STATUS;
     File: mysql-bin.000075
     Position: 588201136
     Binlog_Do_DB:
     Binlog_Ignore_DB:
     1 row in set (0.01 sec)
     

     View Slide

108. ɹɹϚελʔͷEVNQΛऔಘ
     ⾣ϚελʔΛϩοΫ
     mysql(master)> FLUSH TABLES WITH READ LOCK;
     Query OK, 0 rows affected (0.00 sec)
     ⾣όΠφϦϩάͱϙδγϣϯऔಘ
     mysql(master)> SHOW MASTER STATUS;
     File: mysql-bin.000075
     Position: 588201136
     Binlog_Do_DB:
     Binlog_Ignore_DB:
     1 row in set (0.01 sec)
     εϨʔϒઃఆͰ࢖༻͢ΔͨΊ
     ϝϞ͓͖ͯ͠·͠ΐ͏
     

     View Slide

109. ɹɹϚελʔͷEVNQΛऔಘ
     ⾣EVNQऔಘ
     $ mysqldump -u root -p mamy1326 > gzip
     mamy1326.dump.gz
     ɾผίϯιʔϧ͔Β࣮ࢪ
     ɹˠRVJU͢ΔͱϩοΫ͕֎Ε·͢
     ɾετϨʔδ༰ྔΛߟྀͯ͠H[JQ
     ɾTDQίϚϯυ౳ͰεϨʔϒʹసૹ
     

     View Slide

110. ɹɹϚελʔͷEVNQΛऔಘ
     ⾣ϚελʔͷϩοΫΛղআ
     mysql(master)> UNLOCK TABLES;
     Query OK, 0 rows affected (0.00 sec)
     

     View Slide

111. ɹϨϓϦέʔγϣϯखॱ
     ⾣ϚελʔͷEVNQΛऔಘ
     ⾣εϨʔϒͷNZDOGઃఆ
     ⾣εϨʔϒʹϦετΞ
     ⾣εϨʔϒઃఆมߋ
     ⾣ϨϓϦέʔγϣϯ࣮ߦ
     ⾣࣮ߦঢ়گΛ؂ࢹ
     

     View Slide

112. ɹɹεϨʔϒͷNZDOGઃఆ
     [mysqld]
     # εϨʔϒͷαʔόʔID
     server-id=1002
     # Ϛελʔͷঢ֨Λߟྀ͠ɺϩΪϯάΛ༗ޮʹ͢Δ
     log-bin=mysql-bin
     # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
     set-variable=expire_logs_days=3
     # όΠφϦϩάͷग़ྗઃఆ
     log_slave_updates
     

     View Slide

113. [mysqld]
     # εϨʔϒͷαʔόʔID
     server-id=1002
     # Ϛελʔͷঢ֨Λߟྀ͠ɺϩΪϯάΛ༗ޮʹ͢Δ
     log-bin=mysql-bin
     # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
     set-variable=expire_logs_days=3
     # όΠφϦϩάͷग़ྗઃఆ
     log_slave_updates
     ɹɹεϨʔϒͷNZDOGઃఆ
     ϚελʔɺεϨʔϒ
     શͯ߹Θͤͯ
     Ұҙͷ*%
     

     View Slide

114. [mysqld]
     # εϨʔϒͷαʔόʔID
     server-id=1002
     # Ϛελʔͷঢ֨Λߟྀ͠ɺϩΪϯάΛ༗ޮʹ͢Δ
     log-bin=mysql-bin
     # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
     set-variable=expire_logs_days=3
     # όΠφϦϩάͷग़ྗઃఆ
     log_slave_updates
     ɹɹεϨʔϒͷNZDOGઃఆ
     όΠφϦϩάઃఆ
     Ϛελʔʹঢ֨ͨ͠৔߹
     εϨʔϒʹ௨஌͢Δ
     

     View Slide

115. [mysqld]
     # εϨʔϒͷαʔόʔID
     server-id=1002
     # Ϛελʔͷঢ֨Λߟྀ͠ɺϩΪϯάΛ༗ޮʹ͢Δ
     log-bin=mysql-bin
     # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
     set-variable=expire_logs_days=3
     # όΠφϦϩάͷग़ྗઃఆ
     log_slave_updates
     ɹɹεϨʔϒͷNZDOGઃఆ
     ༰ྔѹഭ͠ͳ͍Α͏ʹ
     

     View Slide

116. [mysqld]
     # εϨʔϒͷαʔόʔID
     server-id=1002
     # Ϛελʔͷঢ֨Λߟྀ͠ɺϩΪϯάΛ༗ޮʹ͢Δ
     log-bin=mysql-bin
     # όΠφϦϩάϑΝΠϧͷϩʔςʔτ೔਺
     set-variable=expire_logs_days=3
     # όΠφϦϩάͷग़ྗઃఆ
     log_slave_updates
     ɹɹεϨʔϒͷNZDOGઃఆ
     εϨʔϒͰ΋
     όΠφϦϩάΛग़ྗ͠
     Ϛελʔঢ֨Մೳʹ
     

     View Slide

117. ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ
     ⾣NZDOGΛຊ൪ʹ߹ΘͤΔ
     ⾣NZTRM࠶ىಈ
     ⾣ϦετΞର৅ͷ
     ɹɹɹσʔλϕʔε࡟আɾ࠶࡞੒
     

     View Slide

118. ɹϨϓϦέʔγϣϯखॱ
     ⾣ϚελʔͷEVNQΛऔಘ
     ⾣εϨʔϒͷNZDOGઃఆ
     ⾣εϨʔϒʹϦετΞ
     ⾣εϨʔϒઃఆมߋ
     ⾣ϨϓϦέʔγϣϯ࣮ߦ
     ⾣࣮ߦঢ়گΛ؂ࢹ
     

     View Slide

119. ɹɹεϨʔϒʹϦετΞ
     ⾣ϦετΞ࣮ߦ
     ɾετϨʔδ༰ྔʹ஫ҙʂ
     ɹɹˠαΠζେ͖ΊͷόΠφϦϩά͕
     ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ
     $ zcat mamy1326.dump.gz | mysql -u root
     -p mamy1326
     

     View Slide

120. ɹɹεϨʔϒʹϦετΞ
     ⾣ϦετΞ࣮ߦ
     ɾετϨʔδ༰ྔʹ஫ҙʂ
     ɹɹˠαΠζେ͖ΊͷόΠφϦϩά͕
     ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ
     $ zcat mamy1326.dump.gz | mysql -u root
     -p mamy1326
     163(&."45&3-0(450
     bNZTRMCJOYYYYYY`
     ద੾ʹύʔδ͠·͠ΐ͏
     

     View Slide

121. ɹϨϓϦέʔγϣϯखॱ
     ⾣ϚελʔͷEVNQΛऔಘ
     ⾣εϨʔϒͷNZDOGઃఆ
     ⾣εϨʔϒʹϦετΞ
     ⾣εϨʔϒઃఆมߋ
     ⾣ϨϓϦέʔγϣϯ࣮ߦ
     ⾣࣮ߦঢ়گΛ؂ࢹ
     

     View Slide

122. ɹεϨʔϒઃఆมߋ
     ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ
     mysql> STOP SLAVE;
     mysql> RESET SLAVE;
     mysql> CHANGE MASTER TO
     -> master_log_file = ’mysql-bin.000075’,
     -> master_log_pos = 588201136;
     

     View Slide

123. mysql> STOP SLAVE;
     mysql> RESET SLAVE;
     mysql> CHANGE MASTER TO
     -> master_log_file = ’mysql-bin.000075’,
     -> master_log_pos = 588201136;
     ɹεϨʔϒઃఆมߋ
     ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ
     εϨʔϒΛࢭΊ·͢
     

     View Slide

124. mysql> STOP SLAVE;
     mysql> RESET SLAVE;
     mysql> CHANGE MASTER TO
     -> master_log_file = ’mysql-bin.000075’,
     -> master_log_pos = 588201136;
     ɹεϨʔϒઃఆมߋ
     ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ
     εϨʔϒ͕อ͍࣋ͯͨ͠
     ϨϓϦέʔγϣϯҐஔΛ
     Ϧηοτ͠·͢
     

     View Slide

125. mysql> STOP SLAVE;
     mysql> RESET SLAVE;
     mysql> CHANGE MASTER TO
     -> master_log_file = ’mysql-bin.000075’,
     -> master_log_pos = 588201136;
     ɹεϨʔϒઃఆมߋ
     ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ
     ϚελʔͷόΠφϦϩάɺ
     ϙδγϣϯΛઃఆ
     

     View Slide

126. ɹϨϓϦέʔγϣϯखॱ
     ⾣ϚελʔͷEVNQΛऔಘ
     ⾣εϨʔϒͷNZDOGઃఆ
     ⾣εϨʔϒʹϦετΞ
     ⾣εϨʔϒઃఆมߋ
     ⾣ϨϓϦέʔγϣϯ࣮ߦ
     ⾣࣮ߦঢ়گΛ؂ࢹ
     

     View Slide

127. ɹϨϓϦέʔγϣϯ࣮ߦ
     ⾣ϨϓϦέʔγϣϯͷ։࢝
     mysql> START SLAVE;
     ઃఆͨ͠ϙδγϣϯ͔Β
     ಉظ͕࣮ߦ͞Ε·͢
     

     View Slide

128. ɹϨϓϦέʔγϣϯ࣮ߦ
     ⾣ϨϓϦέʔγϣϯͷ֬ೝ
     mysql> SHOW SLAVE STATUS\G
     ***************** 1. row *****************
     Slave_IO_State: Waiting for master to send event
     Master_Log_File: mysql-bin.000075
     Read_Master_Log_Pos: 878873047
     Slave_IO_Running: Yes
     Slave_SQL_Running: Yes
     Exec_Master_Log_Pos: 605504154
     Seconds_Behind_Master: 244615
     Last_IO_Errno: 0
     Last_IO_Error:
     Last_SQL_Errno: 0
     Last_SQL_Error:
     Master_Server_Id: 1001
     

     View Slide

129. ɹϨϓϦέʔγϣϯͷ֬ೝ
     ⾣4MBWF@*0@4UBUFɿ
     8BJUJOHGPSNBTUFSUPTFOEFWFOU
     εϨʔϒͷݱࡏͷεςʔλε
     ϨϓϦέʔγϣϯ͕։࢝͞Ε
     Ϛελʔ͔ΒͷΠϕϯτ଴ͪ
     

     View Slide

130. ɹϨϓϦέʔγϣϯͷ֬ೝ
     ⾣.BTUFS@-PH@'JMFɿ
     NZTRMCJO
     ϚελʔͷόΠφϦϩάϑΝΠϧ
     ݱࡏϚελͰߋ৽͞Ε͍ͯΔ
     ϑΝΠϧ໊ʹͳ͍ͬͯΔ
     

     View Slide

131. ɹϨϓϦέʔγϣϯͷ֬ೝ
     ⾣3FBE@.BTUFS@-PH@1PTɿ
     
     ϚελʔͷόΠφϦϩά͔Β
     *0εϨου͕ಡΈऔͬͨҐஔ
     ˞42-࣮ߦ͞Εͨͱ͸ݶΒͳ͍
     

     View Slide

132. ɹϨϓϦέʔγϣϯͷ֬ೝ
     ⾣&YFD@.BTUFS@-PH@1PTɿ
     
     *0εϨου͕ಡΈࠐΜͩϩά͔Β
     42-εϨου͕
     ࣮ߦͨ͠ΫΤϦͷҐஔ
     

     View Slide

133. ɹϨϓϦέʔγϣϯͷ֬ೝ
     ⾣4FDPOET@#FIJOE@.BTUFSɿ
     
     εϨʔϒ͕Ϛελʔʹൺ΂
     ஗Ԇ͍ͯ͠Δඵ਺
     

     View Slide

134. ɹϨϓϦέʔγϣϯͷ֬ೝ
     ⾣4MBWF@*0@3VOOJOHɿ:&4
     ϚελʔͷόΠφϦϩάΛ
     औಘͰ͖͍ͯΔ
     

     View Slide

135. ɹϨϓϦέʔγϣϯͷ֬ೝ
     ⾣4MBWF@42-@3VOOJOHɿ:&4
     औಘͨ͠όΠφϦϩάͷ
     42-࣮ߦͰ͖͍ͯΔ
     

     View Slide

136. ɹϨϓϦέʔγϣϯखॱ
     ⾣ϚελʔͷEVNQΛऔಘ
     ⾣εϨʔϒͷNZDOGઃఆ
     ⾣εϨʔϒʹϦετΞ
     ⾣εϨʔϒઃఆมߋ
     ⾣ϨϓϦέʔγϣϯ࣮ߦ
     ⾣࣮ߦঢ়گΛ؂ࢹ
     

     View Slide

137. ɹ࣮ߦঢ়گΛ؂ࢹ
     mysql> SHOW SLAVE STATUS\G
     **************** 1. row **************
     Read_Master_Log_Pos: 878873047
     Exec_Master_Log_Pos: 605504154
     Seconds_Behind_Master: 244615
     ⾣࣮ߦ௚ޙ
     

     View Slide

138. ɹ࣮ߦঢ়گΛ؂ࢹ
     mysql> SHOW SLAVE STATUS\G
     **************** 1. row **************
     Read_Master_Log_Pos: 878873047
     Exec_Master_Log_Pos: 605504154
     Seconds_Behind_Master: 244615
     ⾣࣮ߦ௚ޙ
     mysql> SHOW SLAVE STATUS\G
     **************** 1. row **************
     Read_Master_Log_Pos: 879066686
     Exec_Master_Log_Pos: 879066686
     Seconds_Behind_Master: 0
     ⾣ಉظ׬ྃ
     

     View Slide

139. ɹϨϓϦέʔγϣϯ·ͱΊ
     ⾣ෳ੡࡞੒ɾӡ༻׬ྃʂ
     ⾣ࢀরܥͷαʔόʔ४උ׬ྃʂ
     ⾣όοΫΞοϓαʔόʔ࡞੒׬ྃ
     

     View Slide

140. ৼΓฦΓ
     

     View Slide

141. શମͷৼΓฦΓ
     ⾣NZDOGઃఆ
     ຊདྷͷύϑΥʔϚϯεΛಘͨ
     ⾣ΫΤϦΩϟογϡଌఆ
     ܧଓ؂ࢹͷେࣄ͞Λ஌ͬͨ
     ⾣ϨϓϦέʔγϣϯ࣮ࢪ
     ৑௕Խͷ४උ͕Ͱ͖ͨ
     

     View Slide

142. ՝୊
     

     View Slide

143. ࠓޙͷ՝୊
     ⾣ܧଓ؂ࢹͷ࢓૊Έ
     ֤छγΣϧͰରԠத
     ⾣ࢀরܥΛεϨʔϒʹ
     ϓϩάϥϜվमઃܭத
     ⾣ෆཁϨίʔυͷ࡟আ ϩάܥ
     
     ஈ֊Λ౿ΜͰ࡟আܭըத
     

     View Slide

144. Τϐϩʔά
     

     View Slide

145. ઃఆ͔ͨ͠Β
     ऴΘΓͰ͸ͳ͍
     

     View Slide

146. Πϯϑϥ͸
     ϥΠϑαΠΫϧ͕௕͍
     

     View Slide

147. ೔ʑͷ؂ࢹɾܭଌ͔Β
     ઌखΛଧͭʂ
     

     View Slide

148. ܧଓ͸ྗͳΓ
     

     View Slide

149. ࠓ೔Ұ൪
     ఻͔͑ͨͬͨ͜ͱ
     

     View Slide

150. Πϯϑϥʹಓʹೖͬͨ͹͔Γ
     ਖ਼௚ܟԕͯ͠·ͨ͠
     

     View Slide

151. ͻΐΜͳ͜ͱ͔Βೖͬͨಓ͕
     ࠓ͸ָͯ͘͠࢓ํ͕ͳ͍ʂ
     

     View Slide

152. ΄ͱΜͲ1)1ॻ͍ͯͳ͍͠
     ॻ͍ͯ΋γΣϧ
     

     View Slide

153. WJN͔͠࢖Θͳ͍ͷͰ
     ຖ೔ࠇ͍ը໘
     

     View Slide

154. ͔͠͠ʂ
     

     View Slide

155. ਂ͘ߟ͑
     ͭͣͭௐ΂ͯ
     ൓ө͢Δ
     

     View Slide

156. ܭଌͯ݁͠ՌΛௐ΂
     ࣍ͷखΛଧͭ
     

     View Slide

157. ࡞ۀϩάΛ
     ϚʔΫμ΢ϯͰશͯه࿥
     

     View Slide

158. ΤϯτϦʔʹ͢Δͱ͖
     શ෦ௐ΂௚͢
     

     View Slide

159. ϩʔΧϧʹ؀ڥߏஙΛ
     ΧδϡΞϧʹ͍ͯ͠Δ
     

     View Slide

160. Ξ΢τϓοτ
     ָ͍͠ʂʂʂʂ
     

     View Slide

161. ָ͍͠ʂʂʂʂ
     

     View Slide

162. ΞϓϦΤϯδχΞ͔ͩΒͬͯ
     ΠϯϑϥΛ
     ଞਓ೚ͤʹ͠ͳ͍
     

     View Slide

163. ΞϓϦΤϯδχΞ͔ͩΒͬͯ
     ϑϩϯτΤϯυΛ
     ଞਓ೚ͤʹ͠ͳ͍
     

     View Slide

164. ੈքΛ޿͛Δ͜ͱ͸
     ΤϯδχΞਓੜͷ޿͕Γ
     Λҙຯ͢Δ
     

     View Slide

165. ஌Βͳ͍ΑΓ΋
     ஌Δ΄͏ָ͕͍͠ʂ
     

     View Slide

166. ੈքΛ޿͛ͯ
     ͜Ε͔Β΋
     ָ͍͠ΤϯδχΞϥΠϑΛʂ
     

     View Slide

167. ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ
     

     View Slide

168. ͓·͚
     ⾣ݩهࣄͷ͝঺հ
     ɾ.Z42-ύϑΥʔϚϯενϡʔχϯά
     ɹɹNZDOGͷݟ௚͠
     ɹIUUQRJJUBDPNNBNZJUFNTDFBFFDD⒎B
     ɾ.Z42-ύϑΥʔϚϯενϡʔχϯά
     ɹɹΫΤϦΩϟογϡద༻ঢ়گͷ֬ೝ
     ɹIUUQRJJUBDPNNBNZJUFNTEEDGB
     ɾ.Z42-ϨϓϦέʔγϣϯઃఆ
     ɹɹखॱɾ֤छεςʔλεͷৄࡉͱτϥϒϧγϡʔςΟϯά
     ɹIUUQRJJUBDPNNBNZJUFNTBFEGBCGE
     

     View Slide