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

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

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

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

"NFCBͷΦϯϓϨ,VCFSOFUFTΫϥελ "NFCBϢʔβͷϓϩϑΟʔϧγεςϜ  ࡮৽ϓϩδΣΫτ ‣ ೥຤ ‣ ྺ࢙తܦҢͰ෼அ͞Ε͍ͯͨͭͷγεςϜΛ  ౷߹͠ϦχϡʔΞϧʂ ʮϦχϡʔΞϧΛظʹ%PDLFSԽʂʯ
ʮίϯςφΦʔέετϨʔγϣϯʹ͸  ɹ,VCFSOFUFTΛ࢖͏ͧʂʂʯ ϓϥΠϕʔτΫϥ΢υ্ʹ  ,VCFSOFUFTΫϥελ͕ര஀

"NFCBͷΦϯϓϨ,VCFSOFUFTΫϥελ 0QFO4UBDL্ʹߏங ‣ σϓϩΠ͸,VCFTQSBZͰ .Z42-σʔλϕʔε ‣ LTΫϥελͷ֎ʹ7.Ͱߏங ‣ .BTUFS4MBWF 
  .)"GPS.Z42- 7. 7. 7. 7. .BTUFS 7. 4MBWF ˞Πϯλʔωοτ޿ࠂࣄۀ෦ͷ,VCFSOFUFT ",& ͱ͸ผͷ؀ڥͰ͢ ࠓͳΒ%#Λ,VCFSOFUFTʹ  ͷͤΔ͜ͱ΋Ͱ͖Δʁ ͲΜͳํ๏͕͋ΔͩΖ͏ʁʁ

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

ίϯςφͰεςʔτϑϧͳΞϓϦΛಈ্͔͢ͰͷͭͷϙΠϯτ ΞϓϦέʔγϣϯݻ༗ͷ  ӡ༻φϨοδ Ӭଓతͳσʔλͷѻ͍

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

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

εςʔτϑϧͳΞϓϦέʔγϣϯͷ৔߹ σʔλϕʔε΍෼ࢄγεςϜʜΞϓϦέʔγϣϯ͸ঢ়ଶΛ࣋ͭ ࠶ىಈ΍ผϗετͰىಈ͢Δέʔεͷߟྀ΋ඞཁ ‣ ಉ͡σʔλ͕࠶ͼར༻ՄೳͰͳ͚Ε͹ͳΒͳ͍  ྫ%#ͷ߸ػ༻1PEͰ͸ɺҎલͱಉ͡  ɹ1PE༻ͷϘϦϡʔϜΛϚ΢ϯτͯ͠΄͍͠ OPEF OPEF
OPEF ʁ SFSFTDIFEVMJOH

εςʔτϑϧͳΞϓϦέʔγϣϯͷ৔߹ σʔλϕʔε΍෼ࢄγεςϜˠΞϓϦέʔγϣϯ͸ঢ়ଶΛ࣋ͭ ݻఆͷ໊લΛ࢖͍͍ͨ ‣ ଟ਺ͷϊʔυͰߏ੒͞ΕΔγεςϜͷ৔߹  ϗετ໊*1͕มΘΔͱϝϯόͷಛఆ͕೉͘͠ͳΔ OPEF OPEF OPEF
%#$MVTUFS $POpH'JMF .FNCFST OPEFT[DQʜ/PU'PVOE OPEFUIW[ʜ/PU'PVOE ʁ OPEFIUIC OPEFQMTT

4UBUFGVM4FU εςʔτϑϧͳΞϓϦέʔγϣϯΛಈ͔ͨ͢Ίͷ,VCFSOFUFT૊ΈࠐΈͷϦιʔε ‣ 1PEͰ࢖༻͢ΔӬଓσʔλͷऔΓѻ͍ͱωʔϛϯάͷ՝୊Λղܾ NZTRM NZTRM NZTRM NZTRM
ॱ൪ʹ  σϓϩΠ ॱ൪ʹ  ऴྃ࡟আ ֤1PEʹઐ༻ͷετϨʔδϘϦϡʔϜΛ  ׂΓ౰ͯΔ ରԠؔ܎΋ҡ࣋͞ΕΔ 1PEʹݻఆͷࣝผࢠΛׂΓ౰ͯΔ

ίϯςφͰεςʔτϑϧͳΞϓϦΛಈ্͔͢ͰͷͭͷϙΠϯτ ΞϓϦέʔγϣϯݻ༗ͷ  ӡ༻φϨοδ Ӭଓతͳσʔλͷѻ͍ ʁʁʁ 4UBUFGVM4FU ,VCFSOFUFTͷඪ४ػೳ ඪ४ػೳ͕αϙʔτ͠ͳ͍ྖҬ

εςʔτϑϧͳΞϓϦέʔγϣϯͷ৔߹ σʔλϕʔε΍෼ࢄγεςϜˠΞϓϦέʔγϣϯ͸ঢ়ଶΛ࣋ͭ ΞϓϦέʔγϣϯݻ༗ͷૢ࡞͕ඞཁ ‣ ,VCFSOFUFT্Ͱ͸ࣗ཯ಈ࡞͕લఏ ‣ ىಈޙʹԿΒ͔ͷΦϖϨʔγϣϯ͕ඞཁͳ৔߹  ࣗಈԽͰߦ͏࢓૊Έ͕΄͍͠ ‣
ྫ৽ن%#ϊʔυͷΫϥελ΁ͷKPJOૢ࡞ ‣ ྫো֐͔Βͷ෮چʹΦϖϨʔγϣϯ͕ඞཁ OPEF OPEF OPEF ʁ %#$MVTUFS +PJOJOHBOPEF Ͳ͏ରॲ͢Δʜʁ

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

͓͞Β͍ ,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

͓͞Β͍ ,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

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

,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ͷྫ

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

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

ࢀߟ .Z42-*OOP%#$MVTUFS .Z42-޲͚ͷߴՄ༻ੑιϦϡʔγϣϯ .Z42-(SPVQ3FQMJDBUJPO ෳ਺ͷ.BTUFSؒͰϨϓϦέʔγϣϯΛߏ੒  ϝϯόγοϓ؅ཧɾϑΣΠϧΦʔόʔɾ੔߹ੑҡ࣋Λࣗಈతʹߦ͏ ‣ 4JOHMF1SJNBSZ EFGBVMU
  ࣗಈͰબ͹Εͨ୆ͷαʔό͕ߋ৽Λड͚෇͚Δ  1SJNBSZͷো֐࣌͸4FDPOEBSZ͕ࣗಈతͰ1SJNBSZʹঢ֨ ‣ .VMUJ1SJNBSZ  શαʔόͰߋ৽Λड͚෇͚Δ .Z42-3PVUFS ΞϓϦέʔγϣϯ͔Βͷ3FBE8SJUFτϥϑΟοΫΛ  ద੾ͳόοΫΤϯυͷ.Z42-αʔό΁ϧʔςΟϯά IUUQTEFWNZTRMDPNEPDSFGNBOFONZTRMJOOPECDMVTUFSJOUSPEVDUJPOIUNM

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

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

.Z42-*OOP%#$MVTUFSPO,VCFSOFUFT NZTRMBHFOU NZTRM NZTRMBHFOU NZTRM NZTRMBHFOU NZTRM NZTRM4UBUFGVM4FU (SPVQ3FQMJDBUJPO
.Z42-$MVTUFS $VTUPN3FTPVSDF .Z42-0QFSBUPS $VTUPN$POUSPMMFS 8BUDI $SFBUF ΫϥελϝϯόΛ੍ޚ͢Δ.Z42-"HFOUͱ  ҰॹʹσϓϩΠ͞ΕΔ (SPVQ3FQMJDBUJPOʹΑΔ  ߴՄ༻ੑάϧʔϓ ࣗ཯తͳϝϯό؅ཧ΍  ো֐ݕ஌ɾ෮چ͕ߦΘΕΔ

.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ͱ  ҰॹʹσϓϩΠ͞ΕΔ

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͕ར༻  ՄೳʹͳΔ

.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

.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

όοΫΞοϓͱϦετΞ 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

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

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

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

4JOHMF.BTUFSߏ੒Ͱ1SJNBSZͷ1PE͕མͪͨ৔߹ ͦͷޙʜ ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ 4UBUFGVM4FU %FTJSFETUBUFSFQMJDBT $VSSFOUTUBUFSFQMJDBT NZTRM SPMFTFDPOEBSZ
NZTRM ϦΧόϦॲཧ͕૸Γఀࢭதͷ  σʔλͷࠩ෼Λಉظ ,VCFSOFUFTʹΑΓ1PE͕  ্ཱͪ͛ΒΕΔ NZTRM SPMFQSJNBSZ Binary Log

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

ো֐ൃੜ࣌͸Ͳ͏ͳΔʁ LTOPEF͕མͪͨ৔߹1PEͷεςʔλε͸6OLOPXOʹͳΔ 4UBUFGVM4FUͷ1PE͸ࣗಈͰ࠶εέδϡʔϦϯά͞Εͳ͍ ‣ ಛఆͷ໊લͷ1PE͕Ϋϥελ಺ʹ࠷େͰͭଘࡏ͢Δ͜ͱΛอূ͢Δ ‣ TQSJUCSBJOʹΑΔো֐Λ๷͙ͨΊ࠶࡞੒͸ߦΘΕͳ͍ % kubernetes
get node k8s-node02 NAME STATUS ROLES AGE VERSION k8s-node02 NotReady <none> 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͕·ؚͩ·Ε͍ͯΔʂ

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

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

ίϯςφͰεςʔτϑϧͳΞϓϦΛಈ্͔͢ͰͷͭͷϙΠϯτ ΞϓϦέʔγϣϯݻ༗ͷ  ӡ༻φϨοδ Ӭଓతͳσʔλͷѻ͍ ,VCFSOFUFT 0QFSBUPS 4UBUFGVM4FU ,VCFSOFUFTͷඪ४ػೳ ඪ४ػೳ͕αϙʔτ͠ͳ͍ྖҬ
εςʔτϑϧͳϫʔΫϩʔυ΋,VCFSOFUFTͷίϯηϓτΛར༻ͯ͠ ࣗ཯ಈ࡞ͤ͞Δ͜ͱ͕ՄೳʹͳΔ

%#PO,VCFSOFUFTؔ࿈ϓϩδΣΫτ IUUQTHJUIVCDPNQSFTTMBCTNZTRMPQFSBUPS QSFTTMBCTNZTRMPQFSBUPS ‣ .BTUFS4MBWFߏ੒ͷ.Z42-Λαϙʔτ ‣ ো֐ݕ஌ͱϑΣΠϧΦʔόʔ͸ PSDIFTUSBUPSΛ࢖༻ IUUQTWJUFTTJP
7JUFTT ‣ େن໛ͳ.Z42-ΫϥελΛσϓϩΠ͠  ؅ཧ͢ΔͨΊͷιϦϡʔγϣϯ ‣ γϟʔσΟϯάػߏΛ಺ଂ ‣ ϑΣΠϧΦʔόʔ΍όοΫΞοϓͷࣗಈԽ .Z42-ʹؔ࿈ͨ͠ϓϩδΣΫτ 0QFSBUPS͕ଘࡏ͢Δσʔλϕʔε "FSPTQJLF $BTTBOESB $PVDICBTF &MBTUJDTFBSDI FUDE *OqVY%# .FNDBDIFE .POHP%# 1PTUHSF42- 3FEJT 5J%# ʜͳͲ

,VCFSOFUFT0QFSBUPSͷ͜Ε͔Β %#Ҏ֎΋ؚΊɺ༷ʑͳ0QFSBUPS͕ެ։͞Ε͍ͯΔ PQFSBUPSGSBNFXPSLBXFTPNFPQFSBUPST ‣ ެ։͞Ε͍ͯΔ0QFSBUPSΛΞϓϦ͝ͱʹ  ·ͱΊͨϦετ 0QFSBUPS)VCJP ‣ 0QFSBUPSͷҰཡΛఏڙ͢ΔϙʔλϧαΠτ
‣ "84 (PPHMF$MPVE .JDSPTPGU"[VSFͱڞಉͰ  3FE)BUʹΑΓެ։ ӡ༻λεΫΛ0QFSBUPSͱͯ͠ύοέʔδԽ͠  ϢʔβؒͰڞ༗͢Δ͜ͱ͕Ͱ͖Δ

,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

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

͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ <DSJUJDBM>130#-&. EBUBCBTF%08/ ࠓ೔ϦϦʔεͨ͠ࢪࡦͰ  ϦΫΤετ૿͑ΔΒ͍͠ʜ  %#΋૿΍͞ͳ͍ͱʜʂ ։ൃ؀ڥʹσʔλϕʔε  ͙͢ʹ༻ҙͯ͠΄͍͠ͳ

͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ ಥൃతͳ࡞ۀͷෛՙ͕Լ͕Δ ਓखʹΑΔΦϖϛε΋ݮΔ <DSJUJDBM>130#-&. EBUBCBTF%08/ ࠓ೔ϦϦʔεͨ͠ࢪࡦͰ  ϦΫΤετ૿͑ΔΒ͍͠ʜ  %#΋૿΍͞ͳ͍ͱʜʂ ։ൃ؀ڥʹσʔλϕʔε  ͙͢ʹ༻ҙͯ͠΄͍͠ͳ
LVCFDUMBQQMZGDMVTUFSZBNM

͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ ಥൃతͳ࡞ۀͷෛՙ͕Լ͕Δ ਓखʹΑΔΦϖϛε΋ݮΔ Ϗδωεͷεϐʔυ͕Ճ଎͢Δ ਫ਼ਆతෛ୲͕Լ͕Δ <DSJUJDBM>130#-&. EBUBCBTF%08/ ࠓ೔ϦϦʔεͨ͠ࢪࡦͰ  ϦΫΤετ૿͑ΔΒ͍͠ʜ  %#΋૿΍͞ͳ͍ͱʜʂ
LVCFDUMBQQMZGDMVTUFSZBNM ։ൃ؀ڥʹσʔλϕʔε  ͙͢ʹ༻ҙͯ͠΄͍͠ͳ LVCFDUMBQQMZGDMVTUFSZBNM

͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ ෮چͷख͕ؒ࠷খԽ͞ΕΔ ۓٸରԠ΋ݮΔ ಥൃతͳ࡞ۀͷෛՙ͕Լ͕Δ ਓखʹΑΔΦϖϛε΋ݮΔ Ϗδωεͷεϐʔυ͕Ճ଎͢Δ ਫ਼ਆతෛ୲͕Լ͕Δ <DSJUJDBM>130#-&. EBUBCBTF%08/ 㵺Т㵺
ţźōʜ ࠓ೔ϦϦʔεͨ͠ࢪࡦͰ  ϦΫΤετ૿͑ΔΒ͍͠ʜ  %#΋૿΍͞ͳ͍ͱʜʂ LVCFDUMBQQMZGDMVTUFSZBNM ։ൃ؀ڥʹσʔλϕʔε  ͙͢ʹ༻ҙͯ͠΄͍͠ͳ LVCFDUMBQQMZGDMVTUFSZBNM

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

͜Ε͔Βͷσʔλϕʔεߏஙɾӡ༻͸͜͏ͳΔ͸ͣʜ "ϚωʔδυαʔϏεΛ࢖͍·͠ΐ͏ʂ ࢖͍͍ͨ%#ͷϚωʔδυαʔϏε͕ఏڙ͞Ε͍ͯΔ͚ΕͲɺ ,VCFSOFUFT0QFSBUPSΛ࢖ͬͯࣗ෼Ͱӡ༻ͨ͠΄͏͕ྑ͔ͬͨΓ͢Δʁ ‣ ಈ࡞ͤ͞ΔΞϓϦέʔγϣϯʹ͍ͭͯͷ  ઐ໳஌ࣝ͸ඞཁ ‣ ,VCFSOFUFTࣗମͷӡ༻΋೉͍͠
εςʔτϑϧͳϫʔΫϩʔυΛಈ͔͢࢓૊Έ͸  ੔͖͍ͬͯͯΔ͕ʜ ‣ 1BB4΍4FSWFSMFTTͷબ୒΋ݕ౼͠Α͏ ‣ ϓϥοτϑΥʔϜͱͯ͠ճ෮ੑ͕୲อ  ͞Ε͍ͯΔ ແཧʹ,VCFSOFUFTͰಈ͔ͦ͏ͱ͠ͳ͍ LTΫϥελ্ͷσʔλϕʔεͰ͸ͳ͘ɺΫϥ΢υ্ͷϚωʔδυαʔϏεΛ ૢ࡞͢Δ0QFSBUPS΋͋Γ·͢ "844FSWJDF0QFSBUPSͳͲ ɻ ผ్*B$πʔϧͳͲͰߦ͍ͬͯͨΠϯϑϥ؀ڥͷߏஙΛ0QFSBUPSʹ೚ͤ  ΞϓϦͱҰॹʹ3FTPVSDFఆٛΛHJU؅ཧࣗ཯ӡ༻ɺͱ͍͏͜ͱ΋Ͱ͖ͦ͏Ͱ͢ɻ ิ଍

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

0QFSBUPSͰεςʔτϑϧͳϫʔΫϩʔυ΋,VCFSOFUFTͷࢥ૝Ͱࣗ཯ಈ࡞͕Մೳ ‣ γεςϜશମͷճ෮ྗΛΑΓߴΊΔ ‣ σʔλʔϕʔε΋ӡ༻ͷ࠷খԽΛਤΔ͜ͱ͕Ͱ͖ͦ͏ʂ ·ͱΊ "QQ "QQ "NFCBϓϩϑΟʔϧγεςϜͰͷ 
ಋೖ͕Մೳ͔ݕূ༧ఆ ‣ ࢒Δ՝୊CJOMPHϩετ࣌ͷ෮چํ๏  ,VCFSOFUFT 0QFSBUPSͷ؀ڥԼͰͷ  ෮چखॱΛͲͷΑ͏ʹ͢Δ͔ ஌ݟ͕ͨ·ͬͨΒ  ·ͨผͷػձͰڞ༗͠·͢ωʂ .Z42-0QFSBUPS

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

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

More Decks by yukirii

Other Decks in Technology

Featured

Transcript