jtf_2019_データベースのDR環境をoracle_cloud上に立ててみた.pdf

Transcript

1. σʔλϕʔεͷDR؀ڥΛORACLE CLOUD ্ʹཱͯͯΈͨ July Tech Festa 2019 1 Masashi Koyasu

2. ࣗݾ঺հ ࢠ҆ɹਖ਼࢙ʢMasashiɹKoyasuʣ @koyapig ΦΠγοΫεɾϥɾେ஍גࣜձࣾ Oracle / MySQL / PostgreSQL /

   ͦͷଞ DBA4೥ ~ SRE2೥~ 2

3. About DR ࣄۀܧଓϚωδϝϯτʹ͓͚Δ֓೦ͷͻͱͭͰɺࡂ֐ ͳͲʹΑΔඃ֐͔Βͷճ෮ાஔɺ͋Δ͍͸ඃ֐Λ࠷খݶ ʹ཈͑ΔͨΊͷ༧๷ાஔͷ͜ͱͰ͋Δ Ҿ༻ʣWikipediaɿσΟβελϦΧόϦ https://ja.wikipedia.org/wiki/ %E3%83%87%E3%82%A3%E3%82%B6%E3%82%B9%E3%82%BF%E3%83%AA%E3%82%AB%E3%83%90%E3%83%AA σΟβελϦΧόϦʢӳޠɿdisaster recoveryʣ

   3

4. About DR ࣄۀܧଓϚωδϝϯτʹ͓͚Δ֓೦ͷͻͱ ͭͰɺࡂ֐ͳͲʹΑΔඃ֐͔Βͷճ෮ા ஔɺ͋Δ͍͸ඃ֐Λ࠷খݶʹ཈͑ΔͨΊͷ ༧๷ાஔͷ͜ͱͰ͋Δ Ҿ༻ʣWikipediaɿσΟβελϦΧόϦ https://ja.wikipedia.org/wiki/ %E3%83%87%E3%82%A3%E3%82%B6%E3%82%B9%E3%82%BF%E3%83%AA%E3%82%AB%E3%83%90%E3%83%AA σΟβελϦΧόϦʢӳޠɿdisaster

   recoveryʣ 4 ཁ͢Δʹɾɾɾ ࡂ֐ͳͲʹΑΓɺαʔόʔ͕΍͹ ͍͜ͱʹͳͬͨ৔߹ʹૣٸʹ෮چ Ͱ͖ΔΑ͏උ͑Δ͜ͱ

5. About RPO & RTO ໨ඪ෮چ࣌఺(Recovery Point Objective) ͍ͭ࣌఺ͷσʔλ·Ͱ໭ͤΔͷ͔ ໨ඪ෮چ࣌ؒ(Recovery Time

   Objective) ͍ͭ·ͰʹʢԿ࣌ؒͰʣ෮چͰ͖Δͷ͔ 5

6. എܠ ۙ೥ɺຖ೥ͷΑ͏ʹࣗવࡂ֐͕ൃੜ͍ͯ͠Δ طʹDR؀ڥ͸͋Δ͕ɺສશͳ΋ͷͰ͸ͳ͍ ࡂ֐࣌ʹαʔϏεҡ࣋Ͱ͖Δ࢓૊Έʹ࡮৽͢Δ 6

7. ໨త ҰॹʹDRʹ͍ͭͯߟ͑Δ࣌ؒʹ͍ͨ͠ ҰҊͱͯ͠ฐࣾͷDR؀ڥΛ஌ͬͯ΄͍͠ 7

8. ͳͥDR͸ඞཁͳͷ͔ ࡂ֐࣌ͷૣظ෮چͷͨΊͷରࡦ σʔλͷܽଛ͕ͳ͍Α͏ʹ͢ΔͨΊͷରࡦ ͓٬༷΁ͷӨڹΛ࠷খݶʹ཈͑ΔͨΊͷରࡦ (※)RPO, RTOʹج͖ͮ෮چͰ͖ΔΑ͏ʹ͢Δ 8

9. ࣗࣾͷDR؀ڥ͸େৎ෉Ͱ͔͢ʁ

10. γεςϜશମ૾ʢࢀߟʣ On-Premises Cloud-VM ECαʔόʔ جװܥαʔόʔ ෺ྲྀܥαʔόʔ • ECαΠτɺجװܥγεςϜɺ෺ྲྀܥγεςϜ…etcΛࣗࣾߏ ஙɾӡ༻ •

    αʔόʔ୆਺͸ओཁαʔόʔ͚ͩͰ20਺୆ • Ұ෦Λআ͖શͯͷॲཧͰOracle Database͕࢖ΘΕ͍ͯΔ όοναʔόʔ 11gR2 SE 2node RAC 10

11. ͜Ε·ͰͷDR؀ڥ - ߏ੒ On-Premises(ຊ൪) Archive Logs Full Backup File Amazon

    S3 Archive Logs AWS EC2(DR) temp area ECαʔόʔ جװܥαʔόʔ11 ᶃ ᶄ ᶅ ᶆ ᶇ

12. ͜Ε·ͰͷDR - ՝୊ DBͷࠩ෼ಉظ͕ͪΐͪ͘ΐࣦ͘ഊ ىಈʢOPENʣͰ͖Δ͔͕Θ͔Βͳ͍ ӡ༻͕ଐਓԽ͍ͯ͠Δ͔Β୲౰ऀͷෛ୲ ͕͍͢͝ 12

13. ͜Ε·ͰͷDR؀ڥ - ߏ੒ Archive Logs Full Backup File Amazon S3

    Archive Logs AWS EC2(DR) temp area ECαʔόʔ جװܥαʔόʔ 13 On-Premises(ຊ൪)

14. ৽͍͠DR؀ڥ - ඞཁͳཁ݅ Standard EditionʢOracle DatabaseͷEditionʣͰ΋Ͱ͖Δ͜ͱ σʔλࢀর͕Ͱ͖Δ͜ͱʢಉظঢ়گͷ֬ೝʣ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔ͕Ͱ͖Δ͜ͱ ӡ༻͕ଐਓԽ͠ͳ͍͜ͱ ίετΛͳΔ΂͘཈͑Δ͜ͱ

    14

15. ৽͍͠DR؀ڥ - ߏ੒ Virtual Cloud Network(VCN) subnet subnet subnet DBaaS

    Compute Block Storage Object Storage Nat Server(vm) mount Oracle Cloud Infrastructure(US East (Ashburn)) Oracle cloud(DR) 15 11gR2 SE 2node RAC ᶃ ᶄ On-Premises(ຊ൪)

16. ৽͍͠DR؀ڥ - ߏ੒ Virtual Cloud Network(VCN) subnet subnet subnet DBaaS

    Compute Block Storage Object Storage Nat Server(vm) mount Oracle Cloud Infrastructure(US East (Ashburn)) Oracle cloud(DR) 16 11gR2 SE 2node RAC ᶃ ᶄ On-Premises(ຊ൪)

17. ৽͍͠DR؀ڥ - ߏ੒ Virtual Cloud Network(VCN) subnet subnet subnet DBaaS

    Compute Nat Server(vm) mount Oracle Cloud Infrastructure(US East (Ashburn)) Oracle cloud(DR) 17 11gR2 SE 2node RAC Block Storage Object Storage On-Premises(ຊ൪)

18. ৽͍͠DR؀ڥ - Platform Platform Oracle Could InfrastructureʢOCIʣ Bare Metal, VM,

    and ExadataʢDBaaSʣ Compute Block Volume Object Storage 18

19. ৽͍͠DR؀ڥ - Platform 19 OCI AWS DATABASE DBaaS RDS SERVER

    Compute EC2 DISK Block Volume EBS STORAGE Object Storage S3

20. ৽͍͠DR؀ڥ - Software Software Dbvisit Standby Oracle Database޲͚ࡂ֐ରࡦιϑτ΢ΣΞ 20

21. ৽͍͠DR؀ڥ - Dbvisitͱ͸ Dbvisit͕ࣾఏڙ͍ͯ͠ΔOracle Database޲͚σΟβελϦ ΧόϦιϑτ΢ΣΞ ࠓճ͸૯୅ཧళͷInsight Technology༷͔Βߪೖɾαϙʔτ Enterprise Editionͷ(※)Data

    Guardͷ୅ସҊͱͯ͠࡞ΒΕͨ ιϑτ΢ΣΞɻػೳ͸ॆ࣮͓ͯ͠ΓɺैདྷͷOracle੡඼ʹ ൺ΂҆ՁͰಋೖՄೳɻ 21

22. ิ଍ɿAbout Data Guard ओʹσʔλอޢΛ໨తͱͨ͠ϨϓϦέʔ γϣϯػೳ ෳ਺ͷಉظϞʔυΛඋ͑ΔʢಡΈऔΓઐ ༻/ॻ͖ࠐΈՄೳʣ 22

23. ৽͍͠DR؀ڥ - OCIΛ࢖͏ཧ༝ DBaaS͸ଞͷManagedDBͱҧ͍VMʹssh઀ ଓͰ͖Δ ଞCloudΛ࢖͏ΑΓOracleͷϥΠηϯεί ετͷ࡟ݮ͕Մೳ 23

24. ৽͍͠DR؀ڥ - DbvisitΛ࢖͏ཧ༝ Standard EditionͰDataGuardʹ͍ۙػೳ͕҆ՁͰར༻Մೳ ಡΈऔΓઐ༻ͰDBΛىಈ(OPEN)͢Δ͜ͱͰσʔλࢀর ͕Մೳ ಉظঢ়ଶʹ໭ͯࠩ͠෼ಉظ࠶։͕Մೳ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔ͕༰қ GUI͕࢖͑Δ͜ͱͰӡ༻ʹDBAҎ֎Ͱ΋ରԠՄೳ

    24

25. ৽͍͠DR؀ڥ - ຊߏ੒ͷϝϦοτ DbvisitΛ࢖͏͜ͱʹΑΓ՝୊Λղফ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔͳͲͷ ࡞ۀ͕ʢ࠷ѱͷ৔߹ʣDBAҎ֎Ͱ΋ରԠՄೳ Oracle Cloud & DbvisitΛ࢖͏͜ͱʹΑΓɺϥ

    ΠηϯείετΛେ෯࡟ݮ͕Մೳ 25

26. ࢀߟ·Ͱʹ - ίετ ؀ڥ ͜Ε·ͰͷDR ؀ڥ ৽͍͠DR ؀ڥ ࠩ෼ ʢ৽ن

    - ͜Ε·Ͱʣ DB ********** ********** ▼51% DBVISIT (ϥΠηϯεඅ) ********** ********** ˛ DBVISIT (อकඅ) ********** ˛ ߹ܭ ********** ********** ▼19% 26

27. ໨తʢ࠶ܝʣ ҰॹʹDRʹ͍ͭͯߟ͑Δ࣌ؒʹ͍ͨ͠ ҰҊͱͯ͠ฐࣾͷDR؀ڥΛ஌ͬͯ΄͍͠ 27

28. We are hiringʂ ΦΠγοΫεɹ࠾༻ https://recruit.oisixradaichi.co.jp/ 28

29. Thank You!! ࣭͝໰౳͋Γ·ͨ͠Βɺ͓ؾܰʹDM͍ͩ͘͞ʂ @koyapig