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

by koyapig

Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

Ͳ͏΋ ͜Μ͹Μ͸ ॳΊ·ͯ͠

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

ͯ͞

Slide 7

Slide 7 text

ͿͬͪΌ͚λΠτϧෛ ͚ͯ͠·͢

Slide 8

Slide 8 text

No content

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

ߏ੒ʢࢀߟʣ ϋʔυ΢ΣΞɿ αΠϨϯτΠϯετʔϧ •AWS EC2 redhat7 t2.small Docker •Mac RDS •AWS RDS db.t2.small Oracleɿ  12.2.0.1 Enterprise Edition

Slide 11

Slide 11 text

ΤϯτϦNo.1 αΠϨϯτΠϯετʔϧ

Slide 12

Slide 12 text

Time 22min

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

ΤϯτϦNo.2 RDS

Slide 15

Slide 15 text

Time 18min

Slide 16

Slide 16 text

ۤ࿑ͨ͜͠ͱ Կ΋ͳ͍

Slide 17

Slide 17 text

ΤϯτϦNo.3 Docker

Slide 18

Slide 18 text

Time 29min

Slide 19

Slide 19 text

ɾɾɾ

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

ۤ࿑ͨ͜͠ͱ ʙඪ४ग़ྗϩάʙ ɾ ɾ ɾ 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 ﬁle 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 ﬁle# 10, old size 337920K, new size 358400K ɾ ɾ