Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
オンプレ to オンプレした話/on-premises2on-premises
Taiju Aoki
August 28, 2020
Programming
0
2.3k
オンプレ to オンプレした話/on-premises2on-premises
M3 techtalk
https://m3-engineer.connpass.com/event/186277/
Taiju Aoki
August 28, 2020
Tweet
Share
More Decks by Taiju Aoki
See All by Taiju Aoki
本番運用中 Oracle を破壊してしまった話 ~ 破壊と創世 ~ / Oracle Destruction and Creation
blue0513
0
2.2k
GitもCIもテストもないプロジェクトでデプロイを自動化するまでの道 / rebuild of DevOps
blue0513
0
2.4k
Git & GitLab & コードレビューって? / about Git, GitLab, CodeReview
blue0513
0
120
ElectronでSlackをさらに便利にしちゃう / Slack with Electron
blue0513
3
430
GitHub の README をいい感じにする / Cool Readme
blue0513
3
1.4k
Emacs × Sound やってみた / Emacs with Sound
blue0513
2
690
Slack を TweetDeck にしてみた件 / slackdeck-proto
blue0513
1
2.4k
知ってるとお得な iTerm2 と zsh/bash の小技
blue0513
3
600
クラウド電子カルテを支える魂の技術
blue0513
0
2k
Other Decks in Programming
See All in Programming
OIDC仕様に準拠した Makuake ID連携基盤構築の裏側
ymtdzzz
0
500
Quarto Tips for Academic Presentation
nicetak
0
910
PHPアプリケーションにおけるアーキテクチャメトリクスについて / Architecture Metrics in PHP Applications
isanasan
1
230
監視せなあかんし、五大紙だけにオオカミってな🐺🐺🐺🐺🐺
sadnessojisan
2
1.4k
How to Fight Production Incidents?
asatarin
0
190
Findy - エンジニア向け会社紹介 / Findy Letter for Engineers
findyinc
2
42k
AWSとCPUのムフフな関係
cmdemura
0
460
Remote SSHで行うVS Codeリモートホスト開発とトラブルシューティング
smt7174
1
460
ITエンジニア特化型Q&Aサイトteratailを 言語、DB、クラウドなど フルリプレイスした話
leveragestech
0
400
NGK2023S - OCaml最高! スマホ開発にも使えちゃう?!
haochenxie
0
120
量子コンピュータ時代のプログラミングセミナー / 20230119_Amplify_seminar _shift_optimization
fixstars
0
180
Step Functions Distributed Map を使ってみた
codemountains
0
100
Featured
See All Featured
What the flash - Photography Introduction
edds
64
10k
Automating Front-end Workflow
addyosmani
1351
200k
The Invisible Side of Design
smashingmag
292
48k
Atom: Resistance is Futile
akmur
256
24k
Agile that works and the tools we love
rasmusluckow
320
20k
How GitHub (no longer) Works
holman
298
140k
Docker and Python
trallard
30
1.9k
Statistics for Hackers
jakevdp
785
210k
Building an army of robots
kneath
301
40k
Robots, Beer and Maslow
schacon
154
7.3k
Thoughts on Productivity
jonyablonski
49
2.7k
Making the Leap to Tech Lead
cromwellryan
117
7.7k
Transcript
ΦϯϓϨ to ΦϯϓϨͨ͠ @blue_1617
ࢲ୭ʁ blue (@blue_1617) https://blue0513.github.io/show_room/ 2 ‣ ΨʔϦΟϨίʔυνϟϯωϧ ‣ ࠷ۙͬͯΔ͜ͱ /
ϋϚ͍ͬͯΔ͜ͱ ‣ ϙέϞϯιʔυ&γʔϧυ ‣ Magic: The Gathering ‣ ࣍ʹΓ͍ͨ͜ͱ ‣ Fall Guys
͜ͷൃදʁ 3 ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ AWS GCP Terraform Cloud Azure Ansible Digdag
MicroService ʢM3ͷάϧʔϓձࣾʣ
͜ͷൃදʁ 4 ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ AWS GCP Terraform Cloud Azure Ansible Digdag
MicroService ग़͖ͯ·ͤΜɻѱ͔͠Βͣ ʢM3ͷάϧʔϓձࣾʣ
͜ͷൃදʁ 5 ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ ֎ઌ ΦϯϓϨ ֤छΞϓϦ ࣾ ཧ
͜ͷൃදʁ 6 ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ ֎ઌ ΦϯϓϨ ΦϯϓϨ ࣾ VM
7 ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ Batchॲཧαʔό ໊دͤॲཧαʔό Database ΞϓϦέʔγϣϯ Windows αʔό Oracle SE
11g Windows Forms .bat .exe = = = JP1 αʔό ͜ͷൃදʁ
8 ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ ͜ͷൃදʁ ֎ઌ ΦϯϓϨ ϓϩδΣΫτ։࢝: 4݄ Ϧϛοτ: 9݄ॳ० ओཁϝϯόʔ:
4ਓ Ϛωʔδϟ * 1 Πϯϑϥ * 1 ΞϓϦ * 2 Ҡߦͷརӹ: Nઍສԁ/
9 ͬ͘͟ΓΠϯϑϥߏਤ ຊ൪ ݕূ Batch ໊دͤ JP1 ڞ༗σΟϨΫτϦA ڞ༗σΟϨΫτϦB Batch
໊دͤ JP1 ΦϑΟε
10 ͬ͘͟ΓΠϯϑϥߏਤ ຊ൪ ݕূ Batch ໊دͤ JP1 ڞ༗σΟϨΫτϦA ڞ༗σΟϨΫτϦB Batch
໊دͤ JP1 ΦϑΟε
11 ͬ͘͟ΓΠϯϑϥߏਤ ຊ൪ ݕূ Batch ໊دͤ JP1 ڞ༗σΟϨΫτϦA Batch/DB ໊دͤ
ΦϑΟε
࡞ઓ
13 ࡞ઓ 1. ԶɺݕূڥΛɺࣺͯΔ 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ
4. Γସ͑ 5. ݱ࣮
1. ԶɺݕূڥΛɺࣺͯΔ
15 1. ԶɺݕূڥΛɺࣺͯΔ ݕূڥͱຊ൪ڥͰ ‣ αʔόͷ ‣ αʔόͷछྨ ‣ ωοτϫʔΫ
͕ҟͳ͍ͬͯͨ 1. ݕূڥΛҠߦͯ͠ɺϊϋΛஷΊͯຊ൪Ҡߦ 2. ݕূڥΛຊ൪ڥͱಉ͡ߏʹ͔ͯ͠ΒҠߦ
16 1. ԶɺݕূڥΛɺࣺͯΔ ݕূڥͱຊ൪ڥͰ ‣ αʔόͷ ‣ αʔόͷछྨ ‣ ωοτϫʔΫ
͕ҟͳ͍ͬͯͨ ݕূڥͷҠߦϊϋຊ൪Ͱʹཱͨͳ͍ & Ҡߦʹ͔͚ΒΕΔ͕࣌ؒগͳ͍ ݕূڥஔ͍ͱ͍ͯɺຊ൪ڥ͔ΒΔͧ
17 1. ԶɺݕূڥΛɺࣺͯΔ clone ֤ͨ͠αʔόʔΛผ Host ໊ʹͯ͠ಈ࡞ݕূʢޙड़ʣ ͱ͍͑ɺຊ൪ҰൃΤΠϠͰͳ͍ ֎ઌ ΦϯϓϨ
ΦϯϓϨ ࣾ VM P2V ཧ
2. ωοτϫʔΫɺݽཱɺःஅͯ͠
19 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ ֎ઌ Batch ໊دͤ JP1 ΦϑΟε
20 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 ΦϑΟε P2V ֎ઌ
21 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 ΦϑΟε Batch ໊دͤ JP1
֎ઌ
22 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 ΦϑΟε Batch 2 ໊دͤ
2 JP1 2 DB 2 DB ϗετ໊Λมߋ ֎ઌ
23 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch εέδϡʔϦϯάδϣϒ: ͋Δ....͔͠Εͳ͍ʁ τϦΨʔ: ͋Δ....͔͠Εͳ͍ʁ JP1 ͋ͬͨ͠߹ɺՔಇதຊ൪DBʹมߋΛՃ͔͑Ͷͳ͍
Digdag Jenkins తͳΦʔτϝʔγϣϯπʔϧ Կ͕ಈ͍ͯΔ͔ਖ਼Θ͔ΒΜ....... ෳࡶͳδϣϒͨͪ Կ͕͍ͭಈ͍ͯΔ͔Θ͔ΒΜ http://itdoc.hitachi.co.jp/manuals/3020/30203S0933/AJSV0099.HTM
24 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 Batch 2 ֎ઌ ΦϑΟε
JP1 2
25 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ https://www.rakuten.ne.jp/gold/trycycle/smart/basic06.html
26 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ https://www.rakuten.ne.jp/gold/trycycle/smart/basic06.html αʔόʔΛਫʹΊͯ Ͳ͔͜Β௨৴͕࿙ΕͯΔ͔Λ ֬ೝ͢Δ
27 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2
JP1 2 DB 2 DB ωοτϫʔΫ͔Βݽཱͤ͞Δ
28 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ http://www.pc2.jp/tips/err_log.html ֎ʹΞΫηε͠Α͏ͱ͢ΔϓϩηεɺΤϥʔϩάʹه͞ΕΔ ดωοτʹΊͨΒΤϥʔϩάΛ֬ೝͯ҆͠શΛ֬ೝ ʢΤϥʔͰͯͳ͍͔ΒDBʹΞΫηε͠ͳ͍ żŢ!!ʣ
29 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2
JP1 2 DB 2 DB ֬ೝޙɺΕͯυϝΠϯࢀՃ
3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ
31 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2
໊دͤ 2 JP1 2 DB 2 DB
32 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2
໊دͤ 2 JP1 2 DB 2 DB https://www.itmedia.co.jp/enterprise/articles/0910/14/news003.html Host ໊Ͱδϣϒ࣮ߦ
33 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2
໊دͤ 2 JP1 2 DB 2 DB SET DB_HOST = ຊ൪DB SET SERVER = ຊ൪SERVER DELETE * FROM FOO; # BT01002Batch.exe, .bat etc ڥมॻ͖
34 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2
໊دͤ 2 JP1 2 DB 2 DB SET DB_HOST = ຊ൪DB SET SERVER = ຊ൪SERVER DELETE * FROM FOO; # BT01002Batch.exe, .bat etc ڥมॻ͖ Ͳͷ .exe Λୟ͘ͱຊ൪ʹӨڹ͋Δͷ͔Θ͔ΒΜɻ͜Θ͍
35 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ C:\Windows\System32\drivers\etc\hosts http://www.obenri.com/_dnsserver/hosts_file.html
36 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ C:\Windows\System32\drivers\etc\hosts http://www.obenri.com/_dnsserver/hosts_file.html 127.0.0.1 Քಇதຊ൪DB 127.0.0.1
Քಇதຊ൪Server1 127.0.0.1 Քಇதຊ൪Server2 127.0.0.1 Քಇதຊ൪Server3 ؔαʔόʔΛͯ͢ϩʔΧϧϗετΛ͚ͯ͠·͏
37 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2
໊دͤ 2 JP1 2 DB 2 DB https://www.itmedia.co.jp/enterprise/articles/0910/14/news003.html IP Λ͝·͔ͯ͠ΔͷͰ ϩʔΧϧϗετΛݟʹߦ͘
38 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2
໊دͤ 2 JP1 2 DB 2 DB 127.0.0.1ͷน
39 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch 2 ໊دͤ 2 JP1
2 DB 2 127.0.0.1ͷน ૄ௨֬ೝ Ϣʔβݖݶ ੑೳࢼݧ ֤छ࣮ݧ DB exp/imp
4. Γସ͑
41 4. Γସ͑ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2
JP1 2 DB 2 DB 127.0.0.1ͷน ωοτϫʔΫΓ͠
42 4. Γସ͑ Batch 2 ໊دͤ 2 JP1 2 DB
2 127.0.0.1ͷน
43 4. Γସ͑ Batch ໊دͤ JP1 DB 127.0.0.1ͷน ϗετ໊मਖ਼
44 4. Γସ͑ Batch ໊دͤ JP1 DB นͷఫഇ # 127.0.0.1
Քಇதຊ൪DB # 127.0.0.1 Քಇதຊ൪Server1 # 127.0.0.1 Քಇதຊ൪Server2 # 127.0.0.1 Քಇதຊ൪Server3
45 4. Γସ͑ Batch ໊دͤ JP1 DB
46 4. Γସ͑ ֎ઌ Batch ໊دͤ JP1 ΦϑΟε Batch ໊دͤ
JP1 ֎ઌͷΦϯϓϨαʔόʔ͔Β ࣗࣾͷΦϯϓϨαʔόʔʹΓସ͑ΒΕͨ
47 4. Γସ͑ ྃʂʂ
5. ݱ࣮
49 5. ݱ࣮ ‣ ݕূதʹຊ൪DBʹରͯ͠δϣϒ࣮ߦͪ͠Όͬͨ ‣ ҠߦޙॳɺDBͷҰҙΩʔ੍Ͱ Error ‣ ҠߦޙॳɺFTPΫϥΠΞϯτͷόάͰग़ྗ
0 ‣ ݕূڥ·ͩҠߦͯ͠ͳ͍ and more ..... JP1ͰεέδϡʔϦϯάδϣϒͷରαʔό: null ʹઃఆ ରαʔό: null == JP1αʔόʔࣗ ͳͷͰɺࣗʹରͯ͠δϣϒൃߦ ڞ༗αʔόͷ exe Λୟ͍ͯຊ൪DBͷεΩʔϚ Drop ͠Α͏ͱͯͨ͠ʢfail ͨ͠ʣ Oracle ७ਖ਼ͷ export/import πʔϧͰ DB ΛϑϧϦετΞ SequenceObject Λ Overwrite Ͱ͖ͣɺݹ͍ Sequence ͕Δ next val Ͱࢦఆ͞ΕΔ id ʹ͢ͰʹϨίʔυ͕ଘࡏͯ͠Δʢखಈ inc ͨ͠ʣ Windows ଆͷόάɻύονΛͯΔͱͬͨɻ͔ͦ͜Α
ৼΓฦΓ
51 ৼΓฦΓ ‣ ຊ൪ͱΠϯϑϥߏΛἧ͑ͨݕূڥΛ༻ҙ͢Δ ‣ ࣗಈςετΛ࡞Δ ‣ JP1 ΛΊΔ ‣
࠷ॳ͔Βผ෦ॺͷਓؒΛר͖ࠐΜͰҠߦΛਐΊΔ ‣ ຊ൪ڥͰӨڹൣғʹؾΛ͚ͭͳ͕Β࡞ۀ͢Δͷຊʹ͖͍ͭ ‣ υϝΠϯ͕ࣝͳ͍ঢ়ଶͰಈ͔͢ͱຊʹ͙͢ʹোʹͳΔ ‣ ҰݸҰݸख࡞ۀͰ֬ೝ͢Δͷຊʹਫ਼ਆతʹͭΒ͍ ‣ ୀ۶ͳ͜ͱίϯϐϡʔλʹΒͤΕΑΖ͍͠ ‣ ͳΜΘ͔ΒΜ ‣ ԿΛීஈͷۀͰಈ͔ͯ͠ɺͲ͏֬ೝ͢Ε͍͍ͷ͔Θ͔ΒΜ ‣ ࣄऀΛר͖ࠐΜͰQAͳΓܭըͳΓ࿈བྷͳΓऔͬͨํ͕ૣ͍
52 ৼΓฦΓ ‣ υϝΠϯࣝΛ͖ͪΜͱ͚ͭΔ ‣ ؔΘͬͯ͘Εͨօ͞Μʹײँ͔͠ͳ͍ ‣ υϝΠϯ͕ࣝͳ͍ঢ়ଶͰಈ͔͢ͱຊʹ͙͢ʹোʹͳΔ ‣ αʔόʔͷಈ࡞֬ೝܭըΛϝΠϯͰ୲͚ͨ͠ͲɺΠϯϑϥͷ
ํͷര࡞ۀϚωʔδϟͷํͷυϝΠϯࣝɺϕςϥϯEngͷ ΞυόΠεʹຊʹॿ͚ΒΕ·ͨ͠ ‣ Πϯϑϥ as ίʔυ is ΊͬͪΌ important ‣ ͜ͷαʔόͰԿ͕ಈ͘ͷ͔Βͷௐࠪຊʹେม ‣ ख࡞ۀͰ /etc/hosts ॻ͖͑ͨΓ tnsnames.ora ॻ͖͑ͨΓ config ॻ͖͑ͨΓωοτϫʔΫ͍ͬͨ͡Γຊʹ͖͍ͭ ‣ ϨϏϡʔͰ͖Δɺঢ়ଶ͕ݟ͑Δঢ়ଶͰΔɺຊʹେࣄ
53 to be continued .....