「レプリケーション追加手順」の編集履歴(バックアップ)一覧はこちら
「レプリケーション追加手順」(2013/12/13 (金) 17:54:15) の最新版変更点
追加された行は緑色になります。
削除された行は赤色になります。
<div><span style="background-color:transparent;font-size:10pt;line-height:13pt;font-family:Arial, Helvetica, FreeSans, sans-serif;">
1.レプリケーションのマスタとなるDBからダンプする</span></div>
<div>
<div class="wiki-content" style="line-height:13pt;margin:1em 0px 0px;font-family:Arial, Helvetica, FreeSans, sans-serif;">
<div class="code panel" style="color:#000000;padding:0px;margin:10px 0px;border:1px dashed rgb(187,187,187);">
<div class="codeContent panelContent" style="background-color:transparent;color:rgb(51,51,51);margin:10px 0px;padding:0px 10px;font-size:.95em;">
<div class="syntaxhighlighter nogutter bash" id="highlighter_933974" style="width:1555px;margin:1em 0px;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;font-size:1em;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
mysqldump --single-transaction --all-databases --master-data=1 --host --port
-uroot -p > db.dump</code></div>
</div>
</td>
</tr></tbody></table></div>
</div>
</div>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
</p>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
2.レプリケーションのスレーブとなるDBにリストアする(※リストアするDBは初期状態)</p>
<div class="code panel" style="color:#000000;padding:0px;margin:10px 0px;border:1px dashed rgb(187,187,187);">
<div class="codeContent panelContent" style="background-color:transparent;color:rgb(51,51,51);margin:10px 0px;padding:0px 10px;font-size:.95em;">
<div class="syntaxhighlighter nogutter bash" id="highlighter_476494" style="width:1555px;margin:1em 0px;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;font-size:1em;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
mysql -uroot -p < db.dump</code></div>
</div>
</td>
</tr></tbody></table></div>
</div>
</div>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
</p>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
3.マスタのポジションチェック</p>
<div class="code panel" style="color:#000000;padding:0px;margin:10px 0px;border:1px dashed rgb(187,187,187);">
<div class="codeContent panelContent" style="background-color:transparent;color:rgb(51,51,51);margin:10px 0px;padding:0px 10px;font-size:.95em;">
<div class="syntaxhighlighter nogutter bash" id="highlighter_494342" style="width:1555px;margin:1em 0px;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;font-size:1em;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash functions" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(255,20,147);">
head</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">-50
db.dump</code></div>
</div>
</td>
</tr></tbody></table></div>
</div>
</div>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
</p>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
4.スレーブの設定および開始</p>
<div class="code panel" style="color:#000000;padding:0px;margin:10px 0px 0px;border:1px dashed rgb(187,187,187);">
<div class="codeContent panelContent" style="background-color:transparent;color:rgb(51,51,51);margin:10px 0px;padding:0px 10px;font-size:.95em;">
<div class="syntaxhighlighter nogutter bash" id="highlighter_521014" style="width:1555px;margin:1em 0px;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;font-size:1em;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
CHANGE MASTER TO MASTER_HOST =</code><code class="bash string" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,51,102);">''</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">,</code></div>
<div class="line number2 index1 alt1" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_USER
=</code><code class="bash string" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,51,102);">'slave'</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">,</code></div>
<div class="line number3 index2 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_PASSWORD
=</code><code class="bash string" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,51,102);">'slave'</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">,</code></div>
<div class="line number4 index3 alt1" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_PORT
= ,</code></div>
<div class="line number5 index4 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_LOG_FILE
=</code><code class="bash string" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,51,102);">''</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">,</code></div>
<div class="line number6 index5 alt1" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_LOG_POS
=</code></div>
<div class="line number7 index6 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
;</code></div>
<div class="line number8 index7 alt1" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
START SLAVE;</code></div>
<div> </div>
</div>
</td>
</tr></tbody></table></div>
</div>
</div>
</div>
</div>
<p> </p>
<div><span style="background-color:transparent;font-size:10pt;line-height:13pt;font-family:Arial, Helvetica, FreeSans, sans-serif;">
1.レプリケーションのマスタとなるDBからダンプする</span></div>
<div>
<div class="wiki-content" style="line-height:13pt;margin:1em 0px 0px;font-family:Arial, Helvetica, FreeSans, sans-serif;">
<div class="code panel" style="color:#000000;padding:0px;margin:10px 0px;border:1px dashed rgb(187,187,187);">
<div class="codeContent panelContent" style="background-color:transparent;color:rgb(51,51,51);margin:10px 0px;padding:0px 10px;font-size:.95em;">
<div class="syntaxhighlighter nogutter bash" id="highlighter_933974" style="width:1555px;margin:1em 0px;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;font-size:1em;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
mysqldump --single-transaction --all-databases --master-data=1 --host
<MasterIP> --port <MasterPort> -uroot -p > db.dump</code></div>
</div>
</td>
</tr></tbody></table></div>
</div>
</td>
</tr></tbody></table></div>
</div>
</div>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
</p>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
2.レプリケーションのスレーブとなるDBにリストアする(※リストアするDBは初期状態)</p>
<div class="code panel" style="color:#000000;padding:0px;margin:10px 0px;border:1px dashed rgb(187,187,187);">
<div class="codeContent panelContent" style="background-color:transparent;color:rgb(51,51,51);margin:10px 0px;padding:0px 10px;font-size:.95em;">
<div class="syntaxhighlighter nogutter bash" id="highlighter_476494" style="width:1555px;margin:1em 0px;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;font-size:1em;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
mysql -uroot -p < db.dump</code></div>
</div>
</td>
</tr></tbody></table></div>
</div>
</div>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
</p>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
3.マスタのポジションチェック</p>
<div class="code panel" style="color:#000000;padding:0px;margin:10px 0px;border:1px dashed rgb(187,187,187);">
<div class="codeContent panelContent" style="background-color:transparent;color:rgb(51,51,51);margin:10px 0px;padding:0px 10px;font-size:.95em;">
<div class="syntaxhighlighter nogutter bash" id="highlighter_494342" style="width:1555px;margin:1em 0px;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;font-size:1em;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<code class="bash functions" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(255,20,147);">
head</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">-50
db.dump</code></div>
</div>
</td>
</tr></tbody></table></div>
</div>
</div>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
</p>
<p style="font-size:10pt;line-height:13pt;background-color:transparent;padding:0px;margin-bottom:10px;">
4.スレーブの設定および開始</p>
<div class="code panel" style="color:#000000;padding:0px;margin:10px 0px 0px;border:1px dashed rgb(187,187,187);">
<div class="codeContent panelContent" style="background-color:transparent;color:rgb(51,51,51);margin:10px 0px;padding:0px 10px;font-size:.95em;">
<div class="syntaxhighlighter nogutter bash" id="highlighter_521014" style="width:1555px;margin:1em 0px;font-size:1em;">
<table border="0" cellpadding="0" cellspacing="0" style="clear:left;width:1555px;font-size:1em;line-height:1.2em;border:0px;margin:0px;padding:0px;background-image:none;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;"><tbody style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"><tr style="font-size:1em;line-height:1.2em;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px;vertical-align:baseline;width:auto;"><td class="code" style="width:1555px;font-size:1em;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;border:0px dashed;background-image:none;float:none;height:auto;">
<div class="container" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 0px 0px 0em;vertical-align:baseline;width:auto;font-size:1em;" title="Hint: double-click to select code">
<div class="line number1 index0 alt2" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;font-size:1em;">
<div class="line number1 index0 alt2" style="line-height:15.1875px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
CHANGE MASTER TO MASTER_HOST =</code> <code class="bash string" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,51,102);">
'<MasterIP>'</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">,</code></div>
<div class="line number2 index1 alt1" style="line-height:15.1875px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_USER
=</code> <code class="bash string" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,51,102);">
'slave'</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">,</code></div>
<div class="line number3 index2 alt2" style="line-height:15.1875px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_PASSWORD
=</code> <code class="bash string" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,51,102);">
'slave'</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">,</code></div>
<div class="line number4 index3 alt1" style="line-height:15.1875px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_PORT
= <MasterIP>,</code></div>
<div class="line number5 index4 alt2" style="line-height:15.1875px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_LOG_FILE
=</code> <code class="bash string" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,51,102);">
'<MasterBinlogFile>'</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">,</code></div>
<div class="line number6 index5 alt1" style="line-height:15.1875px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;">
<code class="bash spaces" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;">
</code><code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">MASTER_LOG_POS
= <MasterPosition></code></div>
<div class="line number7 index6 alt2" style="line-height:15.1875px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
;</code></div>
<div class="line number8 index7 alt1" style="line-height:15.1875px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;background-image:none;border:0px;float:none;height:auto;margin:0px;padding:0px 1em 0px 0em;vertical-align:baseline;width:auto;">
<code class="bash plain" style="background-image:none;border:0px;float:none;height:auto;line-height:1.2em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,0,0);">
START SLAVE;</code></div>
</div>
</div>
</td>
</tr></tbody></table></div>
</div>
</div>
</div>
</div>
<p> </p>