Cloud Native RDBMS Aurora 〜進化は止まらず〜

Slide 1

Slide 1 text

$MPVE/BUJWF3%#.4 "VSPSB ʙਐԽ͸ࢭ·Βͣʙ $MBTTNFUIPE *OD"84%JW4FOJPS4PMVUJPOT"SDIJUFDU )BKJNF0HVSJ %FWFMPQFST*0 #cmdevio2017

Slide 2

Slide 2 text

໔੹ࣄ߲ ຊൃද͸2017೥7݄1೔࣌఺Ͱ  ެ։͞Ε͍ͯΔ৘ใΛݩʹ͍ͯ͠·͢  কདྷ࢓༷͕มΘΔՄೳੑ͕͋Γ·͢

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

8IPBN* େ܀फʢ!NBSPPOTUʣ ϝʔΧʔܥ4*FSʹ೥΄Ͳࡏ੶ͯ͠  ΫϥεϝιουʹδϣΠϯ ݱࡏ͸"84ͷಋೖίϯαϧςΟϯά΍  ΠϯϑϥߏஙΛߦ͍ͬͯ·͢ 

Slide 5

Slide 5 text

"HFOEB ࿩͢͜ͱɾ࿩͞ͳ͍͜ͱ "VSPSBͷಛ௃ 3%#.4Λ࠶ઃܭ͔ͨ͠Β࣮ݱͰ͖Δػೳ "VSPSB࢖͍͜ͳ͠ͷྫ ·ͱΊ

Slide 6

Slide 6 text

ࠓ೔࿩͢͜ͱɾ࿩͞ͳ͍͜ͱ

Slide 7

Slide 7 text

ࠓ೔࿩͢͜ͱɾ࿩͞ͳ͍͜ͱ ࠓ೔࿩͢͜ͱ "VSPSBͷಛ௃ "VSPSBͷΞʔΩςΫνϟ "VSPSBΛ࢖͍͜ͳ͢ํ๏

Slide 8

Slide 8 text

ࠓ೔࿩͢͜ͱɾ࿩͞ͳ͍͜ͱ ࠓ೔࿩͞ͳ͍͜ͱ Ұൠతͳ3%#.4ͷػೳ "VSPSBҎ֎ͷ3%4ͷ͜ͱ "VSPSBͷ໢ཏతͳػೳઆ໌

Slide 9

Slide 9 text

"VSPSBͷಛ௃

Slide 10

Slide 10 text

࠷ֵۙ৽తͳσʔλϕʔε͕ ͍Ζ͍Ζग़͍ͯ·͢ΑͶʂ

Slide 11

Slide 11 text

ʮϞϯΩʔϨϯνʯʢ2017೥2݄19೔ (೔) 10:10 UTCͷ൛ʣʰ΢ΟΩϖσΟΞ೔ຊޠ൛ʱɻ https://ja.wikipedia.org/wiki/ϞϯΩʔϨϯν

Slide 12

Slide 12 text

European Southern ObservatoryʢESOʣ / Creative Commons Attribution 4.0 International https://upload.wikimedia.org/wikipedia/commons/3/38/Artist%27s_rendering_ULAS_J1120%2B0641.jpg

Slide 13

Slide 13 text

Ͱ΋ɺ΍ͬͺΓ

Slide 14

Slide 14 text

Creative Commons Attribution-Share Alike 3.0 Unported https://upload.wikimedia.org/wikipedia/commons/b/b0/Aurora_Borealis_NO.JPG

Slide 15

Slide 15 text

Auroraͷ࿩Ͱ͢

Slide 16

Slide 16 text

"NB[PO"VSPSB SF*OWFOUͰൃද "84্࢙࠷΋ૣ͘੒௕ .Z42-ͱ1PTUHSF42-

Slide 17

Slide 17 text

"VSPSBͷಛ௃ w ؅ཧ͕؆୯ w ߴ͍εέʔϥϏϦςΟ w Մ༻ੑͱ଱ٱੑ w ߴ଎ w ҆શ w ҆Ձ Creative Commons Attribution-Share Alike 3.0 Unported https://commons.wikimedia.org/wiki/File:Aurora_Borealis_22Jan2004.jpg

Slide 18

Slide 18 text

"VSPSBͷಛ௃ ߴੑೳ .Z42-ͷഒ  1PTUHSF42-ͷഒ 3FBE࠷େ *014  8SJUF࠷େ *014 NTͷϨϓϦΧϨΠςϯγ ߴ͍εέʔϥϏϦςΟ W$16(#ʙ  W$16(# 5#·Ͱࣗಈ֦ு ࠷େݸͷϨϓϦΧ

Slide 19

Slide 19 text

"VSPSBͷಛ௃ ߴ͍҆શੑ ωοτϫʔΫͷ෼཭ 71$ ,.4ʹΑΔ҉߸Խ ίωΫγϣϯ҉߸Խ ߴՄ༻ੑͱ଱ٱੑ ͷՄ༻ੑͰઃܭ ඵͰϑΣΠϧΦʔόʔ σʔλΛ";ʹॏԽ

Slide 20

Slide 20 text

"VSPSBͷಛ௃ ޓ׵ੑ .Z42-ޓ׵ 1PTUHSF42-ޓ׵ ׬શϚωʔδυܕ ؅ཧλεΫʹ೰·ͳ͍ ࣗಈతͳϞχλϦϯά ࣗಈόοΫΞοϓ

Slide 21

Slide 21 text

"VSPSBͷಛ௃ "VSPSB͸044ͷ3%#.4Λϕʔεʹͯ͠ɺ  େྔΞΫηεΛࡹͨ͘Ίʹεϧʔϓοτ͕޲্͢Δ  ํ਑Ͱ։ൃ͍ͯ͠·͢ɻ ҰͭҰͭͷΫΤϦ͕େ͖͍Ϣʔεέʔεͷ৔߹͸ɺ  ΦϦδφϧͷ3%#.4ʢ.Z42-1PTUHSF42-ʣ͕ ྑ͍৔߹͕͋Γ·͢ɻ

Slide 22

Slide 22 text

3%#.4Λ࠶ઃܭ͔ͨ͠Β ࣮ݱͰ͖Δػೳ

Slide 23

Slide 23 text

Auroraͷ࠷ॏཁ෦෼ Storage

Slide 24

Slide 24 text

"VSPSB$MVTUFSͷશମ৅ Availability Zone A "VSPSB4UPSBHF&OHJOF ࿦ཧతͳڞ༗ετϨʔδϘϦϡʔϜ (#୯Ґͷ1SPUFDUJPO(SPVQ Availability Zone B Availability Zone C $BDIF $BDIF $BDIF $BDIF $BDIF

Slide 25

Slide 25 text

"VSPSB4UPSBHF&OHJOF Availability Zone A "VSPSB4UPSBHF&OHJOF ࿦ཧతͳڞ༗ετϨʔδϘϦϡʔϜ (#୯Ґͷ1SPUFDUJPO(SPVQ Availability Zone B Availability Zone C

Slide 26

Slide 26 text

-PH4USVDUVSFE4UPSBHF w σʔλΛϩάͷΑ͏ʹઌ಄͔Β௥ه͢Δ w ֤ʑͷϩάϨίʔυ͸-PH4FRVFODF/VNCFS ʢ-4/ʣΛ࣋ͪෆ଍ɾॏෳΛ൑ผͰ͖Δ w طଘͷσʔλ͕͋ΔϒϩοΫΛ্ॻ͖͠ͳ͍ w ݸਓͷײ૝Ͱ͕͢ %%%ͷ&WFOU4PVSDJOHʹ௨͡Δ ۭ͖εϖʔε EBUB EBUB EBUB EBUB EBUB ࣌ܥྻ

Slide 27

Slide 27 text

1SPUFDUJPO(SPVQ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF

Slide 28

Slide 28 text

4UPSBHF/PEF ΠϯϝϞϦΩϡʔΠϯά 6QEBUF 2VFVF )PU -PH %BUB #MPDLT 4#BDLVQ ACK ৼΓ෼͚ͯ ूΊΔ ϨίʔυΛه࿥ GC ચড় ߹ମ ϙΠϯτΠϯλΠϜ εφοϓγϣοτ P2PͰ௨৴ ᶃϨίʔυΛड৴͠ΠϯϝϞϦͷ  ɹΩϡʔʹ௥Ճ ᶄϨίʔυΛӬଓԽͯ͠"$, ᶅϨίʔυΛ੔ཧͯ͠ΪϟοϓΛ೺Ѳ ᶆϐΞͱ௨৴ͯ݀͠ຒΊ ᶇϩάϨίʔυΛ৽͍͠όʔδϣϯͷ  ɹσʔλϒϩοΫʹ߹ମ ᶈఆظతʹϩάͱ৽͍͠όʔδϣϯͷ  ɹϒϩοΫΛ4ʹసૹ ᶉఆظతʹݹ͍όʔδϣϯͷΨϕʔδ  ɹίϨΫγϣϯΛ࣮ࢪ ᶊఆظతʹϒϩοΫͷ$3$Λݕূ ᶊ ᶉ ᶈ ᶇ ᶆ ᶅ ᶄ ᶃ

Slide 29

Slide 29 text

ಡΈॻ͖௨ৗ࣌ͷಈ࡞ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF

Slide 30

Slide 30 text

ಡΈॻ͖௨ৗ࣌ͷಈ࡞ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF

Slide 31

Slide 31 text

ಡΈॻ͖ετϨʔδো֐࣌ͷಈ࡞ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF

Slide 32

Slide 32 text

ಡΈॻ͖ετϨʔδো֐࣌ͷಈ࡞ ॏো֐Ͱ΋ॻ͖ࠐΈ2VPSVNΛཱ֬Ͱ͖Δ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF

Slide 33

Slide 33 text

ಡΈॻ͖ετϨʔδো֐࣌ͷಈ࡞ ॏো֐Ͱ΋ಡΈࠐΈ2VPSVNΛཱ֬Ͱ͖Δ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF

Slide 34

Slide 34 text

σʔλ෮چετϨʔδো֐࣌ͷಈ࡞ ࣗಈతʹো֐Λݕ஌ͯ͠σʔλΛ෮چ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF (PTTJQ1SPUPDPM

Slide 35

Slide 35 text

ϨϓϦέʔγϣϯͱϑΣΠϧΦʔόʔ

Slide 36

Slide 36 text

ϨϓϦέʔγϣϯ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF $BDIF $BDIF $BDIF

Slide 37

Slide 37 text

ϨϓϦέʔγϣϯ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF $BDIF $BDIF ϝλσʔλ $BDIF

Slide 38

Slide 38 text

ϨϓϦέʔγϣϯ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF $BDIF $BDIF ࡟আ $BDIF ࡟আ

Slide 39

Slide 39 text

ϑΣΠϧΦʔόʔ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF $BDIF $BDIF $BDIF

Slide 40

Slide 40 text

ϑΣΠϧΦʔόʔ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF $BDIF $BDIF ঢ֨ $BDIF

Slide 41

Slide 41 text

ϑΣΠϧΦʔόʔ 1SPUFDUJPO(SPVQ "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF $BDIF $BDIF શͯ࡟আ $BDIF શͯ࡟আ

Slide 42

Slide 42 text

AWSαʔϏεͱͷ࿈ܞ

Slide 43

Slide 43 text

-BNCEB'VODUJPO*OUFHSBUJPO "VSPSB͔Β-BNCEBΛݺ΂Δ ࣮૷͸ετΞυϓϩγʔδϟ  ʢඇಉظͰ໭Γ஋ͳ͠ʣ τϦΨʔ΍Πϕϯτεέδϡʔϥ ͱ૊Έ߹ΘͤՄೳ AWS Lambda Amazon  Aurora

Slide 44

Slide 44 text

-BNCEB'VODUJPO*OUFHSBUJPO "VSPSB͔Β-BNCEBΛݺ΂Δ ࣮૷͸ετΞυϓϩγʔδϟ  ʢඇಉظͰ໭Γ஋ͳ͠ʣ τϦΨʔ΍Πϕϯτεέδϡʔϥ ͱ૊Έ߹ΘͤՄೳ "VSPSBͷσʔλߋ৽ͰΠϕϯτ υϦϒϯʹ֤αʔϏεΛݺ΂Δ Amazon CloudWatch Amazon Kinesis Amazon  SNS Amazon  DynamoDB Amazon ES AWS Lambda Amazon  Aurora

Slide 45

Slide 45 text

*"."VUIFOUJDBUJPO*OUFHSBUJPO "VSPSBʹ*".ݖݶͰϩάΠϯ ᶃೝূ৘ใΛ໰߹ͤΔ ᶄೝূ৘ใΛऔಘ͢Δ ᶅ"VSPSBʹΞΫηε͢Δʢ44-ʣ ᶆ ͓ͦΒ͘ ೝূ৘ใΛݕূ͢Δ ᶇ ͓ͦΒ͘ ݖݶΛऔಘ͢Δ ˞εϧʔϓοτ͕௿͍ͷ͕೉఺  ɹʢ઀ଓඵɺECUNJDSP͸઀ଓඵʣ client IAM temporary security credential permissions "84"VUIFOUJDBUJPO1MVHJO Amazon  Aurora ᶇ ᶆ ᶅ ᶄ ᶃ

Slide 46

Slide 46 text

σʔλ؅ཧ

Slide 47

Slide 47 text

%BUBCBTF$MPOJOH ଈ࠲ʹ%#σʔλΛෳ੡ ίϐʔͤͣʹಉ͡σʔλΛࢀর ΄΅ଈ࠲ʹ࡞੒׬ྃ ΫϩʔϯઌͰมߋʢ௥Ճߋ৽ ࡟আʣͨ࣌͠ʹίϐʔ ΦϦδφϧͰมߋͯ͠΋Ϋϩʔ ϯઌͷσʔλαΠζʹӨڹͳ͠ Ϋϩʔϯ਺͸·Ͱ࡞੒Մೳ ຊ൪Ϋϥελ (# $MPOJOH ݕূΫϥελ ΄΅(# มߋσʔλ มߋσʔλ ΦϦδφϧ ίϐʔ ʴ

Slide 48

Slide 48 text

%BUBCBTF$MPOJOH ଈ࠲ʹ%#σʔλΛෳ੡ ίϐʔͤͣʹಉ͡σʔλΛࢀর ΄΅ଈ࠲ʹ࡞੒׬ྃ ΫϩʔϯઌͰมߋʢ௥Ճߋ৽ ࡟আʣͨ࣌͠ʹίϐʔ ΦϦδφϧͰมߋͯ͠΋Ϋϩʔ ϯઌͷσʔλαΠζʹӨڹͳ͠ Ϋϩʔϯ਺͸·Ͱ࡞੒Մೳ ʢͦΕҎ্͸ίϐʔʣ ຊ൪Ϋϥελ (# $MPOJOH ݕূΫϥελ ΄΅(# …… ݸ໨ (# $MPOJOH $PQZ

Slide 49

Slide 49 text

%#σʔλΛ೚ҙͷ࣌఺ʹߴ଎ʹר͖໭͢ UͰUʹ໭͢৔߹ɺUͱUͷؒͷ-4/ͷϨίʔυΛݟ͑ͳ͘͢Δɻ  ͢ΔͱU͔Βͷߋ৽͕ফ͑Δɻ ಉ༷ʹU͔ΒUʹ໭͢৔߹ʹ͸UʙUͷϨίʔυΛݟ͑ͳ͘͢Δɻ -PH4USVDUVSFE4UPSBHFͷಛ௃͕ग़ͨػೳͩͱࢥΘΕΔɻ *OWJTJCMF *OWJTJCMF %BUBCBTFCBDLUSBDLʢ$0.*/(400/ʣ t0 t1 t2 t3 t4 t5

Slide 50

Slide 50 text

R Ͱ΋ɺඈͼಓ۩తͳػೳ͚ͩ͡Όͳ͍

Slide 51

Slide 51 text

஍ಓͳύϑΥʔϚϯεվળ ϩοΫڝ߹ͷվળ ඇಉظάϧʔϓίϛοτ εϨουϓʔϧͷ࣮૷ ϓϥΠϚϦΩʔͷ૸ࠪํ๏ͷվળ

Slide 52

Slide 52 text

"VSPSB࢖͍͜ͳ͠ͷྫ

Slide 53

Slide 53 text

Auroraͷ࣮ߦதΫΤϦΛ؂ࢹ͢Δ

Slide 54

Slide 54 text

"VSPSBͷ࣮ߦதΫΤϦΛ؂ࢹ͢Δ 4MPX2VFSZ͸׬ྃޙͷग़ྗɻʰ࣮ߦதʱͷঢ়گ͕ݟ͍ͨɻ &WFOU4DIFEVMFSͰΫΤϦ࣮ߦ 130$&44-*45ͷ݁ՌΛ  -BNCEB΁ૹΔ -BNCEB͔Β$MPVE8BUDI-PHT΁ ৄࡉ͸ͪ͜Β΁  IUUQEFWDMBTTNFUIPEKQDMPVEBXTBVSPSBQSPDFTTMJTUUPDMPVEXBUDIMPHT ˞3FBEFS͸&WFOU4DIFEVMFS͕ಈ͔ͳͯ͘πϥ͍ &7&/54$)&%6-&3 130$&44-*455"#-& DBMMMBNCEB@BTZOD Amazon CloudWatch AWS Lambda

Slide 55

Slide 55 text

Կނ"VSPSB͔Β-BNCEB࣮ߦʁ -BNCEBΛఆظ࣮ߦͤͯ͞"VSPSBʹΞΫηεՄೳ "VSPSB͔Β-BNCEBΛ࢖ͬͯΈ͔ͨͬͨɻ 71$಺ͷ"VSPSBʹΞΫηε͢Δʹ͸&/*͕ඞཁ͕ͩɺ࡞੒ʹ ͕͔͔࣌ؒΔɻ ʮ؂ࢹର৅ʹใࠂͤ͞Δͳʯ͕ͩܭଌ͕໨తͳͷͰ໰୊ແ͠

Slide 56

Slide 56 text

ߴ଎ϑΣΠϧΦʔόʔ

Slide 57

Slide 57 text

ߴ଎ϑΣΠϧΦʔόʔ .BSJB%#$POOFDUPS+Λ࢖༻͢Δͱ֤ϊʔυͷεςʔ λεΛ൑அͯ͠8SJUFS΁઀ଓͰ͖Δɻ wʙඵͰ઀ଓઌϊʔυΛ੾ସՄೳ  ΫϥελΤϯυϙΠϯτͷ55-͸ඵ wJOOPEC@SFBE@POMZάϩʔόϧม਺Λ൑அͯ͠8SJUFS΁઀ଓ w௨ৗͷ.Z42-༻+%#$υϥΠόͱͯ͠࢖༻Մೳ

Slide 58

Slide 58 text

Slide 59

Slide 59 text

ߴ଎ϑΣΠϧΦʔόʔ +BWBҎ֎ͷ؀ڥͰ΋ಉ͡Α͏ͳ͜ͱΛ΍Γ͍ͨɻ wJOOPEC@SFBE@POMZͰϔϧενΣοΫ͢Ε͹ྑ͍ wϩʔυόϥϯαΛ࢖ͬͯΫϥΠΞϯτଆͰ൑அ w)"1SPYZΛ࢖͑͹FYUFSOBMDIFDL͕࢖͑Δ w͍ͭͰʹ3FBEFSͷෛՙ෼ࢄ΋Ͱ͖ͦ͏

Slide 60

Slide 60 text

ߴ଎ϑΣΠϧΦʔόʔ ΍ͬͯΈͨʂʢະ׬੒ɻɻɻϋϚΓॴ͕͋Δ͔΋ʣ wJOOPEC@SFBE@POMZͷνΣοΫεΫϦϓτΛ࡞੒ wIBQSPYZDGHͷFYUFSOBMDIFDLʹ  ্هεΫϦϓτΛઃఆ w8SJUFSʢϑΣΠϧΦʔόʔʣͱ3FBEFS  ʢϩʔυόϥϯγϯάʣͷޱΛ༻ҙ ࢀߟࢿྉɿ  3%4GPS.Z42-͔Β"VSPSBʹҠߦͨ͠࿩3%4GPS.Z42-UP"VSPSBCZ'6+*8"3"4IVOJDIJSP  IUUQTTQFBLFSEFDLDPNGVKJXBSBSETGPSNZTRMUPBVSPSB EC2 instance contents

Slide 61

Slide 61 text

ߴ଎ϑΣΠϧΦʔόʔʢະ׬੒ɻɻɻʣ ௨ৗ࣌ wॻ͖ࠐΈ͸Ϛελ wಡΈࠐΈ͸εϨʔϒΛ  ϩʔυόϥϯγϯά 8SJUF 3FBE OFF ON ON innodb_read_only

Slide 62

Slide 62 text

ߴ଎ϑΣΠϧΦʔόʔʢະ׬੒ɻɻɻʣ ো֐ൃੜ wϚελʹো֐ൃੜ wΞΫηεෆೳʹͳΔ 8SJUF 3FBE ʔ ON ON innodb_read_only

Slide 63

Slide 63 text

ߴ଎ϑΣΠϧΦʔόʔʢະ׬੒ɻɻɻʣ ো֐ൃੜ wϔϧενΣοΫ͕/(ʹͳΔ 8SJUF 3FBE ʔ ON ON innodb_read_only

Slide 64

Slide 64 text

ߴ଎ϑΣΠϧΦʔόʔʢະ׬੒ɻɻɻʣ "VSPSBଆϑΣΠϧΦʔόʔ wผͷϊʔυ͕Ϛελʹঢ֨  JOOPEC@SFBE@POMZ΋มΘΔ 8SJUF 3FBE ʔ OFF ON innodb_read_only

Slide 65

Slide 65 text

ߴ଎ϑΣΠϧΦʔόʔʢະ׬੒ɻɻɻʣ )"1SPYZଆϑΣΠϧΦʔόʔ wJOOPEC@SFBE@POMZΛݩʹ  Ϛελʹॻ͖ࠐΈΛྲྀ͢ wϚελʹಡΈࠐΈΛྲྀ͞ͳ͍ 8SJUF 3FBE ʔ OFF ON innodb_read_only

Slide 66

Slide 66 text

ߴ଎ϑΣΠϧΦʔόʔʢະ׬੒ɻɻɻʣ ো֐ϊʔυͷ෮چ wো֐͕ൃੜͨ͠ϊʔυ͸  εϨʔϒͱͯ͠෮چ wϔϧενΣοΫ͕0,ʹͳΔͱ  ಡΈࠐΈ͕ྲྀΕΔ 8SJUF 3FBE ON OFF ON innodb_read_only

Slide 67

Slide 67 text

ߴ଎ϑΣΠϧΦʔόʔʢະ׬੒ɻɻɻʣ ໝ૝Ͱ͕͢ɺ͞Βʹ๛෋ͳػೳ΋͚ͭΒΕΔ͔΋ɻɻɻ wΫϥελ৘ใ͔ΒIBQSPYZDGHΛࣗಈੜ੒͢Ε͹εϨʔϒ௥ ՃͰ΋ιϑτ΢ΣΞͷઃఆΛมߋ͠ͳͯ͘΋૊ΈࠐΊΔ wϚελͷεέʔϧΞοϓΛαʔϏε࣌ؒதʹ࣮ߦ΋Մೳʁ  ʢ਺ඵͷ઀ଓஅ͕ڐ༰Ͱ͖Δ৔߹ʣ

Slide 68

Slide 68 text

·ͱΊ

Slide 69

Slide 69 text

·ͱΊ w "VSPSBͷཁ͸ετϨʔδ w -PH4USVDUVSFE4UPSBHFΛϕʔεʹͯ͠๛෋ͳ  ػೳΛ࣮ݱ͍ͯ͠Δ w "VSPSBΛ࢖͍͜ͳ͢͜ͱͰ৭ʑͳϢʔεέʔεʹ  ରԠͰ͖Δ w ߴ଎ϑΣΠϧΦʔόʔΛ׬੒͍ͤͨ͞ਓੜͩͬͨɻɻɻ