Operator でどう変わる? これからのデータベース運用 / cndt2019_k8s_operator

CloudNative Days Tokyo 2019 (2019/07/22 [1G3] 15:40 - 16:20)
https://cloudnativedays.jp/cndt2019/

データベースをはじめとするステートフルなアプリケーションはコンテナでの運用と相性が良くないと考えられていましたが、Kubernetesと周辺ツールを活用し運用するための仕組みが整ってきました。また、CRDとCustom Controllerを使い、運用に必要な操作の自動化をする取り組みも注目されています。本セッションではMySQLを取り上げ、Kubernetesを使った場合のデータベース運用や監視方法について従来のVMを使った場合とはどのように変わるのか、それぞれのメリットとデメリットは何か、等の比較を交えながら今後どのように変わっていくかご紹介します。

Transcript

1. 0QFSBUPSͰͲ͏มΘΔʁ
   ͜Ε͔Βͷσʔλϕʔεӡ༻
   $MPVE/BUJWF%BZT5PLZP
   :VLJ,JSJJ
   ,VCFSOFUFT
   

   View Slide

2. "CPVU.F
   :VLJ,JSJJ
   *OGSBTUSVDUVSF&OHJOFFS
   ZVLJSJJ@
   ZVLJSJJ
   $FSUJpFE,VCFSOFUFT"ENJOJTUSBUPS $,"
   
   
   גࣜձࣾαΠόʔΤʔδΣϯτ
   ٕज़ຊ෦4FSWJDF3FMJBCJMJUZ(SPVQ 43(
   
   "NFCBͷը૾഑৴γεςϜ΍ج൫γεςϜͷΠϯϑϥΛ୲౰
   

   View Slide

3. 
   ࠓ೔͓࿩͢͠Δ͜ͱ
   ˒ ,VCFSOFUFT0QFSBUPSΛ࢖͏ͱͲΜͳࣄ͕Ͱ͖Δͷ͔
   ˒ ͲΜͳ఺͕͏Ε͍͠ͷ͔
   ࣮ྫͱͯ͠σʔλϕʔεΛಈ͔͢ྫΛަ͑ͳ͕Βղઆ͍͖ͯ͠·͢
   ·ͣ͸࢖ͬͯݟΔͱ͜Ζ͔Β͸͡ΊͯΈ·͠ΐ͏ʂ
   ͠ͳ͍͜ͱ
   ˒ ,VCFSOFUFT0QFSBUPSͷ࡞Γํ
   ຊ೔ͷࢿྉ͸ެ։͠·͢ͷͰ

   ࣸਅऔΒͳͯ͘΋େৎ෉Ͱ͢Ϥʂ
   

   View Slide

4. 
   "NFCBͷΦϯϓϨ,VCFSOFUFTΫϥελ
   "NFCBϢʔβͷϓϩϑΟʔϧγεςϜ

   ࡮৽ϓϩδΣΫτ
   ‣ ೥຤
   ‣ ྺ࢙తܦҢͰ෼அ͞Ε͍ͯͨͭͷγεςϜΛ

   ౷߹͠ϦχϡʔΞϧʂ
   ʮϦχϡʔΞϧΛظʹ%PDLFSԽʂʯ
   ʮίϯςφΦʔέετϨʔγϣϯʹ͸

   ɹ,VCFSOFUFTΛ࢖͏ͧʂʂʯ
   ϓϥΠϕʔτΫϥ΢υ্ʹ

   ,VCFSOFUFTΫϥελ͕ര஀
   

   View Slide

5. 
   "NFCBͷΦϯϓϨ,VCFSOFUFTΫϥελ
   0QFO4UBDL্ʹߏங
   ‣ σϓϩΠ͸,VCFTQSBZͰ
   .Z42-σʔλϕʔε
   ‣ LTΫϥελͷ֎ʹ7.Ͱߏங
   ‣ .BTUFS4MBWF

   

   .)"GPS.Z42-
   7.
   7.
   7. 7.
   .BTUFS
   7.
   4MBWF
   ˞Πϯλʔωοτ޿ࠂࣄۀ෦ͷ,VCFSOFUFT ",&
   ͱ͸ผͷ؀ڥͰ͢
   ࠓͳΒ%#Λ,VCFSOFUFTʹ

   ͷͤΔ͜ͱ΋Ͱ͖Δʁ
   ͲΜͳํ๏͕͋ΔͩΖ͏ʁʁ
   

   View Slide

6. 
   5PEBZ`T"HFOEB
   
   
   
   ίϯςφͰεςʔτϑϧͳΞϓϦέʔγϣϯΛಈ͔͢
   ,VCFSOFUFT0QFSBUPSͱ͸
   ࣮ྫ.Z42-0QFSBUPSΛಈ͔ͯ͠ΈΑ͏
   ,VCFSOFUFT0QFSBUPSͷ͜Ε͔Β
   ߟྀ͢΂͖ϙΠϯτͱ,VCFSOFUFT্Ͱͷղܾํ๏ʹ͍ͭͯ஌Δ
   $VTUPN3FTPVSDFΛ׆༻ͨ͠ӡ༻ࣗಈԽͷύλʔϯʹ͍ͭͯ஌Δ
   0QFSBUPSͷ࢖༻ײ͸ʁ࣮ࡍʹLT্Ͱ.Z42-Λಈ͔ͯ͠ΈΔ
   ؔ࿈ϓϩδΣΫτͷ঺հͱ0QFSBUPSͷࠓޙʹ͍ͭͯ
   

   View Slide

7. 
   ίϯςφͰεςʔτϑϧͳΞϓϦΛಈ্͔͢ͰͷͭͷϙΠϯτ
   ΞϓϦέʔγϣϯݻ༗ͷ

   ӡ༻φϨοδ
   Ӭଓతͳσʔλͷѻ͍
   

   View Slide

8. 
   εςʔτϨεͳΞϓϦέʔγϣϯͷ৔߹
   8FCαʔό΍"1*αʔόʜΞϓϦέʔγϣϯ͸ঢ়ଶΛ࣋ͨͳ͍
   OPEF
   OPEF
   OPEF
   ͲͷϗετͰ΋ىಈͰ͖Δ
   㾎 ϙʔλϏϦςΟ͕ߴ͍
   ૿΍͠΍͍͢ݮΒ͠΍͍͢
   㾎 εέʔϥϏϦςΟ͕ߴ͍
   ໰୊ͷ͋Δίϯςφ͸ࣺͯΔ͜ͱ͕Ͱ͖Δ
   㾎 ճ෮ྗ͕ߴ͍
   

   View Slide

9. 
   εςʔτϑϧͳΞϓϦέʔγϣϯͷ৔߹
   σʔλϕʔε΍෼ࢄγεςϜʜΞϓϦέʔγϣϯ͸ঢ়ଶΛ࣋ͭ
   
   ΞϓϦέʔγϣϯͷϥΠϑαΠΫϧͱͷΪϟοϓ
   4UBSUFE 4UPQQFE
   $SFBUFE ,JMMFE
   ίϯςφ಺ͷσʔλͷอ࣋ظؒ
   ίϯςφͷϥΠϑαΠΫϧ
   σϓϩΠͷ୯Ґ ΞϓϦέʔγϣϯͷ
   ϥΠϑαΠΫϧ
   ίϯςφΠϯελϯεͷ֎΁

   σʔλͷӬଓԽ͕ඞཁ
   ΞϓϦέʔγϣϯ͕

   σʔλΛඞཁͱ͢Δظؒ
   

   View Slide

10. 
    εςʔτϑϧͳΞϓϦέʔγϣϯͷ৔߹
    σʔλϕʔε΍෼ࢄγεςϜʜΞϓϦέʔγϣϯ͸ঢ়ଶΛ࣋ͭ
    
    ࠶ىಈ΍ผϗετͰىಈ͢Δέʔεͷߟྀ΋ඞཁ
    ‣ ಉ͡σʔλ͕࠶ͼར༻ՄೳͰͳ͚Ε͹ͳΒͳ͍

    ྫ%#ͷ߸ػ༻1PEͰ͸ɺҎલͱಉ͡

    ɹ1PE༻ͷϘϦϡʔϜΛϚ΢ϯτͯ͠΄͍͠
    OPEF
    OPEF
    OPEF
    ʁ
    SFSFTDIFEVMJOH
    

    View Slide

11. 
    εςʔτϑϧͳΞϓϦέʔγϣϯͷ৔߹
    σʔλϕʔε΍෼ࢄγεςϜˠΞϓϦέʔγϣϯ͸ঢ়ଶΛ࣋ͭ
    
    ݻఆͷ໊લΛ࢖͍͍ͨ
    ‣ ଟ਺ͷϊʔυͰߏ੒͞ΕΔγεςϜͷ৔߹

    ϗετ໊*1͕มΘΔͱϝϯόͷಛఆ͕೉͘͠ͳΔ
    OPEF
    OPEF
    OPEF
    %#$MVTUFS
    $POpH'JMF
    .FNCFST
    OPEFT[DQʜ/PU'PVOE
    OPEFUIW[ʜ/PU'PVOE
    ʁ
    OPEFIUIC
    OPEFQMTT
    

    View Slide

12. 
    4UBUFGVM4FU
    εςʔτϑϧͳΞϓϦέʔγϣϯΛಈ͔ͨ͢Ίͷ,VCFSOFUFT૊ΈࠐΈͷϦιʔε
    ‣ 1PEͰ࢖༻͢ΔӬଓσʔλͷऔΓѻ͍ͱωʔϛϯάͷ՝୊Λղܾ
    NZTRM
    NZTRM
    NZTRM
    NZTRM
    
    
    
    ॱ൪ʹ

    σϓϩΠ
    ॱ൪ʹ

    ऴྃ࡟আ
    ֤1PEʹઐ༻ͷετϨʔδϘϦϡʔϜΛ

    ׂΓ౰ͯΔ
    ରԠؔ܎΋ҡ࣋͞ΕΔ
    1PEʹݻఆͷࣝผࢠΛׂΓ౰ͯΔ
    

    View Slide

13. 
    ίϯςφͰεςʔτϑϧͳΞϓϦΛಈ্͔͢ͰͷͭͷϙΠϯτ
    ΞϓϦέʔγϣϯݻ༗ͷ

    ӡ༻φϨοδ
    Ӭଓతͳσʔλͷѻ͍
    ʁʁʁ
    4UBUFGVM4FU
    ,VCFSOFUFTͷඪ४ػೳ
    ඪ४ػೳ͕αϙʔτ͠ͳ͍ྖҬ
    

    View Slide

14. 
    εςʔτϑϧͳΞϓϦέʔγϣϯͷ৔߹
    σʔλϕʔε΍෼ࢄγεςϜˠΞϓϦέʔγϣϯ͸ঢ়ଶΛ࣋ͭ
    
    ΞϓϦέʔγϣϯݻ༗ͷૢ࡞͕ඞཁ
    ‣ ,VCFSOFUFT্Ͱ͸ࣗ཯ಈ࡞͕લఏ
    ‣ ىಈޙʹԿΒ͔ͷΦϖϨʔγϣϯ͕ඞཁͳ৔߹

    ࣗಈԽͰߦ͏࢓૊Έ͕΄͍͠
    ‣ ྫ৽ن%#ϊʔυͷΫϥελ΁ͷKPJOૢ࡞
    ‣ ྫো֐͔Βͷ෮چʹΦϖϨʔγϣϯ͕ඞཁ
    OPEF
    OPEF
    OPEF
    ʁ
    %#$MVTUFS
    +PJOJOHBOPEF Ͳ͏ରॲ͢Δʜʁ
    

    View Slide

15. 
    5PEBZ`T"HFOEB
    
    
    
    ίϯςφͰεςʔτϑϧͳΞϓϦέʔγϣϯΛಈ͔͢
    ,VCFSOFUFT0QFSBUPSͱ͸
    ࣮ྫ.Z42-0QFSBUPSΛಈ͔ͯ͠ΈΑ͏
    ,VCFSOFUFT0QFSBUPSͷ͜Ε͔Β
    ߟྀ͢΂͖ϙΠϯτͱ,VCFSOFUFT্Ͱͷղܾํ๏ʹ͍ͭͯ஌Δ
    $VTUPN3FTPVSDFΛ׆༻ͨ͠ӡ༻ࣗಈԽͷύλʔϯʹ͍ͭͯ஌Δ
    0QFSBUPSͷ࢖༻ײ͸ʁ࣮ࡍʹLT্Ͱ.Z42-Λಈ͔ͯ͠ΈΔ
    ؔ࿈ϓϩδΣΫτͷ঺հͱ0QFSBUPSͷࠓޙʹ͍ͭͯ
    

    View Slide

16. 
    ,VCFSOFUFT0QFSBUPS
    ಛఆͷΞϓϦέʔγϣϯΛ,VCFSOFUFT্Ͱ࣮ߦɾ؅ཧ͢ΔͨΊͷιϑτ΢ΣΞ $POUSPMMFS
    
    ‣ ೥$PSF04͕ఏএͨ͠ख๏
    ‣ ӡ༻্ͷφϨοδ͕ιϑτ΢ΣΞͱ࣮ͯ͠૷͞Ε͍ͯΔ
    ‣ 0QFSBUPSࣗମ΋,VCFSOFUFTͰ؅ཧ͞ΕΔίϯςφͱͯ͠ಈ࡞
    IUUQTDPSFPTDPNCMPHJOUSPEVDJOHPQFSBUPSTIUNM
    㾎 ΞϓϦέʔγϣϯͷόʔδϣϯΞοϓ
    㾎 ෳࡶͳো֐ճ෮ͷखॱͷ࣮ߦ
    㾎 ఆظతͳσʔλͷόοΫΞοϓ
    㾎 εςʔτϑϧͳΞϓϦέʔγϣϯͷ

    εέʔϧΞοϓμ΢ϯ
    0QFSBUPS
    $SFBUF/FX1PE
    #BDLVQ
    ΞϓϦέʔγϣϯݻ༗ͷӡ༻खॱΛ

    ιϑτ΢ΣΞԽ
    

    View Slide

17. 
    ͓͞Β͍
    ,VCFSOFUFTͷಛ௃ͱಈ࡞
    ಛ௃%FDMBSBUJWF એݴతͳ
    "1*
    ‣ Ϣʔβ͸ͳʹΛୡ੒͍ͨ͠ͷ͔ EFTJSFETUBUF
    ΛγεςϜʹ఻͑Δ
    apiVersion: extensions/v1beta1
    kind: ReplicaSet
    metadata:
    name: nginx
    spec:
    replicas: 3
    template:
    spec:

    containers:

    - name: nginx
    image: nginx:latest
    Ϣʔβ͸"1*Λ௨ͯ͠

    3FTPVSDFΛొ࿥͢Δ
    $POUSPMMFS͸"1*Λ௨ͯ͠

    3FTPVSDFͷΦϒδΣΫτΛ؅ཧ͢Δ
    8BUDI
    "QQMZ
    3FQMJDB4FU3FTPVSDF

    OBNFOHJOY
    3FQMJDB4FU

    $POUSPMMFS
    

    View Slide

18. 
    ͓͞Β͍
    ,VCFSOFUFTͷಛ௃ͱಈ࡞
    ಛ௃$POUSPMMFSʹΑΔ3FDPODJMJBUJPOMPPQ ௐ੔ϧʔϓ
    
    ‣ ,VCFSOFUFT͸ෳ਺ͷಠཱͨ͠$POUSPMMFSͷू߹ମ
    ‣ ֤$POUSPMMFS͕୲౰͢Δ3FTPVSDFͷΦϒδΣΫτΛl๬·͍͠ঢ়ଶ EFTJSFETUBUF
    zʹҡ࣋͢Δ
    3FQMJDB4FU$POUSPMMFS
    0CTFSWF
    "OBMZ[F
    l3FQMJDB4FU9z͕ߋ৽͞Εͨ
    %FTJSFETUBUFSFQMJDBT

    $VSSFOUTUBUFSFQMJDBT
    kubectl apply -f replicaset.yaml
    "DU
    $SFBUFOFX1PE

    $VSSFOUTUBUFSFQMJDBT
    3FQMJDB4FU9
    VQEBUFE
    6QEBUF

    DVSSFOUTUBUF
    $SFBUF
    ྫ
    3FQMJDB4FU
    

    View Slide

19. 
    ,VCFSOFUFT0QFSBUPSͷߏ੒
    Ϣʔβ͸,VCFSOFUFTΛಠࣗͷ3FTPVSDFͱ$POUSPMMFSͰ֦ுͰ͖Δ
    ‣ 0QFSBUPS͸͜ͷ࢓૊ΈΛ׆༻
    $VTUPN3FTPVSDF
    ‣ ϢʔβʹΑͬͯಠࣗʹఆٛ͞Εͨ3FTPVSDF
    ‣ ྫԿͷσʔλϕʔεγεςϜΛɺԿ୆Ͱߏ੒͢Δ͔Λఆٛ
    ‣ $VTUPN3FTPVSDF%FpOJUJPOT $3%
    ʹΑͬͯLT"1*Λ֦ு͢Δͱѻ͑ΔΑ͏ʹͳΔ
    $VTUPN$POUSPMMFS
    ‣ ϢʔβʹΑͬͯಠࣗʹఆٛ͞Εͨ$POUSPMMFS
    ‣ $VTUPN3FTPVSDFͷΦϒδΣΫτΛlEFTJSFETUBUFlʹҡ࣋͢Δ
    ‣ ྫ৽͍͠1PEΛΫϥελʹ૊ΈࠐΉॲཧΛߦ͏
    ‣ ྫ1PEͷεςʔλεΛऔಘ͠ɺඞཁʹԠͯ͡෮چखॱΛ࣮ࢪ͢Δ
    

    View Slide

20. 
    ,VCFSOFUFT0QFSBUPSͷಈ࡞
    $VTUPN$POUSPMMFS
    0CTFSWF
    "OBMZ[F
    l%BUBCBTF9z͕ߋ৽͞Εͨ
    %FTJSFETUBUFWFSTJPOW

    $VSSFOUTUBUFWFSTJPOW
    kubectl apply -f database.yaml
    "DU
    3PMMJOH6QEBUF

    $VSSFOUTUBUFWFSTJPOW
    %BUBCBTF9
    VQEBUFE
    6QEBUF

    DVSSFOUTUBUF 6QEBUF
    $VTUPN3FTPVSDFʹج͖ͮ$VTUPN$POUSPMMFS͕ඞཁͳଞͷ3FTPVSDFΛૢ࡞͢Δ
    ྫ
    σʔλϕʔεΛ

    ɹ؅ཧ͢Δ0QFSBUPSͷྫ
    

    View Slide

21. 
    5PEBZ`T"HFOEB
    
    
    
    ίϯςφͰεςʔτϑϧͳΞϓϦέʔγϣϯΛಈ͔͢
    ߟྀ͢΂͖ϙΠϯτͱ,VCFSOFUFT্Ͱͷղܾํ๏ʹ͍ͭͯ஌Δ
    ,VCFSOFUFT0QFSBUPSͱ͸
    $VTUPN3FTPVSDFΛ׆༻ͨ͠ӡ༻ࣗಈԽͷύλʔϯʹ͍ͭͯ஌Δ
    ࣮ྫ.Z42-0QFSBUPSΛಈ͔ͯ͠ΈΑ͏
    0QFSBUPSͷ࢖༻ײ͸ʁ࣮ࡍʹLT্Ͱ.Z42-Λಈ͔ͯ͠ΈΔ
    ,VCFSOFUFT0QFSBUPSͷ͜Ε͔Β
    ؔ࿈ϓϩδΣΫτͷ঺հͱ0QFSBUPSͷࠓޙʹ͍ͭͯ
    

    View Slide

22. 
    PSBDMFNZTRMPQFSBUPS
    .Z42-*OOP%#$MVTUFSΛ,VCFSOFUFT্Ͱಈ࡞ͤ͞ΔͨΊͷ0QFSBUPS
    ‣ 0SBDMFͷ044ϓϩδΣΫτ
    ‣ ݱࡏW
    ‣ .Z42-WdΛαϙʔτ
    ‣ ίϚϯυͭͰՄ༻ੑͷߴ͍.Z42-ΫϥελΛ,VCFSOFUFT্ʹσϓϩΠ
    ‣ ߏங΍ӡ༻ʹඞཁͳφϨοδ͕ιϑτ΢ΣΞͱ࣮ͯ͠૷͞Ε͍ͯΔ
    ‣ Ϋϥελͷ࡞੒ɾ࡟আ
    ‣ ΫϥελͷϦαΠζ
    ‣ ো֐ͷݕ஌ͱ෮چ
    ‣ όοΫΞοϓͱϦετΞ
    IUUQTHJUIVCDPNPSBDMFNZTRMPQFSBUPS
    

    View Slide

23. 
    ࢀߟ
    .Z42-*OOP%#$MVTUFS
    .Z42-޲͚ͷߴՄ༻ੑιϦϡʔγϣϯ
    .Z42-(SPVQ3FQMJDBUJPO
    ෳ਺ͷ.BTUFSؒͰϨϓϦέʔγϣϯΛߏ੒

    ϝϯόγοϓ؅ཧɾϑΣΠϧΦʔόʔɾ੔߹ੑҡ࣋Λࣗಈతʹߦ͏
    ‣ 4JOHMF1SJNBSZ EFGBVMU
    

    ࣗಈͰબ͹Εͨ୆ͷαʔό͕ߋ৽Λड͚෇͚Δ

    1SJNBSZͷো֐࣌͸4FDPOEBSZ͕ࣗಈతͰ1SJNBSZʹঢ֨
    ‣ .VMUJ1SJNBSZ

    શαʔόͰߋ৽Λड͚෇͚Δ
    .Z42-3PVUFS
    ΞϓϦέʔγϣϯ͔Βͷ3FBE8SJUFτϥϑΟοΫΛ

    ద੾ͳόοΫΤϯυͷ.Z42-αʔό΁ϧʔςΟϯά
    IUUQTEFWNZTRMDPNEPDSFGNBOFONZTRMJOOPECDMVTUFSJOUSPEVDUJPOIUNM
    

    View Slide

24. 
    .Z42-*OOP%#$MVTUFSPO,VCFSOFUFT
    .Z42-0QFSBUPS
    $VTUPN$POUSPMMFS
    
    

    View Slide

25. 
    .Z42-*OOP%#$MVTUFSPO,VCFSOFUFT
    .Z42-$MVTUFS
    $VTUPN3FTPVSDF
    .Z42-0QFSBUPS
    $VTUPN$POUSPMMFS
    
    8BUDI
    

    View Slide

26. 
    .Z42-*OOP%#$MVTUFSPO,VCFSOFUFT
    NZTRMBHFOU
    NZTRM
    NZTRMBHFOU
    NZTRM
    NZTRMBHFOU
    NZTRM
    NZTRM4UBUFGVM4FU
    (SPVQ3FQMJDBUJPO
    .Z42-$MVTUFS
    $VTUPN3FTPVSDF
    .Z42-0QFSBUPS
    $VTUPN$POUSPMMFS
    
    8BUDI
    $SFBUF
    ΫϥελϝϯόΛ੍ޚ͢Δ.Z42-"HFOUͱ

    ҰॹʹσϓϩΠ͞ΕΔ
    (SPVQ3FQMJDBUJPOʹΑΔ

    ߴՄ༻ੑάϧʔϓ
    ࣗ཯తͳϝϯό؅ཧ΍

    ো֐ݕ஌ɾ෮چ͕ߦΘΕΔ
    

    View Slide

27. 
    .Z42-*OOP%#$MVTUFSPO,VCFSOFUFT
    NZTRMBHFOU
    NZTRM
    NZTRMBHFOU
    NZTRM
    NZTRMBHFOU
    NZTRM
    NZTRM4UBUFGVM4FU
    (SPVQ3FQMJDBUJPO
    .Z42-$MVTUFS
    $VTUPN3FTPVSDF
    .Z42-0QFSBUPS
    $VTUPN$POUSPMMFS
    
    NZTRMSPVUFS
    XFCBQQ
    NZTRMSPVUFS
    XFCBQQ
    8BUDI
    $SFBUF
    XFCBQQ
    4FSWJDF
    ΞϓϦέʔγϣϯ͸TJEFDBSͷ.Z42-3PVUFSʹ઀ଓ
    (SPVQ3FQMJDBUJPOʹΑΔ

    ߴՄ༻ੑάϧʔϓ
    ࣗ཯తͳϝϯό؅ཧ΍

    ো֐ݕ஌ɾ෮چ͕ߦΘΕΔ
    8SJUF
    3FBE
    ΫϥελϝϯόΛ੍ޚ͢Δ.Z42-"HFOUͱ

    ҰॹʹσϓϩΠ͞ΕΔ
    

    View Slide

28. 
    NZTRMPQFSBUPSͷΠϯετʔϧ
    # ωʔϜεϖʔεΛ࡞੒
    $ kubectl create ns mysql-operator
    # mysql-operator ϦϙδτϦΛऔಘ (helm chart ؚ͕·ΕΔ)
    $ git clone https://github.com/oracle/mysql-operator.git
    $ cd mysql-operator
    # mysql-operator Λ helm ͰΠϯετʔϧ
    $ helm install --namespace mysql-operator \
    --name mysql-operator \
    mysql-operator
    $ kubectl get crd --selector=release=mysql-operator
    NAME AGE
    mysqlbackups.mysql.oracle.com 18d
    mysqlbackupschedules.mysql.oracle.com 18d
    mysqlclusters.mysql.oracle.com 18d
    mysqlrestores.mysql.oracle.com 18d
    $ kubectl get pods --selector=app=mysql-operator
    NAME READY STATUS RESTARTS AGE
    mysql-operator-65475db5-tdchf 1/1 Running 0 9d
    $3%ͱ$VTUPN$POUSPMMFS͕
    Πϯετʔϧ͞Εɺ

    $VTUPN3FTPVSDF͕ར༻

    ՄೳʹͳΔ
    

    View Slide

29. 
    .Z42-Ϋϥελͷ࡞੒
    $ kubectl get mysqlcluster,sts,pods
    NAME AGE
    cluster.mysql.oracle.com/mysql 4m
    NAME DESIRED CURRENT AGE
    statefulset.apps/mysql 3 3 4m
    NAME READY STATUS RESTARTS AGE
    pod/mysql-0 2/2 Running 0 4m
    pod/mysql-1 2/2 Running 0 3m
    pod/mysql-2 2/2 Running 0 2m
    apiVersion: mysql.oracle.com/v1alpha1
    kind: Cluster
    metadata:
    name: mysql
    spec:
    members: 3
    DMVTUFSZBNM
    $MVTUFS

    lNZTRMz
    4UBUFGVM4FU

    lNZTRMz
    LVCFDUMBQQMZ
    .Z42-
    0QFSBUPS
    

    View Slide

30. 
    .Z42-Ϋϥελͷεέʔϧ
    $ kubectl get sts,pods
    NAME DESIRED CURRENT AGE
    statefulset.apps/mysql 5 5 8m
    NAME READY STATUS RESTARTS AGE
    pod/mysql-0 2/2 Running 0 8m
    pod/mysql-1 2/2 Running 0 8m
    pod/mysql-2 2/2 Running 0 7m
    pod/mysql-3 2/2 Running 0 1m
    pod/mysql-4 2/2 Running 0 50s
    apiVersion: mysql.oracle.com/v1alpha1
    kind: Cluster
    metadata:
    name: mysql
    spec:
    members: 5ϝϯό਺Λมߋ ˠ
    
    DMVTUFSZBNM
    $MVTUFS

    lNZTRMz
    4UBUFGVM4FU

    lNZTRMz
    LVCFDUMBQQMZ
    .Z42-
    0QFSBUPS
    

    View Slide

31. 
    όοΫΞοϓͱϦετΞ
    apiVersion: mysql.oracle.com/v1alpha1
    kind: Backup
    metadata:
    name: mysql-cluster-backup
    spec:
    executor:
    mysqldump:
    databases:
    - name: employees
    storageProvider:
    s3:
    endpoint: s3.ap-northeast-1.amazonaws.com
    region: ap-northeast-1
    bucket: mysql-operator-test
    forcePathStyle: true
    credentialsSecret:
    name: s3-credentials
    cluster:
    name: mysql
    CBDLVQZBNM
    #BDLVQϦιʔεఆٛ͠BQQMZ͢Δ
    ‣ 4ޓ׵"1*͕࢖༻Մೳ
    "844 0$*0CKFDU4UPSBHF ($1($4
    ‣ NZTRMEVNQΛαϙʔτ
    ‣ #BDLVQ4DIFEVMFϦιʔεͰఆظ࣮ߦ΋Մೳ
    $ kubectl get mysqlbackup
    NAME AGE
    mysql-cluster-backup 13m
    

    View Slide

32. 
    όοΫΞοϓͱϦετΞ
    3FTUPSFϦιʔεఆٛ͠BQQMZ͢Δ
    ‣ ࢖༻͢Δ#BDLVQͱ

    ϦετΞઌͷ$MVTUFSΛࢦఆ
    apiVersion: mysql.oracle.com/v1alpha1
    kind: Restore
    metadata:
    name: mysql-cluster-restore
    spec:
    cluster:
    name: mysql-restore
    backup:
    name: mysql-cluster-backup
    SFTUPSFZBNM
    mysql> show databases;
    +-------------------------------+
    | Database |
    +-------------------------------+
    | information_schema |
    | mysql |
    | mysql_innodb_cluster_metadata |
    | performance_schema |
    | sys |
    +-------------------------------+
    5 rows in set (0.01 sec)
    mysql> show databases;
    +-------------------------------+
    | Database |
    +-------------------------------+
    | employees |
    | information_schema |
    | mysql |
    | mysql_innodb_cluster_metadata |
    | performance_schema |
    | sys |
    +-------------------------------+
    6 rows in set (0.00 sec)
    3FTUPSFલ 3FTUPSFޙ
    

    View Slide

33. 4JOHMF.BTUFSߏ੒Ͱ1SJNBSZͷ1PE͕མͪͨ৔߹
    .Z42-*OOP%#$MVTUFSͷಈ࡞
    
    ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ
    4UBUFGVM4FU
    %FTJSFETUBUFSFQMJDBT
    $VSSFOUTUBUFSFQMJDBT
    
    NZTRM
    SPMFQSJNBSZ
    NZTRM
    SPMFTFDPOEBSZ
    NZTRM
    SPMFTFDPOEBSZ
    

    View Slide

34. 4JOHMF.BTUFSߏ੒Ͱ1SJNBSZͷ1PE͕མͪͨ৔߹
    .Z42-*OOP%#$MVTUFSͷಈ࡞
    
    ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ
    
    4UBUFGVM4FU
    %FTJSFETUBUFSFQMJDBT
    $VSSFOUTUBUFSFQMJDBT
    NZTRM
    SPMFTFDPOEBSZ
    NZTRM
    SPMFQSJNBSZ
    (SPVQ3FQMJDBUJPOͷϝϯό͔Β

    আ֎͞ΕΔ
    NZTRM
    SPMFTFDPOEBSZ
    

    View Slide

35. 
    ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ
    4JOHMF.BTUFSߏ੒Ͱ1SJNBSZͷ1PE͕མͪͨ৔߹
    .Z42-*OOP%#$MVTUFSͷಈ࡞
    
    4UBUFGVM4FU
    %FTJSFETUBUFSFQMJDBT
    $VSSFOUTUBUFSFQMJDBT
    NZTRM
    SPMFTFDPOEBSZ

    QSJNBSZ
    NZTRM
    SPMFQSJNBSZ
    (SPVQ3FQMJDBUJPOͷϝϯό͔Β

    আ֎͞ΕΔ
    NZTRM
    SPMFTFDPOEBSZ
    4FDPOEBSZ͕1SJNBSZʹঢ֨
    

    View Slide

36. 4JOHMF.BTUFSߏ੒Ͱ1SJNBSZͷ1PE͕མͪͨ৔߹
    ͦͷޙʜ
    
    ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ
    
    4UBUFGVM4FU
    %FTJSFETUBUFSFQMJDBT
    $VSSFOUTUBUFSFQMJDBT
    NZTRM
    SPMFTFDPOEBSZ
    NZTRM
    ϦΧόϦॲཧ͕૸Γఀࢭதͷ

    σʔλͷࠩ෼Λಉظ
    ,VCFSOFUFTʹΑΓ1PE͕

    ্ཱͪ͛ΒΕΔ
    NZTRM
    SPMFQSJNBSZ
    Binary Log
    

    View Slide

37. 4JOHMF.BTUFSߏ੒Ͱ1SJNBSZͷ1PE͕མͪͨ৔߹
    ͦͷޙʜ
    
    ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ
    
    4UBUFGVM4FU
    %FTJSFETUBUFSFQMJDBT
    $VSSFOUTUBUFSFQMJDBT
    NZTRM
    SPMFTFDPOEBSZ
    NZTRM
    SPMFTFDPOEBSZ
    4FDPOEBSZͱͯ͠Ϋϥελʹ

    ࠶ࢀՃ
    NZTRM
    SPMFQSJNBSZ
    

    View Slide

38. 
    ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ
    LTOPEF͕མͪͨ৔߹1PEͷεςʔλε͸6OLOPXOʹͳΔ
    4UBUFGVM4FUͷ1PE͸ࣗಈͰ࠶εέδϡʔϦϯά͞Εͳ͍
    ‣ ಛఆͷ໊લͷ1PE͕Ϋϥελ಺ʹ࠷େͰͭଘࡏ͢Δ͜ͱΛอূ͢Δ
    ‣ TQSJUCSBJOʹΑΔো֐Λ๷͙ͨΊ࠶࡞੒͸ߦΘΕͳ͍
    % kubernetes get node k8s-node02
    NAME STATUS ROLES AGE VERSION
    k8s-node02 NotReady 8d v1.12.7
    % kubectl get pods -l v1alpha1.mysql.oracle.com/cluster=mysql -o wide
    NAME READY STATUS RESTARTS AGE NODE
    mysql-0 2/2 Running 0 3d k8s-node01
    mysql-1 2/2 Unknown 0 3d k8s-node02
    1PE4UBUVT͕6OLOPXOͷ৔߹ɺ

    ίϯςφࣗମ͸·ͩಈ͍͍ͯΔՄೳੑ͕͋Δ
    mysql> SELECT MEMBER_HOST, MEMBER_STATE, MEMBER_ROLE FROM
    performance_schema.replication_group_members ORDER BY
    MEMBER_HOST;
    +---------------+--------------+-------------+
    | MEMBER_HOST | MEMBER_STATE | MEMBER_ROLE |
    +---------------+--------------+-------------+
    | mysql-0.mysql | ONLINE | SECONDARY |
    | mysql-1.mysql | ONLINE | SECONDARY |
    | mysql-2.mysql | ONLINE | SECONDARY |
    (SPVQ3FQMJDBUJPOͷϝϯόҰཡʹ͸

    ର৅ͷ1PE͕·ؚͩ·Ε͍ͯΔʂ
    

    View Slide

39. 
    ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ
    LTOPEF͕མͪͨ৔߹1PEͷεςʔλε͸6OLOPXOʹͳΔ
    ࠶εέδϡʔϦϯά͢Δʹ͸
    ‣ ݱঢ়ͩͱ1PEΛڧ੍࡟আ͢Δ͔͠ͳͦ͞͏ʜʁ
    $ kubectl delete pod —force —grace-period=0
    ঢ়ଶ֬ೝˠ੾Γ཭͠ˠ෮چͷखॱ΋0QFSBUPSʹ೚͍ͤͨʜʂ
    ‣ ݱࡏ
    ࣮૷͸͞Ε͍ͯͳ͍
    1PEͷ࠶εέδϡʔϦϯά

    GPSDFEFMFUF
    
    (SPVQ3FQMJDBUJPO͔Β

    ੾Γ཭͞ΕͯΔ͜ͱΛ֬ೝ
    1PEͷεςʔλεΛ֬ೝ
    

    View Slide

40. 
    ϞχλϦϯά
    .Z42-0QFSBUPSͷίϯϙʔωϯτ΋1SPNFUIFVTΤϯυϙΠϯτΛ͍࣋ͬͯΔ
    ‣ Ϋϥελͷߏ੒มߋʹؔ͢ΔϝτϦΫε͕ऩूՄೳ
    *OOP%#$MVTUFS
    .Z42-0QFSBUPS

    $POUSPMMFS
    
    &YQPSUFS
    NZTRMBHFOU
    NZTRM
    .POJUPSJOH
    "HFOU
    

    View Slide

41. 
    ίϯςφͰεςʔτϑϧͳΞϓϦΛಈ্͔͢ͰͷͭͷϙΠϯτ
    ΞϓϦέʔγϣϯݻ༗ͷ

    ӡ༻φϨοδ
    Ӭଓతͳσʔλͷѻ͍
    ,VCFSOFUFT
    0QFSBUPS
    4UBUFGVM4FU
    ,VCFSOFUFTͷඪ४ػೳ
    ඪ४ػೳ͕αϙʔτ͠ͳ͍ྖҬ
    εςʔτϑϧͳϫʔΫϩʔυ΋,VCFSOFUFTͷίϯηϓτΛར༻ͯ͠
    ࣗ཯ಈ࡞ͤ͞Δ͜ͱ͕ՄೳʹͳΔ
    

    View Slide

42. 
    5PEBZ`T"HFOEB
    
    
    
    ίϯςφͰεςʔτϑϧͳΞϓϦέʔγϣϯΛಈ͔͢
    ,VCFSOFUFT0QFSBUPSͱ͸
    ࣮ྫ.Z42-0QFSBUPSΛಈ͔ͯ͠ΈΑ͏
    ,VCFSOFUFT0QFSBUPSͷ͜Ε͔Β
    ߟྀ͢΂͖ϙΠϯτͱ,VCFSOFUFT্Ͱͷղܾํ๏ʹ͍ͭͯ஌Δ
    $VTUPN3FTPVSDFΛ׆༻ͨ͠ӡ༻ࣗಈԽͷύλʔϯʹ͍ͭͯ஌Δ
    0QFSBUPSͷ࢖༻ײ͸ʁ࣮ࡍʹLT্Ͱ.Z42-Λಈ͔ͯ͠ΈΔ
    ؔ࿈ϓϩδΣΫτͷ঺հͱ0QFSBUPSͷࠓޙʹ͍ͭͯ
    

    View Slide

43. 
    %#PO,VCFSOFUFTؔ࿈ϓϩδΣΫτ
    IUUQTHJUIVCDPNQSFTTMBCTNZTRMPQFSBUPS
    QSFTTMBCTNZTRMPQFSBUPS
    ‣ .BTUFS4MBWFߏ੒ͷ.Z42-Λαϙʔτ
    ‣ ো֐ݕ஌ͱϑΣΠϧΦʔόʔ͸
    PSDIFTUSBUPSΛ࢖༻
    IUUQTWJUFTTJP
    7JUFTT
    ‣ େن໛ͳ.Z42-ΫϥελΛσϓϩΠ͠

    ؅ཧ͢ΔͨΊͷιϦϡʔγϣϯ
    ‣ γϟʔσΟϯάػߏΛ಺ଂ
    ‣ ϑΣΠϧΦʔόʔ΍όοΫΞοϓͷࣗಈԽ
    .Z42-ʹؔ࿈ͨ͠ϓϩδΣΫτ
    0QFSBUPS͕ଘࡏ͢Δσʔλϕʔε
    "FSPTQJLF
    $BTTBOESB
    $PVDICBTF
    &MBTUJDTFBSDI
    FUDE
    *OqVY%#
    .FNDBDIFE
    .POHP%#
    1PTUHSF42-
    3FEJT
    5J%#
    ʜͳͲ
    

    View Slide

44. 
    ,VCFSOFUFT0QFSBUPSͷ͜Ε͔Β
    %#Ҏ֎΋ؚΊɺ༷ʑͳ0QFSBUPS͕ެ։͞Ε͍ͯΔ
    PQFSBUPSGSBNFXPSLBXFTPNFPQFSBUPST
    ‣ ެ։͞Ε͍ͯΔ0QFSBUPSΛΞϓϦ͝ͱʹ

    ·ͱΊͨϦετ
    0QFSBUPS)VCJP
    ‣ 0QFSBUPSͷҰཡΛఏڙ͢ΔϙʔλϧαΠτ
    ‣ "84 (PPHMF$MPVE .JDSPTPGU"[VSFͱڞಉͰ

    3FE)BUʹΑΓެ։
    ӡ༻λεΫΛ0QFSBUPSͱͯ͠ύοέʔδԽ͠

    ϢʔβؒͰڞ༗͢Δ͜ͱ͕Ͱ͖Δ
    

    View Slide

45. 
    ,VCFSOFUFT0QFSBUPSͰ/P0QTΛ࣮ݱʁ
    /P0QT/P6ODPNGPSUBCMF0QT
    ‣ γεςϜӡ༻อकʹؔ͢Δʮخ͘͠ͳ͍΋ͷʯΛऔΓআ͘׆ಈ
    ‣ औΓ૊ΈͷͭγεςϜʹࣗ཯ӡ༻ೳྗΛ࣋ͨͤਓؒʹΑΔӡ༻Λ࠷খԽ͢Δ
    ࣗ཯ӡ༻ʹඞཁͳlճ෮ྗ
    4FMG)FBMJOH

    ো֐ൃੜ࣌ͷʮαʔϏεແӨڹࣗݾम෮ʯ
    *OqJHIUSFOFXJOH

    มߋɾߋ৽ʹର͢Δʮແఀࢭϝϯςφϯεʯ
    "EBQUJWF4DBMF

    ෛՙมಈʹ஄ྗతʹదԠ͢Δʮࣗ཯తϦιʔεௐ੔ʯ
    IUUQTHJUIVCDPNOPPQTKBQBODPNNVOJUZCMPCNBTUFS%&'*/*5*0/NE
    4FMG)FBMJOH
    㾎 %FDMBSBUJWF$POpHVSBUJPO
    㾎 -JWFOFTT3FBEJOFTT1SPCF
    *OqJHIUSFOFXJOH
    㾎 3PMMJOH6QEBUF
    "EBQUJWF4DBMF
    㾎 )PSJ[POUBM1PE"VUPTDBMFS
    㾎 $MVTUFS"VUPTDBMFS
    ,VCFSOFUFTͷ࣋ͭճ෮ྗ
    /P0QT%FpOJUJPOW
    

    View Slide

46. 
    ,VCFSOFUFT0QFSBUPSͰ/P0QTΛ࣮ݱʁ
    1MBUGPSN
    "QQMJDBUJPO
    ,VCFSOFUFT0QFSBUPS
    ,VCFSOFUFTͷίϯηϓτͱ֦ுੑΛ׆༻͠
    γεςϜશମͷճ෮ྗΛߋʹߴ͍΋ͷʹͰ͖Δ
    8FC4FSWFS %BUBCBTF .FTTBHF2VFVF
    $BDIF
    ΞϓϦΛؚΊͨγεςϜશମͰճ෮ྗΛ࣋ͭ͜ͱ͕ॏཁ
    ‣ ো֐͔Βͷ෮چ͕࣌ؒ௕͍
    ‣ ෮چͷͨΊͷखॱ͕ෳࡶ
    ‎ ճ෮ྗͷ௿Լʹ

    ͭͳ͕ͬͯ͠·͏
    

    View Slide

47. ͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ
    130#-&.
    EBUBCBTF%08/
    ࠓ೔ϦϦʔεͨ͠ࢪࡦͰ

    ϦΫΤετ૿͑ΔΒ͍͠ʜ

    %#΋૿΍͞ͳ͍ͱʜʂ
    ։ൃ؀ڥʹσʔλϕʔε

    ͙͢ʹ༻ҙͯ͠΄͍͠ͳ
    
    

    View Slide

48. ͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ
    ಥൃతͳ࡞ۀͷෛՙ͕Լ͕Δ
    ਓखʹΑΔΦϖϛε΋ݮΔ
    130#-&.
    EBUBCBTF%08/
    ࠓ೔ϦϦʔεͨ͠ࢪࡦͰ

    ϦΫΤετ૿͑ΔΒ͍͠ʜ

    %#΋૿΍͞ͳ͍ͱʜʂ
    ։ൃ؀ڥʹσʔλϕʔε

    ͙͢ʹ༻ҙͯ͠΄͍͠ͳ
    LVCFDUMBQQMZGDMVTUFSZBNM
    
    

    View Slide

49. ͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ
    ಥൃతͳ࡞ۀͷෛՙ͕Լ͕Δ
    ਓखʹΑΔΦϖϛε΋ݮΔ
    Ϗδωεͷεϐʔυ͕Ճ଎͢Δ
    ਫ਼ਆతෛ୲͕Լ͕Δ
    130#-&.
    EBUBCBTF%08/
    ࠓ೔ϦϦʔεͨ͠ࢪࡦͰ

    ϦΫΤετ૿͑ΔΒ͍͠ʜ

    %#΋૿΍͞ͳ͍ͱʜʂ
    LVCFDUMBQQMZGDMVTUFSZBNM
    ։ൃ؀ڥʹσʔλϕʔε

    ͙͢ʹ༻ҙͯ͠΄͍͠ͳ
    LVCFDUMBQQMZGDMVTUFSZBNM
    
    

    View Slide

50. ͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ
    ෮چͷख͕ؒ࠷খԽ͞ΕΔ
    ۓٸରԠ΋ݮΔ
    ಥൃతͳ࡞ۀͷෛՙ͕Լ͕Δ
    ਓखʹΑΔΦϖϛε΋ݮΔ
    Ϗδωεͷεϐʔυ͕Ճ଎͢Δ
    ਫ਼ਆతෛ୲͕Լ͕Δ
    130#-&.
    EBUBCBTF%08/
    㵺Т㵺
    ţźōʜ
    ࠓ೔ϦϦʔεͨ͠ࢪࡦͰ

    ϦΫΤετ૿͑ΔΒ͍͠ʜ

    %#΋૿΍͞ͳ͍ͱʜʂ
    LVCFDUMBQQMZGDMVTUFSZBNM
    ։ൃ؀ڥʹσʔλϕʔε

    ͙͢ʹ༻ҙͯ͠΄͍͠ͳ
    LVCFDUMBQQMZGDMVTUFSZBNM
    
    

    View Slide

51. 
    ͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ
    ͨͩ͠ɺ஫ҙ͠ͳ͚Ε͹ͳΒͳ͍͜ͱ
    ‣ γεςϜઃܭ΍νϡʔχϯά·Ͱ΋͕ࣗಈԽ
    ͞ΕΔΘ͚Ͱ͸ͳ͍
    ‣ ࣗಈԽ͞ΕͨγεςϜ͸ϒϥοΫϘοΫεʹ
    ͳΓ͕ͪ
    ਓؒͷӡ༻ऀ͕θϩʹͳΔΘ͚Ͱ͸ͳ͍ʂ
    ‣ ໰୊ൃݟղܾͷख͕͔ΓΛ࢒͓ͯ͜͠͏
    ‣ ϞχλϦϯάɾϩΪϯάͷ࢓૊Έ͕ඞਢ
    ‣ ࣗಈԽ͕ࣦഊͨ͠৔߹ͷखஈΛ༻ҙ͓ͯ͘͠
    ‣ ࠷ޙͷखஈʜਓख
    ো֐ൃੜ࣌ͷඋ͑͸ඞ͓ͣͯ͘͠ʂ
    

    View Slide

52. 
    ͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ
    "ϚωʔδυαʔϏεΛ࢖͍·͠ΐ͏ʂ
    ࢖͍͍ͨ%#ͷϚωʔδυαʔϏε͕ఏڙ͞Ε͍ͯΔ͚ΕͲɺ
    ,VCFSOFUFT0QFSBUPSΛ࢖ͬͯࣗ෼Ͱӡ༻ͨ͠΄͏͕ྑ͔ͬͨΓ͢Δʁ
    ‣ ಈ࡞ͤ͞ΔΞϓϦέʔγϣϯʹ͍ͭͯͷ

    ઐ໳஌ࣝ͸ඞཁ
    ‣ ,VCFSOFUFTࣗମͷӡ༻΋೉͍͠
    εςʔτϑϧͳϫʔΫϩʔυΛಈ͔͢࢓૊Έ͸

    ੔͖͍ͬͯͯΔ͕ʜ
    ‣ 1BB4΍4FSWFSMFTTͷબ୒΋ݕ౼͠Α͏
    ‣ ϓϥοτϑΥʔϜͱͯ͠ճ෮ੑ͕୲อ

    ͞Ε͍ͯΔ
    ແཧʹ,VCFSOFUFTͰಈ͔ͦ͏ͱ͠ͳ͍
    LTΫϥελ্ͷσʔλϕʔεͰ͸ͳ͘ɺΫϥ΢υ্ͷϚωʔδυαʔϏεΛ
    ૢ࡞͢Δ0QFSBUPS΋͋Γ·͢ "844FSWJDF0QFSBUPSͳͲ
    ɻ
    ผ్*B$πʔϧͳͲͰߦ͍ͬͯͨΠϯϑϥ؀ڥͷߏஙΛ0QFSBUPSʹ೚ͤ

    ΞϓϦͱҰॹʹ3FTPVSDFఆٛΛHJU؅ཧࣗ཯ӡ༻ɺͱ͍͏͜ͱ΋Ͱ͖ͦ͏Ͱ͢ɻ
    ิ଍
    

    View Slide

53. 
    ·ͱΊ
    ,VCFSOFUFT0QFSBUPS
    ‣ ,VCFSOFUFTͷ࢓૊ΈΛԠ༻ͨ͠ӡ༻ࣗಈԽͷύλʔϯ
    ‣ $VTUPN3FTPVSDF$VTUPN$POUSPMMFS
    ‣ ΞϓϦέʔγϣϯݻ༗ͷӡ༻࡞ۀΛਓʹ୅ΘͬͯࣗಈԽ
    .Z42-0QFSBUPS
    ‣ ,VCFSOFUFT্ʹ.Z42-*OOP%#$MVTUFSΛߏங
    ‣ એݴతͳઃఆʹج͖֤ͮछӡ༻࡞ۀΛࣗಈԽ
    ‣ Ϋϥελߏங εέʔϧ όοΫΞοϓϦετΞ ো֐ݕ஌ͱϑΣΠϧΦʔόʔ
    

    View Slide

54. 0QFSBUPSͰεςʔτϑϧͳϫʔΫϩʔυ΋,VCFSOFUFTͷࢥ૝Ͱࣗ཯ಈ࡞͕Մೳ
    ‣ γεςϜશମͷճ෮ྗΛΑΓߴΊΔ
    ‣ σʔλʔϕʔε΋ӡ༻ͷ࠷খԽΛਤΔ͜ͱ͕Ͱ͖ͦ͏ʂ
    
    ·ͱΊ
    "QQ
    "QQ
    "NFCBϓϩϑΟʔϧγεςϜͰͷ

    ಋೖ͕Մೳ͔ݕূ༧ఆ
    ‣ ࢒Δ՝୊CJOMPHϩετ࣌ͷ෮چํ๏

    ,VCFSOFUFT0QFSBUPSͷ؀ڥԼͰͷ

    ෮چखॱΛͲͷΑ͏ʹ͢Δ͔
    ஌ݟ͕ͨ·ͬͨΒ

    ·ͨผͷػձͰڞ༗͠·͢ωʂ
    .Z42-0QFSBUPS
    

    View Slide