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

Transcript

1. Oracle؀ڥΛΑΓૣ͘࡞Δʹ ͸ʁ ʙαΠϨϯτ vs Docker vs RDS(AWS)ʙ ʢגʣϙοέͱΦΠγοΫεɾϥɾେ஍ʢגʣͷެ։ٕज़ษڧձ With ϚΠΫϩιϑτࣉా͞Μ
2. Ͳ͏΋ ͜Μ͹Μ͸ ॳΊ·ͯ͠
3. ձࣾɿΦΠγοΫεɾϥɾେ஍גࣜձࣾ Twitterɿkoyapig ΍͖ͬͯͨ͜ͱɿσʔλϕʔεΤϯδχΞ (Oracle԰)ɺSRE ͜Αͳ͘Ѫ͢Δ΋ͷɿ͢Έͬί͙Β͠
4. ίϯςφษڧ͍͚ͨ͠ ͲɺԿͨ͠Β͍͍ΜͩΖ
5. ͦ͏ͩʂOracle࡞Γ ͳ͕Βษڧ͠Αʂ
6. ͯ͞
7. ͿͬͪΌ͚λΠτϧෛ ͚ͯ͠·͢
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. ͝੩ௌ͋Γ͕ͱ͏͟͝ ͍·ͨ͠