Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
jtf_2019_データベースのDR環境をoracle_cloud上に立ててみた.pdf
koyapig
December 08, 2019
Technology
0
1.3k
jtf_2019_データベースのDR環境をoracle_cloud上に立ててみた.pdf
koyapig
December 08, 2019
Tweet
Share
More Decks by koyapig
See All by koyapig
データベースのDR環境をORACLE_CLOUD上に立ててみた.pdf
koyapig
0
1k
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
NGINXENG JP#2 - 3-NGINX Plus・プロダクトのアップデート
hiropo20
0
190
FlexScan HD2452Wの 後継を探して
tring
0
5.7k
230125 モニターマウントLT ITガジェット翁(Ryu.Cyber)さん
comucal
PRO
0
4.3k
ChatGPT for Hacking
anugrahsr
0
3.4k
SPA・SSGでSSRのようなOGP対応!
simo123
2
150
Oktaの管理者権限を適切に移譲してみた
shimosyan
2
260
ステート管理を超えるRecoil運用の考え方
uhyo
7
5.6k
DNS権威サーバのクラウドサービス向けに行われた攻撃および対策 / DNS Pseudo-Random Subdomain Attack and mitigations
kazeburo
5
1.2k
2022年に起きたフロントエンドの変化
sakito
29
17k
「一通りできるようになった」その先の話
hitomi___kt
0
100
もし本番ネットワークをまるごと仮想環境に”コピー”できたらうれしいですか? / janog51
corestate55
0
330
スクラム導入して変わったチーム、組織のありかた
yumechi
0
120
Featured
See All Featured
The Invisible Customer
myddelton
113
12k
It's Worth the Effort
3n
177
26k
Teambox: Starting and Learning
jrom
124
7.9k
ParisWeb 2013: Learning to Love: Crash Course in Emotional UX Design
dotmariusz
101
6.2k
A better future with KSS
kneath
230
16k
Bootstrapping a Software Product
garrettdimon
299
110k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
224
50k
No one is an island. Learnings from fostering a developers community.
thoeni
12
1.5k
Adopting Sorbet at Scale
ufuk
65
7.8k
Keith and Marios Guide to Fast Websites
keithpitt
407
21k
A Modern Web Designer's Workflow
chriscoyier
689
180k
Building Better People: How to give real-time feedback that sticks.
wjessup
346
17k
Transcript
σʔλϕʔεͷDRڥΛORACLE CLOUD ্ʹཱͯͯΈͨ July Tech Festa 2019 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ʹ͍ͭͯߟ͑Δ࣌ؒʹ͍ͨ͠ ҰҊͱͯ͠ฐࣾͷ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ʹ͍ͭͯߟ͑Δ࣌ؒʹ͍ͨ͠ ҰҊͱͯ͠ฐࣾͷDRڥΛͬͯ΄͍͠ 27
We are hiringʂ ΦΠγοΫεɹ࠾༻ https://recruit.oisixradaichi.co.jp/ 28
Thank You!! ࣭͋͝Γ·ͨ͠Βɺ͓ؾܰʹDM͍ͩ͘͞ʂ @koyapig