Oracle環境をより早く作るには

6afdaa95e9142c55ab6b365c32f402ad?s=47 koyapig
April 11, 2019

 Oracle環境をより早く作るには

6afdaa95e9142c55ab6b365c32f402ad?s=128

koyapig

April 11, 2019
Tweet

Transcript

  1. Oracle؀ڥΛΑΓૣ͘࡞Δʹ ͸ʁ ʙαΠϨϯτ vs Docker vs RDS(AWS)ʙ ʢגʣϙοέͱΦΠγοΫεɾϥɾେ஍ʢגʣͷެ։ٕज़ษڧձ With ϚΠΫϩιϑτࣉా͞Μ

  2. Ͳ͏΋ ͜Μ͹Μ͸ ॳΊ·ͯ͠

  3. ձࣾɿΦΠγοΫεɾϥɾେ஍גࣜձࣾ Twitterɿkoyapig ΍͖ͬͯͨ͜ͱɿσʔλϕʔεΤϯδχΞ (Oracle԰)ɺSRE ͜Αͳ͘Ѫ͢Δ΋ͷɿ͢Έͬί͙Β͠

  4. ίϯςφษڧ͍͚ͨ͠ ͲɺԿͨ͠Β͍͍ΜͩΖ

  5. ͦ͏ͩʂOracle࡞Γ ͳ͕Βษڧ͠Αʂ

  6. ͯ͞

  7. ͿͬͪΌ͚λΠτϧෛ ͚ͯ͠·͢

  8. None
  9. None
  10. ߏ੒ʢࢀߟʣ ϋʔυ΢ΣΞɿ αΠϨϯτΠϯετʔϧ •AWS EC2 redhat7 t2.small Docker •Mac RDS

    •AWS RDS db.t2.small Oracleɿ
 12.2.0.1 Enterprise Edition
  11. ΤϯτϦNo.1 αΠϨϯτΠϯετʔϧ

  12. Time 22min

  13. ۤ࿑ͨ͜͠ͱ • ϨεϙϯεϑΝΠϧͷς ϯϓϨ͕͋Δ͕Կมߋ͠ ͍͍͔ͯΘ͔Βͳ͍ • ݁ہGUI͔ΒϨεϙϯε ϑΝΠϧ࡞ͬͨ

  14. ΤϯτϦNo.2 RDS

  15. Time 18min

  16. ۤ࿑ͨ͜͠ͱ Կ΋ͳ͍

  17. ΤϯτϦNo.3 Docker

  18. Time 29min

  19. ɾɾɾ

  20. ۤ࿑ͨ͜͠ͱ • Dockerͷ࢖͍ํΘ͔Β ͳ͍ʂ • ߏங׬͕ྃΘ͔Βͳ͍ (ΊͬͪΌ଴ͪ·ͨ͠ʣ

  21. ۤ࿑ͨ͜͠ͱ ʙඪ४ग़ྗϩάʙ ɾ ɾ ɾ Completed: ALTER PLUGGABLE DATABASE ORCLPDB1

    SAVE STATE 2019-03-18T17:45:33.000169+00:00 Warning: VKTM detected a time stall. Time drifts can result in unexpected behavior such as time-outs. Please see the VKTM trace file for more details: /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_vktm_2086.trc 2019-03-18T17:53:05.331875+00:00 ORCLPDB1(3):Resize operation completed for file# 10, old size 337920K, new size 358400K ɾ ɾ
  22. ݁Ռ RDS͸΍ͬͺΓૣ͔ͬͨ

  23. ϩʔΧϧͰແྉͰ؆୯ʹ؀ڥ Λ࡞ΕΔDockerαΠ ίʔʂʂʂ

  24. ࣍ճ Docker൛OracleΛNo.1ʹͯ͠Έͨ

  25. ͝੩ௌ͋Γ͕ͱ͏͟͝ ͍·ͨ͠