Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

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

Developers.IO 2017 の発表資料です。
http://eventregist.com/e/63HfQR3hNu7K

maroon1st

July 01, 2017
Tweet

More Decks by maroon1st

Other Decks in Technology

Transcript

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

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

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


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

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

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

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

  9.  "VSPSBͷಛ௃

  10.  ࠷ֵۙ৽తͳσʔλϕʔε͕ ͍Ζ͍Ζग़͍ͯ·͢ΑͶʂ

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

  12.  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
  13.  Ͱ΋ɺ΍ͬͺΓ

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

  15.  Auroraͷ࿩Ͱ͢

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

  17. "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
  18. "VSPSBͷಛ௃  ߴੑೳ .Z42-ͷഒ
 1PTUHSF42-ͷഒ 3FBE࠷େ *014
 8SJUF࠷େ *014 NTͷϨϓϦΧϨΠςϯγ

    ߴ͍εέʔϥϏϦςΟ W$16(#ʙ
 W$16(# 5#·Ͱࣗಈ֦ு ࠷େݸͷϨϓϦΧ
  19. "VSPSBͷಛ௃  ߴ͍҆શੑ ωοτϫʔΫͷ෼཭ 71$  ,.4ʹΑΔ҉߸Խ ίωΫγϣϯ҉߸Խ ߴՄ༻ੑͱ଱ٱੑ ͷՄ༻ੑͰઃܭ

    ඵͰϑΣΠϧΦʔόʔ σʔλΛ";ʹॏԽ
  20. "VSPSBͷಛ௃  ޓ׵ੑ .Z42-ޓ׵ 1PTUHSF42-ޓ׵ ׬શϚωʔδυܕ ؅ཧλεΫʹ೰·ͳ͍ ࣗಈతͳϞχλϦϯά ࣗಈόοΫΞοϓ

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

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

  23.  Auroraͷ࠷ॏཁ෦෼ Storage

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

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

    B Availability Zone C
  26. -PH4USVDUVSFE4UPSBHF  w σʔλΛϩάͷΑ͏ʹઌ಄͔Β௥ه͢Δ w ֤ʑͷϩάϨίʔυ͸-PH4FRVFODF/VNCFS ʢ-4/ʣΛ࣋ͪෆ଍ɾॏෳΛ൑ผͰ͖Δ w طଘͷσʔλ͕͋ΔϒϩοΫΛ্ॻ͖͠ͳ͍ w

    ݸਓͷײ૝Ͱ͕͢ %%%ͷ&WFOU4PVSDJOHʹ௨͡Δ ۭ͖εϖʔε EBUB EBUB EBUB EBUB EBUB ࣌ܥྻ
  27. 1SPUFDUJPO(SPVQ  1SPUFDUJPO(SPVQ  "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF

    4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF
  28. 4UPSBHF/PEF  ΠϯϝϞϦΩϡʔΠϯά 6QEBUF 2VFVF )PU -PH %BUB #MPDLT 4#BDLVQ

    ACK ৼΓ෼͚ͯ ूΊΔ ϨίʔυΛه࿥ GC ચড় ߹ମ ϙΠϯτΠϯλΠϜ εφοϓγϣοτ P2PͰ௨৴ ᶃϨίʔυΛड৴͠ΠϯϝϞϦͷ
 ɹΩϡʔʹ௥Ճ ᶄϨίʔυΛӬଓԽͯ͠"$, ᶅϨίʔυΛ੔ཧͯ͠ΪϟοϓΛ೺Ѳ ᶆϐΞͱ௨৴ͯ݀͠ຒΊ ᶇϩάϨίʔυΛ৽͍͠όʔδϣϯͷ
 ɹσʔλϒϩοΫʹ߹ମ ᶈఆظతʹϩάͱ৽͍͠όʔδϣϯͷ
 ɹϒϩοΫΛ4ʹసૹ ᶉఆظతʹݹ͍όʔδϣϯͷΨϕʔδ
 ɹίϨΫγϣϯΛ࣮ࢪ ᶊఆظతʹϒϩοΫͷ$3$Λݕূ ᶊ ᶉ ᶈ ᶇ ᶆ ᶅ ᶄ ᶃ
  29. ಡΈॻ͖௨ৗ࣌ͷಈ࡞  1SPUFDUJPO(SPVQ  "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF "WBJMBCJMJUZ;POF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF

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

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

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

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

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

    4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF (PTTJQ1SPUPDPM
  35.  ϨϓϦέʔγϣϯͱϑΣΠϧΦʔόʔ

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

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

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

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

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

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

    4UPSBHF/PEF 4UPSBHF/PEF 4UPSBHF/PEF $BDIF $BDIF શͯ࡟আ $BDIF શͯ࡟আ
  42.  AWSαʔϏεͱͷ࿈ܞ

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


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

    CloudWatch Amazon Kinesis Amazon
 SNS Amazon
 DynamoDB Amazon ES AWS Lambda Amazon
 Aurora
  45. *"."VUIFOUJDBUJPO*OUFHSBUJPO  "VSPSBʹ*".ݖݶͰϩάΠϯ ᶃೝূ৘ใΛ໰߹ͤΔ ᶄೝূ৘ใΛऔಘ͢Δ ᶅ"VSPSBʹΞΫηε͢Δʢ44-ʣ ᶆ ͓ͦΒ͘ ೝূ৘ใΛݕূ͢Δ ᶇ

    ͓ͦΒ͘ ݖݶΛऔಘ͢Δ ˞εϧʔϓοτ͕௿͍ͷ͕೉఺
 ɹʢ઀ଓඵɺECUNJDSP͸઀ଓඵʣ client IAM temporary security credential permissions "84"VUIFOUJDBUJPO1MVHJO Amazon
 Aurora ᶇ ᶆ ᶅ ᶄ ᶃ
  46.  σʔλ؅ཧ

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

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

    ʢͦΕҎ্͸ίϐʔʣ ຊ൪Ϋϥελ (# $MPOJOH  ݕূΫϥελ ΄΅(# …… ݸ໨ (# $MPOJOH  $PQZ 
  49. %#σʔλΛ೚ҙͷ࣌఺ʹߴ଎ʹר͖໭͢ UͰUʹ໭͢৔߹ɺUͱUͷؒͷ-4/ͷϨίʔυΛݟ͑ͳ͘͢Δɻ
 ͢ΔͱU͔Βͷߋ৽͕ফ͑Δɻ ಉ༷ʹU͔ΒUʹ໭͢৔߹ʹ͸UʙUͷϨίʔυΛݟ͑ͳ͘͢Δɻ -PH4USVDUVSFE4UPSBHFͷಛ௃͕ग़ͨػೳͩͱࢥΘΕΔɻ *OWJTJCMF *OWJTJCMF %BUBCBTFCBDLUSBDLʢ$0.*/(400/ʣ  t0

    t1 t2 t3 t4 t5
  50. R  Ͱ΋ɺඈͼಓ۩తͳػೳ͚ͩ͡Όͳ͍

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

  52.  "VSPSB࢖͍͜ͳ͠ͷྫ

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

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

  56.  ߴ଎ϑΣΠϧΦʔόʔ

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

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

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

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


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

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

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

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

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

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

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

  68.  ·ͱΊ

  69. ·ͱΊ  w "VSPSBͷཁ͸ετϨʔδ w -PH4USVDUVSFE4UPSBHFΛϕʔεʹͯ͠๛෋ͳ
 ػೳΛ࣮ݱ͍ͯ͠Δ w "VSPSBΛ࢖͍͜ͳ͢͜ͱͰ৭ʑͳϢʔεέʔεʹ
 ରԠͰ͖Δ

    w ߴ଎ϑΣΠϧΦʔόʔΛ׬੒͍ͤͨ͞ਓੜͩͬͨɻɻɻ
  70. 2VFTUJPO5JNF  ʁ

  71. None