Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
mysql_replication
Search
mamy1326
April 20, 2017
Programming
0
170
mysql_replication
MySQLサーバーを複製し、私が死んでも代わりは(略)するお話
mamy1326
April 20, 2017
Tweet
Share
More Decks by mamy1326
See All by mamy1326
PHPer が知るべき MySQL クエリチューニング/What PHPers Need to Know about MySQL Query Tuning
mamy1326
17
6.7k
戦って品質保証を勝ち取る/Fight_for_quality_assurance
mamy1326
2
640
MySQLでGROUP BY と ORDER BY を同時に使いたくなったら/If_you_want_to_use_GROUP_BY_and_ORDER_BY_at_the_same_time_in_mysql
mamy1326
4
4.9k
初めてのMySQLパフォーマンスチューニングーデータベースは怖くない!/mysql-performance-tuning-basics-in-db-study-chugoku-chiho
mamy1326
8
2.4k
アウトプットを継続するためにやる10箇条-吉祥寺.pm-/10_things_practicing_to_continue_output-in_kichijoji.pm
mamy1326
4
1.9k
MySQLパフォーマンスチューニングの基本ー実際のトラブルシュートから my.cnf までー/MySQL_Performance_Tuning_Basics_in_OSC_Niigata
mamy1326
2
3.2k
アウトプットを継続するためにやっている 10 のこと/10_things_practicing_to_continue_output
mamy1326
21
9.3k
アプリケーションエンジニアが知るべきDNSの基本/Basics_of_DNS_that_application_engineers_should_know
mamy1326
112
46k
dns-penetration-problem-why-can-not-i-say-penetration-kichijojipm15
mamy1326
5
3.3k
Other Decks in Programming
See All in Programming
GitHub Actionsで泣かないためにやっておきたい設定 / Recommended GHA settings to avoid crying
pinkumohikan
3
490
TYPO3 v13 – The road to LTS: What's new and new APIs
luisasofie_xoxo
0
180
チーム力を高めるスクラム実践法:カンバン公開と課題攻略について - ニフティのスクラムトーク Vol. 2 - NIFTY Tech Talk #18
niftycorp
PRO
1
110
SpringBoot+MyBatisで例外が出たときどこを見るか
syukai
0
110
StreamlitとTerraformでデータカタログを作った話
gussan0223
0
300
1BRC--Nerd Sniping the Java Community
gunnarmorling
0
300
Ruby GitHub Packages
bkuhlmann
0
620
Ruby Function Composition
bkuhlmann
1
330
PHPの次期バージョンはこの時期どうなっているのか - Internalsの開発体制について - PHPカンファレンス小田原
youkidearitai
PRO
1
180
Netty Chicago Java User Group 2024-04-17
sullis
0
120
Ruby Pattern Matching
bkuhlmann
0
920
今、知っておきたい! 生成AIエージェントの世界
elith
3
340
Featured
See All Featured
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
76
41k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
154
14k
The Pragmatic Product Professional
lauravandoore
24
5.8k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
39
4.4k
Unsuck your backbone
ammeep
662
57k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
119
38k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
356
22k
Fontdeck: Realign not Redesign
paulrobertlloyd
76
4.9k
5 minutes of I Can Smell Your CMS
philhawksworth
199
19k
How to Ace a Technical Interview
jacobian
272
22k
Statistics for Hackers
jakevdp
789
220k
What the flash - Photography Introduction
edds
64
11k
Transcript
.Z42-αʔόʔΛ ϨϓϦέʔγϣϯ Λ࣮ߦ͢Δ͓ ·Έͳ͓͖ !NBNZ "QS !ୈճ1)1ษڧձˏ౦ژ
.Z42- Λ ෳ ͠ αʔόʔ 1)1ษڧձ!౦ژୈ ࢲ͕ ˓ΜͰ ΘΓ
ུ ͢Δ ͓ ·ΈͳϮ͖ !NBNZ
ࠓͷςʔϚ ࢲͷΘΓ ͍͘ΒͰ͍ΔΘ ͱݴͬͯ
ࠓͷςʔϚ ࣮ࡍ ࢮΜͩΒऴΘΔ .Z42-Λ
ࠓͷςʔϚ ෳ ϨϓϦέʔγϣϯ ͢Δ͓
ྐྵ݄
ϑΝʔετ ΠϯύΫτ
NZDOG͕ σϑΥϧτ
લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕͘ʂ ⾣ϝϞϦ͕దʹΘΕΔΑ͏ʹʂ
લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕͘ʂ ⾣ϝϞϦ͕దʹΘΕΔΑ͏ʹʂ
લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕͘ʂ ⾣ϝϞϦ͕దʹΘΕΔΑ͏ʹʂ
લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕͘ʂ ⾣ϝϞϦ͕దʹΘΕΔΑ͏ʹʂ
ྐྵ݄
ηΧϯυ ΠϯύΫτ
՝
՝ Ϛελʔ͕ࢮ͵ͱ σʔλ͕શ෦ࢮ͵
՝ Ϛελʔ͕ࢮ͵ͱ σʔλ͕શ෦ࢮ͵
՝ Ϛελʔ͕ࢮ͵ͱ σʔλ͕શ෦ࢮ͵ ·͔͞ͷ େരൃ
ෳ Ϛελʔ͔͠ͳ͍ ݱঢ়ʹ εϨʔϒΛ࡞Γ
ෳ ϨϓϦέʔγϣϯ ΛՔಇ͠·͢
ɹϨϓϦέʔγϣϯͱ
ɹϨϓϦέʔγϣϯͱ ⾣σʔλϕʔεશମͷෳ ϨϓϦΧ ⾣ผͷαʔόʔʹෳʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ
ɹϨϓϦέʔγϣϯͱ ⾣σʔλϕʔεશମͷෳ ϨϓϦΧ ⾣ผͷαʔόʔʹෳʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ
ɹϨϓϦέʔγϣϯͱ ⾣σʔλϕʔεશମͷෳ ϨϓϦΧ ⾣ผͷαʔόʔʹෳʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ
ɹϨϓϦέʔγϣϯͱ ⾣σʔλϕʔεશମͷෳ ϨϓϦΧ ⾣ผͷαʔόʔʹෳʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ
ߏ Ϛελʔ ʢ୯Ұʣ εϨʔϒ ʢʣ εϨʔϒ ʢOʣ ɾɾɾ
Ϛελʔ
Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨ ⾣ෳͷεϨʔϒΛ࣋ͯΔ
Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨ ⾣ෳͷεϨʔϒΛ࣋ͯΔ
Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨ ⾣ෳͷεϨʔϒΛ࣋ͯΔ
Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨ ⾣ෳͷεϨʔϒΛ࣋ͯΔ
εϨʔϒ
εϨʔϒ ⾣ߋ৽༻Ͱͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽༰Λ%#ʹө ⾣ͭͷϚελʔͷΈ࣋ͯΔ
εϨʔϒ ⾣ߋ৽༻Ͱͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽༰Λ%#ʹө ⾣ͭͷϚελʔͷΈ࣋ͯΔ
εϨʔϒ ⾣ߋ৽༻Ͱͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽༰Λ%#ʹө ⾣ͭͷϚελʔͷΈ࣋ͯΔ
εϨʔϒ ⾣ߋ৽༻Ͱͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽༰Λ%#ʹө ⾣ͭͷϚελʔͷΈ࣋ͯΔ DPNNJUϩά *0εϨου
εϨʔϒ ⾣ߋ৽༻Ͱͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽༰Λ%#ʹө ⾣ͭͷϚελʔͷΈ࣋ͯΔ
εϨʔϒ ⾣ߋ৽༻Ͱͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽༰Λ%#ʹө ⾣ͭͷϚελʔͷΈ࣋ͯΔ DPNNJUϩάͷ 42-࣮ߦ 42-εϨου
εϨʔϒ ⾣ߋ৽༻Ͱͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽༰Λ%#ʹө ⾣ͭͷϚελʔͷΈ࣋ͯΔ
ϝϦοτ ⾣ࢀর 4&-&$5 ੑೳͷ্ ݕࡧॲཧ͕ॏ͍߹ εϨʔϒΛࢀরܥʹͯ͠ ෛՙࢄ
ϝϦοτ ⾣ࢀর 4&-&$5 ੑೳͷ্ ݕࡧॲཧ͕ॏ͍߹ εϨʔϒΛࢀরܥʹͯ͠ ෛՙࢄ
ϝϦοτ ⾣ࢀর 4&-&$5 ੑೳͷ্ ݕࡧॲཧ͕ॏ͍߹ εϨʔϒΛࢀরܥʹͯ͠ ෛՙࢄ
ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏͷ࣮ݱ Ϛελʔোͷ߹ εϨʔϒΛϚελʔʹঢ֨ μϯλΠϜॖ
ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏͷ࣮ݱ Ϛελʔোͷ߹ εϨʔϒΛϚελʔʹঢ֨ μϯλΠϜॖ
ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏͷ࣮ݱ Ϛελʔোͷ߹ εϨʔϒΛϚελʔʹঢ֨ μϯλΠϜॖ
ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏͷ࣮ݱ Ϛελʔোͷ߹ εϨʔϒΛϚελʔʹঢ֨ μϯλΠϜॖ ͨͩ͠ɾɾɾ
ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏͷ࣮ݱ Ϛελʔোͷ߹ εϨʔϒΛϚελʔʹঢ֨ μϯλΠϜॖ ϑΣΠϧΦʔόʔ ࣗಈԽ ͷ Έ͕ඞཁ
ϝϦοτ ⾣όοΫΞοϓαʔόʔ εϨʔϒͰόοΫΞοϓ ϚελʔʹӨڹͳ͘ όοΫΞοϓऔಘ
ϝϦοτ ⾣όοΫΞοϓαʔόʔ εϨʔϒͰόοΫΞοϓ ϚελʔʹӨڹͳ͘ όοΫΞοϓऔಘ
ɹϨϓϦέʔγϣϯͷঢ়گ νϡʔχϯάલ ʹҰ Ϛελʔ͕μϯ͍ͯͨ͠
ɹϨϓϦέʔγϣϯͷঢ়گ νϡʔχϯάલ ʹҰ Ϛελʔ͕μϯ͍ͯͨ͠
ɹϨϓϦέʔγϣϯͷঢ়گ νϡʔχϯάલ ʹҰ Ϛελʔ͕μϯ͍ͯͨ͠
ɹϨϓϦέʔγϣϯͷঢ়گ Ϛελʔ࠶ىಈͷ εϨʔϒͷ ઃఆΛ͍ͯͨ͠͠
ɹϨϓϦέʔγϣϯͷঢ়گ Ϛελʔ࠶ىಈͷ εϨʔϒͷ ઃఆΛ͍ͯͨ͠͠
ɹϨϓϦέʔγϣϯͷঢ়گ Ϛελʔ࠶ىಈͷ εϨʔϒͷ ઃఆΛ͍ͯͨ͠͠ ͭΒ͍
ɹϨϓϦέʔγϣϯͷঢ়گ ͋·Γʹ໘Ͱ εϨʔϒΛ
ɹϨϓϦέʔγϣϯͷঢ়گ ͋·Γʹ໘Ͱ εϨʔϒΛ 4501ʂ
ͭ·Γ
ͭ·Γ ӡ༻͔Β ಀ͍͛ͯͨ
Ͱ
Ͱ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɻ
Ͱ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɻ
Ͱ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɻ
Ͱ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɻ
Ͱ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɻ
Ͱ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɺ ಀ͛ͪΌବͩɻ
͕ Γ·͢
ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ
ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ఆٛ ɹɾϚελʔଆʹ࡞ ɹɾεϨʔϒ͔Βଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ఆٛ ɹɾϚελʔଆʹ࡞ ɹɾεϨʔϒ͔Βଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ఆٛ ɹɾϚελʔଆʹ࡞ ɹɾεϨʔϒ͔Βଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ఆٛ ɹɾϚελʔଆʹ࡞ ɹɾεϨʔϒ͔Βଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣࣮ɾɾɾ ɹɹϚελʔଆͷطଘϢʔβʔͰ ɹɹଓ͕Մೳ ͔͠͠ɾɾɾ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣࣮ɾɾɾ ɹɹϚελʔଆͷطଘϢʔβʔͰ ɹɹଓ͕Մೳ ͔͠͠ɾɾɾ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ TVEPDBUWBSMJCNZTRMNBTUFSJOGP NZTRMCJO <Ϛελʔͷ*1ΞυϨε·ͨϗετ໊> <Ϛελʔʹଓ͢ΔNZTRMϢʔβʔ໊> <Ϛελʔʹଓ͢ΔNZTRMύεϫʔυ>
ʜ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ TVEPDBUWBSMJCNZTRMNBTUFSJOGP NZTRMCJO <Ϛελʔͷ*1ΞυϨε·ͨϗετ໊> <Ϛελʔʹଓ͢ΔNZTRMϢʔβʔ໊> <Ϛελʔʹଓ͢ΔNZTRMύεϫʔυ>
ʜ ଓใ͕ ϓϨʔϯςΩετ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ TVEPDBUWBSMJCNZTRMNBTUFSJOGP NZTRMCJO <Ϛελʔͷ*1ΞυϨε·ͨϗετ໊> <Ϛελʔʹଓ͢ΔNZTRMϢʔβʔ໊> <Ϛελʔʹଓ͢ΔNZTRMύεϫʔυ>
ʜ ηΩϡϦςΟͷͨΊ ઐ༻Ϣʔβ࡞
͜͏͍͏࣌ ͋Γ·ͤΜ͔ʁ
·͋ɺ ͍͍͡Όͳ͍Ͱ͔͢ ಈ͘Μ͔ͩΒ
ݴΘΕΕ Γ·͢Α
ऑ͍ ఒγϯδ Έ͍ͨͳࣗ ໓͠·͠ΐ͏
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣࡞ίϚϯυ NZTRM NBTUFS $3&"5&64&3 NZTRM NBTUFS `SFQM`!`<εϨʔϒͷϗετ໊>` NZTRM NBTUFS
*%&/5*'*&%#:1"44803%` `
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ݖݶίϚϯυ NZTRM NBTUFS (3"/53&1-*$"5*0/4-"7& NZTRM NBTUFS 0/ 50
NZTRM NBTUFS `SFQM`!`<εϨʔϒͷϗετ໊>`
ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ
ϚελʔͷNZDOG
ϚελʔͷNZDOG DPNNJUΛ௨ޙ εϨʔϒ͕ଓͯ͠औಘ WBSMJCNZTRM NZTRMCJO999999
ϚελʔͷNZDOG εϨʔϒ͔Βݟͨ Ϛελʔͷ*%
ϚελʔͷNZDOG ଟ͗͘͢͠Δͱ ετϨʔδѹഭ
ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ ⾣όΠφϦϩάͱҐஔใ ɹɾόΠφϦϩάͱ ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ ɹɾϩʔςʔτ͞ΕΔ ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ ɹɹɹˠҐஔใΛ֬ೝ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ ⾣όΠφϦϩάͱҐஔใ ɹɾόΠφϦϩάϑΝΠϧͱ ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ ɹɾϩʔςʔτ͞ΕΔ ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ ɹɹɹˠҐஔใΛ֬ೝ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ ⾣όΠφϦϩάͱҐஔใ ɹɾόΠφϦϩάϑΝΠϧͱ ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ ɹɾϩʔςʔτ͞ΕΔ ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ ɹɹɹˠҐஔใΛ֬ೝ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ ⾣όΠφϦϩάͱҐஔใ ɹɾόΠφϦϩάϑΝΠϧͱ ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ ɹɾϩʔςʔτ͞ΕΔ ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ ɹɹɹˠҐஔใΛ֬ೝ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:
mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec)
ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:
mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) DPNNJUΛ௨ޙ εϨʔϒ͕ଓͯ͠औಘ WBSMJCNZTRM NZTRMCJO999999
ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:
mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ϚελʔͰ DPNNJU͕࣮ߦ͞Εͨ ϙδγϣϯ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:
mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) εϨʔϒઃఆͰ༻͢ΔͨΊ ϝϞ͓͖ͯ͠·͠ΐ͏
⾣εϨʔϒΛ࡞Δࡍͷҙ ɹ௨ৗɺϚελʔΛࢭΊͯEVNQ͠ ɹಉҰͷঢ়ଶͰϦετΞͯ͠ ɹϑΝΠϧɾϙδγϣϯΛ߹ΘͤΔ ࠩͳ͘ϨϓϦέʔγϣϯ։࢝ ɹɹϚελʔόΠφϦϩάͷ֬ೝ
⾣εϨʔϒΛ࡞Δࡍͷݪଇ ɹ௨ৗɺϚελʔΛࢭΊͯEVNQ͠ ɹಉҰͷঢ়ଶͰϦετΞͯ͠ ɹϑΝΠϧɾϙδγϣϯΛ߹ΘͤΔ ࠩͳ͘ϨϓϦέʔγϣϯ։࢝ ɹɹϚελʔόΠφϦϩάͷ֬ೝ
ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ
ɹɹεϨʔϒͷઃఆ֬ೝ mysql> SHOW SLAVE STATUS\G **************** 1. row **************** Slave_IO_State:
Master_Host: [Ϛελʔͷϗετ໊] Master_User: repl Master_Log_File: mysql-bin.000009 Read_Master_Log_Pos: 303456264 Slave_IO_Running: No Slave_SQL_Running: No Seconds_Behind_Master: NULL Master_Server_Id: 0 1 row in set (0.01 sec)
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@4UBUFɿۭจࣈ ɹεϨʔϒͷݱࡏͷεςʔλε ɹϨϓϦέʔγϣϯ్͕Ε͍ͯΔͨΊ ɹۭจࣈͱͳ͍ͬͯΔ ࣮ߦ͞Ε͍ͯΕ 8BJUJOHGPSNBTUFSUPTFOEFWFOU
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@4UBUFɿۭจࣈ ɹεϨʔϒͷݱࡏͷεςʔλε ɹϨϓϦέʔγϣϯ్͕Ε͍ͯΔͨΊ ɹۭจࣈͱͳ͍ͬͯΔ ࣮ߦ͞Ε͍ͯΕ 8BJUJOHGPSNBTUFSUPTFOEFWFOU
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@)PTUɿϚελʔϗετ໊ Ϛελʔͷϗετ໊ ʢ·ͨ*1ΞυϨεʣ ɹ มߋ͞Ε͍ͯΕ ࠶ઃఆ͕ඞཁ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@)PTUɿϚελʔϗετ໊ Ϛελʔͷϗετ໊ ʢ·ͨ*1ΞυϨεʣ ɹ มߋ͞Ε͍ͯΕ ࠶ઃఆ͕ඞཁ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@6TFSɿSFQM εϨʔϒ͔ΒϚελʔʹ ଓ͢ΔϢʔβʔ໊ ɹ ઌ΄Ͳઃఆͨ͠ઐ༻Ϣʔβʔ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@6TFSɿSFQM εϨʔϒ͔ΒϚελʔʹ ଓ͢ΔϢʔβʔ໊ ɹ ϚελʔͰ࡞ͨ͠ઐ༻Ϣʔβʔ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@-PH@'JMFɿNZTRMCJO εϨʔϒ͕Ϛελʔ͔Β औಘ͢ΔόΠφϦϩά ɹ Քಇ͍ͯ͠ͳ͔ͬͨͷͰ ζϨ͍ͯΔ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@-PH@'JMFɿNZTRMCJO εϨʔϒ͕Ϛελʔ͔Β औಘ͢ΔόΠφϦϩά ɹ Քಇ͍ͯ͠ͳ͔ͬͨͷͰ ζϨ͍ͯΔ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:
mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ϩʔςʔτ͞Εͯ ϑΝΠϧ͕ͳ͍ͷͰ औಘͰ͖ͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣
[email protected]
@-PH@1PTɿ εϨʔϒͷ*0εϨου͕ ࠷ޙʹಡΈऔͬͨҐஔ ɹ ͔͜͜ΒϨϓϦέʔγϣϯ࠶։͕ͩ େ͖͘ζϨ͍ͯΔ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣
[email protected]
@-PH@1PTɿ εϨʔϒͷ*0εϨου͕ ࠷ޙʹಡΈऔͬͨҐஔ ɹ ͔͜͜ΒϨϓϦέʔγϣϯ࠶։͕ͩ େ͖͘ζϨ͍ͯΔ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:
mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ͕ࠩ͋Γ͗͢Δͱ ಉظͷࡍʹ ෛՙ͕͔͔Δ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ/0 εϨʔϒͷ*0εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ ϚελʔͷόΠφϦϩά͕ҧ͏ͷͰ ଓͰ͖͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ/0 εϨʔϒͷ*0εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ ϚελʔͷόΠφϦϩά͕ҧ͏ͷͰ ଓͰ͖͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ/0 εϨʔϒͷ42-εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ εϨʔϒͷ%#͕ ߋ৽͞Ε͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ/0 εϨʔϒͷ42-εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ εϨʔϒͷ%#͕ ߋ৽͞Ε͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#
[email protected]
ɿ/6-- Ϛελʔʹൺͯ Ԇ͍ͯ͠Δඵ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#
[email protected]
ɿ/6-- Ϛελʔʹൺͯ Ԇ͍ͯ͠Δඵ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#
[email protected]
ɿ/6-- Ϛελʔʹൺͯ Ԇ͍ͯ͠Δඵ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍ ྫɿϚελʔͰඵ͔͔Δ ɹɹτϥϯβΫγϣϯ࣮ߦ εϨʔϒͰಉ͡42-͕࣮ߦ ͞ΕΔͷͰɺඵԆ͢Δ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#
[email protected]
ɿ/6-- Ϛελʔʹൺͯ Ԇ͍ͯ͠Δඵ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍ ྫɿϚελʔͰඵ͔͔Δ ɹɹτϥϯβΫγϣϯ࣮ߦ εϨʔϒͰಉ͡42-͕࣮ߦ ͞ΕΔͷͰɺඵԆ͢Δ
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ଓ͍ͯ͠Δ Ϛελʔͷ*% ɹ ଓͰ͖͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ଓ͍ͯ͠Δ Ϛελʔͷ*% ɹ ଓͰ͖͍ͯͳ͍
ϚελʔͷNZDOG ϨϓϦέʔγϣϯ͞Ε͍ͯΕ ͜ͷʹͳΔ
ɹϨϓϦέʔγϣϯखॱ
ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛࢹ
ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛࢹ
ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼલʹ࣮ࢪ ɹɾਂόονͰEVNQ࣮ߦ
ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼલʹ࣮ࢪ ɹɾਂόονͰEVNQ࣮ߦ
ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼલʹ࣮ࢪ ɹɾਂόονͰEVNQ࣮ߦ
ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼલʹ࣮ࢪ ɹɾਂόονͰEVNQ࣮ߦ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:
mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) εϨʔϒઃఆͰ༻͢ΔͨΊ ϝϞ͓͖ͯ͠·͠ΐ͏
ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛࢹ
ɹɹεϨʔϒͷNZDOGઃఆ
ɹɹεϨʔϒͷNZDOGઃఆ ϚελʔɺεϨʔϒ શͯ߹Θͤͯ Ұҙͷ*%
ɹɹεϨʔϒͷNZDOGઃఆ όΠφϦϩάઃఆ Ϛελʔʹঢ֨ͨ͠߹ εϨʔϒʹ௨͢Δ
ɹɹεϨʔϒͷNZDOGઃఆ ϩʔςʔτͯ͠ ༰ྔѹഭ͠ͳ͍Α͏ʹ
ɹɹεϨʔϒͷNZDOGઃఆ εϨʔϒͰ όΠφϦϩάΛग़ྗ͠ Ϛελʔঢ֨Մೳʹ
ɹɹεϨʔϒͷNZDOGઃఆ ಉظ࣌ɺ 1,͕ॏෳ͢ΔϨίʔυΛ ඈ͢
ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ
ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ ⾣NZTRM࠶ىಈ ⾣ϦετΞରͷ ɹɹɹσʔλϕʔεআɾ࠶࡞
ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ ⾣NZTRM࠶ىಈ ⾣ϦετΞରͷ ɹɹɹσʔλϕʔεআɾ࠶࡞
ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛࢹ
ɹɹεϨʔϒʹϦετΞ ⾣ਂόονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ
ɹɹεϨʔϒʹϦετΞ ⾣ਂόονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ
ɹɹεϨʔϒʹϦετΞ ⾣ਂόονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ
ɹɹεϨʔϒʹϦετΞ ⾣ਂόονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ
ɹɹεϨʔϒʹϦετΞ ⾣ਂόονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ 163(&."45&3-0(450 bNZTRMCJOYYYYYY` దʹύʔδ͠·͠ΐ͏
ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛࢹ
ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠༰Λઃఆ mysql> STOP SLAVE; mysql> RESET SLAVE; mysql> CHANGE
MASTER TO -> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136;
mysql> STOP SLAVE; mysql> RESET SLAVE; mysql> CHANGE MASTER TO
-> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136; ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠༰Λઃఆ ೦ͷͨΊ εϨʔϒΛࢭΊ·͢
mysql> STOP SLAVE; mysql> RESET SLAVE; mysql> CHANGE MASTER TO
-> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136; ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠༰Λઃఆ εϨʔϒ͕อ͍࣋ͯͨ͠ ϨϓϦέʔγϣϯҐஔΛ Ϧηοτ͠·͢
mysql> STOP SLAVE; mysql> RESET SLAVE; mysql> CHANGE MASTER TO
-> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136; ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠༰Λઃఆ ϚελʔͷόΠφϦϩάɺ ϙδγϣϯΛઃఆ
ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛࢹ
ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ։࢝ mysql> START SLAVE;
ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ։࢝ mysql> START SLAVE; ઃఆͨ͠ϙδγϣϯ͔Β ಉظ͕࣮ߦ͞Ε·͢
ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ֬ೝ
ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ֬ೝ mysql> SHOW SLAVE STATUS\G
ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ֬ೝ mysql> SHOW SLAVE STATUS\G ***************** 1. row *****************
Slave_IO_State: Waiting for master to send event Master_Log_File: mysql-bin.000075 Read_Master_Log_Pos: 878873047 Slave_IO_Running: Yes Slave_SQL_Running: Yes Exec_Master_Log_Pos: 605504154 Seconds_Behind_Master: 244615 Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Master_Server_Id: 1001
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@4UBUFɿ 8BJUJOHGPSNBTUFSUPTFOEFWFOU εϨʔϒͷݱࡏͷεςʔλε ϨϓϦέʔγϣϯ͕։࢝͞Ε Ϛελʔ͔ΒͷΠϕϯτͪ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@4UBUFɿ 8BJUJOHGPSNBTUFSUPTFOEFWFOU εϨʔϒͷݱࡏͷεςʔλε ϨϓϦέʔγϣϯ͕։࢝͞Ε Ϛελʔ͔ΒͷΠϕϯτͪ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@-PH@'JMFɿ NZTRMCJO ϚελʔͷόΠφϦϩάϑΝΠϧ ݱࡏϚελͰߋ৽͞Ε͍ͯΔ ϑΝΠϧ໊ʹͳ͍ͬͯΔ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@-PH@'JMFɿ NZTRMCJO ϚελʔͷόΠφϦϩάϑΝΠϧ ݱࡏϚελͰߋ৽͞Ε͍ͯΔ ϑΝΠϧ໊ʹͳ͍ͬͯΔ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣
[email protected]
@-PH@1PTɿ ϚελʔͷόΠφϦϩά͔Β εϨʔϒ͕ಡΈऔͬͨҐஔ ˞42-࣮ߦ͞ΕͨͱݶΒͳ͍
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣
[email protected]
@-PH@1PTɿ ϚελʔͷόΠφϦϩά͔Β *0εϨου͕ಡΈऔͬͨҐஔ ˞42-࣮ߦ͞ΕͨͱݶΒͳ͍
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣&
[email protected]
@-PH@1PTɿ *0εϨου͕ಡΈࠐΜͩϩά͔Β 42-εϨου͕ ࣮ߦͨ͠ΫΤϦͷҐஔ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣&
[email protected]
@-PH@1PTɿ *0εϨου͕ಡΈࠐΜͩϩά͔Β 42-εϨου͕ ࣮ߦͨ͠ΫΤϦͷҐஔ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣&
[email protected]
@-PH@1PTɿ *0εϨου͕ಡΈࠐΜͩϩά͔Β 42-εϨου͕ ࣮ߦͨ͠ΫΤϦͷҐஔ ಡΈऔͬͨҐஔʔ࣮ߦͨ͠Ґஔ ʹ Ԇ͍ͯ͠ΔτϥϯβΫγϣϯ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4FDPOET@#
[email protected]
ɿ εϨʔϒ͕Ϛελʔʹൺ Ԇ͍ͯ͠Δඵ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4FDPOET@#
[email protected]
ɿ εϨʔϒ͕Ϛελʔʹൺ Ԇ͍ͯ͠Δඵ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4FDPOET@#
[email protected]
ɿ εϨʔϒ͕Ϛελʔʹൺ Ԇ͍ͯ͠Δඵ ԆτϥϯβΫγϣϯͷ ֤ඵͷ૯߹ܭ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ:&4 ϚελʔͷόΠφϦϩάΛ औಘͰ͖͍ͯΔ͔
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ:&4 ϚελʔͷόΠφϦϩάΛ औಘͰ͖͍ͯΔ͔
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ:&4 औಘͨ͠όΠφϦϩάͷ 42-࣮ߦͰ͖͍ͯΔ͔
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ:&4 औಘͨ͠όΠφϦϩάͷ 42-࣮ߦͰ͖͍ͯΔ͔
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠*0εϨουͷ Τϥʔ൪߸
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ *0εϨουͷ Τϥʔ൪߸
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ *0εϨουͷ Τϥʔϝοηʔδ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ *0εϨουͷ Τϥʔϝοηʔδ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔ൪߸
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔ൪߸
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔ൪߸ 1,ॏෳΤϥʔͷ߹
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔϝοηʔδ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔϝοηʔδ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔϝοηʔδ 1,ॏෳΤϥʔͷ߹ &SSPS%VQMJDBUFFOUSZGPS LFZ13*."3:PORVFSZɽɽɽ
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ಉظ͍ͯ͠Δ Ϛελʔͷ*%
ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ಉظ͍ͯ͠Δ Ϛελʔͷ*%
ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛࢹ
ɹ࣮ߦঢ়گΛࢹ mysql> SHOW SLAVE STATUS\G **************** 1. row ************** Read_Master_Log_Pos:
878873047 Exec_Master_Log_Pos: 605504154 Seconds_Behind_Master: 244615 ⾣࣮ߦޙ
ɹ࣮ߦঢ়گΛࢹ mysql> SHOW SLAVE STATUS\G **************** 1. row ************** Read_Master_Log_Pos:
878873047 Exec_Master_Log_Pos: 605504154 Seconds_Behind_Master: 244615 ⾣࣮ߦޙ mysql> SHOW SLAVE STATUS\G **************** 1. row ************** Read_Master_Log_Pos: 879066686 Exec_Master_Log_Pos: 879066686 Seconds_Behind_Master: 0 ⾣ಉظྃ
ॠؒɺ৺ɺॏͶͯ
γϯΫϩ ˋ
݁Ռ
݁Ռ ࢲ Ϛελʔ ͕ མͪͯ
݁Ռ ΘΓ ϨϓϦΧ ͕͋Δͷʂ
՝
՝ ϑΣΠϧΦʔόʔ ͷΈΛ༻ҙ͠ ࣗಈతʹԽ
·ͱΊ
·ͱΊ ⾣ෳ࡞ɾӡ༻ྃʂ ⾣ࢀরܥͷαʔόʔ४උྃʂ ⾣όοΫΞοϓαʔόʔ࡞ྃ
·ͱΊ ⾣ෳ࡞ɾӡ༻ྃʂ ⾣ࢀরܥͷαʔόʔ४උྃʂ ⾣όοΫΞοϓαʔόʔ࡞ྃ
·ͱΊ ⾣ෳ࡞ɾӡ༻ྃʂ ⾣ࢀরܥͷαʔόʔ४උྃʂ ⾣όοΫΞοϓαʔόʔ࡞ྃ
ऴΘΓʹ σʔλ ෳ໋͕
ऴΘΓʹ Մ༻ੑΛߴΊ γεςϜΛ αʔϏεαʔϏε͎ ͍͖ͯ͠·͠ΐ͏ʂ
ऴΘΓʹ ΠϯϓοτΛ ௐͯΞτϓοτ ʹ ݟ࣮ͯߦ͢Δʂ
ऴΘΓʹ ϚϯΨ͡Όͳ͍͚Ͳ ՄࢹԽେʂ
ऴΘΓʹ ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ
4QFDJBM5IBOLT ωλఏڙˏ Ԟ ͞ · ݄ ݄
͓·͚ ⾣ݩهࣄͷ͝հ ɾ.Z42-ϨϓϦέʔγϣϯઃఆ खॱɾ֤छεςʔλεͷৄࡉͱ τϥϒϧγϡʔςΟϯά ɹIUUQRJJUBDPNNBNZJUFNTBFEGBCGE