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
200
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.5k
戦って品質保証を勝ち取る/Fight_for_quality_assurance
mamy1326
2
810
MySQLでGROUP BY と ORDER BY を同時に使いたくなったら/If_you_want_to_use_GROUP_BY_and_ORDER_BY_at_the_same_time_in_mysql
mamy1326
4
6k
初めてのMySQLパフォーマンスチューニングーデータベースは怖くない!/mysql-performance-tuning-basics-in-db-study-chugoku-chiho
mamy1326
8
2.8k
アウトプットを継続するためにやる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.6k
アウトプットを継続するためにやっている 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
git worktree × Claude Code × MCP ~生成AI時代の並列開発フロー~
hisuzuya
1
510
生成AIコーディングとの向き合い方、AIと共創するという考え方 / How to deal with generative AI coding and the concept of co-creating with AI
seike460
PRO
1
340
明示と暗黙 ー PHPとGoの インターフェイスの違いを知る
shimabox
2
380
すべてのコンテキストを、 ユーザー価値に変える
applism118
2
980
Rubyでやりたい駆動開発 / Ruby driven development
chobishiba
1
510
C++20 射影変換
faithandbrave
0
550
エンジニア向け採用ピッチ資料
inusan
0
170
都市をデータで見るってこういうこと PLATEAU属性情報入門
nokonoko1203
1
580
Result型で“失敗”を型にするPHPコードの書き方
kajitack
4
540
ソフトウェア品質を数字で捉える技術。事業成長を支えるシステム品質の マネジメント
takuya542
0
230
コードの90%をAIが書く世界で何が待っているのか / What awaits us in a world where 90% of the code is written by AI
rkaga
48
32k
イベントストーミング図からコードへの変換手順 / Procedure for Converting Event Storming Diagrams to Code
nrslib
1
540
Featured
See All Featured
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
5
230
Reflections from 52 weeks, 52 projects
jeffersonlam
351
20k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
29
1.8k
Statistics for Hackers
jakevdp
799
220k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
10
940
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.6k
Documentation Writing (for coders)
carmenintech
72
4.9k
Art, The Web, and Tiny UX
lynnandtonic
299
21k
A Tale of Four Properties
chriscoyier
160
23k
Stop Working from a Prison Cell
hatefulcrawdad
270
20k
A Modern Web Designer's Workflow
chriscoyier
694
190k
Side Projects
sachag
455
42k
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