<html xmlns="http://www.w3.org/1999/xhtml"><head><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/11467120/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><title></title></head><body><div id="sidebar" style="display: none"><div id="outline"></div></div><div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/11467120/bg1.jpg"><div class="c x1 y1 w2 h2"><div class="t m0 x2 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">陈华军</div><div class="t m0 x3 h3 y3 ff1 fs0 fc0 sc0 ls0 ws0">苏宁云商<span class="_ _0"> </span><span class="ls1">2016/<span class="_ _1"></span>5</span></div><div class="t m0 x4 h4 y4 ff1 fs1 fc0 sc0 ls0 ws0">基于<span class="ls2">Pa<span class="_ _2"></span>c<span class="_ _2"></span>e<span class="_ _2"></span>ma<span class="_ _2"></span>ke<span class="_ _2"></span>r<span class="_ _2"></span>+<span class="_ _2"></span>M<span class="_ _3"></span>H<span class="_ _2"></span>A<span class="_ _3"></span></span>的<span class="ls3">MyS<span class="_ _3"></span>QL</span>高<span class="_ _3"></span>可用实<span class="_ _4"></span>践</div></div></div><div class="pi" data-data='{"ctm":[1.140143,0.000000,0.000000,1.140143,0.000000,0.000000]}'></div></div></body></html>
<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/11467120/bg2.jpg"><div class="c x1 y1 w2 h2"><div class="t m0 x5 h5 y5 ff2 fs2 fc1 sc0 ls0 ws0">!</div><div class="t m0 x6 h6 y6 ff3 fs3 fc2 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff1 fs4">曾经的<span class="ls4">MyS<span class="_ _1"></span>QL<span class="_ _3"></span>HA<span class="ls0">方案</span></span></span></div><div class="t m0 x6 h7 y7 ff3 fs5 fc3 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff4 fs6">如何防止脑裂和数据丢失</span></div><div class="t m0 x6 h7 y8 ff3 fs5 fc3 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff4 fs6">实现方式的选择</span></div><div class="t m0 x6 h7 y9 ff3 fs5 fc3 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff4 fs6">基于<span class="ls5">Pa<span class="_ _6"></span>c<span class="_ _6"></span>e<span class="_ _4"></span>m<span class="_ _3"></span>a<span class="_ _6"></span>k<span class="_ _2"></span>e<span class="_ _3"></span>r<span class="_ _6"></span></span>实现<span class="ls6">My<span class="_ _2"></span>SQL<span class="_ _7"> </span><span class="ls7">HA</span></span></span></div><div class="t m0 x6 h7 ya ff3 fs5 fc3 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff4 fs6">双节点零数据丢失<span class="ls7">HA<span class="_ _3"></span></span>方案</span></div></div></div><div class="pi" data-data='{"ctm":[1.140143,0.000000,0.000000,1.140143,0.000000,0.000000]}'></div></div>
<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/11467120/bg3.jpg"><div class="c x1 y1 w2 h2"><div class="t m0 x5 h5 y5 ff2 fs2 fc1 sc0 ls0 ws0">"</div><div class="t m0 x7 h8 yb ff4 fs7 fc4 sc0 ls0 ws0">曾经的<span class="ls8">MyS<span class="_ _3"></span>Q<span class="_ _2"></span>L<span class="_ _7"> </span><span class="ls9">HA</span></span>方案</div><div class="t m0 x6 h9 yc ff2 fs8 fc5 sc0 lsa ws0">#$<span class="_ _2"></span>$%&<span class="_ _2"></span>'<span class="_ _2"></span>(<span class="_ _2"></span>)<span class="_ _8"></span>$<span class="_ _8"></span>*<span class="ls0">+<span class="ff5">主</span>,<span class="_ _9"> </span></span>#$<span class="_ _8"></span>$<span class="_ _8"></span>%&<span class="_ _2"></span>'<span class="_ _2"></span>(<span class="_ _2"></span>)<span class="_ _8"></span>$<span class="_ _8"></span>*<span class="ls0">+<span class="ff5">备</span>,</span></div><div class="t m0 x8 h9 yd ff2 fs8 fc5 sc0 lsb ws0">-.<span class="_ _1"></span>/<span class="_ _a"></span>0<span class="_ _b"></span>-&1<span class="_ _b"></span>&<span class="_"> </span>2$3+<span class="_ _1"></span><span class="ff5 ls0">主<span class="ff2">,</span></span></div><div class="t m0 x9 h9 ye ff2 fs8 fc5 sc0 lsb ws0">-.<span class="_ _1"></span>/<span class="_ _a"></span>0<span class="_ _b"></span>-&1<span class="_ _b"></span>&<span class="_"> </span>2$3+<span class="_ _1"></span><span class="ff5 ls0">备<span class="ff2">,</span></span></div><div class="t m0 xa ha yf ff2 fs8 fc5 sc0 lsb ws0">-4<span class="_ _a"></span>5<span class="_ _a"></span>67+<span class="_ _1"></span>-&8<span class="_ _a"></span>9<span class="_ _b"></span>$3,</div><div class="t m0 xb ha y10 ff2 fs8 fc5 sc0 lsb ws0">-4<span class="_ _a"></span>5<span class="_ _a"></span>67+<span class="_ _1"></span>5<span class="_ _b"></span>'&)<span class="_ _1"></span>$<span class="_ _1"></span>,</div><div class="t m0 xc ha y11 ff2 fs8 fc5 sc0 lsc ws0">:3<span class="_ _3"></span>(<span class="_ _2"></span>9<span class="_ _8"></span>$<span class="_ _8"></span>;<span class="_ _2"></span>)(<span class="_ _3"></span>%</div><div class="t m0 xd hb y12 ff5 fs0 fc4 sc0 ls0 ws0">主机<span class="_ _c"> </span>备机</div><div class="t m0 xe h9 y13 ff2 fs8 fc4 sc0 lsd ws0"><(1<span class="_ _a"></span>2'=<span class="_ _a"></span>2<span class="ff5 ls0">复制</span></div><div class="t m0 xf hc y14 ff4 fs8 fc5 sc0 ls0 ws0">应用</div></div></div><div class="pi" data-data='{"ctm":[1.140143,0.000000,0.000000,1.140143,0.000000,0.000000]}'></div></div>
<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/11467120/bg4.jpg"><div class="c x1 y1 w2 h2"><div class="t m0 x10 hd y15 ff3 fs3 fc4 sc0 ls0 ws0">!<span class="_ _d"> </span><span class="ff4">主备之间的网络出现故障时，<span class="_ _b"></span>集群脑<span class="_ _b"></span>裂，导<span class="_ _b"></span>致数据双<span class="_ _b"></span>写，<span class="lse">VI<span class="_ _1"></span>P<span class="ls0">来<span class="_ _b"></span>回切换。</span></span></span></div><div class="t m0 x5 h5 y5 ff2 fs2 fc1 sc0 ls0 ws0">></div><div class="t m0 x7 h8 yb ff4 fs7 fc4 sc0 ls0 ws0">存在的问题</div><div class="t m0 x11 h9 y16 ff2 fs8 fc5 sc0 lsa ws0">#$<span class="_ _8"></span>$<span class="_ _8"></span>%&<span class="_ _2"></span>'<span class="_ _2"></span>(<span class="_ _2"></span>)<span class="_ _8"></span>$<span class="_ _8"></span>*<span class="ls0">+<span class="ff5">主</span>,</span></div><div class="t m0 x12 h9 y17 ff2 fs8 fc5 sc0 lsb ws0">-.<span class="_ _1"></span>/<span class="_ _a"></span>0<span class="_ _b"></span>-&1<span class="_ _b"></span>&<span class="_"> </span>2$3+<span class="_ _1"></span><span class="ff5 ls0">主<span class="ff2">,</span></span></div><div class="t m0 x13 ha y18 ff2 fs8 fc5 sc0 lsb ws0">-4<span class="_ _a"></span>5<span class="_ _a"></span>67+<span class="_ _1"></span>-&8<span class="_ _a"></span>9<span class="_ _b"></span>$3,</div><div class="t m0 x14 ha y19 ff2 fs8 fc5 sc0 lsc ws0">:3<span class="_ _3"></span>(<span class="_ _2"></span>9<span class="_ _8"></span>$<span class="_ _8"></span>;<span class="_ _2"></span>)(<span class="_ _3"></span>%</div><div class="t m0 x15 hb y1a ff5 fs0 fc4 sc0 ls0 ws0">主机<span class="ff2">+</span>旧<span class="ff2">,</span></div><div class="t m0 x16 h9 y1b ff2 fs8 fc5 sc0 lsa ws0">#$<span class="_ _8"></span>$<span class="_ _8"></span>%&<span class="_ _2"></span>'<span class="_ _2"></span>(<span class="_ _2"></span>)<span class="_ _8"></span>$<span class="_ _8"></span>*<span class="ls0">+<span class="ff5">主</span>,</span></div><div class="t m0 x17 h9 y1c ff2 fs8 fc5 sc0 lsb ws0">-.<span class="_ _1"></span>/<span class="_ _a"></span>0<span class="_ _b"></span>-&1<span class="_ _b"></span>&<span class="_"> </span>2$3+<span class="_ _1"></span><span class="ff5 ls0">主<span class="ff2">,</span></span></div><div class="t m0 x18 ha y1d ff2 fs8 fc5 sc0 lsb ws0">-4<span class="_ _a"></span>5<span class="_ _a"></span>67+<span class="_ _1"></span>-&8<span class="_ _a"></span>9<span class="_ _b"></span>$3,</div><div class="t m0 x19 ha y1e ff2 fs8 fc5 sc0 lsc ws0">:3<span class="_ _3"></span>(<span class="_ _2"></span>9<span class="_ _8"></span>$<span class="_ _8"></span>;<span class="_ _2"></span>)(<span class="_ _3"></span>%</div><div class="t m0 x1a hb y1f ff5 fs0 fc4 sc0 ls0 ws0">主机<span class="ff2">+</span>新<span class="ff2">,</span></div><div class="t m0 x1b he y20 ff4 fs9 fc4 sc0 ls0 ws0">分区1</div><div class="t m0 x1c he y21 ff4 fs9 fc4 sc0 ls0 ws0">分区2</div><div class="t m0 x1d h6 y22 ff1 fs4 fc6 sc0 ls0 ws0">教训：<span class="lsf">Kee<span class="_ _8"></span>pAl<span class="_ _2"></span>i<span class="_ _2"></span>v<span class="_ _8"></span>e<span class="_ _8"></span>d</span>不适合做有状态服务的<span class="ls10">HA</span></div></div></div><div class="pi" data-data='{"ctm":[1.140143,0.000000,0.000000,1.140143,0.000000,0.000000]}'></div></div>
<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/11467120/bg5.jpg"><div class="c x1 y1 w2 h2"><div class="t m0 x5 h5 y5 ff2 fs2 fc1 sc0 ls0 ws0">?</div><div class="t m0 x6 h7 y23 ff3 fs5 fc3 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff4 fs6">苏宁曾经的<span class="ls6">My<span class="_ _8"></span>SQL<span class="_ _2"></span><span class="_ _e"></span>HA<span class="_ _3"></span></span>方案</span></div><div class="t m0 x6 h6 y24 ff3 fs3 fc2 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff1 fs4">如何防止脑裂和数据丢失</span></div><div class="t m0 x6 h7 y8 ff3 fs5 fc3 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff4 fs6">实现方式的选择</span></div><div class="t m0 x6 h7 y9 ff3 fs5 fc3 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff4 fs6">基于<span class="ls5">Pa<span class="_ _6"></span>c<span class="_ _6"></span>e<span class="_ _4"></span>m<span class="_ _3"></span>a<span class="_ _6"></span>k<span class="_ _8"></span>e<span class="_ _4"></span>r<span class="_ _6"></span></span>实现<span class="ls6">My<span class="_ _8"></span>SQL<span class="_ _2"></span><span class="_ _e"></span>HA</span></span></div><div class="t m0 x6 h7 ya ff3 fs5 fc3 sc0 ls0 ws0">!<span class="_ _5"> </span><span class="ff4 fs6">双节点零数据丢失<span class="ls7">HA<span class="_ _3"></span></span>方案</span></div></div></div><div class="pi" data-data='{"ctm":[1.140143,0.000000,0.000000,1.140143,0.000000,0.000000]}'></div></div>
专场20：数据库自动化运维
