MySQLサーバーを複製し、私が死んでも代わりは(略)するお話
.Z42-αʔόʔΛϨϓϦέʔγϣϯΛ࣮ߦ͢Δ͓·Έͳ͓͖ !NBNZ"QS !ୈճ1)1ษڧձˏ౦ژ
View Slide
.Z42-Λෳ͠αʔόʔ1)1ษڧձ!౦ژୈࢲ͕˓ΜͰΘΓ ུ͢Δ͓·ΈͳϮ͖!NBNZ
ࠓͷςʔϚࢲͷΘΓ͍͘ΒͰ͍ΔΘͱݴͬͯ
ࠓͷςʔϚ࣮ࡍࢮΜͩΒऴΘΔ.Z42-Λ
ࠓͷςʔϚෳϨϓϦέʔγϣϯ͢Δ͓
ྐྵ݄
ϑΝʔετΠϯύΫτ
NZDOG͕σϑΥϧτ
લճ·Ͱͷվળ⾣νϡʔχϯάͰඵؒˠ⾣ςʔϒϧݸผͰߋ৽ܥ͕͘ʂ⾣ϝϞϦ͕దʹΘΕΔΑ͏ʹʂ
ηΧϯυΠϯύΫτ
՝
՝Ϛελʔ͕ࢮ͵ͱσʔλ͕શ෦ࢮ͵
՝Ϛελʔ͕ࢮ͵ͱσʔλ͕શ෦ࢮ͵·͔͞ͷେരൃ
ෳϚελʔ͔͠ͳ͍ݱঢ়ʹεϨʔϒΛ࡞Γ
ෳϨϓϦέʔγϣϯΛՔಇ͠·͢
ɹϨϓϦέʔγϣϯͱ
ɹϨϓϦέʔγϣϯͱ⾣σʔλϕʔεશମͷෳ ϨϓϦΧ⾣ผͷαʔόʔʹෳʢεϨʔϒʣ⾣.Z42-ͷඪ४ػೳͰ͓खܰ⾣΄΅࣌ؒࠩͳ͠ʹಉظ
ߏϚελʔʢ୯ҰʣεϨʔϒʢʣεϨʔϒʢOʣɾɾɾ
Ϛελʔ
Ϛελʔ⾣σʔλΛߋ৽͢Δଆ⾣ߋ৽༰ΛεϨʔϒ͕औΓʹདྷΔɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨⾣ෳͷεϨʔϒΛ࣋ͯΔ
εϨʔϒ
εϨʔϒ⾣ߋ৽༻Ͱͳ͘ࢀর༻⾣Ϛελʔͷߋ৽༰Λड͚औΔ⾣ϚελʔͷόΠφϦϩάΛऔಘ⾣ߋ৽༰Λ%#ʹө⾣ͭͷϚελʔͷΈ࣋ͯΔ
εϨʔϒ⾣ߋ৽༻Ͱͳ͘ࢀর༻⾣Ϛελʔͷߋ৽༰Λड͚औΔ⾣ϚελʔͷόΠφϦϩάΛऔಘ⾣ߋ৽༰Λ%#ʹө⾣ͭͷϚελʔͷΈ࣋ͯΔDPNNJUϩά*0εϨου
εϨʔϒ⾣ߋ৽༻Ͱͳ͘ࢀর༻⾣Ϛελʔͷߋ৽༰Λड͚औΔ⾣ϚελʔͷόΠφϦϩάΛऔಘ⾣ߋ৽༰Λ%#ʹө⾣ͭͷϚελʔͷΈ࣋ͯΔDPNNJUϩάͷ42-࣮ߦ42-εϨου
ϝϦοτ⾣ࢀর 4&-&$5ੑೳͷ্ݕࡧॲཧ͕ॏ͍߹εϨʔϒΛࢀরܥʹͯ͠ෛՙࢄ
ϝϦοτ⾣Մ༻ੑͷߴ͍ߏͷ࣮ݱϚελʔোͷ߹εϨʔϒΛϚελʔʹঢ֨μϯλΠϜॖ
ϝϦοτ⾣Մ༻ੑͷߴ͍ߏͷ࣮ݱϚελʔোͷ߹εϨʔϒΛϚελʔʹঢ֨μϯλΠϜॖͨͩ͠ɾɾɾ
ϝϦοτ⾣Մ༻ੑͷߴ͍ߏͷ࣮ݱϚελʔোͷ߹εϨʔϒΛϚελʔʹঢ֨μϯλΠϜॖϑΣΠϧΦʔόʔࣗಈԽͷΈ͕ඞཁ
ϝϦοτ⾣όοΫΞοϓαʔόʔεϨʔϒͰόοΫΞοϓϚελʔʹӨڹͳ͘όοΫΞοϓऔಘ
ɹϨϓϦέʔγϣϯͷঢ়گνϡʔχϯάલʹҰϚελʔ͕μϯ͍ͯͨ͠
ɹϨϓϦέʔγϣϯͷঢ়گϚελʔ࠶ىಈͷεϨʔϒͷઃఆΛ͍ͯͨ͠͠
ɹϨϓϦέʔγϣϯͷঢ়گϚελʔ࠶ىಈͷεϨʔϒͷઃఆΛ͍ͯͨͭ͠͠Β͍
ɹϨϓϦέʔγϣϯͷঢ়گ͋·Γʹ໘ͰεϨʔϒΛ
ɹϨϓϦέʔγϣϯͷঢ়گ͋·Γʹ໘ͰεϨʔϒΛ4501ʂ
ͭ·Γ
ͭ·Γӡ༻͔Βಀ͍͛ͯͨ
Ͱ
Ͱಀ͛ͪΌବͩɺಀ͛ͪΌବͩɺಀ͛ͪΌବͩɺಀ͛ͪΌବͩɺಀ͛ͪΌବͩɺಀ͛ͪΌବͩɻ
͕Γ·͢
ࣄલ४උ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞⾣ϚελʔՔಇঢ়ଶͷ֬ೝ⾣ϚελʔόΠφϦϩάͷ֬ೝ⾣εϨʔϒͷઃఆ֬ೝ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞⾣ఆٛɹɾϚελʔଆʹ࡞ɹɾεϨʔϒ͔Βଓ͢ΔɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞⾣࣮ɾɾɾɹɹϚελʔଆͷطଘϢʔβʔͰɹɹଓ͕Մೳ͔͠͠ɾɾɾ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞TVEPDBUWBSMJCNZTRMNBTUFSJOGPNZTRMCJO<Ϛελʔͷ*1ΞυϨε·ͨϗετ໊><Ϛελʔʹଓ͢ΔNZTRMϢʔβʔ໊><Ϛελʔʹଓ͢ΔNZTRMύεϫʔυ>ʜ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞TVEPDBUWBSMJCNZTRMNBTUFSJOGPNZTRMCJO<Ϛελʔͷ*1ΞυϨε·ͨϗετ໊><Ϛελʔʹଓ͢ΔNZTRMϢʔβʔ໊><Ϛελʔʹଓ͢ΔNZTRMύεϫʔυ>ʜଓใ͕ϓϨʔϯςΩετ
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞TVEPDBUWBSMJCNZTRMNBTUFSJOGPNZTRMCJO<Ϛελʔͷ*1ΞυϨε·ͨϗετ໊><Ϛελʔʹଓ͢ΔNZTRMϢʔβʔ໊><Ϛελʔʹଓ͢ΔNZTRMύεϫʔυ>ʜηΩϡϦςΟͷͨΊઐ༻Ϣʔβ࡞
͜͏͍͏࣌͋Γ·ͤΜ͔ʁ
·͋ɺ͍͍͡Όͳ͍Ͱ͔͢ಈ͘Μ͔ͩΒ
ݴΘΕΕΓ·͢Α
ऑ͍ఒγϯδΈ͍ͨͳࣗ໓͠·͠ΐ͏
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞⾣࡞ίϚϯυNZTRM NBTUFS$3&"5&64&3NZTRM NBTUFS`SFQM`!`<εϨʔϒͷϗετ໊>`NZTRM NBTUFS*%&/5*'*&%#:1"44803%``
ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞⾣ݖݶίϚϯυNZTRM NBTUFS(3"/53&1-*$"5*0/4-"7&NZTRM NBTUFS0/50NZTRM NBTUFS`SFQM`!`<εϨʔϒͷϗετ໊>`
ϚελʔͷNZDOG
ϚελʔͷNZDOGDPNNJUΛ௨ޙεϨʔϒ͕ଓͯ͠औಘWBSMJCNZTRMNZTRMCJO999999
ϚελʔͷNZDOGεϨʔϒ͔ΒݟͨϚελʔͷ*%
ϚελʔͷNZDOGଟ͗͘͢͠ΔͱετϨʔδѹഭ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ⾣όΠφϦϩάͱҐஔใɹɾόΠφϦϩάͱɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺɹɾϩʔςʔτ͞ΕΔɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ɹɹɹˠҐஔใΛ֬ೝ
ɹɹϚελʔόΠφϦϩάͷ֬ೝ⾣όΠφϦϩάͱҐஔใɹɾόΠφϦϩάϑΝΠϧͱɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺɹɾϩʔςʔτ͞ΕΔɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ɹɹɹˠҐஔใΛ֬ೝ
ɹɹϚελʔόΠφϦϩάͷ֬ೝmysql> SHOW MASTER STATUS\G********* 1. row *********File: mysql-bin.000075Position: 588201136Binlog_Do_DB:Binlog_Ignore_DB:1 row in set (0.01 sec)
ɹɹϚελʔόΠφϦϩάͷ֬ೝmysql> SHOW MASTER STATUS\G********* 1. row *********File: mysql-bin.000075Position: 588201136Binlog_Do_DB:Binlog_Ignore_DB:1 row in set (0.01 sec)DPNNJUΛ௨ޙεϨʔϒ͕ଓͯ͠औಘWBSMJCNZTRMNZTRMCJO999999
ɹɹϚελʔόΠφϦϩάͷ֬ೝmysql> SHOW MASTER STATUS\G********* 1. row *********File: mysql-bin.000075Position: 588201136Binlog_Do_DB:Binlog_Ignore_DB:1 row in set (0.01 sec)ϚελʔͰDPNNJU͕࣮ߦ͞Εͨϙδγϣϯ
ɹɹϚελʔόΠφϦϩάͷ֬ೝmysql> SHOW MASTER STATUS\G********* 1. row *********File: mysql-bin.000075Position: 588201136Binlog_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: replMaster_Log_File: mysql-bin.000009Read_Master_Log_Pos: 303456264Slave_IO_Running: NoSlave_SQL_Running: NoSeconds_Behind_Master: NULLMaster_Server_Id: 01 row in set (0.01 sec)
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]*[email protected]ɿۭจࣈɹεϨʔϒͷݱࡏͷεςʔλεɹϨϓϦέʔγϣϯ్͕Ε͍ͯΔͨΊɹۭจࣈͱͳ͍ͬͯΔ࣮ߦ͞Ε͍ͯΕ8BJUJOHGPSNBTUFSUPTFOEFWFOU
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected])PTUɿϚελʔϗετ໊Ϛελʔͷϗετ໊ʢ·ͨ*1ΞυϨεʣɹมߋ͞Ε͍ͯΕ࠶ઃఆ͕ඞཁ
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]ɿSFQMεϨʔϒ͔ΒϚελʔʹଓ͢ΔϢʔβʔ໊ɹઌ΄Ͳઃఆͨ͠ઐ༻Ϣʔβʔ
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]ɿSFQMεϨʔϒ͔ΒϚελʔʹଓ͢ΔϢʔβʔ໊ɹϚελʔͰ࡞ͨ͠ઐ༻Ϣʔβʔ
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]@'JMFɿNZTRMCJOεϨʔϒ͕Ϛελʔ͔Βऔಘ͢ΔόΠφϦϩάɹՔಇ͍ͯ͠ͳ͔ͬͨͷͰζϨ͍ͯΔ
ɹɹϚελʔόΠφϦϩάͷ֬ೝmysql> SHOW MASTER STATUS\G********* 1. row *********File: mysql-bin.000075Position: 588201136Binlog_Do_DB:Binlog_Ignore_DB:1 row in set (0.01 sec)ϩʔςʔτ͞ΕͯϑΝΠϧ͕ͳ͍ͷͰऔಘͰ͖ͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]@[email protected]ɿεϨʔϒͷ*0εϨου͕࠷ޙʹಡΈऔͬͨҐஔɹ͔͜͜ΒϨϓϦέʔγϣϯ࠶։͕ͩେ͖͘ζϨ͍ͯΔ
ɹɹϚελʔόΠφϦϩάͷ֬ೝmysql> SHOW MASTER STATUS\G********* 1. row *********File: mysql-bin.000075Position: 588201136Binlog_Do_DB:Binlog_Ignore_DB:1 row in set (0.01 sec)͕ࠩ͋Γ͗͢Δͱಉظͷࡍʹෛՙ͕͔͔Δ
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]*[email protected]ɿ/0εϨʔϒͷ*0εϨου͕࣮ߦ͞Ε͍ͯͳ͍ɹϚελʔͷόΠφϦϩά͕ҧ͏ͷͰଓͰ͖͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]@3VOOJOHɿ/0εϨʔϒͷ42-εϨου͕࣮ߦ͞Ε͍ͯͳ͍ɹεϨʔϒͷ%#͕ߋ৽͞Ε͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]#[email protected]ɿ/6--ϚελʔʹൺͯԆ͍ͯ͠ΔඵɹϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]#[email protected]ɿ/6--ϚελʔʹൺͯԆ͍ͯ͠ΔඵɹϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍ྫɿϚελʔͰඵ͔͔ΔɹɹτϥϯβΫγϣϯ࣮ߦεϨʔϒͰಉ͡42-͕࣮ߦ͞ΕΔͷͰɺඵԆ͢Δ
ɹɹεϨʔϒͷઃఆ֬ೝ⾣[email protected]@*Eɿଓ͍ͯ͠ΔϚελʔͷ*%ɹଓͰ͖͍ͯͳ͍
ϚελʔͷNZDOGϨϓϦέʔγϣϯ͞Ε͍ͯΕ͜ͷʹͳΔ
ɹϨϓϦέʔγϣϯखॱ
ɹϨϓϦέʔγϣϯखॱ⾣ϚελʔͷEVNQΛऔಘ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه⾣εϨʔϒͷNZDOGઃఆ⾣εϨʔϒʹϦετΞ⾣εϨʔϒઃఆมߋ⾣ϨϓϦέʔγϣϯ࣮ߦ⾣࣮ߦঢ়گΛࢹ
ɹɹϚελʔͷEVNQΛऔಘ⾣ϚελʔΛࢭΊͣʹ࣮ߦɹɾόΠφϦϩάϑΝΠϧ໊ϝϞɹɾDPNNJUϙδγϣϯϝϞɹɹˠؼલʹ࣮ࢪɹɾਂόονͰEVNQ࣮ߦ
ɹɹεϨʔϒͷNZDOGઃఆ
ɹɹεϨʔϒͷNZDOGઃఆϚελʔɺεϨʔϒશͯ߹ΘͤͯҰҙͷ*%
ɹɹεϨʔϒͷNZDOGઃఆόΠφϦϩάઃఆϚελʔʹঢ֨ͨ͠߹εϨʔϒʹ௨͢Δ
ɹɹεϨʔϒͷNZDOGઃఆϩʔςʔτͯ͠༰ྔѹഭ͠ͳ͍Α͏ʹ
ɹɹεϨʔϒͷNZDOGઃఆεϨʔϒͰόΠφϦϩάΛग़ྗ͠Ϛελʔঢ֨Մೳʹ
ɹɹεϨʔϒͷNZDOGઃఆಉظ࣌ɺ1,͕ॏෳ͢ΔϨίʔυΛඈ͢
ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ
ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ⾣NZTRM࠶ىಈ⾣ϦετΞରͷɹɹɹσʔλϕʔεআɾ࠶࡞
ɹɹεϨʔϒʹϦετΞ⾣ਂόονͷঢ়ଶͰϦετΞɹɾEVNQϑΝΠϧऔಘˍల։ɹɾϦετΞ࣮ߦɹɾετϨʔδ༰ྔʹҙʂɹɹˠ(୯ҐͷόΠφϦϩά͕ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ
ɹɹεϨʔϒʹϦετΞ⾣ਂόονͷঢ়ଶͰϦετΞɹɾEVNQϑΝΠϧऔಘˍల։ɹɾϦετΞ࣮ߦɹɾετϨʔδ༰ྔʹҙʂɹɹˠ(୯ҐͷόΠφϦϩά͕ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ163(&."45&3-0(450bNZTRMCJOYYYYYY`దʹύʔδ͠·͠ΐ͏
ɹεϨʔϒઃఆมߋ⾣ϚελʔͰϝϞͨ͠༰Λઃఆ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;ɹεϨʔϒઃఆมߋ⾣ϚελʔͰϝϞͨ͠༰ΛઃఆϚελʔͷόΠφϦϩάɺϙδγϣϯΛઃఆ
ɹϨϓϦέʔγϣϯ࣮ߦ⾣ϨϓϦέʔγϣϯͷ։࢝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 eventMaster_Log_File: mysql-bin.000075Read_Master_Log_Pos: 878873047Slave_IO_Running: YesSlave_SQL_Running: YesExec_Master_Log_Pos: 605504154Seconds_Behind_Master: 244615Last_IO_Errno: 0Last_IO_Error:Last_SQL_Errno: 0Last_SQL_Error:Master_Server_Id: 1001
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]*[email protected]ɿ8BJUJOHGPSNBTUFSUPTFOEFWFOUεϨʔϒͷݱࡏͷεςʔλεϨϓϦέʔγϣϯ͕։࢝͞ΕϚελʔ͔ΒͷΠϕϯτͪ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@'JMFɿNZTRMCJOϚελʔͷόΠφϦϩάϑΝΠϧݱࡏϚελͰߋ৽͞Ε͍ͯΔϑΝΠϧ໊ʹͳ͍ͬͯΔ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@[email protected]ɿϚελʔͷόΠφϦϩά͔ΒεϨʔϒ͕ಡΈऔͬͨҐஔ˞42-࣮ߦ͞ΕͨͱݶΒͳ͍
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@[email protected]ɿϚελʔͷόΠφϦϩά͔Β*0εϨου͕ಡΈऔͬͨҐஔ˞42-࣮ߦ͞ΕͨͱݶΒͳ͍
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣&[email protected]@[email protected]ɿ*0εϨου͕ಡΈࠐΜͩϩά͔Β42-εϨου͕࣮ߦͨ͠ΫΤϦͷҐஔ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣&[email protected]@[email protected]ɿ*0εϨου͕ಡΈࠐΜͩϩά͔Β42-εϨου͕࣮ߦͨ͠ΫΤϦͷҐஔಡΈऔͬͨҐஔʔ࣮ߦͨ͠ҐஔʹԆ͍ͯ͠ΔτϥϯβΫγϣϯ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]#[email protected]ɿεϨʔϒ͕ϚελʔʹൺԆ͍ͯ͠Δඵ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]#[email protected]ɿεϨʔϒ͕ϚελʔʹൺԆ͍ͯ͠ΔඵԆτϥϯβΫγϣϯͷ֤ඵͷ૯߹ܭ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]*[email protected]ɿ:&4ϚελʔͷόΠφϦϩάΛऔಘͰ͖͍ͯΔ͔
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@3VOOJOHɿ:&4औಘͨ͠όΠφϦϩάͷ42-࣮ߦͰ͖͍ͯΔ͔
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]*[email protected]&SSOPɿ࠷ޙʹ࣮ߦͨ͠*0εϨουͷΤϥʔ൪߸
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]*[email protected]&SSPSɿۭจࣈ࠷ޙʹ࣮ߦͨ͠*0εϨουͷΤϥʔϝοηʔδ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@&SSOPɿ࠷ޙʹ࣮ߦͨ͠42-εϨουͷΤϥʔ൪߸
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@&SSOPɿ࠷ޙʹ࣮ߦͨ͠42-εϨουͷΤϥʔ൪߸1,ॏෳΤϥʔͷ߹
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@&SSPSɿۭจࣈ࠷ޙʹ࣮ߦͨ͠42-εϨουͷΤϥʔϝοηʔδ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@&SSPSɿۭจࣈ࠷ޙʹ࣮ߦͨ͠42-εϨουͷΤϥʔϝοηʔδ1,ॏෳΤϥʔͷ߹&SSPS%VQMJDBUFFOUSZGPSLFZ13*."3:PORVFSZɽɽɽ
ɹϨϓϦέʔγϣϯͷ֬ೝ⾣[email protected]@*Eɿಉظ͍ͯ͠ΔϚελʔͷ*%
ɹ࣮ߦঢ়گΛࢹmysql> SHOW SLAVE STATUS\G**************** 1. row **************Read_Master_Log_Pos: 878873047Exec_Master_Log_Pos: 605504154Seconds_Behind_Master: 244615⾣࣮ߦޙ
ɹ࣮ߦঢ়گΛࢹmysql> SHOW SLAVE STATUS\G**************** 1. row **************Read_Master_Log_Pos: 878873047Exec_Master_Log_Pos: 605504154Seconds_Behind_Master: 244615⾣࣮ߦޙmysql> SHOW SLAVE STATUS\G**************** 1. row **************Read_Master_Log_Pos: 879066686Exec_Master_Log_Pos: 879066686Seconds_Behind_Master: 0⾣ಉظྃ
ॠؒɺ৺ɺॏͶͯ
γϯΫϩˋ
݁Ռ
݁Ռࢲ Ϛελʔ͕མͪͯ
݁ՌΘΓ ϨϓϦΧ͕͋Δͷʂ
՝ϑΣΠϧΦʔόʔͷΈΛ༻ҙࣗ͠ಈతʹԽ
·ͱΊ
·ͱΊ⾣ෳ࡞ɾӡ༻ྃʂ⾣ࢀরܥͷαʔόʔ४උྃʂ⾣όοΫΞοϓαʔόʔ࡞ྃ
ऴΘΓʹσʔλෳ໋͕
ऴΘΓʹՄ༻ੑΛߴΊγεςϜΛαʔϏεαʔϏε͎͍͖ͯ͠·͠ΐ͏ʂ
ऴΘΓʹΠϯϓοτΛௐͯΞτϓοτʹݟ࣮ͯߦ͢Δʂ
ऴΘΓʹϚϯΨ͡Όͳ͍͚ͲՄࢹԽେʂ
ऴΘΓʹ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ
4QFDJBM5IBOLTωλఏڙˏ Ԟ͞·݄ ݄
͓·͚⾣ݩهࣄͷ͝հɾ.Z42-ϨϓϦέʔγϣϯઃఆखॱɾ֤छεςʔλεͷৄࡉͱτϥϒϧγϡʔςΟϯάɹIUUQRJJUBDPNNBNZJUFNTBFEGBCGE