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

6afdaa95e9142c55ab6b365c32f402ad?s=47 koyapig
January 28, 2020

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

6afdaa95e9142c55ab6b365c32f402ad?s=128

koyapig

January 28, 2020
Tweet

Transcript

  1. σʔλϕʔεͷDR؀ڥΛORACLE CLOUD ্ʹཱͯͯΈͨ Oistudy #5 - GAUSS͞ΜͱΦΠϥେ஍ͷOracleCloud 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؀ڥΛ஌ͬͯ΄͍͠ ฐࣾͷOracle Cloudͷ࢖͍ํ 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؀ڥΛ஌ͬͯ΄͍͠ ฐࣾͷOracle Cloudͷ࢖͍ํ DR؀ڥΛߏ੒͍ͯ͠Διϑτ΢ΣΞ 27

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

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