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

Transcript

1. 1.

   σʔλϕʔεͷDR؀ڥΛORACLE CLOUD ্ʹཱͯͯΈͨ Oistudy #5 - GAUSS͞ΜͱΦΠϥେ஍ͷOracleCloud 1 Masashi Koyasu

2. 2.

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

   ͦͷଞ DBA4೥ ~ SRE2೥~ 2
3. 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. 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. 5.

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

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

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

7. 7.

   ໨త ҰҊͱͯ͠ฐࣾͷDR؀ڥΛ஌ͬͯ΄͍͠ ฐࣾͷOracle Cloudͷ࢖͍ํ DR؀ڥΛߏ੒͍ͯ͠Διϑτ΢ΣΞ 7

8. 8.

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

9. 9.

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

10. 10.

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

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

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

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

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

13. 13.

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

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

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

    14
15. 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. 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. 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. 18.

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

    and ExadataʢDBaaSʣ Compute Block Volume Object Storage 18
19. 19.

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

    Compute EC2 DISK Block Volume EBS STORAGE Object Storage S3
20. 20.

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

21. 21.

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

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

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

23. 23.

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

24. 24.

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

    24
25. 25.

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

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

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

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

    ໨తʢ࠶ܝʣ ҰҊͱͯ͠ฐࣾͷDR؀ڥΛ஌ͬͯ΄͍͠ ฐࣾͷOracle Cloudͷ࢖͍ํ DR؀ڥΛߏ੒͍ͯ͠Διϑτ΢ΣΞ 27

28. 28.

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

29. 29.

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