Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
データベースのDR環境をORACLE_CLOUD上に立ててみた.pdf
koyapig
January 28, 2020
Technology
0
1k
データベースのDR環境をORACLE_CLOUD上に立ててみた.pdf
koyapig
January 28, 2020
Tweet
Share
More Decks by koyapig
See All by koyapig
jtf_2019_データベースのDR環境をoracle_cloud上に立ててみた.pdf
koyapig
0
1.3k
DR_disaster_recovery_環境について考えていますか_.pdf
koyapig
0
240
Oracle_Cloudによる_Database環境づくりの事始め.pdf
koyapig
1
170
Oracle環境をより早く作るには
koyapig
0
1k
Other Decks in Technology
See All in Technology
Periodic Multi-Agent Path Planning
hziwara
0
110
マイクロサービス宣言から8年 振り返りとこれから / Eight Years After the Microservices Declaration A Look Back and A Look Ahead
eisuke
2
160
NGINXENG JP#2 - 1-NGINX-エンジニアリング勉強会-きょうの見どころ
hiropo20
0
110
PCI DSS に準拠したシステム開発
yutadayo
0
310
SPA・SSGでSSRのようなOGP対応!
simo123
2
150
オブザーバビリティのベストプラクティスと弥生の現状 / best practices for observability and YAYOI’s current state
yayoi_dd
0
100
Hatena Engineer Seminar #23 「チームとプロダクトを育てる Mackerel 開発合宿」
arthur1
0
520
インフラ技術基礎勉強会 開催概要
toru_kubota
0
170
Bill One 開発エンジニア 紹介資料
sansantech
PRO
0
120
Oktaの管理者権限を適切に移譲してみた
shimosyan
2
270
WebLogic Server for OCI 概要
oracle4engineer
PRO
3
880
あつめたデータをどう扱うか
skrb
2
160
Featured
See All Featured
Happy Clients
brianwarren
90
5.8k
Faster Mobile Websites
deanohume
295
29k
Side Projects
sachag
451
37k
The Brand Is Dead. Long Live the Brand.
mthomps
48
2.9k
Support Driven Design
roundedbygravity
88
8.9k
Building Better People: How to give real-time feedback that sticks.
wjessup
346
17k
Debugging Ruby Performance
tmm1
67
11k
Embracing the Ebb and Flow
colly
75
3.6k
Fontdeck: Realign not Redesign
paulrobertlloyd
74
4.3k
The World Runs on Bad Software
bkeepers
PRO
59
5.7k
Atom: Resistance is Futile
akmur
256
24k
Streamline your AJAX requests with AmplifyJS and jQuery
dougneiner
128
8.8k
Transcript
σʔλϕʔεͷDRڥΛORACLE CLOUD ্ʹཱͯͯΈͨ Oistudy #5 - GAUSS͞ΜͱΦΠϥେͷOracleCloud 1 Masashi Koyasu
ࣗݾհ ࢠ҆ɹਖ਼࢙ʢMasashiɹKoyasuʣ @koyapig ΦΠγοΫεɾϥɾେגࣜձࣾ Oracle / MySQL / PostgreSQL /
ͦͷଞ DBA4 ~ SRE2~ 2
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
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 ཁ͢Δʹɾɾɾ ࡂͳͲʹΑΓɺαʔόʔ͕ ͍͜ͱʹͳͬͨ࣌ʹૣٸʹ෮چͰ ͖ΔΑ͏උ͑Δ͜ͱ
About RPO & RTO ඪ෮چ࣌(Recovery Point Objective) ͍ͭ࣌ͷσʔλ·ͰͤΔͷ͔ ඪ෮چ࣌ؒ(Recovery Time
Objective) ͍ͭ·ͰʹʢԿ࣌ؒͰʣ෮چͰ͖Δͷ͔ 5
എܠ ۙɺຖͷΑ͏ʹࣗવࡂ͕ൃੜ͍ͯ͠Δ طʹDRڥ͋Δ͕ɺສશͳͷͰͳ͍ ࡂ࣌ʹαʔϏεҡ࣋Ͱ͖ΔΈʹ৽͢Δ 6
త ҰҊͱͯ͠ฐࣾͷDRڥΛͬͯ΄͍͠ ฐࣾͷOracle Cloudͷ͍ํ DRڥΛߏ͍ͯ͠ΔιϑτΣΞ 7
ͳͥDRඞཁͳͷ͔ ࡂ࣌ͷૣظ෮چͷͨΊͷରࡦ σʔλͷܽଛ͕ͳ͍Α͏ʹ͢ΔͨΊͷରࡦ ͓٬༷ͷӨڹΛ࠷খݶʹ͑ΔͨΊͷରࡦ (※)RPO, RTOʹج͖ͮ෮چͰ͖ΔΑ͏ʹ͢Δ 8
ࣗࣾͷDRڥେৎͰ͔͢ʁ
γεςϜશମ૾ʢࢀߟʣ On-Premises Cloud-VM ECαʔόʔ جװܥαʔόʔ ྲྀܥαʔόʔ • ECαΠτɺجװܥγεςϜɺྲྀܥγεςϜ…etcΛࣗࣾߏ ஙɾӡ༻ •
αʔόʔओཁαʔόʔ͚ͩͰ20 • Ұ෦Λআ͖શͯͷॲཧͰOracle Database͕ΘΕ͍ͯΔ όοναʔόʔ 11gR2 SE 2node RAC 10
͜Ε·ͰͷDRڥ - ߏ On-Premises(ຊ൪) Archive Logs Full Backup File Amazon
S3 Archive Logs AWS EC2(DR) temp area ECαʔόʔ جװܥαʔόʔ11 ᶃ ᶄ ᶅ ᶆ ᶇ
͜Ε·ͰͷDR - ՝ DBͷࠩಉظ͕ͪΐͪ͘ΐࣦ͘ഊ ىಈʢOPENʣͰ͖Δ͔͕Θ͔Βͳ͍ ӡ༻͕ଐਓԽ͍ͯ͠Δ͔Β୲ऀͷෛ୲ ͕͍͢͝ 12
͜Ε·ͰͷDRڥ - ߏ Archive Logs Full Backup File Amazon S3
Archive Logs AWS EC2(DR) temp area ECαʔόʔ جװܥαʔόʔ 13 On-Premises(ຊ൪)
৽͍͠DRڥ - ඞཁͳཁ݅ Standard EditionʢOracle DatabaseͷEditionʣͰͰ͖Δ͜ͱ σʔλࢀর͕Ͱ͖Δ͜ͱʢಉظঢ়گͷ֬ೝʣ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔ͕Ͱ͖Δ͜ͱ ӡ༻͕ଐਓԽ͠ͳ͍͜ͱ ίετΛͳΔ͑͘Δ͜ͱ
14
৽͍͠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(ຊ൪)
৽͍͠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(ຊ൪)
৽͍͠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(ຊ൪)
৽͍͠DRڥ - Platform Platform Oracle Could InfrastructureʢOCIʣ Bare Metal, VM,
and ExadataʢDBaaSʣ Compute Block Volume Object Storage 18
৽͍͠DRڥ - Platform 19 OCI AWS DATABASE DBaaS RDS SERVER
Compute EC2 DISK Block Volume EBS STORAGE Object Storage S3
৽͍͠DRڥ - Software Software Dbvisit Standby Oracle Database͚ࡂରࡦιϑτΣΞ 20
৽͍͠DRڥ - Dbvisitͱ Dbvisit͕ࣾఏڙ͍ͯ͠ΔOracle Database͚σΟβελϦ ΧόϦιϑτΣΞ ࠓճ૯ཧళͷInsight Technology༷͔Βߪೖɾαϙʔτ Enterprise Editionͷ(※)Data
GuardͷସҊͱͯ͠࡞ΒΕͨ ιϑτΣΞɻػೳॆ࣮͓ͯ͠ΓɺैདྷͷOracleʹ ൺ҆ՁͰಋೖՄೳɻ 21
ิɿAbout Data Guard ओʹσʔλอޢΛతͱͨ͠ϨϓϦέʔ γϣϯػೳ ෳͷಉظϞʔυΛඋ͑ΔʢಡΈऔΓઐ ༻/ॻ͖ࠐΈՄೳʣ 22
৽͍͠DRڥ - OCIΛ͏ཧ༝ DBaaSଞͷManagedDBͱҧ͍VMʹssh ଓͰ͖Δ ଞCloudΛ͏ΑΓOracleͷϥΠηϯεί ετͷݮ͕Մೳ 23
৽͍͠DRڥ - DbvisitΛ͏ཧ༝ Standard EditionͰDataGuardʹ͍ۙػೳ͕҆ՁͰར༻Մೳ ಡΈऔΓઐ༻ͰDBΛىಈ(OPEN)͢Δ͜ͱͰσʔλࢀর ͕Մೳ ಉظঢ়ଶʹͯࠩ͠ಉظ࠶։͕Մೳ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔ͕༰қ GUI͕͑Δ͜ͱͰӡ༻ʹDBAҎ֎ͰରԠՄೳ
24
৽͍͠DRڥ - ຊߏͷϝϦοτ DbvisitΛ͏͜ͱʹΑΓ՝Λղফ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔͳͲͷ ࡞ۀ͕ʢ࠷ѱͷ߹ʣDBAҎ֎ͰରԠՄೳ Oracle Cloud & DbvisitΛ͏͜ͱʹΑΓɺϥ
ΠηϯείετΛେ෯ݮ͕Մೳ 25
ࢀߟ·Ͱʹ - ίετ ڥ ͜Ε·ͰͷDR ڥ ৽͍͠DR ڥ ࠩ ʢ৽ن
- ͜Ε·Ͱʣ DB ********** ********** ▼51% DBVISIT (ϥΠηϯεඅ) ********** ********** ˛ DBVISIT (อकඅ) ********** ˛ ߹ܭ ********** ********** ▼19% 26
తʢ࠶ܝʣ ҰҊͱͯ͠ฐࣾͷDRڥΛͬͯ΄͍͠ ฐࣾͷOracle Cloudͷ͍ํ DRڥΛߏ͍ͯ͠ΔιϑτΣΞ 27
We are hiringʂ ΦΠγοΫεɹ࠾༻ https://recruit.oisixradaichi.co.jp/ 28
Thank You!! ࣭͋͝Γ·ͨ͠Βɺ͓ؾܰʹDM͍ͩ͘͞ʂ @koyapig