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