mysql_replication

.Z42-αʔόʔΛ ϨϓϦέʔγϣϯ Λ࣮ߦ͢Δ͓࿩ ·Έ΍ͳ͓͖ !NBNZ "QS !ୈճ1)1ษڧձˏ౦ژ

.Z42- Λ ෳ ੡ ͠ αʔόʔ 1)1ษڧձ!౦ژୈ࿩ ࢲ͕ ˓ΜͰ΋ ୅ΘΓ͸
ུ ͢Δ ͓࿩ ·Έ΍ͳϮ͖ !NBNZ

ࠓ೔ͷςʔϚ ࢲͷ୅ΘΓ͸ ͍͘ΒͰ΋͍ΔΘ ͱݴͬͯ

ࠓ೔ͷςʔϚ ࣮ࡍ͸ ࢮΜͩΒऴΘΔ .Z42-Λ

ࠓ೔ͷςʔϚ ෳ੡ ϨϓϦέʔγϣϯ ͢Δ͓࿩

੢ྐྵ೥݄

ϑΝʔετ ΠϯύΫτ

NZDOG͕ σϑΥϧτ

લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕଎͘ʂ ⾣ϝϞϦ͕ద੾ʹ࢖ΘΕΔΑ͏ʹʂ

੢ྐྵ೥݄

ηΧϯυ ΠϯύΫτ

՝୊ Ϛελʔ͕ࢮ͵ͱ σʔλ͕શ෦ࢮ͵

՝୊ Ϛελʔ͕ࢮ͵ͱ σʔλ͕શ෦ࢮ͵ ·͔͞ͷ େരൃ

ෳ੡ Ϛελʔ͔͠ͳ͍ ݱঢ়ʹ εϨʔϒΛ࡞Γ

ෳ੡ ϨϓϦέʔγϣϯ ΛՔಇ͠·͢

ɹϨϓϦέʔγϣϯͱ͸

ɹϨϓϦέʔγϣϯͱ͸ ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

ߏ੒ Ϛελʔ ʢ୯Ұʣ εϨʔϒ ʢʣ εϨʔϒ ʢOʣ ɾɾɾ

Ϛελʔ

Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽಺༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨஌ ⾣ෳ਺ͷεϨʔϒΛ࣋ͯΔ

εϨʔϒ

εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ

εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ DPNNJUϩά *0εϨου

εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ DPNNJUϩάͷ 42-࣮ߦ 42-εϨου

ϝϦοτ ⾣ࢀর 4&-&$5 ੑೳͷ޲্ ݕࡧॲཧ͕ॏ͍৔߹ εϨʔϒΛࢀরܥʹͯ͠ ෛՙ෼ࢄ

ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ Ϛελʔো֐ͷ৔߹ εϨʔϒΛϚελʔʹঢ֨ μ΢ϯλΠϜ୹ॖ

ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ Ϛελʔো֐ͷ৔߹ εϨʔϒΛϚελʔʹঢ֨ μ΢ϯλΠϜ୹ॖ ͨͩ͠ɾɾɾ

ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ Ϛελʔো֐ͷ৔߹ εϨʔϒΛϚελʔʹঢ֨ μ΢ϯλΠϜ୹ॖ ϑΣΠϧΦʔόʔ ࣗಈԽ ͷ ࢓૊Έ͕ඞཁ

ϝϦοτ ⾣όοΫΞοϓαʔόʔ εϨʔϒͰόοΫΞοϓ ϚελʔʹӨڹͳ͘ όοΫΞοϓऔಘ

ɹϨϓϦέʔγϣϯͷঢ়گ νϡʔχϯάલ͸ ਺೔ʹҰ౓ Ϛελʔ͕μ΢ϯ͍ͯͨ͠

ɹϨϓϦέʔγϣϯͷঢ়گ Ϛελʔ࠶ىಈͷ౎౓ εϨʔϒͷ ઃఆΛ͠௚͍ͯͨ͠

ɹϨϓϦέʔγϣϯͷঢ়گ Ϛελʔ࠶ىಈͷ౎౓ εϨʔϒͷ ઃఆΛ͠௚͍ͯͨ͠ ͭΒ͍

ɹϨϓϦέʔγϣϯͷঢ়گ ͋·Γʹ΋໘౗Ͱ εϨʔϒΛ

ɹϨϓϦέʔγϣϯͷঢ়گ ͋·Γʹ΋໘౗Ͱ εϨʔϒΛ 4501ʂ

ͭ·Γ

ͭ·Γ ӡ༻͔Β ಀ͍͛ͯͨ

Ͱ΋ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɻ

๻͕ ΍Γ·͢

ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ

ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ఆٛ ɹɾϚελʔଆʹ࡞੒ ɹɾεϨʔϒ͔Β઀ଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ

ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣࣮͸ɾɾɾ ɹɹϚελʔଆͷطଘϢʔβʔͰ΋ ɹɹ઀ଓ͕Մೳ ͔͠͠ɾɾɾ

ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ 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Ͱ͖ͯΔ͔ ɹɹɹˠҐஔ৘ใΛ֬ೝ

ɹɹϚελʔόΠφϦϩάͷ֬ೝ 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-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) DPNNJUΛ௨஌ޙ εϨʔϒ͕઀ଓͯ͠औಘ WBSMJCNZTRM NZTRMCJO999999

mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ϚελʔͰ DPNNJU͕࣮ߦ͞Εͨ ϙδγϣϯ

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

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@)PTUɿϚελʔϗετ໊ Ϛελʔͷϗετ໊ ʢ·ͨ͸*1ΞυϨεʣ ɹ มߋ͞Ε͍ͯΕ͹ ࠶ઃఆ͕ඞཁ

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@6TFSɿSFQM εϨʔϒ͔ΒϚελʔʹ ઀ଓ͢ΔϢʔβʔ໊ ɹ ઌ΄Ͳઃఆͨ͠ઐ༻Ϣʔβʔ

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@6TFSɿSFQM εϨʔϒ͔ΒϚελʔʹ ઀ଓ͢ΔϢʔβʔ໊ ɹ ϚελʔͰ࡞੒ͨ͠ઐ༻Ϣʔβʔ

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@-PH@'JMFɿNZTRMCJO εϨʔϒ͕Ϛελʔ͔Β औಘ͢ΔόΠφϦϩά ɹ Քಇ͍ͯ͠ͳ͔ͬͨͷͰ ζϨ͍ͯΔ

mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ϩʔςʔτ͞Εͯ ϑΝΠϧ͕ͳ͍ͷͰ औಘͰ͖ͳ͍

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣3FBE@.BTUFS@-PH@1PTɿ εϨʔϒͷ*0εϨου͕ ࠷ޙʹಡΈऔͬͨҐஔ ɹ ͔͜͜ΒϨϓϦέʔγϣϯ࠶։͕ͩ େ͖͘ζϨ͍ͯΔ

mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ͕ࠩ͋Γ͗͢Δͱ ಉظͷࡍʹ ෛՙ͕͔͔Δ

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ/0 εϨʔϒͷ*0εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ ϚελʔͷόΠφϦϩά͕ҧ͏ͷͰ ઀ଓͰ͖͍ͯͳ͍

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ/0 εϨʔϒͷ42-εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ εϨʔϒͷ%#͕ ߋ৽͞Ε͍ͯͳ͍

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ/6-- Ϛελʔʹൺ΂ͯ ஗Ԇ͍ͯ͠Δඵ਺ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ/6-- Ϛελʔʹൺ΂ͯ ஗Ԇ͍ͯ͠Δඵ਺ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍ ྫɿϚελʔͰඵ͔͔Δ ɹɹτϥϯβΫγϣϯ࣮ߦ εϨʔϒͰಉ͡42-͕࣮ߦ ͞ΕΔͷͰɺඵ஗Ԇ͢Δ

ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ઀ଓ͍ͯ͠Δ Ϛελʔͷ*% ɹ ઀ଓͰ͖͍ͯͳ͍

ϚελʔͷNZDOG ϨϓϦέʔγϣϯ͞Ε͍ͯΕ͹ ͜ͷ஋ʹͳΔ

ɹϨϓϦέʔγϣϯखॱ

ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه࿥ ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛ؂ࢹ

ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼ୐લʹ࣮ࢪ ɹɾਂ໷όονͰEVNQ࣮ߦ

mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) εϨʔϒઃఆͰ࢖༻͢ΔͨΊ ϝϞ͓͖ͯ͠·͠ΐ͏

ɹɹεϨʔϒͷNZDOGઃఆ

ɹɹεϨʔϒͷNZDOGઃఆ ϚελʔɺεϨʔϒ શͯ߹Θͤͯ Ұҙͷ*%

ɹɹεϨʔϒͷNZDOGઃఆ όΠφϦϩάઃఆ Ϛελʔʹঢ֨ͨ͠৔߹ εϨʔϒʹ௨஌͢Δ

ɹɹεϨʔϒͷNZDOGઃఆ ϩʔςʔτͯ͠ ༰ྔѹഭ͠ͳ͍Α͏ʹ

ɹɹεϨʔϒͷNZDOGઃఆ εϨʔϒͰ΋ όΠφϦϩάΛग़ྗ͠ Ϛελʔঢ֨Մೳʹ

ɹɹεϨʔϒͷNZDOGઃఆ ಉظ࣌ɺ 1,͕ॏෳ͢ΔϨίʔυΛ ඈ͹͢

ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ

ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ ⾣NZTRM࠶ىಈ ⾣ϦετΞର৅ͷ ɹɹɹσʔλϕʔε࡟আɾ࠶࡞੒

ɹɹεϨʔϒʹϦετΞ ⾣ਂ໷όονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹ஫ҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ

ɹɹεϨʔϒʹϦετΞ ⾣ਂ໷όονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹ஫ҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ 163(&."45&3-0(450 bNZTRMCJOYYYYYY` ద੾ʹύʔδ͠·͠ΐ͏

ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ 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; ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ ೦ͷͨΊ εϨʔϒΛࢭΊ·͢

-> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136; ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ εϨʔϒ͕อ͍࣋ͯͨ͠ ϨϓϦέʔγϣϯҐஔΛ Ϧηοτ͠·͢

-> 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 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 εϨʔϒͷݱࡏͷεςʔλε ϨϓϦέʔγϣϯ͕։࢝͞Ε Ϛελʔ͔ΒͷΠϕϯτ଴ͪ

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@-PH@'JMFɿ NZTRMCJO ϚελʔͷόΠφϦϩάϑΝΠϧ ݱࡏϚελͰߋ৽͞Ε͍ͯΔ ϑΝΠϧ໊ʹͳ͍ͬͯΔ

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣3FBE@.BTUFS@-PH@1PTɿ ϚελʔͷόΠφϦϩά͔Β εϨʔϒ͕ಡΈऔͬͨҐஔ ˞42-࣮ߦ͞Εͨͱ͸ݶΒͳ͍

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣3FBE@.BTUFS@-PH@1PTɿ ϚελʔͷόΠφϦϩά͔Β *0εϨου͕ಡΈऔͬͨҐஔ ˞42-࣮ߦ͞Εͨͱ͸ݶΒͳ͍

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣&YFD@.BTUFS@-PH@1PTɿ *0εϨου͕ಡΈࠐΜͩϩά͔Β 42-εϨου͕ ࣮ߦͨ͠ΫΤϦͷҐஔ

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣&YFD@.BTUFS@-PH@1PTɿ *0εϨου͕ಡΈࠐΜͩϩά͔Β 42-εϨου͕ ࣮ߦͨ͠ΫΤϦͷҐஔ ಡΈऔͬͨҐஔʔ࣮ߦͨ͠Ґஔ ʹ ஗Ԇ͍ͯ͠ΔτϥϯβΫγϣϯ

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ εϨʔϒ͕Ϛελʔʹൺ΂ ஗Ԇ͍ͯ͠Δඵ਺

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ εϨʔϒ͕Ϛελʔʹൺ΂ ஗Ԇ͍ͯ͠Δඵ਺ ஗ԆτϥϯβΫγϣϯͷ ֤ඵ਺ͷ૯߹ܭ

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ:&4 ϚελʔͷόΠφϦϩάΛ औಘͰ͖͍ͯΔ͔

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ:&4 औಘͨ͠όΠφϦϩάͷ 42-࣮ߦͰ͖͍ͯΔ͔

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠*0εϨουͷ Τϥʔ൪߸

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ *0εϨουͷ Τϥʔ൪߸

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ *0εϨουͷ Τϥʔϝοηʔδ

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔ൪߸

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔ൪߸ 1,ॏෳΤϥʔͷ৔߹

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔϝοηʔδ

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔϝοηʔδ 1,ॏෳΤϥʔͷ৔߹ &SSPS%VQMJDBUFFOUSZGPS LFZ13*."3:PORVFSZɽɽɽ

ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ಉظ͍ͯ͠Δ Ϛελʔͷ*%

ɹ࣮ߦঢ়گΛ؂ࢹ 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

mysql_replication

mysql_replication

More Decks by mamy1326

Other Decks in Programming

Featured

Transcript