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
190
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
18
7.3k
戦って品質保証を勝ち取る/Fight_for_quality_assurance
mamy1326
2
770
MySQLでGROUP BY と ORDER BY を同時に使いたくなったら/If_you_want_to_use_GROUP_BY_and_ORDER_BY_at_the_same_time_in_mysql
mamy1326
4
5.9k
初めてのMySQLパフォーマンスチューニングーデータベースは怖くない!/mysql-performance-tuning-basics-in-db-study-chugoku-chiho
mamy1326
8
2.7k
アウトプットを継続するためにやる10箇条-吉祥寺.pm-/10_things_practicing_to_continue_output-in_kichijoji.pm
mamy1326
4
2.2k
MySQLパフォーマンスチューニングの基本ー実際のトラブルシュートから my.cnf までー/MySQL_Performance_Tuning_Basics_in_OSC_Niigata
mamy1326
2
3.5k
アウトプットを継続するためにやっている 10 のこと/10_things_practicing_to_continue_output
mamy1326
21
9.5k
アプリケーションエンジニアが知るべきDNSの基本/Basics_of_DNS_that_application_engineers_should_know
mamy1326
113
47k
dns-penetration-problem-why-can-not-i-say-penetration-kichijojipm15
mamy1326
5
3.5k
Other Decks in Programming
See All in Programming
PRレビューのお供にDanger
stoticdev
1
230
DRFを少しずつ オニオンアーキテクチャに寄せていく DjangoCongress JP 2025
nealle
2
270
Datadog DBMでなにができる? JDDUG Meetup#7
nealle
0
140
Rubyと自由とAIと
yotii23
6
1.7k
Bedrock Agentsレスポンス解析によるAgentのOps
licux
3
920
Kotlinの開発でも AIをいい感じに使いたい / Making the Most of AI in Kotlin Development
kohii00
5
1.2k
pylint custom ruleで始めるレビュー自動化
shogoujiie
0
150
Rails 1.0 のコードで学ぶ find_by* と method_missing の仕組み / Learn how find_by_* and method_missing work in Rails 1.0 code
maimux2x
1
200
Ça bouge du côté des animations CSS !
goetter
2
150
Honoをフロントエンドで使う 3つのやり方
yusukebe
7
3.5k
PEPCは何を変えようとしていたのか
ken7253
2
220
Better Code Design in PHP
afilina
0
170
Featured
See All Featured
The World Runs on Bad Software
bkeepers
PRO
67
11k
Gamification - CAS2011
davidbonilla
80
5.2k
The Art of Programming - Codeland 2020
erikaheidi
53
13k
Automating Front-end Workflow
addyosmani
1368
200k
How STYLIGHT went responsive
nonsquared
98
5.4k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
175
52k
Designing on Purpose - Digital PM Summit 2013
jponch
117
7.1k
How to train your dragon (web standard)
notwaldorf
91
5.9k
A Philosophy of Restraint
colly
203
16k
Navigating Team Friction
lara
183
15k
BBQ
matthewcrist
87
9.5k
Art, The Web, and Tiny UX
lynnandtonic
298
20k
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