何玲 发表于 2025-5-29 16:13:24

数据库架构的升级和变更

    SQLServer2008在数据的高安全、高性能、高可用方面的技术已经比较成熟,这些技术和方案都是随着很多公司的业务和数据访问压力的增加而不断的升级和
变迁的,同时经历了方方面面的考验,证明了它们都是成熟可靠的,下面就这方面的技术方案和变迁过程来做一些分析。
 阶段一:
裸奔时代:
https://www.cnblogs.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAP8AAAB1CAIAAAAOQaAjAAAUgElEQVR4nO2deVRT57qH9+1a99Y6NU6tlmqirUKPbaXHtuqpRc6pVetAwXOqeHW1tFirbVWqqFirsSoiWsUBpU5EBhEFjMEBBTHIPATCjIlAZEoYZAyQECDv/WN7s1ISkp2QhL3J967fH6zN5vH7Xp79wd5r+4GBzhIKhbpPUK/q6mriJyMyIg86GSPJOBAZkS1PRvYjsvWSkf2IbL1kZD8iWy8Z2Y/I1kvGhDorKytL9wnqxefziZ+MyIg86GS09iOy9ZKR/YhsvWRkPyJbLxnZj8jWS0b2I7L1kpH9iGy9ZGQ/IlsvGdmPyNZLRvYjsvWSkf2IbL1kZD8iWy8Z2Y/I1ktG9iOy9ZKR/YhsvWSsWmfx+XzdJ6hXUVER8ZNxcnBw8KJFi/z9/U1OJliIPLhkrQJYbMyDtvbfunXL0dFxxfKl10PPr1vrymAw2Gy2SchDYE2yBnJaWlp/Agzl33xEIpGzs/Ocjz+6FXmlujQNT2bynRUrltrb28fExBhNxou0329ExkuvAEPTfolE4uHhwaDTQ1jnasoyNPPofsSizxc6OjpyuVyDyOYbMyKbkExQAAcHhz4CmGnMFrJfJpMxmUxbW1ufQ0xxeZbucCKDHRw+XbJkCZ/P10s235gR2YTk8vLygQhgpjFbwv6AgAAGnb5713ZhQZJElE0wEWGXZ81639nZWSQSUfH7jciqGrgAZhqzee1ns9m2trbr3d0K+Qm1FXwjEhr0J4NOX7dune4WmHDMiGxCsqkEcHNz608AMtqP39E7rVielnSvrjJvgDnnf9zO1tbDw0MikRg6Q+JjRmQTki0mALnsf3FHP+fj2+yw+qoCU6W6LPvI4d8ZdDqTyWxubjbtmAkWIhMhW1gAstifl5fn4eHBYNCvBl+ory40R6rLc37dvYPBoDOZTJlMNvAxk9wkapFfPNKxrACDbz/+SMfO1tbX50CDuNjcKRNk4S3w8/PTvAaGhknUIg+iAOXl5UZ3wwT2BwQEMBj0Pbt3lguzn0sEFsuTgvStW7fY29sbMWZVkdAkypHJJgDxbgzIfjabbWdr+/367wSFGY21Ty2ZjrYGpbK3rqoQw/pOgdImUYtMTgGId8NI+1/c0TutyErjNtWVWTLtLbXK3t7melFWXEDs1R3I/kEhp6WlOTg4kFMA4t0w2H7VHf29O1HNDSJLRtoi6e3taW+pzU0MehSx72H4r8h+y5PJLwDxbhiwh3N6evqmTZsYDHp4WFDL8wpLpq1F0tvTLe9sLcliJ97yToj6XX3yOsast8i5tzA5yVQRgHg3CK39L+7o7WyP+R5ubayyZKTNkp5uhbyzrawgLu3eiZTbRzUnr/v61l1DdYU2LZlaAhDvhn77AwICGAzGb3t2Vz8TtDXVWCztLXU93V1dMmmlMJUXfz79/mlk/6CQKScA8W7o+Up7e/sfNnxfJiyQNkssl5a6boVc3tlaW5GXn3yVF38hM+4csn9QyFQUgHg39HwlhmHSZklne1N7a51l0t3V2SVra5QISzJv5iWF8BNYyP5BJFNRAOLd0G9/YXpER1uDvLO1o63BrFF0dXTJ21sbK0vzHxSl3yhICUP2DzqZigIQ74Z++3MSWIUZUe2tdV0yaae00RxRyDtAqWxvra8oSRTk3C7JYiP7SUKmogDEu0HI/tyk0OLMm+2t9T3dXbL2ZhNGIW9XKpWyjhaxKKesIO5pbgyyn1RkKgpAvBtE7S9Ivf6EF93yvFKpVCrkUnln6wCjkHcolUpFV0d9dXHFk2RRcYKV2C+VSs1E1lqmsp9CAhDvhgH2F2VElfCiq8uyFPL23h5Fl6zNuCi62pXK3p5uRXN9eU1ZVtXT9CFgv1QqdXFx8fb2dnd3F4vF/ZHx01Qfz58/n8vlcrncbdu2WX7MRMhUFIB4Nwy2X5gbU17ElbZIQKns6ZYrutoNSadS2dvb0y1tltRXFUqe8YeM/QDg7e0NABwOx9/fXwfZ09NT9bHqSoiNjSU+jMG1n/wCEO+GMfaX5seJihPqqooU8g4AZW9vd7eiU1/k+LQ72hqa6sqei58MSfs5HI67uzsAcDic06dP+/v74ztzuLu783g83HtPT0+BQIB/rG4//rUhISH4VWSZMeslU1EA4t0gZH9GPGvuh+8tX+KQyb2mmnzFk+Sq0oznEqG8sxUAlMrenm651iiVvT3dXZ3Sxqa60kaJsFEiHKr2AwCXy/X29haLxYcOHfL29vb29ubxePinBAIBALi7u+NXCPzVfh6Px+Px1A9aYMx6yVQUgHg3iK79U+k2L730X2PHvHrp7EH1yYtFObWV+U11ZfLONqVSiXeht7ent0fR26N4Me32xkbJ04aaEvUMVfvFYrG7uzu+wOPrvWqlDwkJAQD8xkB97ReLxTdv3uTxePgPChLaTy0BiHeDqP2psYGz3p0x/JVhI4a/suizT/Iy7qhPvqGmpLG2tLnhWaf0uULe0dvTrVQquxUyWUdzo0RYX12kJUPLfrFY7OLi4unpiSsuEAg2btyIr/0AwOFwPD09uVwufppAIHBxceFwOPiFERISIhQK8R8R+NVimTETIVNRAOLd0LOHc59f+w7s+Yn26qiXXnpp9KiRRw7s1Jx8W1ONtKVW2lLb3loHAHVVBTpiqsn3GTPJdy3ujxwYGBgYGGgOMvGTNclUFIB4Nwy+6015GOb6lUt0dLRAIPjjmG/ktQt9Jt/WLMYDALUVuToylNb+oUqmogDEu0HU/ksXzqz/xiU3NVKYG9PWVCPrbGpvk3TJpT4+h6dMtjnjdxiffGtTjSoAIBHl6A6yn+RkKgpAvBtE7ZfJZP9ynPv2tCk3gv0qBKmKro4ueVuXvFWp7P1w9uxhw4YNGzbsS6elgRfP1olL8f+XAADicp7uIPtJTqaiAMS7QdR+AHD9z9L3Z854+y36t+tWFvJim+ufyTpapG1NRw7vH0N7dfjw4RiGjRw5YuTIEUncmJaGCgCoKcvUG2Q/mclUFIB4N4ja39OjyE69dWDvltdfG/fRh++/Mem1oIvHVTc91eW5F/88+fnCf7788ssjRozYsP6bpnoRAFQ9TScSZD9pyVQUgHg3iNr/NO+BXNYmKEwL/NNn5jvTGfQ3336LsfjzBVev+KtueprqyiSVxdHsMHznCQCoFKYSCbKftGQqCkC8G4a949lc/6y5sS4mOmTThrXjxtLsZ82cMX3a+PFjf9u9rSQ/tc9+QwBQ8SSZYJD95CRTUQDi3TD4iWelME0ua8vOTDx5bN8Xi/85evQo+1nv/mPeR2PG0Fycl10M8HsuEeIBgGfFjwkG2U9OMhUFIN4NY95yKyuIb3leUV8nvs0ODTx/fMP6dTZvTBozhvbp/LkLPp03ebJNdXleQ80TABAVcYkH2U9CMhUFIN4N49/xrK3IU8g7mhrrc3NSYm5fO3vKZ9VXTlMZkzEMq68urq8uBoDywnjiQfaTkExFAYh3w3j78dc8GsSCzvam3p5ucXV5dmZ8blYchmF1VYV1VYUAUFYQZ1CQ/WQjU1EA4t0YqP34A6+66qLWpupuhVwua8cwrLYyv7YyHwCe5t03LMh+kpGpKADxbpjAfklFnioN4if0KZNrK/MlFXkA8DT3nqFB9pOKTEUBiHfDBPaLRXytAQBhzh1Dg+y3PFkkEuF/Ccs4+8kmAPFu6Nn/Vu/ka8qz+wsACLKjjYihk5/z15o9e/acOXO2b9+umgWHw9msrc6dO6fatTglJSVEW92/f1/FuX//vtbjWotCezhv3rwZw7CFCxf+/vvvPB5P/VOUEMDobhi59j/hx+7atpETebmmjNdfAKAki21cDJo8968VEhLC5XJLSkpUs0hLS2NqKzabrVrt2Gy2o7by8fFRcS5duqQ6zmAwsP8vJpOpOofJZKqOMxgM1fksFkt1DovF6vOvzJkzp885XC5X65i5XK5qzCKRiKut1P+0rZDA2q8+ZgzDnJ2dWSwW/tOAEgLonWB/3TDS/rWrneavXDxh2puXAo5WlWZoDQAUZ0YZl6Hxm4+6nepGalqLX7Hq5xCxX/Mq0rzS8HVds9Sv2AULFmg9x83NjYoCEP8OGmk/hmEsfsx2zunRo0f19+oSABRlRBiZIWE/Vch91n4ajebm5sZms4GaAhDvhpH2Txg/9lfO2T3xlzAM6+/VJQAoTAsnmPArvoePHTx87OCRYwce3DxTmBaO7LcYGbefRqOtWrUKl15VFhNAM+S1/9qVk2Mmvz7T6VOnZQv7e28JAApSwnRk//4dcxcuHTZ6LIZhr9pMnzD9gwnTP5jw9gfDx07EMIw2ccqyr1yDLvsi+81N5nK5uPTEn/mYRAC9Ian9ouIEdvifu7b9IMiNf1aSpDUAkJ8cqjWswBPjJ79l877DJ+u8NpyN2xmeq5mvfaPsV6wf9Tp91vzP7kX6IfsHhWwmAQiGvPaLih/rDgDkJYVo5ifPbWPenO5+9IZPdDGRLNqwf9zUmcGXvZH9liebQwCDQkb7y4u4egMA/MdX+uRaqN/oifSTdwv/jC8lnp//CH9t6jvIfsuTTS6AwSGh/WWF8XoDADkJgX2y7eCR4WMn3cioNDQYhj2MPo3stzDZ5AIYEdLZTyQAkP3oUp+wb4diGHYruzquUEI8Z2KfYBiG1n7Lk00ugBEZfPsP7dk0f94H+CamT/NiiQQAePHnNYNh2Eq/xxcePc0qbySSfZEF/zmdguwfFLI5BDAig7/2nz/52zTGmzeC/YS594kEALLiAjSDYdgvoTlrA9K+OpOyNzI/rlBSWifVTGRmxU9B2S5+id9dzNgamq3Vfr9DW2g0mu4Z6q6h4aj5yOYQwIj0Z79WAYh3w4BdbNMfBic9CLJ/z+6Hb1fxEiOE/Hu6AwCZsWc1g2GY1/W8o3dKjtwu2XEtd11AmtOJRKcTiWvOpq45m7raP3X1mRSnE4nfXsjYG5nve6f4ILvwl6s5fewPOrdn/ifznJ2d1d/n0TpD3TU0HDUf2RwCGJc+9qsESE5ONrobRO0P9GfOencGO+ykIOfu9s1u0xhv7v/1J0HOXR0BgIwHZzSjsv8itywqq+pRcS2/ojlFWJ9R+jy3sjlJ0JBb2Zxe+jwmTxyWWuEfJ+xj/+1rR5Z9sWju3Ln4ft96Z6i7hoaj5iObQwDjorK/jwAD6YYBezjfuX561nu2zN2bSnjRSQ+CXP/9hd2MaYeZW0t40VoDAOkxJzWj1f5nDe2tnYruXmV9m1wgadNqf1zU8Y3fu9Hp9KCgIB1jpugezuQkm0MAo6NVgIF0g+jaHxHkGxXyR27KDdd/L/l03t/vRviXZN1iX/VzWf4vm0mv7d7mnvnoaknWLfUAQNq9E5ox2n47Ozs/Pz9Dr2/dVT0kVmjzkc0hgBFJjfHfse1HrQIMpBtE7X8Q5T/r3RlMr43FmewLp/ZNY9h8vWZFRnxocSY7jnP+6zUrRo0a8dmCOUyvjYkxrOJMdnEmGwBS7/yhGaPtx984N3SGumtoOGo+sjkEMCiZD84cObibwWAwmUytAljC/oLU6zlJ4atXLl76+fz0h8FFGVG7fvnWZtJrX7suf3zvclFGVFFG1Omju1avXDyVYYOfAADJ0b6aMdp+42aou4aGo+Yjm0MAgkmPOXnxrI+dnd3GjRslEok5umGA/YXpEYXpEccOekyl2+zb+X1hekRa3JVdHm7jx9GclzleveSNn6AKACRxfDSD7KcQ2RwC6E3K7WORV884OjpqfaZnwm7oUYpGo+3e+TM++YK0G3i4dy6scvncbjoj8CwTP3Lotx/ff3f6qJEjvlzmeMp3B34QABJveWsG2U8hsjkE0J1Hdy47OTnpeKand8w6yjD7hUKhl5eX29dr8lPD++RG0JGP/v43u+mMowe24EdSYi8f3LPpy2ULUmIv56eGA8Bj9kHNIPupRTa5AP0l4e4FDw8PBoNx/vz5AY65vzLYfgAICAhYvnRxVkJoXnJYn9xg+SxZOO+NSRO2bnS9dfUP9U8BQELUfs0g+ylHNq0Amsl4eNFr5y+qRzoW6wYh+wGAzWZ//NGHcdHnc5NCNXMvwu+7dSum0t+YSn9jyw+r8YMAwI1gagbZT0WyCQVQT1ZcwIljh/o80iGd/QDA5/Pt7Ox+3bmZnxjcX9ihvp6b12Y8vMxPDAaARzf2agbZT1GyqQTAk3r3eNClM1of6ZDRfgCQyWReXl62M2bcCD7BfxykOwAQf31Pn7BOb/3vV0YaZ39Xd68RM9RdQ89Rs5IHLkD89T1JHJ/bN6/oeKRDUvvxKikpmTt37prVKx+wz+UksPoLAMRd81IPN2r/wWNHxzFmGmq/66GwcZNnIPtJQh6IACnxEc7Ozrof6ZDafrxYLBaDwVj4meOpY3uzuZc1AwCxYTvxPIpkpnOv43f0sxeunP6P5cxrGQTt//l09PipM08Fs/sbCfExa9agm0Rd8qlTp4wToM+mKZYcs8nsxysmJsbV1XXixImbN313O/wkL/6iKgDwINQz7ppXXmoEk8lUf0njp33HR79OX+y288jVhzrs33UmcvYXa8dPmeF78brRM9RdJDGJumSCAuzdu5fga1oWGLOqBmo/XhKJxMfHx9bWlkajLftikZfnj8EXDgNAQWpYQECA1pc0ouMSHV2+oU1kvDJ63JS/fThv8covv9268jsPJ7ctHyxYZvPO7P8ZPur1t95b/fNvkuetpPp+I7ImGRfAzs6uPwG2b99O8DUti40Z9O7hbOjewjk5OYGBgR4eHg4ODvi2eGvXrk1JSdFBjo5LPHAqcJ3H/qX/+wOe9bt8fM+yHiZnqpOJD2Nw90O2cnJ/ApBzzKZZ+wd+FSIyIluejOxHZOslI/sR2XrJyH5Etl4ysh+RrZeM7Edk6yUj+xHZesnIfkS2XjKyH5Gtl4zsR2TrJSP7Edl6ych+RLZeMrIfka2XjOxHZOsl69nDmbR7CyMyIg+cjNZ+RLZeMrIfka2XjOxHZOslI/sR2XrJyH5Etl7y/wFwryL4zQ24EAAAAABJRU5ErkJggg==
优点:裸奔最大的好处就是简单,成本低。
缺点:一旦服务器出现问题,恢复起来比较麻烦;如果访问压力变大,服务器可能不堪重负。
 
阶段二:
单库+Mirror+BackUp方案:
 https://www.cnblogs.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQIAAADFCAIAAAAwt2u/AAAgAElEQVR4nO2de1zT9f7H9zg9TlZmh1+eSu3CrIRVKpjmpUNKx0uc0oJKo5PmOrOiKA8pKqaJmRNNElEUNXPSFESRmyio4FAu4zIZyGUwLuO6cR84YGNje//++HZ2dgZs333Z7Ts+78frj7H24fn9fN+fJ9/LlqMAKlTjvii23gBUqGxfSANUqJAGqFAhDVChAqQBKlSANECFCpAGqFAB0gAVKkAaoEIFxDRobm4mzBMKhYTHIi7iWoiLNEBcxEUaIC7iIg0QF3GRBoiLuEgDxEVcXQ2aTany8nKTXq9bfD6f8FjERVwLcdHRAHERF50UIS7iIg0QF3HtUYOEhAQvL6+YmBgrcw0U4lqBm5CQsGLFihH7blEu2JsGHA5n4cKFq1a+HXvu5OoPfdzd3TkcjhW4RgtxLco12ncLcbVlLxrw+XwvL6/Fiz1Sk8831+RhyUi7uHixh5eXl0AgsBAXZyGuhbg4+252rl7ZXgORSOTr6+vmNjs2+nRLbcHwxEafdnV19fPzk0gkDr8sxg/XpL6bkTti2VIDiUTi5+dHdXb+7WS4uI5nOIcOMqnOztu3b5dKpWPkEigHXo7W5xLoe3BwsNG+k08DqVQaFBREdXYOC90nqS/CmQZh/vagza6urpGRkcS4hLfZIZej9bkW7TuZNJDL5Tt37qQ6O/8Y/H1TdUFbQ7GpKednbmDQaTRaQkKCSWg7XBbjhyuXy0NCQizad9JoEBkZSXV23rxpY7Ugr63p3ljCzUp9d9VKT09PLpeLk25Xy2Jcca3TdxJoEBMTQ6U6b9jwWUVJVntzqblyJTF6wYL5vr6+IpHI6DbYz7IYP1xr9t2uNUhNTXV3d1+z+oPiQk5HS7klcub0MZqra0BAgOGrKHtYFuOHa/2+26kGXC7X09PzrRXLszKvdkoqLRpxw70D+3+iUp1DQkLkcvmI2zM+l6P1uYmJiTbpe1lZ2Vjma34NBAKBt7f3ggXzryZf7GoVWi0iYdG2rVvc3d1H3Krxthytz7Vt393c3MYyX3NqIBKJ6HQ6jeYac57V3VZjzfTLOjUadVtTGYUy8ozGz3K0Ptee+45zvubRQCKRBAQE0GiuJyOPSNvrrJm+3jaNekjaLipMj7xxfgvSwJpc++87zvmOVQOpVBocHEyjuR48wGwVC3s6662Wvh6JWq3q62ktzTnPubQrI/Z7pIHVuGTpO875EtdALpeHhYXRaK47dwQ1iSp6uxqtFlmvRD2kVAz0VhVdyUrcdzt+D9LAalxy9R3nfP8YLDSl+Hx+eHg4jeb67bf+NVUl97ubrZa+ntYh1aBCfl9UweFeC8tJOTh8d4y4zYWFhSbNUW++hMc6GJd0fcc5XyIOubu7f/rpuopSnkwqtl56WodUikG5rKW28O6tU/nXj462O0bcZqHD/VW2PpeMfcc5XyKDKRSKRj3U19Pe19NqnaiUcqWir72prDQnuohzujA9EmlgfS4Z+45zvgQ1qLl3Q6NRD8i6+u93WDTKwQHlYH93W10lL/Fe9rni22eRBrbikrHvOOdLUIOiTFZtabpGo1H0SwdkXZaIanAAQHO/u6W29GZFweUy7gWkgW25ZOw7zvkS16Ak+3x1yXUAjVIxIO+TmjFKxYBGoxmQdTUJuUL+1cq7SUgDe+CSse845zsmDUpzY2vu3Rzo69aohxQDvWOPUtGv0WgG5bK2xnt1Zbdq7t1AGtgPl4x9xznfsWpQXhBfefdKh7gKAFRK+aD8PrGoBvs1GrVKKe9qrW4Schsqs5AG9sYlY99xztc8GgiL0xqFXMVAr0ajVikHlIN9JkQ5oNGoh1SDvd3Nknp+S20h0sA+uWTsO875mk2D2tIMUcVtabtoaEip0WiGhgZVygFjUWg06iGVsv9+R6e4qq2pjEQacDgcDw+PqqoqAGAwGD4+PjKZDAAiIiJ8fHwsx8VZVtPAzvuOc77ENchIPvbwQxOWeS4oyLyg3R2Nwtzm2sKezsYhlQJAo1GrhlSKEYP9JRiQdXW11XRKhB0tleTSAAA8PDwiIiIAYMaMGUwmU/u8WCy2KBdPWU4DcvUd53yJa1Bw66zLi8898MADj//fX04f26u7OyT1xW1N5b3dzcrBAdBoADQajVqtHlKrlWq18o8d0dfVJanuaBFoQ0YNGAyGWCzWasDhcJhMJpvNxl7AZDIZDEZVVVVERERERIRMJsOewR4kJSVhL4uIiGAymZg8bDYb+w1JSUnbtm0jvM2W04Bcfcc53zGdFPEyz32y5u2HJjz44IN/XrHUoyT/qu7u6JQIu9vrerub5f1S5WC/Wj2EXQzJ+6RdEmF7U7leSKcBg8Hw8PBgs9k+Pj7aowGPx9M9MsydOxczQXumhDnD4/EYDAYA+Pj48Hg8mUzm4eGBvYDJZHp4eHA4nI8//hg76SJQFj0pIlHfcc7XDNcGsWdDp0158oEHHpj5yssH9gbp746uJllPK5a+3nYAaGssHS3k0iAwMNDDwyMwMDAwMNCABnr/IueMGTO0j6uqqnRXP3aKxWQyAwMDDXDxlBWuDUjRd5zzHevRALtUKs1PvpJ0Wa1WAcCmTQEHmDuE5Xna3XFfKtYGACT1xaOHZBpgBwQmk2lAAx6PpztKVwMej6erATZQ+8BuNSBR33HOd0wa/Lz/J49Fc65djhQWpw2pBu9LG2X3xSrVwNpPPnnkkYeXL11y6QKrt6tJNwAgFhUZCLk0YLPZ2KGAmAYAoL3F5OPjg10e2L8GJOo7zvmOSQMAmD9v1nTqM5s3ftZUna9SytVqpUY91NbWNnHiRAqFMnHixEmTJn3tt6Ghtqyns7GnsxEAWup4hkISDbCrYR6PV1VVhS1cmUyGPam9SmYymZs2bWIymdh5EXZlrH2x9ldhZ0HYZQB2iYz9BrvVAMjTd5zzHasGh3/e/vz0Zz1enztn9stX43+TNJR0iCs7xVUZaZc/Wu396KMTH3744T/96U/Ozz0r7aiXdtQDQHNNgeGQQgOc5UhcMvYd53zHpMHQkLK2Mj8xNmKp56JZM12fnjbl6y/X1VbkaC+VJE2C0yfDX5s3533vld3tdd3tdQDQJOQaDdLADrlk7DvO+Y5Jg6q7KdKOhs725rQrUT/tCnh++nNz3F5+7LFHP/1kdTYnpVMi7Gqt1QsANFblGA3SwA65ZOw7zvkS+V5kvRtnTdV5g4q+Qm7GiSN7Vyx944knJs+f5z5lypMzX3kp9MCe2qq7nZJqbQCgoTILTwjvjhG3maTf12tXXDL2Hed8zfOZoprS9N6u5rbWlovRp/bv3e65+PU///nPr86ZtWD+3MmT/8/3Ix/fj3w6xJUd4koAEFVk4gk6GliBKxKJhv/br6Nxydh3PNVs3o/WiUV8paKvtrr85rU41qnDn65d8+IL1ClTnlyx3JNCobQ3C9qbBQBQV3YLZ5AGluYGBwdTKBRvb28Wi6X1Ab8G9t93PGVmDUQVt5uq86Qd9SqlQnZfWll+93Z6YtLls8E7N1MolLam8ramcgCoLU3HGaSBpbmYBtrCfKioqBjxxWTsO54yvwbaz5Z0SqoHZF3qIVVHe3NdNZ9CobQ2lrY2lgJAzb0b+IM0sChXTwM9H/TOl8jYdzxlQQ1aG0paG0raGu/1djYqFf3PPfcM9gwAVBen4g/SwKLc0TQY0Qcy9h1PWVCD0QIAQn6KSbGhBhwOh8PhXLp0iUO02Gw29oDFYgWbWJs2bRrtP3kaqwULFhh9jaenJ5VKNayBtuh0Ohn7jqcspYGBj44AQNXdZJNi6u4wY2FrZdGiRXiWlOHlSKfTzagBfv0M1/r16w3vAScnJzqdjn3xnp333V40KMm/GsuOqK3Iaa4tHC0AIChMMDXopMhC3OBRTop0V7+2yNh3PGVODSp4qUs85r/w6sueixcZ+NwIAFQUXCYQpIEluHoaYKv/9OnTI76YjH3HU+bUgBW5f+4bC0/yrsz/6K2gwK+bqvNGDACU518iEKSBJbiYBnp/+01638DO+46nzKlB3Pmjz89yDc2N9d7GWP3+O43C3BEDAGXcWDzJTDkZemhP6KE9mSkny7ixSANLcDkczvAv3DZJAzvvO54y87XBhz7/cFn62tQ5M44e2t1QlT1iAKA0J3q0fL9r27wlyx967HEKhTJh0uNPvDjniRfnTJj0OIVCefixx+cuXrZ9ZyDSwFZcMvYd53zNqUEl/yYzePOpiH31gqzRAgD3ss8Nzy+HmZOecn7GbfGSz3Z9eezmtgvFevny2M0ln+16xm3xX6Y8e+DgD0gD63PJ2Hec8zXzDVOjAYCSrN/1sprO+Ov0mf5HkvZfqTAa/yNJf50+8/ON3yANrMwlY99xztecGtSV3zIaAODfZukmNfHEQ49NDr9WdvJWDc7sv5g7cfLUq3FIA6tyydh3nPM1pwZ4AgBFnN904xl45tHJU+MKGk3KI49P3frLcaSBNblk7DvO+Y5JA86Vk9rdUXPvJp4AwN1bv+rm3UN3KBRKdG59RnkrzsTmNVAoFE7yEaSBNblk7DvO+Y7tH2jZ82+3mS7ZN34XFqdVl1zHEwDgZZzUDbY7Vh/NYSaVF9R2FdV3G0hBbVfIlYrVR3MoFAq6NrAyl4x9xznfsZ4URZ/Z/zz1mdPH9gqL0/AEAApvHtcNtju2xvDpJ/PWHM2hn8r7OaUiKkt0gVsvaOkVtPTGFzZFZYnC0io/O5W/5mjOuhN5gdFFI+6OsL0bnZycRtxmR1qOtuKSse8450vke5G1uyN8f2D0mf0FmRfeeH3uO28tyUk/X8W/ZjgAUHAjQjfY7vj+Yknotcrj6dUHrwq2XigOOFf09Vneu4fuvHvoDv1U/r/PFW1k3w1JLo+4KTyQIgiKLdbbHb8e3vravFdXrlyZkZEx4jY72PcT24Rrub5HjrnvycnJY5nvmI4Gl6IOuM10+YL+YUle/C8hW5+e9tQ3X/6zJC++sihltABAftoR3ejujjO365LuNt+pbC9r7hFLBxTKoX6Fqqmrv6RRmiloiy9sOp1Zq7c7Yn4NXvr3xZ6enlwu18A2Cx3or7KtuJbrO2vMfR/jfM1wp2jTN5/SXJ6/wDpYnBvn/8XHT0970v+Lj7OuRwl4ycMDANxrYbohrEFKzAGf9952d3dPTU01us2OtBxtxbVc303SYMS+21KDH7Zs+M5/bUVhYsqlCLdZrp/TP+DnXLyTxvL/3PfpqU9+9IHXqSO7KgoTdQMAuVd/0Q1hDahUakxMDM5tdqTlaCuu5fpukgYj9t2WGvAyz21Y/77bTJeUi0fLC+K/819Lc5l+NnJPeUF8UXbsrqAvPRbNmTRpovfKv99IOlFeEF9eEA8AOSkHdUNYA5O22ZGWo624luu7SRpYYr5jPinKj4v+bR/Nhfrd15+U58elxIa/9uorNBcq8wf/8vy48vy4vPQo5g/+l9mh2I8AkJ18QDdIA7JwLdd3Umrg5OTEuXIC2x1leZfK8i7dvRO94VNvt5kuV2IPl+Vdivv9oPc7nk9PfWLN+ytYx3djr8ECAFmJ+3SDNCAL13J9J6UGGRkZCxcuvHY5sjQ3Vjfnf91Lm0Fd47P8+uWI0tzY65cjftiy4bVXX5706MTw/YHYawDgTsJe3SANyMLl8/kW6jspNWhubhaJRAsXLoxmHbqXE6ObQs7vO7cwpk19wmvZ6+dO7cGezLn+W87137DHAHA7fo9ukAYk4lqo72TVAACkUqmXl9fRX3aXZJ8fngO7v5n9yovTpj6x2nvpb0d3ap8HAE5csG6QBuTiWqLvJNYAAORyua+v78cffZB59XTxHfbwXLsYtmPzZ/PmvBTGDMCeAYBbF3/QDdKAdFyz953cGmDFYrFoNNq+H7fyb0cZDQBkxO7QDdKApFwz9t0RNAAAqVTq5+c3/7W5KRePFmWyDAQA0i9s181b288S0yAjvxT/NjvwcrQh11x9N0mDEftuFxpgxeVyaTTasqWe4Qd/uMs5M2IA4Gb0VixXorZt/GodjUZ7Ztbryz/fjV+DNz/b/sLcN03aZsdejrbljr3vODUw0Hc70gCr1NRUX1/fKVOmfPvVv9IuH+XdOq0bALhxPvAaO3D7ZgaNRgsODpZKpcLG1hfc/+byt5UBh2MN747PdkU8O3PRjHlvChtbTdrm8bAcbcu1bd/tTgOsJBJJSEgIlUqdPXvm+nUfHWQGJV8IK8w4BQB7d/jRaLSAgACJRKI7ZMve8CkvznrwkUmv/M3La+03az7/bvfBiJPRyb5ffPfW2m/c//7eg488+sLcN0NORBPY5vGzHG3LzcvLs0DfJxntu51qoC0+nx8ZGUmn02k0mpOTE5VKpdPpIpFotNeLWtqCDkR+wAjwWvvNbM/3nF95bersJR8wAjbuPpRdWEJga7Eab8vR5lwCff92V6hu35f/0x/rO54jv71roFtSqTQrK8vUUdqbA6ReFuOZK5VKDQhgOS7OsrYGQGhzkQaIa2kuCTQIDg62CVdbiOvwXCLfi2xv39eLuIg7Ri4JjgaIi7iW5iINEBdxyaABujZAXEtzSaABulOEuJbmIg2MF+I6PBdpYLwQ1+G5SAPjhbgOz0UaGC/EdXgu0sB4Ia7Dc5EGxgtxHZ5LAg3Q+waIa2kuCTRAXMS1NBdpgLiIizRAXMQlhQbo2gBxLc0lgQboThHiWpqLNDBeiOvwXKSB8UJch+ciDYwX4jo8l8j3Ilv5+3opFIpNuNpCXIfnoqOB8UJch+ciDYwX4jo8lwQaoPcNENfSXBJogLiIa2ku0gBxERdpgLiISwoN0LUB4lqaSwIN0J0ixLU0F2lgvBDX4blIA+OFuA7PRRoYr3HLTUhI8PLyiomJsTKXQCENLMXV1jjkcjgcT0/PVavejj13avWHPgsXLuRyuVbgEh6LNLAUV1vjiisQCFatWrV4sUdSXFRLbT6W1OToBfNf8/X1NfoVZqSbLyANcNY44UokEjqd7urqymYdF9cVDs9vJ8NdXV2DgoKkUqkZudpCGhgq9L6BpblSqTQoKIjq7Hz8aKikvshAGoT5u4O3u7q6RkZGjp2rV0gDxLUNVy6Xh4SEUJ2dfwz+vqmmsK2xBE/K+bc3MOg0Gi01NZUYd8RCGiCuDbgsFovq7Lx508YaQX57U6mpyctKW7FiuZeXl0AgMIk7WiENENeq3ISEBJqr67q1/6woyWlvKR9L4mKjaK6ufn5+EonEKNdwIQ0MFbo2MCMXuxP67qqVBTk3OsUCc+XwoQM0V9eQkJCysjLC22x7DZpNKSt/fy2FQrEJV1uOwc3Ozl61atWSxYuvJl/sahWaPSJh0batW9zc3OxkviZxSXA0QDdMx8jF7oTSaK4x51ndbbWWSL+sU6NWtzeVaZtlw/kS4CINRi2ZTGYTrrbGzv3jTijV+eSJoz0dIkukr7dVrR6SdtQXZZ65Gb0NaYCrbKKBTCZbvnw5j8djs9mBgYE4RzEYDF1uYGBgUlISAIjF4oiICJy/xFYalJWVhYSEUKnOP+0JbpPU9HY1mj2yXol6SDUg66rIv3w7fs+tSz8gDfCWrY4G2jXt4+ODc4hWGIzLZDJ5PB72TFVVFc5fYhMNWCwWlUrdEripub7yfnez2dPX0zqkGlTI79eW3shNCc1KCkEamFb2owGHw0lKSsL+wGOF/cjhcLAfMQ04HM6RI0dgmAYymQx7Ru+X6JX1NZg965X16z+tFZbKpBLzp6dtSKUYlMtaagvv3jqVlxaONCBSttJg9erVSUlJbDabzWYDQFVVFXZig50pgc4q13qCaRARETHa0UD7DJPJHO34YH0NKBRKT2ejUtHX39tm3qgGB5SKvvbm8tLcmCLO6cL0SKQBwbLV+wbao0FgYKBYLAYADofDZrMjIiKYTKbuC7QVGBjIZDLZbLYBDbAfeTye9rFe2USD4qxzvZ1NKpViQNZplqiUA4OKvp7OhqqiK6U50cV3opAGpLxzol3l2jMZ7dEAW8HDrxmwZxgMBh4NRrtotokGRbej7uXGSjvq1WqVvK9H3iclHNXggEaj6ettbxDcqeQlludfQhr8dxhhpM018PHxwW71YCf0SUlJ2PGByWRqn8FeiZ0UicViPz8/AOBwONha53A42PFEey7EYDCwZ4aXrTQoyY4uy49rb64A0KiUA4qBXlOjVPRrNBrFQG9rfUltaXp1cSrSQH8YYaRNNJDJZPHx8VVVVbpn8DweD7sa1v0bz2aztQuax+Nhbx1cu3YNe6D3AiaTKRaLk5KSRnMAbK2BgJdcL8hSDPRqNEODiv5BhQxPlMp+jUatUiq6Wqsbhbn1FbeRBiMPI4x0pM8UMRgMrULW5BouPQ2ExWm1ZRnS9nqVUqHRqFVKuXKwf/TINRq1ekh5v7ultaGkpbYQaWBoGGEkid5F1ha5uJgGYSGbJkx4cM8Of0yD+srsllrefalYPaQC0KjVqiGVQi+YAP33O7paq9ubK5AGxocRRiINLM3FNMhIPu70l0kUCsV99kt5mZfqK7ObqvPF9fz25grs3j9oNACg0WjU6iGNRjM0pOy/39khrmpvrsCCNDA+jDASaWBprvakiJsetezNhRQKZcKDD4bs2arVoFNS3dPRcL+nVd4vVSr6VUq5vK+7QyxoayrVDdLA+DDCSKSBpbl61wanj+0NDT04NDR4IvJ4WOiPTbX8PzToFmMBgNaGkhGDNDAyjDASaWBpLqZBwa2ouXPn7Av+d01pulqtksulysG+kJCQhx6a8O5Kr5upib1dTVgAQCy6O2KQBkaGEUYiDSzN1R4NpFLprFdc3GfT7qTHD/R1A8Dg4ODkyZMpFAqFQpk65amUxNiejgYAaKktHC1IA0PDCCORBpbmajUAgAM/Bc58ecbTU5/atskPuzaorsg/eviAy4wXKBTKrJkvS9tFANBcnTdakAaGhhFGOtL7BvbJ1f0wRVdHS+LFk28uXuAyY/qUp574ftvGMv6dTkl1d1ttfvYNkZDf3VYLAI3CXAMZRxoITalx+L25JOLqXiI3CvMGFX38wjvffLX+uWenzXhx+mOPTfLxfic2+nSnRIgFAOoFdwzFRA2sPF+sHP97kRHXpNK7U1RTmi7tqG9rbUmM+32jP2PRwnkv0Vxori9Omzblba9lHS2VACCq4BjOeDkamDqMMHL8LEdbcUf8MIWkoUSp6O/uai8uyr1w7kTgpq/mzXWjUCjtzRUAUFeWYThIg5GHEUYS2Fx0bWBSjagB9i5yh0Qo75Oqh1St4vqqci6FQmlrLAOAmnvXjQZpMMIwwkgCm4vuFJlUBjQQ1/NbG0ramsp6u5pVSsVzzz7T2lACANXFqXiCNNAfRhiJNLA017AGwwMAwqIUPEEa6A8jjEQamJErEomGf9WAAQ1a6u4ODwBU3k3GFaSB3jDCSKSBGbnBwcEUCsXb25vFYml9GK4Bn5s0edqTr7zkUlue3VxToBcAqCiIxxmkwf8MI4xEGpiRi2mgLcyH4Rps/PrTD7/69B8B69Z9/H5TdZ5eAKA8/xL+IA3+O4wwEmlgRq6eBtrS0+DnvVvnvb1k3aGti+a/2liVqxcAKOPG4g/S4L/DCCMJbK6TkxN2zxTjjtZ77X1Vu3oNNl9Ls/Rq+LXBimVvTJjwYNSvv9RXZusFAO7lnDcpSIM/hhFGOuRfZVtxcR4NassyRILbowUASrLYJgVp8McwwkiHXI624upp4OTkRKfTR9SgrpwzWgCg+PZZU4M0sN9lMd64mAbY6k9ISMCeHFEDAwGAoswzJgdpYLfLYrxxORyOdvVrS6vBmvdXZF2PEhan1dy7YSAAwMs4RSBIAztdFogLOhqcOLzjeeoz+/dsFhanGQgAFKZHEoueBmHMfzs5OVl5vlghDRD3f4ryn/8Xede2L7KuR73/7vI3Xp+bk36+in9txABAwY1jxKLV4Lfw7R5/W+jt7Z2RkWHl+WKFNEDc/ynt0WDbd3Say/OxUaG/Rvz4PPWZ3d/7l+TFVxal6AUA8tLCCSfhd+bbXss8PT2xfwmTpPsZaeBoXN2Toqtxx91muX5O/zDrepTvB/+YNGmiz6qlF1gHBbxkbQCAey2MQK5fCvVd402j0XSvT0i6n5EGjsbVnhR5r3zTY9GcO2ms7/zX0Vymnzqyi59zkRn8rdssl6enPvmd/7r8W+cqChMAIDcl1KRkXP7Z3289lUplsVg2n69ZuCT4XmTENal0b5ieOLxjOvXpvT/4X4kN91g05+mpT369Yc31xOPXE49vWO8T/vPWsvw4AMi+8jPOZCb8vG3TF1Qqdffu3XV1dfYwX7Nw0dHA0bhOTk5nIkNKsqNLuRdLuRdzb7Lee8fTY6E7J+XU9fhjXzFWT5v6hMdC9707v+bdPl/KvQgAdxL34UnI7gAqlRoUFDT80902nK9ZuEgDR+NKpVIvL6+QPUH3ci9oE3lo+18nO3kte/3nPRuxH997Zwn2GABuJ/xkOOEHttBoNDqdLpFIDNNJup+RBo7J/de//rXRf0NJdrRuDuz+1mvZor8+7rR2zT8Sz4diTwJA5uUfR8vp/9wJFQgEeLgk3c9IA4flhoSEvOHx+tW448VZ53STnnRsy7drpztPC9v3XXHWOQDgXNo1PLG/7njba6n2Tih+LuFtRhogrkW4HA7H3d19c4Bfwa2z/Du/jxgAyIjdoZuks99/9OEqvTuhJnGJFdIAcS3FlcvlwcHBs2fPCg35Pj/9TFHmWb0AQHpMEJaU34O++vyfI94JNZVLoJAGiGtZrkAgoNPpU6ZMWb/O90psOO/WaW0A4Eb01mvntm7eSKdSqSEhIXV1debimlRIA8S1BlcqlUZGRtJotPmvzf2CsS784M60uCMAsHeHn+6dUIeZL34u0mA8crlcblhYmK+vL5VKpVAoendCHW++RrlIA8RFXKQB4iIu0gBxERdpgLiIizRAXMRFGiAu4gLSAPnkb04AAAAnSURBVHERF5AGiIu4gDRAXMQFpAHiIi7oaiA0pcj1PcGIi7hGuf8PkJ6DtipP/FAAAAAASUVORK5CYII=
说明:Mirror有两种方式,同步和异步;同步方式能保证主库和Mirror端数据的一致性,而且不需要使用企业版,但是对主库的性能影响也比较大;异步方式需要
企业版才支持,绝大部分时刻能保证数据的一致性,但是也有丢失小部分的数据可能,不过它对主库的影响比较小。
 
优点:此方案对主库的数据提供了可靠的保护,一旦主库出现问题,从库能在比较短的时间内恢复,尤其是数据库很大时(从备份恢复需要的时间会很长),能尽
快的恢复业务使用,而且Mirror端能生成快照,能给实时性要求不高的业务使用。
 
缺点:Mirror会影响主库的部分性能(异步方式影响比较小),主库出现问题后,前端需要更改访问的IP地址(或者将从服务器的IP地址改成主服务器的IP地址),
还需要将账号、权限和作业等信息迁移过去。
 
单库+Replication+ BackUp方案:
 https://www.cnblogs.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAARoAAACxCAIAAACUfeV0AAAgAElEQVR4nO2deVhTZ9qHT+s339TWdnBr3SrRaUjaKtDN2gqWqZVS60KcVrFutFildaOVus40bnEZatEaRUVFDIIIFRExbhj2AAmEVUgQwhISNgkSIJDt/f44nfOlBEKWQziB97l+V6+Q5OTOczz38yYnNCAAFixYOBUy2E8AFqyhU1AnWLBwKwQAIBKJLN5eIpFYvC3kQu4Q40KdIBdyceNCnSAXcnHjQp0gF3Jx40KdIBdyceNCnSAXcnHjQp0gF3Jx40KdIBdyceNCnSAXcnHjQp0gF3Jx40KdIBdyceMSSyc2m+3l5RUWFmZjrukFuZBrhIsAAHg8nsjSEggEFm+rz2Wz2XPnzvWcPy864tyqlT4UCuXixYs24JpbkGtLbkRExPz580+cOGFjrmXF4/EGf3WSyWS+vr4uLs7xseF1Fdlo0jk3Fi36fPbs2RwOZ4C4lhXk2oablJTk4eGBjVcqlRoXF2cDrh2/2MvLy6PT6SRHx1O/BUkreYZhJ0TNnevu4eEhEAhw5Nrj4TV8uHrj9VJdRRaafser9Vy07FWnkJAQCoWya8e2amG2TJxnJDd/Z7m4OHt7e4vFYuu5wN4Or+HDlcvlFo9Xa7j6ZX86sdlsKoWyzs+3RJDcUJ1vYq6EnyU5Ovr6+spkMsu4WNnL4TWsuH8er7lG0ut4tZjbo+xJJ4FA4OHh4en5CTeN3VBbaEFOM38lOToGBASUlZVZ/Jzt4vAaPlw2m02hUNb5+RYLkuur801MxJ/HqwXcXss+dMJeECfciGqUFFsTSWXekcP7SSRHOp0ul8steM4EP7yGDxfH8ap/JAxlnf54QUxyPHMquElailcqhPzdu36iUijBwcFKpdLctgeuX8g1hTug43XI6hQSEkKlUPbs2i6tLmqWCXFPWVHWli2bXV1dzW17gPqF3H65fx6vj/BKhZCHjdfi4uLB6negdGKz2VQq5dt13whLslsaygci7a0ynVbbLC1DEPO+j4lQh9ew4tpmvLq4uAxWv/jrhL4g/tRzPj+LI2+sHIi0tUi0GpWiVZbHuXA/cjvUifhcIo9XHPvFU6f/viB2YSdeb22uGoi0tUg06q6ujlZh3q3k3/c9vPYvqBPBucQfrzj2i49O2Avis2eYT5/UDlBUXR3K9pbaci43MTj1xiGoE8G5WVlZdjFe8eoXB51kMllISAiVSvnXnl1N9WKFvG4g0q18quxobZI8EiSHcW8HZyQEQZ2IzLWv8Wp9v2jhoJOLi7P/hg2VouL21vqBSFdHq06nbWupK825npt0LufeKagTwbl2N16t7BcrHHRCEKRR8kij7u5oa8Q3yvYWrVaj7GgVlzwsSI8QJIdBnYjPdXaeuWHDevsar9b0q1/46CRICW+oKdJq1Z2KJ7ikq0Ou1ahV3Z2yqvzSnOvF3KtQJ3vhIgjS2lyj7u7seNqIb5SKgRqv1vSrX7jpVJgRJRXn6XRalbKtq0NuTbRqlaq7Q95Y+bjwnjAvAepkX1z0eGhpqNSouzsVzbikq6NlQMerNf3qF546FWfH1pZndXe1a9XdXZ1PLYha3aVWKdtb62vLuZXFSeUFdwirk5+fH41GCwwMDAwMNHHD+Ph4dCvDK03nmrUJVrbXqTAjqklaptNqujqfKtvl1kQz8OPVmn71C2edynJvPi560CaX6nQ6taqzu0thYtQqpU6n61a2NdQW15Zzq0pTCK4Tg8FgMBgAgMDAQPSCidweOgmFwvj4eNO5Zm2izzXr/r1yTSz940FWJejualeruwg+Xq3pV7/+0EkgEEgsrR46ifLZFcVJDbXFalWXTqfTaFSq7k5jQe+m6pI3VdVXF9RV8i3TyaznbE2/JSUlEolkx44dO3bs0L8gkUjy8vJu376NXk5NTY2JidG/BuV6eXlhPwqFwtu3b8fExOg/fmpqqv4m6CPk5eWh3F43uX37dmpqqv5ltHDs1/TqcTxUFD/sUDTrdNrurg5bjleb9atfAoEAn9Vpi7/PqBeeDz25F9WpqiyttjyrpaGyu6sdAKDTajTqLsMAnU6rUSnksmapsFFSYo1O5k4Ri/uV/Hd1CgwMZLFYbm5uUqkUAMBisZhMZnx8PLr+8Pl8MpnMYDBYLBa2IvVYnRQKBYvF0l/c0MdksVjoa8j4+PjAwEA+n+/n5xcTE9PrJjQaLT4+nslkopugTwl9BBaLhVe/plev47VZJtJoVDqdVqNWqro7jEWl1Om01o9Xm/WrX7i92Is4t/+55/46YsSz8z/+UMCNR3WSigUNNcWtTdXdXe06nRYAAIBOp9NqtWqdTqdRd3e0NTVLy5rqSpvqSu1RJxqNhn11AZlMRi+gAgAAMHPc3NyEQiHo7cUen8/H3BAKheitCoWCyWSC/76uQ4XcsWOH4SaYeChFKpVit+rfzfY6Mf79vcsMp+hLQdh4lTzOefpEolGrANBptWq1usswukEar9b0q194vndKiD4xnTRlxLPPvvDCyJPH9mI6NUtFLY3itpa6TsWTbqVCo+5Wq5SdiidNdaUNNUX6sS+dGAwGh8PBzgqgaxFaCoUC/FknVDDjOvH5/B4nNlgslp+fn1QqZTAYveqEvYXDKATRKeTYzmefffZ//mfEap/Fj3LZ+uNVIZepVV06nfaP2arRaP9YuAZtvFrTr37hfypi04aVixYuvHPnzi9BR2OjQvV1UshlaAAA9dUFvca+dAL/XRPQC6hF8fHx2DXoJtgF4zpJpVLsnqhXmIcMBsPf3x99fP1N9H1GtyWIToUZUVcuHJo4Yfyzzz4zaeLLcdFneoxXhVym7GhVd3dqtRq1StnZ/qRZWtZYW6yf4asTj3N5wWeecZHHRflsAECHoqG7W3H27JkxY0bv2h6Qn5v29IkECwCgry8tshed/Pz80OOYwWCgF/h8Po1Go9Fo2EGMrld+fn7oiTjsRHlgYCDqG3aN/os3Go2GbYKuTujpeC8vL6lU2usm6B1Q8dBbhUIhegEFDdZ7pwJu7GqfxXPmfLh//74zp09kpyUSc7xa069+4bk6cbncqa9O2vDNsrqqIq1WrdGoAABvv/02giAjRox47923Y6MvtzbXtDbXAADqKvl9xS50MqWwpcbGXMOyvU48zuWvfL5IvxcuymfrdLoupVzV3b5v3z7ya9NOBh8Rlxe0tdRhAYM9Xq3pV7/w1AkAsPjzj992fWOa45Qb0ecaJY+aZeWZKYlfr/3qxRdHPfPMMwiCJMRdlTdWAQAk5Vl9ZWjohJ5/6/Edi8NHp8KMKDabPXnSK0f2//ik/rFa3a1WdQKge+edd5555pkXnn9+yeLP79+5QZDxak2/+oWbTkXcaxqNqoD3YO+ezTPeIL86ZeI6X5//X9wbKlmXzny34RtZTWlLQyUAoFaUaSRDQKchyRWLxf1+dZT+eJ075903qK+9/54L5250S2OlQi6LDD8zf95HI0aMeOaZZ5577q/32XF/jNfHOX1lOOpUmBFVlner/WlDTVVZeOgvH8x+m/zatNEOf/vYwy00JPhJ/WP9AACqy9KNBOpETC6dTkcQxNvbOywsrC+v0OOhJPt3rVaTy729dqU3hTxt8qQJOwO/LytIRcerWJR/7D8H3OfMFovyiTBe++rX3ML/zF59TaFapeQ8SFjvt/LNN5ymkaZSKeQxY0Zv3bQhL5vTLBU1S0UAgKpHycYDdSIgF9UJq169wo6H8oK7ne0t5WWC4KN73nidTHH6+4svjvL50vtOwjWijde++jW38NdJlM8Wl6YoWuulkqrkpFvM44fWrFrmRJ7+ztvOL44a1SgpbZSUAgAqSx72E6gT8bg9dOrVqx7HQ5NU2PKkMS7m0tIlXpMnTXjjdfI00lTya9N/ObKvooz//+O1NMV4hq9O6KfgTXVlXZ1PlZ3t4orSzDT2xdDjCII01JY01JYAACqK7vcbs3YfLCKUr68vYnA81JRzuzrbRGVFifGRB/ftmPcP97//nfSW68wpkyc21ZU11ZWBwR6v+kVQndCP7ZqkQkVrvUbd3SpvQhCkvqaovqYIAPC44G6/gasT0bh9rU4ODg6+vr7o31/q63hoaaxUq5St8uaigux77Bj6v7chCNIoedQoeQQGYLzi0q+5NeA6yaoK0LQ0VDpOfRW9DAAQCRJNCdSJUNweOulbhJXx4+FJfUVne4tWo25qlBBnvPbVr7k14Dr1GgCAMC/BxECdiMNFderVIqxMGa8NNcWtzTWOU6di47U8n21KhqlOvPT42vKsusrcXgMAKOPHmxioE3G4HA6n37+oaY/jta9+za0B0SkrOWYq5e9/HfX83YQrkgqeYQAApTnXTQ/UyY64RnQi7Hi1pl/9GhCdtny/ZtnGr3feYI4fP7amnGsYAEBJVozpgTrZEdfweBBw49Hxmnwvhpjj1Zp+9WtAdDoR9C/nebN33D+LIEi1MMMwAIBi7tW+cijowBr/77y+/ArNsm/WHQo6kPngEtTJLrh9jdeAiKOvTXesLc8yDACgJDvW9BBdJx6PJ7K0el3cV/p4Iwjyy+HdVWVphgEAFGZE9kjMtXPO7vP/MnLUy+S3nNxpLgv90Lw+b/nL5Lf+MnLU6+9/dOr00b52n1nP2Zp+BQKBxdsOB67h8fCfg9vfX/gPRioLQZAaUaZhgNHxGnrul0NBB1Z9vdrry6+++MrnUNCB304e6lcnm/WrXzweb0BORYhLU4wEAFCQdlk/GwN/eGmCo+f6vTtZmQduFBvm39H8zzcdHj2FvHT1Wrg6EZnb6/Hg+Yn7SIcXAzZ9bfp4Tbp9wX3BkpEvjXGYTH6Z/NbrnqudF/rNWPDNy+S3xpDeHPnSmLfcP4mLCibi6oS7TpUlHCMBAOSnXMJyPfrUC2Mn/uc6PyTpsfEEJxaPedXp6C90qBNhuX2N15y0OGPjNT1CP4yj+158xXHOVz9uOZe0L67YMFtDk+Z9u/fFVxz9AzYNfZ2MBwCQl3wRy98mkz2+PRCbU2NKxk11cl+3H+pEWK7145V94+xzL43ddyX91P1y4zkSy3tpguMp5t6hphOPc/ngvzeiu+9x0X3jAQDkPgzFgiCId3Da5fTK5NIG44nj1yIIsvjXVKgTYbm4jNdZ/9x4LbvGlIyZRPpw7b+Gmk6FGVHr1tJcZlLuxJ0rL7hjPAAA3oMzWBAE2XAxx4eZuflybnRWdVFtq2Gis6p/iMhbdjLDUCfm0R8cHBzMbdvifu3lsB4sLnY8XLlwyOLxuiQ47fecmocl9caTkCfBZbxa069+4alT8u3z0ZeCXqdM37bFVyS4bSQAgJx7p7AgCLKFlbv3etG2K4LVZ7KW/JrqcypzxanMr89lrzyd6XMqc1UId/WZrICIvH/HFurvvsiz/3KbM9vLy6u0tNTcti3u114O68HiYq9W5n00i7ZoHj8ttrzgrvEAAPhJZ7EgCOJ3Pns5M2PXtYL4PElBjdww94qk++KKlzMzcRmv1vSrX7jplHH3AtWJ9OPmNYVZ19d//aXrTCr7+hlh3q1eAwDIvnsSC6rTgRvFZ5Ie/86rvSWou5Uv5TxqiMysulsou5UvTciTxObUhiSV748rRncf++qR5V8ucXV17fFlDKa3bXG/9nJYDxYXG6+5aVGH926dTnr1/KkDFozXn2MLv7/EX87MWHoi3edU5jeh2dsiBesv5Kw4lbnsZMYXv6VvuMjbfa2g1/GalJRks371C8/VKTctar3vFy4zKdGXgqIvBU0nTfn8U/djh34qy73ZIwAA7u1gLD10Si1rfFT3tKmtCwDQ2KYsqXuaUtrQQycSiYR+T6rFbVu8rb0c1oPFxVYnqhPp8N6tGfdZ7h++s3TxJ7yUaMvGa2xOza18aXhaZWRm1fnkx3F8yZXMKuPjdRD3M26rk8sMp6sXj169eNRlJuVb33/mZ1w7xti2wNN93NjR3/r+MzGGWcq7gQYAkJl4DIsFOimVSns5vIYbFxuv3AfhtEXz3D98O/1e+OG9W6eTpvh88dnt30/3Ol6z2Cew9H88lPUyXsPCwgalX/3Cc3VKiD7hMsNp3dqleenRP2xcNY00+eedG1LYF1PYF9EfF3i6leRcL8m5DgDISAjCYoFO1rdt8baQa7yw8Trvo1mJMcxzv/08nTTlEH1L2p0w+k7/6aQpVKdp9J3+OQ+vWD5eDXRSKpWD1W8PLn6fO2XFFGfFBHy/kupEunKecTfu9LKlnuPGOnw2f86Z43uKs2KSE0PR+wAA0m8ewQJ1Gkpc7HgIC9lHdZr2w8ZVWUks74Ufu33wVtDBH0tyrv8ecWz50k/HjXVYs2KhhePVQKdB7LcH11qdJkyYsGHdmsKMqCJuNJqbV391nkFevXzB3evMIm70f/ZvdZvtOm6sw/aAtegdAACpcQwsUKehxNX/3Ck3LWrdWprLDKeE6BNnju/5bP6ccWMdVvssTIg+kZsWFcv6pTg7tjg7Fpg7XoewThKJJDg4eCltMT/lSmFGFJbtW9ZMmjje+U3ygT3+GXcvPLwZcvzwNvQmAEDK9f1YoE5Dievg4HBo3/bCjKgi7jU0V0IZVDIp4LuvOLfOcW6d2x6wdprjZOcZ5BNHf0LvAABIvXEIy3DXCQAQFRXl7vZhCvtCQfoV/bDO7luyYO64MQ5LFsxlnd2HXgkA4MTuxQJ1GmJcf3//Dd+u1Z+tPM5lv9VLxo118PrkQ3SqRpzbv33LGgvH65DXCQDA5XKpVOqh/Tvy01g9kp10cf/u9d+sWoT+CAB4GPMzFqjT0OMGBwcvpS3iJbN6jNejezd97P7uuDEO36xazI45buF4HQ46AQDkcrm/v/+s996JizwhSAnvKwCApKu7sfxl5KjPfzxhok5/ff5Fr13h1reNS7+Qa6SioqKcnWeGnTliOF4fxDO3bFi2+DN3C8frMNEJLS6X6+rqumL50ujwX/KSwwwDALgftRNNXNjOT5cue2HMRPq1XFN0Gj2FfPlmsvVt49gv5PZVSUlJXl5eS2mLkm+d62e8Ru/B8peRo5YduGKiTn99/sXF+38nSL8DohNaYWFhs2fPpjiRgxg7s+6d4z88jwUAcO/KTzcvbd/y3Wr0AzjfH+gvTXD023fOiE5bg6PHTZux5qejxrmm1HA7rAeXGxUVRaVSd23fxEk4Y8p4/Xiht8Nksok6jZ5CPnXtPnH6HSid0CotLfX19XVwcHB3+/DHrevPnzqQkngaAPDzjvVUKnX79u3YB3C3U3mOzh/+78hRb87x+mzVpq82/BjCiv2BftRr1aa3Pl4y8qWxL0+fcen6PRO5xmt4HtaDyJXL5Tt37pwwYcJS74UXTjNyORf0AwzG6/wvvp705uwDURlGdNofle741kcey78zwrWgcNBJIBBILK2SkpJ+71NZWXnjxo1du3Z5eno6ODggCLJu3bqCggJDbjqvYPPPvyxc9d0/lm2Y5vzBmEmOC1d99+12xt3UbAu4fdVA9wu5fXFDQ0M9PT0dHaeuWL40iLEz4epxflIoAIC+Yz2FQtm1a1dlZSV6z5+DTo18aezfJjh+sGj1mm0HTrJuXLx26zdW3Le7g+at+H7sq04jXxq77eBJE7mml5X9Duzq1K/Nxu9g5H9cGVCukYJc67lisTgsLMzX15dKpTo4OJBIJH9/f5lMZsjlZAn8tu11X7TC8c330LzvufSffgFx99Mt4JpSVvYLdTKvIBdfrlwuF4vFtuf2VVAn/LlGCnIh1wgX6mReQS7kGuFCncwryIVcI1yok3kFuZBrhAt1Mq8gF3KNcAmtE51OHxSukYJcyDXCJbROkAu59sWFOkEu5OLGhTpBLuTixiW0TvC9E+TaF5fQOsEze5BrX1yok3kFuZBrhAt1Mq8gF3KNcKFO5hXkQq4RLtTJvIJcyDXChTqZV5ALuUa4UCfzCnIh1wgXAQDweDyRpSUQCCzetl/u5s2bB4VrpCAXco1wCb06QS7k2hcX6gS5kIsbF+oEuZCLG5fQOsHf2YNc++ISWifLzuwJhUI+n8/n84VCoYlchUIRHx+vfw36COhN6IV+uf0WYfcz5OLFHYI68fl8Nzc3Pp/PYDBoNJopXKlU2uOegYGBgYGB6E3ohX65/RZh9zPk4sUdgjoBADA3yGSyidweOjEYDAaDgV02kWu8CLufIRcv7lDWKT4+Hr0gFArR1QYVA+Wi17BYLP1NaDSan58fMNAJfSgGg7FixQp9u8wqwu5nyMWLOzR1cnNzYzAYfn5+6KFPo9HQ91Fubm5CoVAkEtFoNKlUCvSWL/Qa1CXQ2+qEvoCUSCR+fn4cDse0Fv9UhN3PkIsXd2jqhL1yQ/3h8/moWmQymc/ni0QiNze3Hpu4ubnRaDQmk4n+aKgT+pgSiUT/JrOKsPsZcvHiDn2d+Hw+mUxWKBTYjyKRCFuUpFIpdpNCoUD/C/rTCbPOrMJrP7PZbC8vr7CwMBtzza1hyCW0TpZ97oSd2YuPj0dXITKZLJVKhUIhugSJRKLAwEAmk8nn87HTd6hITCbTz89PoVBwOBwajcbn85lMJnoO3c3NjcVi5eXlGa5sePVrpNB+BQKBl5eX5/x50RHnVq30cXV1jYuLswHXshqGXELrZBkX+9wJ+7xIKpUymUwOh4NKhXI5HA62yKAfLikUCuwCthX24RVq18GDBy1+ztb0W1BQ4O/v7+LiHB0ZWleRjebhnZhFiz738PAw/l5uiP37Epk7BHUaCC6Hw3Fzc2MymbbvV6lU0ul0CoXyaxBDWskzTHzs5blz3b29vQUCAY5ctIbJvy9eXKgToblRUVEkR8fdO7eJitPrq/KMJCL8jIuLs6+vr+FfH7Ojfu2dS2idhvPv7HE4HFdX1y+/XFoiSGmoKTAxp5nHqBRKQECA/t/GtIt+hwaX0DoNz/8bVywWe3t7fzTXPeXBzcbaInMjqcg9cmgflUKh0+lyudx0bq81hPfzQHChTubVgHLlcnlAQACJ5HiFFdpUV2JNKoQ5u3f9RKVQgoODi4uLLX7OQ3I/DxwX6mReDRBXqVQGBweTSI5HjxxolpXhlbIi7pYtm11cXCx+zkNsPw80FwEACAQCiaVVUlJi8bb9chEEGRSukRoI7uXLl6kUyqZN34lFgif15XhF0SrTaTXNUqGR3dhvDaX9bAMuXJ3MK3y5XC7Xw8Nj8eJFRYIMeWMFXmlrqdWou9tb6wvSWA+u7jKyG23c75DnQp3MK7y4MpnMx8fn/fdnsROvtzZX4ZaWGo26q7P9yeOCu6lxBzmxdKiTLblQJ/PKeq5cLt+5cyeJ5BgeFvr0SS2O6VYqupVtksc5vPun028ehTrZnktonYbY507V1dUhISFUKuXggb1N9WKFvA6vdHU+BTpdS2NlYVpE9l0m93Yw1GlQuITWaYhxXVxc/P03VIqK21vr8Upne4tOq21/2igS3BakhOUmnYM6QZ2GBRdBEFl1gVaj6mhrsj7K9idajVrV3SkpzyrOulaYfgXqNOhcqJPtuAiCCFIv11cXaLUaZXuLsv2JpZFrNd1qlbJZKhTl3SrlxUGdCMIltE5D7L0TqlNRZnRdJR8Anaq7o6uj1dxoVF1qlbKtRVotTK8ovA91IhSX0DoNsTN7mE4lOdfFj1KUHa06raZb2WZi1CqlTqdTdrTWVxfUCDPEj5KhTkTjQp3MK7x0EuYlPi6819JQCQDQatWq7nZjUXXqdDq1SilvqpJVCeoqcqBOxORCncwr63XaE+j3/bplqE7iRymyqvwORbNWo9ZptWpVl1ql/HO6dDqtVqNSyGXNMlGj5BHUichcqJN5Zb1On3/qhiDI9Gmv3o2/IH6UUiPi1lXmNtWVdra36HRaAIBOp9NqNRqNSqfTatTd7U8bm6VlTXWlTXWlUCeCc6FO5pX1OvGTI1YuW4AgyIhnn936vS+qU0NNUZNUKG8Ud7Q1q7o6tBqVWqXsbH/SLC1rrC3WD9SJyFyok3mF13un6PBjr7027fDhw2EXL7AuMjGd2lrq2lqkbS1SAEB9db5hoE5E5kKdzCvrdXpw9+YCT7eM+xENtaVqtbKr6ymXyx0/ftzXa1fkZDx4+kSCBgAgFef1GqgTYbmE1mlIfu4EAPhglsvkSa/8h7G9U/FEq9UAnc7f3x9BEARBHKe+euXyudbmagBAXQWvj0CdCMoltE52xBWLxegXMxgpTKe7CWEff/Q+lfL3j9xmZafdapaKHuWnBR3ZO3HCKwiCjBgxQlicAwCQPM7uK1AnYnKhTvhw6XQ6giDe3t5hYWF9eYXqpFYpu5RtRYK0jf6rKOTpL48fu3rlF+mcm01SYUtDRXb6vZtxkS0NFQCAGmGGkUCdCMiFOuHDRXXCqlevsFMRZbkJT5/UNjZILp0/7ur8JtXptZfHj3v3HdeTx4/WVRU3y8qbZeUAgOrSVCOBOhGQiwAAeDyeyNISCAQWb9svd/PmzYPCNVJ9cTdv3oz0Vp988smRI0fQvzPQ47ci6ip43UoFLyvlCGOP53wPV+cZM958fezY0Qu8PmmqKwMAiB8lG4/pOuHerylF2ONq4LiEXp0cHBwMD1D0/ATK7bEm9LgPWra5T1+3YuXr64sY/JJRVWna05Y6rUZVJRYmJ93cT9++ZPGnCII0SkoAABVFD/oJXJ0IxiW0TnbE7UsnBwcHX19f9O9cGOqE/laErCq/raVOo+pqe9pSU/UIQZCGmiIAwOPCu/0G6kQoLtQJH24PnfQtwqovneoqc2XVBbLqgub68g5F89Spr8qqCwAA5fnsfgN1IhQX6oQPF9WpV4uwMqKTVCzoEQCAKO+WKYE6EYcLdcKHy+Fw+v3LZb3qlMm5XleZaxgAQBn/himBOhGHC3WyHddQpy9on42eOP7HLd9KKng9AgB4lHPdxECdCMKFOtmOa6gTgiBn+QmjX32Fc+dqjYirHwBASVaMiYE6EYQLdbId11Cn2bNcF23/Zvz0ybvPVGsAAAQ0SURBVOwbl6qFGfoBABRlRpkeqBMRuFAn23ENdSrITvSc577jxw1VpWk9AgAoTL9iVqBOg86FOtmO2+upiL4CAMhPvWxWoE6DzoU62Y5rqFNlycO+AgAQpISZG6jT4HKhTrbjYjrlpUejOhn5BSIAQO7D82YH6gR1GiZcVKeY8KNUp2nR4cfKC+4aCQCAn3TWgkCdoE7DgoutTreunXSdSfVd6c1PixXls3sNAIB3/7QF6aFT8KEABweHQel3uP37Qp1sykV1usikTyNNjg4/tjtw/XTSlPPM/cK8RMMAALLv/GZZUJ1Cft3pPPNNb2/vpKSkQel3uP37Qp1sytVfnVxmUtb7fpGUcN79w7dnvTPz8N6tBdzYstybWAAAXPZxy3Lp9F63ObO9vLwEAsEg9jsMuVAn23Gx904uM5wSY5g/blxNdZp29eLR8DMHaQs/Hjd2tM8/va5ePFrKu1HKuwEAyEw8Zm6uXTzoNucDDw8PDocz6P0OQy7UyXZcbHWKvHiE6jTth42rbl076TLDaYGn229BO7KSWD/v3OAyw8l74cclOdcBABkJQaYn+sKBBV7zXV1d9UUa3H6HIRfqZDvuc889l/PwUlFmdHFWTG5q5Lo13i4znBKijwcdCJj30axxYx3WrfG+G3e6OCumOCsGAJAWf9iU3Iw4sPzLJa6urn39Svtw28+DrJNAIJBYWiUlJRZvO9y4YWFhs957NzuJVZQZjeZK6EEqmbTkc48roQc5CWcDvlsxaeJ4v9XeRZnRAIDUuIPGkxi5f/mXS0gkEpPJNMIdbvt5ELlwdbIpVyAQuLq6PrgZWpARiSaHE75/j7/zm69Nmjh+q79P0s3TOZzwgoxIAEDy7/v7SkLEvnW+PiQSKSwszBSuxc/ZTvfzYHGhTrbmisXi2bNnnz15MD8tQj+3Y4K/WbVo3Ji/+X+9ND8tAgDAiaUbhh1J37pxLYlECg4OViqVpnMtK/vdz4PChToNAlcmk3l7e38y7x+JsacEqZd7JPHar+iXxSZF79FPImvP1u/XkEgkOp1uokg9uBaUXe9n23OhToPGZbPZrq6u2wL8OQln85Iv9QgA4MHVXWjuRO7aHfgtlUql0+n9fnVzv1yzagjsZ1tyoU6DyVUqlXQ6fcKECUu9F54/xeA/vIAFAHA/cvv9yO30nRtIJNLGjRtlMhleXNNraOxnm3GhToTgRkVFeXl5OTpOXeq9kL576++sXwAAB/f4k0gkf39/mUw2xPodqlyoE4G4YrE4KioqICDA1dUVQRAfHx+xWGwDrpGCXLO4UCfIhVzcuFAnyIVc3LhQJ8iFXNy4UCfIhVzcuFAnyIVc3LhQJ8iFXNy4UCfIhVzcuFAnyIVc3LhQJ8iFXNy4UCfIhVzcuFAnyIVc3LhQJ8iFXNy4ln/dLixYsHoU1AkWLNzq/wDWABzMVm5FpAAAAABJRU5ErkJggg==
优点:Replication端可以提供给前段访问,可以将读操作放到从库,分担主库的部分压力,还能提供数据库的备份功能,不过这种备份很可能数据会有丢失。
 
缺点:不能提供安全的数据保护功能,对主库有一些性能影响。
 
阶段三:
单库+Replication+Mirror+BackUp方案:
 https://www.cnblogs.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAW4AAACyCAIAAADtS7I4AAAgAElEQVR4nO2de1gTd7rHp+05z7Z7tl1atbXalmiLsFsr9HTXujW2br0s23ohbluxrS0tbaW1KltZL3VP44V4WddSa7xXUYMigiCiUC8YucktEBAQEoRwCQkCEiRAILff+eO3nWcMSUjCEDLD+32+j08ImXzyvvPmy28mIxAIBAKBBi1iuF8ACARigyBKQCAQDbKMEqVS6fJzyeVyl7cFLnCBy2guRAlwgQtcGrgQJcAFLnBp4EKUABe4wKWBC1ECXOAClwYuRAlwgQtcGrgQJcAFLnBp4EKUABe4wKWBC1ECXOAClwYuRAlwgQtcGrgQJcAFLnBp4EKUABe4wKWBC1ECXOAClwYuRAlwgQtcGriE/H5JpVK5qyosLLS4JyYmZs6cObt37x5wW3q5josdXOgzcKlcx+eBRu5QrUqkUunMmTPnzpkVF3Poww+C/fz8kpKS7KcaLVxnxXQu9Bm4VKWnpzs1D3Rxh+QAR61Wh4SE+PtPSU441lSTh50tPjd//tvTpk0Ti8W2Xsogua6JuVzoM3Cpcm0eBs/FojlKiouL+Xw+x9t77487VbWF/Z2WEvv66zNmzpwplUpp5DJrlw+eC30GLlUajcbleRgMlyo6o2T//v2+vr7r166ul+WrFUV2fP6syN9/SlBQkEKhGDwXMWeX08KFPgOXqkHOg8tcC9ETJWlpab6+vp+FhpRLrzfXlzjomOMHOd7eISEharXaNS4pRuzywXOhz8ClipZ5cIFrVYONkv+c85s7Ozcr7U7jTRe8T/g9x9s7PDy8qqrK5TI8fJcPngt9Bi5VNM6DRqNxnGtHrkcJeY4n5Vxsi7J8MFbWFm/ftpnD8ebz+dTCHJfH7vLBc6HPwKVqSOfB3VHyn3M8HO8De6NaVbfoco2s8Nv1//Dz9Y2KitLpdE6V4YG7fPBc6DNwqXLDPJSXlw+mXueiZP/+/X6+vhvWr1HVl7WpZbS7qixv5coVAQEBTpXhUbucFi70GbhUuWce/P39B1Ovo1GSlpbm5+f7+Wefyiry2+9UD4W7OtRmk6lNVUUQzv2hL8/Z5YPnQp+BS+V68jxY1DtwlOBzPH+ZO0eSJ9a01A6FO9uVJqNe26EuFh+5cmrNyBxx6DNwqVzPnweLeu1FyS/nePzTLiZ2tNUNhTvblUZDb293h6z4wvWzm66d+ecIHHHoM3CpysvLY8Q8WNRrPUrIczwHDwjv3W0cIut7u3Vd7Y3VubkXozLPbR2BIw59Bi5VzJoHi3qtRMn+/fv9/Hz/uWF9a7NCq2kaCvfp7um6O1qVt6TXo3NTo3JSdo7AEYc+A5cqxs2DRb2WG0+Z8tKyZV/Uysu7OpqHwr3dHWazqbO9qbIgsSj9UMHlvSNzxKHPwKWKifNgUa/lxgRBdLQ1GPp6uu+10Gudtt1kMuq6OxQV10qzY6TXo0fyiEOfgUsVE+fBol4rUSLNON5+p9Zo6OvRttHi3u52k9Gg7+tR15VUFiSW556GEYc+A5cqJs6DRb3Wo+RmTmyrqspsMvb23NN1aQZjo0Gv7+vWtNTevnlZVpzi5hGXSCQqlYq8LZPJyNtkC5xiOcgdUCzr84DCfQ4NDeXxeBEREREREQ5umJycjLfqf6fjXKc2IeX+KGHWPFjUazNKyvMT1HXSvt4ug6G3t+eeCzYYeg16XVdHc2N1bm15enXpz+4fcZFIxOVyEUIymczHxwcnCL5NtsC5njnGHVAs6/OAwn0WCAQCgQAhFBERgW84yLWIEplMlpyc7DjXqU2oXKceb5XroJg4Dxb1Esr7RS2pquh8Tfm1bm2b2Wzq6+3u69U6aINeZzab+3SddxrLG6tz6yoznC1J6YykUqmtb6Wmpk6YMEGpVEZGRuIbFqqoqHCK5SB3QLGszwMK93nt2rVr166l3lAqlcXFxampqfh2ZmZmfHw89R7MDQwMJL+UyWSpqanx8fHU58/MzKRugp+huLgYc61ukpqampmZSb2NRWO9jouJ82BRr71VSVXReXlJWk15eptabjTqzWaT0aDT93Xbs15nNpuM+l5Na11zfWlTrcS1kpxKRPsHOD4+PjKZjMfj4ZWISqWKiIggf8odPXoUr5+FQiGPx0tOThYIBDweD//85PF4+PhIIBCQy3Jyyc3n8/EmTr1aVvZ5QCl/WZVERETgpSJurEgkEgqFycnJeI/g/SUQCEQiEbmPLFYlWq1WJBJRFzX4OUUiEbmDIiIiJBJJaGhofHy81U3wjhMKhXgT/JLwM4hEIrrqdVxMnAeLeq1HieD/vvKfPCnu2E5cUl1VlvJ2wb27SqNBj5DZZDIYDL39bTabTUa9VqNuU8lalBWeMOISiYTH4+G5JA9qEELkaCqVSjy+EolELBbjX4EpEAi4XK5WqxUKhdQpFIvF+Hgbb5KYmEhu4qxY1ucBRY0SHo9HNo3cKfjNjyi7hsvl4nNb/Q9wJBIJmQv45wRCCO8v9MuxDN7pa9eu7b8JGTqYolKpyO9SH+b+KGHWPFjUaz1K9u9a9+CDD/7Xfz20NHjBraK0uqqsxuo8lUJ6p6Fcq1Eb9L1mswkhs9lsMhmNpv8EZ193Z2ubqqq1qbK1qdJDRlwikeDlhkAgsBMl+HwKKfKQHovL5ZKnafGT4E0Gf66ENX0eUErKuRIykRFCeA2CpdVq0f1RgttuP0okEonFSVyRSBQaGqpSqQQCgdUooe5fTPGQKGHWPFjUa/MA5+SRrU+PHfPggw+Me/rJpLgDZEltKnl7i0KrUeu6Owx9PSaT0aDX9XTdbVNVtTSWU+0JI47XGj4+Pvhf8n6nooTH4w1RlLCmzwNKef9pV/IAB6/+EELJycnkPXgT8ob9KFGpVOQjcaaQGSQQCMLCwvDzUzehZhne1kOihFnzYFGvvXMlpbkJS4MXTJ/+2ubNmw7s252fdZEsqbO9SatRYyOEmutLrXrYRxwfQuOlMvkJDg4C8tMc/AAyLGQyGT4tQn5yLJPJ8OQJhUKRSIQPebhcbmJiolOvkyqW9XlAKX/5MBh3UiAQkIeKPB4PLxvxI/E6JTQ0FJ+EIs9MRURE4Kwh76EesPB4PHITvCrBOzEwMFClUlndBD8A73f8XbyjyRNkw3WuhCnzYFGv9SgpFJ94P/id7MvH5SVpZrO5V6fR93Vt2rTJ54UJe6K2K6pLO9ubSCOE1Ipiqx72EcfXkqhUKq1WS15XIvlFCCGZTEb9knoPGSUIIZVKJRKJ8D34qSQSyeCjhDV9HlCOv7UsVohu4/aX+6OEWfNgUa/NVUlaWtr4cU9t3/zN3ebbBkOfQd+DkPmVV1554IEH/ufXv1644O0rP5/raGvoaGtACDXVSmyZNSNOLxf6bFX4DLfFmWwm7l+XVyUMmgeLem1GCULo9el/+L3fC6/+0V98Ka69pVarUZ86fmDOrDceeuihBx544OGHf3UlLUnTUocQUt4usGV2jDjtXOjzyOEqFIoBfy83E+fBol7rUVKRf9ZkMhblpn78QZCvz4Tx48aui/iqqjQTH7Mp5CW7/rVlxvRpCnlJ+51ahFCj/IYdw4j3F/R55HD5fD5BEEFBQdHR0bYyhYnzYFGvzVVJdemlnq726ipp1I4Nv/+dj++k5x999DfB7wb9nHLmbvNtqhFC9VXZdkx7SRqNhvoXxpg4aozoM431esJberi4OEpIWc0UJs6DRb0DXO3aqpK1321Jij+2aGHg+HFjf/87nwmc53xemPjv7ZtqqiRtKnmbSo4QqqvMsG9aStJoNNHR0UFBQQRB8Pl88n4mjpon93ko6vWEt/RwcS2ixGqmMHEeLOod+ML5hurc3p5OeVXZxeRTkZvWzvrzjOef57wc8NIz459ubapqbapCCNVWXBvAgyiJmiCkWBYlw9VnkCcoJCSE8Ix5cHmeHYoSfAFve0utQa/r0LSVleZfTovn/99qgiBalLdalLcQQjVlVwa0syVZTRBS7IuS4eqze+r1hNXBcHFtrUq8vLxCQkKSkpIQM+fBol5HowRfdXe3uaanq91kNLS2KAmCaG4oa24oQwjdLr00oJ0qCec0u+UJfXZqXJj+lh4urkWUUBOEFBPnwaJe56JEXVeqriu901De0dbg/dxz+EuEUHVJmiN2qqSkpKSQkBAvLy+r70O2rkrc32f31OsJb+nh4uIosZogpJg4Dxb1OhclVo0QkhWnOGgXSrKaKeyOkmHp85DW6wlv6eHiisViWwlCionzYFGvE1HSVFtk1QihKkmygx5MSdRMYXGUDHufh6JeT3hLezKXifNgUe/AUSLNTX7O9/lf/ebX1y/HK2sK+xshVFmQ6LgHX1JSUhL12momjhoj+kxjvUx5Sw8Xl4nzYFHvwFGy8quP3lv+SXjMjhcmejdW5/U3QqgiP8Fxw4gj6DNw7xcT58GiXkJ+v/qX9K/INa/O+7MgU0QQRIP8Rn8jhMpzT9vy4UP/3rpzy4efLA189/133g/eunPLj3u2DliS3BkVFhY69XiqpFKpy9sOhgt9Bi5VTJwHi3odOlcyd/aMR7weDf/6k7qqrP5GCN3MOWXh9NQjM95a+MhjT3iN93nS5+XfzV06ZV7o5Lc+fdLn5Sc4Lz7y2BMvz5idFBs1Yn9aQp+BSxUT58GiXoeiRFGZUZCVpKjMsGqEUGl2DNWCHZsefcp7+vvfrDyUvimpvL9XHU6f9fnGR5/yDgv/emSOOPQZuFQxcR4s6nUoSmorxHaMECrJOEY67dzBhx8btelk9t4r1fa9PaHwsbHee4UbR+CIQ5+BSxUT58GiXoeixL4RQsXXj5L+7XifqX9bfia/wRE/MY7z2sf/HIEjDn0GLlVMnAeLeu39mmhc0u2yK/aNECq6dpg0QRALo7LOFjRcq2i275RiJUEQC77PHIEjDn0GLlVMnAeLem3+btdZb0zlzZ8lyUqoLr1k3wghSfpB0gRBhP6Uv1iYs/5MaXKxsrRB09+Xy1SbksoXC2/0L0m44+9eXl5OlcHEUYM+A5cqJs6DRb02VyVFWbHbNq6ayHn2p71b5NJUO0YIFVzeS5ogiJWiou8Sbn51TLJYmLNod3bw3hufHs5ffUr6xZGCJXtvvLcn550fs5cdLfz2TCm1pFMH/8mdPi0wMLCystKpMpg4atBn4FLlCfOQnp4+mHptrkr8JnG2bVyVc0U047VXFi2YXZgRJyu+YNUIofxLe0jjkracKz+QfvtsYWNCQcOFEtXxrNpTN+p+un47SaI8mVOXUNC4P716c1I5Lint9PbF7y4MCAhw7S/dMXHUoM/Apcod83BjgHkYZL02VyW5V4/z5s+a8dr/Zl8+vm3jqomcZ4Lf+Wvq2X1VRectjBDKS9tN2qKkzKqWW033Wjt7EUItnbqKpnsZlXcsSuJwOPhPNLomJo4a9Bm4VLljHqqszEN0dDRd9VqPkpxLR2a9MfVivPDQj99N5Dyzlb8y6+do/rqwiZxn/CZN4K8LK7h2srLwHDZC6MbFXaRdGHGdTseUXU4XF/oMXKrcMQ/9okSn09FYr81VSfT+TX6TJvx9+Yd56aKgeW9y//TyzshvKgoSz8bsWrzoL6NHeX20ZF5FQWJFQSJCKCdlJ2kXRtyF1tPYgmHhQp+BS5U75qFflNBbr73rSoqyYj/7mOc/eVJK3O4DP2z465zpo0d5LQ2elxK3uygrNkH07/L8hPL8BIRQ9vntpGHEHRH0GbhUuWMe3BwlXl5eWzetuZkTW5Z7BvvkYYGfDyf8y/fFFw6JLxxaE/7xBO/xUyb77N7xD/wAhFDmua2kYcQdEfQZuFS5Yx7cHCVKpTIsLGzZ5x/fzIklXSg+Ebp04ehRXoGzX/th2+qbObExhzavWfkR/i5CKCNxM2kYcQe50GfgUjXk8+D+KEEIRUVFLeLNL7wuKs0+SfWOjV+/OeMPo5/w+vTDBWnxP+A7EULihI2kYcQd50KfgUvV0M7DsEQJQig2NnbKlJeiD2wvyRJZ+GqycOWy9xb8dQb+EiF0Lf470jDiTnGhz8ClagjnYbiiBCFUWVkZGBi4iDf/+oVD0ozjtowQSo/bQPq/H/nNe1tOOjjiv/r1ows2n0UM3OU0cqHPwKUqPT19SOahyso80FivvSjBio2N9fPzW7/ma3HKgeLr0f2NELoSuw47KXrdm/OCvMb7ODjijz/js/fMFatcx8WOUYM+A5fKpX8eqqzMA431DhwlCCGNRrNu3bqxY8cuCpp3ZJ+gSHyEaoTQ5ZP/OH9szcovl+Lr5+a888m4F6dtic2xM+KbY7O9X35j5uIv7XAdFGtGDfoMXCqX5nmosjIPVrkuSKlUEsr7VVFRobStw4cPz50719v7uSWLF+0UrEs5/YMk/TBCiL/2C19f39WrV9fW1uJHCn488shjo3471vtP85d+tHrLHtG5o2cu/ChK+vzbnbOWfDXq2UmPPDZqdeQeB7n2JZVKXd7WM7mD7POrM96EPrOJa38e1q9fT87Ddzv3OvW+s891XBUVFQ6tSiykUCiio6NDQkL8/Py8vLw4HE5YWJhare6fauI8aejqjTPmL/F+8Y/Yr85d9LfQ8KQr2S5wbWnYf3oMEdflPhMEAX1mH9fWPPTnOv6+c4TriJQOHuDYkUajUSgUtLwUl7cdCVyn+mznd9gwpV7g2hd1HtzJtSUaooTGlwJcurgQJcB1PxeihIVciBLgup8LUcJCLkQJcN3PhShhIReiBLju50KUsJALUQJc93MhSljI5fP5w8K1I+CyngtRAlzgApcGLkQJcIELXBq4ECXABS5waeBClLCQC+dKgOt+LkQJC7nwCQ5w3c+FKGEhF6IEuO7nQpSwkAtRAlz3cyFKWMiFKAGu+7kQJSzkQpQA1/1ciBIWciFKgOt+LkQJC7kQJcB1P5eQ3y+pVCp3VYWFhS5vC1wauStWrBgWrh0Bl/VcWJUAF7jApYELUQJc4AKXBi5ECXCBC1wauBAlLOTC/8EBrvu5ECUs5Lr2CY5MJpNIJBKJRCaTOcjVarXJycnUe/Az4G/hGwNyB5TH9hm4VC5ECQu5rkWJRCLhcrkSiUQgEPB4PEe4KpXK4pERERERERH4W/jGgNwB5bF9Bi6VC1HCQq7L15WQueDj4+Mg1yJKBAKBQCAgbzvItS+P7TNwqVyIEhZyBxklycnJ+IZMJsOrDBwKmIvvEYlE1E14PF5oaCjqFyX4qQQCwZIlS6jJ4pQ8ts/ApXIhSljIdTlKuFyuQCAIDQ3Fb3sej4fPm3C5XJlMJpfLeTyeSqVClGULvgfnCLK2KsEHTUqlMjQ0VCwWO1biffLYPgOXyoUoYSF38Ac4ODskEgmOFR8fH4lEIpfLuVyuxSZcLpfH4wmFQvxl/yjBz6lUKqnfckoe22fgUrkQJSzk0hIlEonEx8dHq9WSX8rlcnIxolKpyG9ptVr8LxooSsjEcUp09TktLS0wMDA6OtrNXGfFUC5ECQu5rl1XQn6Ck5ycjFcfPj4+KpVKJpPhpYdcLo+IiBAKhRKJhPyYBoeIUCgMDQ3VarVisZjH40kkEqFQiD8n5nK5IpGouLi4/4qGrnrtCNcrlUoDAwPnzpkVF3Poww+CAwICkpKS3MB1TQzlQpQA9z8iryshrwdRqVRCoVAsFuNAwVyxWEwuLvDFI1qtlrxBbkVenIKTJTIy0uXXPJh6S0tLw8LC/P2nxJ063FSTj33t5/j589+eOXOm/XM3LNu/Q82FKAHuEHLFYjGXyxUKhe6vV6fT8fl8X1/f73cKVLWF/Z2ccOL112cEBQVJpVIauVgjZP9SuRAlwGUhNzY2luPt/e261fLy7Oa6YjuOOX7A339KSEiIQqEYPJfUCOkzlQtRwkLuSP4/OGKxOCAg4N13F1VIM+40lDrofcJdfr6+4eHharXaNa6FWN/n/lyIEhZyR+ZvUVMoFEFBQW+8PiPj6vmWxjJnrawp2r51k5+vL5/P12g0jnOtisV9tsWFKGEhd6RFiUajCQ8P53C8T4oOtzZVDMY1soJv1//Dz9c3KiqqvLzc5dfMyj7b50KUsJA7cqJEp9NFRUVxON47tm9pU1fR5aqy3JUrV/j7+7v8mlnWZ0e4hPJ+VVRUKF2VVCp1eVvg0sglCMvd6h6uHQ0F98SJE36+vl9//aVCLr3bXE2XtR1qs8nYppLZaeOAYlOfHeTCqoSFXNavSnJzc2fOnLlgwfwyaY6mpYYud7Y3Gg19XR3NpVmiq6fX22mjm+tlBBeihIVcFkeJWq0ODg5+9dWpaRcTO9rqaHN7g9HQ29N193bppcykSHECH6LEWS5ECQu5rIwSjUazbt06Dsf7ePThe3cbaXSfTtun61TeLii8si/7/A6IEte4ECUs5LLsupL6+vr9+/f7+flGbtnY2qzQaprocm/PPWQ2t7fU3syKyb8kzE2NgihxmQtRAlxP5/r7+4eFLauVl3d1NNPlnq52s8nUda9FLk2VZkQXpR+CKIEoAS7LuQRBqOtLTUZ9d2fr4K3rumsyGvR9PcrqvPK8MzezT0KU0MKFKAGup3MJgpBmnmiuLzWZjLqudl3XXVetMRn7DHpdm0omL75QWZgEUUIjF6KEhVyWnSvBUVJ2I66pVoKQWd/X3dvd4ayN+l6DXtfZrqqXZdfcvAJRQjsXooSFXJZ9gkNGSUVBouJWhq67w2wy9uk6HbRBrzObzbrujub60gZZjuLWdYiSoeBClLCQy+IokRVfvH3zcvudWoSQyWTQ93XZs77HbDYb9DpNa526TtpUUwBRMnRciBIWclkZJRsiQr/67D0cJYpbGeq6km5tm8loMJtMBn2vQa+7371ms8lk1Gs16ja1vEV5C6JkqLkQJSzksjJK3v4LlyCIiROevZR8RHEro0Ge21Rb1NpU2dPVbjabEEJms9lkMhqNerPZZDT0dd1raVNVtTZVtjZVQpS4gQtRwkIuK6NEcj3mg/feIgjioQcfXPVVCI6SOw1lrSqZpkXR3dmm7+02GfUGva6n626bqqqlsZxqiJKh5kKUsJDLyijB50riju964YUJ27Ztiz56RHRUSEZJZ3tTZ7uqs12FEGquL+lviJKh5kKUsJDLyii5eun8W3O5OVdi7jRWGgy63t57ubm5Y8aM/uTjJQU5V+/dVWIjhFSKYquGKBlSLkQJC7msvK4EIfSnqf7jxz31L8GaHu1dk8mIzOawsDCCIAiC8H7u2ZMnDnW01SOEmmoKbRiiZAi5ECXAHU6uQqHAv0jVjsgouZQS/eYbr/r5Pv8Gd2p+1oU2lfxWSdbO7RufHvsUQRAPPfSQrLwAIaS8nW/LECVDx4UoAe5wcvl8PkEQQUFB0dHRtjIFR4lBr+vVdZZJs5aHfejrM/HJMaOWfvBOtvh8q0rWfqcmP/vy+aRT7XdqEEINshw7higZIi5ECXCHk4ujhJTVTCFPu1YVpdy729hyR3nspx8CprzoN+mFJ8eM/sMrAXt+2NFUV96mrm5TVyOE6isz7RiiZIi4hPx+SaVSuasqLCx0eVvg0shdsWLFsHDtyBZ3xYoVhDXNnj17+/bt+G+eW1zt2lRT2KfTFuZlbBdsmDtnZsCUyZNf/N2oUY+/FTi7takKIaS4dd2+HY8S2ut1RB47V/a5sCphIdfLy6v/mxOfi8Vci7WAxWOw3PMYW98lFRISQvS7cL6uMutee5PJqK9TyK6nn9/MX7NwwV8IgmhRViCEasquDmBYlQwBF6IEuMPJtRUlXl5eISEhSUlJyNr/wcFXu6rrSjrbm4z63s577Q11twiCuNNQhhC6ffPSgIYooZ0LUQLc4eRaRAk1QUjZipKm2iJ1fam6vrStubpb2/bcc8+q60sRQtUlaQMaooR2LkQJcIeTi6PEaoKQshMlKoXUwgghefEFRwxRQi8XogS4w8kVi8W2EoSU1Si5IU5sqi3qb4RQleScI4YooZcLUQJcT+f2j5J3eH99/Okx36z8XFlTaGGE0K2CRAcNUUIjF6IEuJ7O7R8lBEEclKQ8/uxT4p9PN8hzqUYIVeTFO2iIEhq5ECXA9XRu/yiZNjVg/ppPx0wcn3buWL0sh2qEUNmNWMcNUUIXF6IEuJ7O7R8lpfkX586asfabZXWVWRZGCN3MPumUIUpo4UKUANfTuVZPu9oyQqgk84RThiihhQtRAlxP5/aPktqKa7aMEJJmRDtriJLBcyFKgOvpXDJKirPjcJTYuSgeIVR07SenDVECUQJc1nNxlMQf3+E3aULc8V3VpZfsGCEkST/ogiFKIEqAy3IuuSq5cGZPwEt+IR8ESbIS5CVpVo0QKryyzwVbREnU1nAvL69hqZeh+xeiBLiezsVRclTIn8AZH3d817cRX0zkPPOTcLOs+GJ/I4Tyf/7RNeMo2f/9uikvvRgUFJSenj4s9TJ0/0KUANfTudRVif9Lvl+EvJOe8tOM1/536isvbdu4qjQ3oaroPGmEUG7aD6752L6N3OnTAgMDpVLpMNbLUC5ECXA9nUueK/GfPOlivPCb5Uv9Jk04fXTH8QORvHlvjh71ePDfAk8f3VFZeK6y8BxC6MbFXc76zNFI7vQ/zZw5UywWD3u9DOVClADX07nkquTU0e1+kyb8ffmHF87s8Z886a253B93rs1LF323bpn/5ElB896sKEhECOWk7HTccUe2vBU4JyAggBoiw1svQ7kQJcD1dO7DDz9ccO1Y2Y248rz4osxTn30U5D95UkrcDzu3hM96Y+roUV6ffRR0KWlfeV58eV48QigreZsjPh+zZfG7CwMCAmz91+SR1ufBRonyflVUVChdlVQqdXlb4ALXlqKjo6f+8Q/56aKyG3HYJw9H+vlwFr498+ThSHHKwfAvl4x7ekzo0qCyG3EIocykSPu+eGrz4ncXcjgcoVBohzvS+jxILqxKgMsArlQqDQgIuHr+cGnOKewC8fHNG8KmvPjCuKfHrAoLTj+/r0J3V6EAAAHQSURBVEB8vDTnFELo+tnNtpwSs+mzkGAOhxMdHe0I1+XXzNA+D4YLUQJcZnAVCsW0adMO7oksyYqhOjU+6tMP549+4rdhnywqyYpBCIkT+P2ddoq/avnHHA4nKipKp9M5znVNzO2zy1yIEuAyhqtWq4OCgmbP+vPFhL3SzBMWvnjme/xH/NLjNlB9UbRh1VcfcTgcPp/vYIhYcF0Qo/vsGheiBLgM46alpQUEBKwODxOnHCy+fszCCKGrp9dj/3xq/bcRn/v5+fH5/AH/nOiAXKfEgj47y4UoAS7zuDqdjs/njx07dlHQvJ/2CiTXjpBGCF05tebKqTX8dcs4HM7y5cvVajVdXMfFjj47xYUoAS6DubGxsYGBgd7ezy0Kmsf/dtVZ0b8RQpEbwjgcTlhYmFqtZlm9nsyFKAEu47kKhSI2NjY8PDwgIIAgiODgYIVC4QauHY1ALkQJcIELXBq4ECXABS5waeBClAAXuMClgQtRAlzgApcGLkQJcIELXBq4ECXABS5waeBClAAXuMClgQtRAlzgApcGLkQJcIELXBq4ECXABS5waeBClAAXuMClgQtRAlzgApcGLiG/X1KpVO6qCgsLXd4WuMAFLqO5/w/2W8bsh6f4cAAAAABJRU5ErkJggg==
优点:这种方案是前面两种方案的结合,既能够解决数据保护的问题,也能够提供读写分离的功能。
缺点:主库上既有Mirror又有Replication,这种方式对主库影响会比较大,而且实际证明,Mirror和Replication在同一台机器上部署,在一个出现问题时,
会对另一个造成影响。
 
阶段四:
Cluster(双A)+BackUp方案:
 https://www.cnblogs.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASEAAADdCAIAAAB7WFOaAAAgAElEQVR4nO2de1yTdf//r7vuzPqVUWZ3ZcXyDsHywH3QqEgpoyiloIPSyShMKdOMdice12lpX01SKTyk0xA8g3hgiuAQQYQNxtGxCQw5bJwHDBin7fP743N3tXvHa7t2wTber8f7j7Fd47n39fk899l1bQMCQSAQJkOM9AOAQNw84BgEwmzAMQiE2Zh1TCaT2f1L6+vr7b4vcIHrZlxwDLjAZZYLjgEXuMxywTHgApdZLjjmLNzk5OSgoCAejzfMXDsCXJu44NjIcwUCQUBAQHDwK0cO7n7v3TAWi0XRNBftd7RxwbGR5Eokkvnz58+e7Z9y/EBDVR4uYU4qRdNcrt/RyQXHRoarVCrDw8O9vb0P7o9TykXGVZB77v1337Zsmgv1O5q54Nhwc1UqVXR0NMvT89cdWxprxJarMDfNgmku0S9wwbHh42o0mo0bN7I8Pb/hrKmrFDbVFlOswrz09997x9g0J+8XuAgcG04uj8djeXp+GbWiUpLXXFdqR4nzLxqY5sz9ApfkgmOMc5OTk328vd9/7x1JcU5LQznNKhIKSNOcs1/gGnDBMQa5+KT8q8Hz869caFVWOLCKCi598MEiX19fux+zO+1nJ+eCY4xwJRJJSEjInNmzz5461tZ43bHV09Wi02qb6soIwv6vTbjHfnYJLjjmYC4+Ke/j430ogadqrnJsdXcotdohVbO8ULA3LfErcMwluCPjmEgkkkqlUqmUOlcgEOj/qFarRSIR+dvUajUVroXQ7/e/J+VZnrt27uhorXFsdXUotEMDveq28rzjmSe+yTi6bngcw/tZKpWSextR2M8GgyUSiRQKBf5tSUlJNj9WylwLGUnHZGYiFArN3WQ1YrHY8gYRERFFRUUymSwwMDAnJ4cKNyoqyuCawMBAfGHz5s0UuRZCp9/8/Px169axWJ7ffctpUlZ2ttU6sNQqxdBgX19vV2VJWs7pzVknf9B3bBj6feutt2QyWU5ODrnDqYyv/o9RUVFJSUn48s6dO217oHoZqfGlyR2ZdYzL5ZIX9J8gLXDJu5AJDQ3FF1JSUihyLcTufnk8HovF+g87qr5G2tXe4MjqUA4O9PVr1A1V+QUZu3L5Pxs7Ngz9stlsfIHc4Vb3M3kXHP1RTktLs+FR/m9cdR2zcJvdv5eiY2q1OiIiAl8THx+fkpISHx9PjkFsbGxKSoq+jQghqVTKZrPxK0MDx7hc7vbt2+Pj4w0GmGLs63f69GnhHyyqlpV1dzQ6tgb7ewf6upvry0tzEgsu7hFe+HVkHROJROSO/f7771NSUmJjY8ltuFyu/jV4y/j4eHyNgWN43FNSUvTHl0rAsT9DxTGRSKQ/bOS+DgwMRH8ohxCKjY3Fh214A/1xNXBMJBJt374dIaRQKOzQzL5+CYLobG8Y7O/t6Wp2VA309/Rr1B2tN6QFp0pyEoou7R9ZxyIiIqRSqUAgwEOgUCj27duHEBKJRHg4IiIi8LMe+YyJ9z85WMbrGJfLxUdo8fHxBgdvFgKO/RnqrxXJccKLmEgkwo4ZP71xuVwul0uOIjLlWGpqqsFN1GO3Y+Ks39ubqwcH+3rVbTRroK9Hp9N1dzbVSC5ViE6WXz3qDI7pPw/i5zu8jsXHx+NhMn5Gi4iIwONF3tHYMfyjSCSivpSBY3/GJsfwyJHjRDpGnnXET3hcLletVuOhxddbcExfRYqh41jJlcOqlhqdVtun6ezrUdlRA33dOp22r6dDWSOuKkmTic86p2P4OZFcx/A46j+j6S9obDabHDtzjgkEAnJArQYc+zNUjonJ14pSqVShUOBREQgEgYGBAoEAv94TiUTx8fF4nPCWCKHQ0FB8gc1mC/4IQkgkEq1atUqtVpNb2hSajpXnnVDWFPX3dQ8O9vX1dlKvgT61TqcdHOhra7xeK82WXxM4lWP42Am/VsRjlJKSsn37drVajQ99FQoFPqwiX5KgP149qtXq0NBQtVqtP5qYi4/fyHGnGHDsz9j3mLBL+lyrquC74OB1TP8am0LfsYrCM9Xlmb3qNp1ONzig6e/rtla9Op1WOzTQ1d6grClqqBI6oWMmU19fj9cr/VgdLLwB6RiVuxhzbdpeP+CYA7hcLnfVqlXDzMWO5aTtTTsZV1F45nrx+epyQYtCOjigQUinHRocHOg1WTrtkHZooKerta3xenNducs5RodLnlccZq7d9wXHRpKLHQt87smbb75p2ZK3sWM3pDn1VcL2pqr+vm6EkE6n1WoHhwb7ceG1q1fd1tYoa1VUtCoqRptjo40LjtHiYsfOndgx4d67CYKY9OjDF84cwI4pa4qaGyQdrXV9vZ3aoQGdTocQGhzQaHo6WpWy5vprfxY45tZccIwWlzweK7x8+L2wYIIgbr75pm83fEU61tZY2dFaq+5o7O5s0vSoEEJNtSXGBY65MRcco8XFjgkz47MEqRWFZ1KT92m1Q1rt4MGD8Usi3iu4mo4d62pX4EIIKWuKTBY45q5ccIwWlzzn4efnF/rqCyX5qVrtUJ+mY2iwb+PGjQRBeD329193/NSkqOxsq+tsq0MIKeQFJgscc1cuOEaLS75WRAg9+e/pEx/8W/y+n9UdSnVn29UrWffcczdBEARBjB17a+LB31QtNQih+so8cwWOuSUXHKPFxY5dE55ECG3bsvYfMx5/bJLnSy/MFl89h4/Hzp89/mrwy3/961/jYn9qb6pGCNXJcs0VOOaWXHCMFpdcx1oUFV2dbRdSD89/+XnfGY/feecdIcFBhw/ubmus1C+EUK0020KBY+7HBcdocfU/5yGXZGl6OkqL8qLZn07xeczb6++TvSY98vDE9Wu+vFac06qUtSplCKEaSZaFAsfcjwuO0eIafJbqevH59qaqttamLEFqzOZvQl57eYr35H/6ThszZky5OLuloQIhJC+/aLnAMTfjgmO0uMaOVZcLFPLCXnVbX5+muvJa1sXTMVu+IQgCv92MEKoqTbdS4Jh7cYl6MxGLxeZuspry8nK77+taXJOO4c95NNWVqTuUQ4P9HapmgiAaa0saa0sQQpUl560WdceGuV+c0TO+DuHCOkaLa8Ex8s3l9qYqT89HmurKlDVFCCGZ+CyVgnXMbbjgGC2uBccU8kLjQghJC05TKXDMbbjgGC2uScdOHtl9TXyxoVpkXAihCtFJigWOuQcXHKPFNXbsuw1fPDx50lNP/quqPLu+Mt+gEELX8pMoFk3HNBqNXC53bL84o2d8HcIFx2hxjR3zm+m7Yd/WWW8EctaurLt+1aAQQuVXj1Iv+xzj8/nh4eFjx47lcDiO7Rdn9IyvQ7jgmFmuXC5XqVSW72Xs2OeffjDrjcApgU9y1nxeK71iUAih0iuHqZdNjkkkkpUrV95///3EHwHHnIELjpnlcjgcgiBCQkJ4PJ452Uwej70Z+vKboS9LizJqJJcNCiFUkpNgU1l1TKlUxsTE+Pj4EEYBx5yBC46Z5WLHyJiUzaRj8muZ5gohVHw53qay7FhYWJixWmRYLJbJ6zkcDtmvQZsm/XSSbcjxteP3TJkyxe65AY4xxTU3kPqyEcaOlV20UAghcSbP1rLgmEajOXToUEhIiNU5Z7Vf6nHF8SVonIN1Isd8fX3pP40tX77c1qcoMlFRUTaxLG9j7lYy4eHhhJFjlj8nhRAqFPxma1E5HlMqlXFxcQZDAI6RIdzDMXJEXXEMqK9jHh4e4eHhycnJSO9v5syYOjk1aef14vOVJWkWCiEkythtR1E/ryiRSKKjo/GrRHCMzPLly0eEC68VLXENHNNXiwy5jiXu3TjFe9KXKz6UFZ2zUAgh4YVf7SsDx2K4Kzw8PCx0RP4FZYr9Uo97jO+wccExs1zsmEm1yGDHUg5tXfj6S9kX4pd8uMB3mg8/eZdUnGqyEEJ552PtK9Kx37at9n/GLyQkJDs724H9Uo97jO+wccExs1yBQGBOLTLkOsZd/9kk1kN7dnx9ZP+WKd6TloS/mXoirqLgtEEhhK6e22Zf5fJ/Tjrw/StBLwQEBOAFyj32s9tz4XiMFhc7dvH0zlVffHj53P5nn/pn6Py5l8/tj1q2aBLroRnTvH/grMi/mCgRpuBCCOWmxthR549tCVsQ4uPjo6/96NnP9LlucjxGHoK74hjQ/CzV4g9CZ0ydfOboDu6GzyaxJnKil+ZlxB/atyl0/vP3jvcInf98Xkb8tfwkhFDO6c02VfrxH5ctXcRisXg83oj367pcNzmvOJodK8s7nrD3B5/JrJWfvpuZ+tuC11+8d7zHy4HP7Px5bcHlQ9+vX5abfqAs7zhCKPvUJoqVmbRp1RdLWCzWxo0bNRqNM/TrulxwjBaXzPBzPTw8tmxcW3LlcGnu0dLco6JLCRGLQqZP9UrYwxVdSvi/bz/39/N98IEJEYtCRJcSSnOPIoSyTv5ApTZ+vZLFYkVHR1v4zOTo2c/0ueAYLS6Z4edqNJrw8PA1qz4vuXKYrIN7vpv+hNejng9+/snbF0/vPHdix1efLzp3Ygf+U6eXkr+zXNt+/I+Pj094eLhSqbRMHz37mT53JB2TmYlQKDR3k7kQxH9/m1gstvW+dLhkRoq7fPnyd8LeEGYeLM5OJOtkwpaP3nv13ns8nn/23zEbo/CVCCHB8a/N1Z5t0f7P+M2fPz8jI4MKd7TtZzpccnIOM1coFMI65hguj8ebPn0aL25TUVa8QcVwVwbN9Us/GVuUFY8QunhsvXEd2bPmlaC55El56ly7H7OL7me77wuvFWlxyYwsVyKRBAUFzXvlJcGZ3YWXDpgshFDGkbX6lbJ/zcI3gw1OytvEtS+uu5/ti5s4NgrfHzPmJicn+/j4hL8fdubo9oLMfQaFELqQuArX6QPRnyx+x9PT0/ikvB1cW+Pq+9nWuMn7Y2RccQwcyFWpVHFxcT4+Pi/MDYj7+WvRxd/IQgilJbBT49lfrgjHJ+XLysocxbUpbrCfXYULjjHI5fP5+Jtdz/o/vfyTD3/9+WulUvn92kj9k/Lu1C9wTXLBseHgCgSCjRs3hoSE4E8Y65+Ud8t+gavPheMx4I4Krpscj43y84rAdWbuxIkTR4Q7fI7x+fygoCAqp6dH29gDdzi51OehA7mMOyYWiwMCAl4MnHvk4K7g+a8EBQVJJBLLj8lWLhnXHXvgMs3l8/k2zUNHcZl1TKlUhoeHz5gx/eTx/fWVubiOJOz29va28FHX0Tb2wGWaa988pM/FYcqxiooKDofD8vT8Zfv/NVTlG9fX66O9vb1Nvvc6esYeuExzVSqV3fOQDlc/jDgWFxfn7e29etWXN6RXlXKRuSotyHj/3bf9/Pxyc3Npcsm4ytgDdxi4NOeh3VyDON4xb2/vxRHhZYWZjTViKnX+zNEnZ82KjIwk3zJy+7EHLtNcPp9Pfx7awTUZhzmGT2zcdtttuZdTm2qLba2Ynzb6eHvHxMTYyjWIk489cJnm/vcE24sv0J+HNnEtxAGOkQeUp5MTm+tK7a5KSd5nyyJ9fHyOHj1qdz9OO/bAZZrr8Hmo/yWjEXPsvweULM+dv8S0NJQ7pPKyz8+Z/WxISIjVrwCbjBOOPXCZ5g7DPBwZx+Li4ny8vdeu/kpxo6RVWeHYSjz4G4vlyeFwTP6hGAtxqrEH7jBwh2ceVldX0+nXZsf4fL6Pt/fHiz+Sll1ta5QxVMrasg3r1/n6+trUj/OMPXCZ5jrzPDTol6g3E7FYbHBNRkbG7NmzX3oxUJgraG+qYq40PSqdTtdcV0YQZh+eyZSXl9u0veV+geucXOefhwb9UlrH/jignME/c6KjRc5cabrbdDptS4MkP+2XC9b+p7hx6p3g+RW4zHGLi4tdYh4a9GvFMfKActfOHZ1tN5ir3u42nU7b0VpbnH0w88Q3F4+uA8eAS8a15qFBv5Yci4uL8/HxXrd2dXNjdVd7PUPV292m0w6pOxrLrx4j//cPOAZcMi43Dw36NXtnX1/fJUs+rpKVqFUKhqpX3arTDvWq26pK0vLTfslNjQHHgGsQV5yHBv2avTNBEDqdtqerpbuzyeHV29Ou1Q4N9HXLJZfEmbyCjN3gGHBNxhXnoUG/lhyrKDit6W7v62nvVbc4qvp6VFrt4EB/j6JaVJZ7uDj7IDgGXAtxxXlo0K8lx8SXDlSITnV3Ng9o1JrudprV39up1Q4NDmhaGiTSwtOS/CRwDLhW44rz0KBfK46V5BySFqX2drdrtYN9PR12lqZLpx0a7O9tb6qUlwuuF58Dx4BLMa44Dw36te5YWd7xioJTLQopQrrBgd5+TZdNpdMODQ32d6kUDVXCGsml6rIMcAy41OOK89CgX6qOyYr4tddz+3q7dDrt0GDvQH+31dJqh7RDAz1dzU11ZQ3VorrrueAYcGk65hLz0KBfK46dO759w6oluLeqsoyaisvtzdVDg/1Ip9MODQwOaEyWTjukHRrQdKtUTVXN9eWNN4rBMeDax3XFeWjQrxXH3l/4yk03/WUS66Fzybtxb3XXryrk4o6WG4MD+EPxOq12cGioH5dOpx0aGtD0qNoaK1sUFS2KCnAMuHS4rjgPDfq14phQ8PvcgCdvvvmmsbeOWfHJIrK3ptqyVoWss72hX9OlHRpASIcQGhzQaHpUbUpZc325foFjwLWb64rz0KBfSsdje3Z8PW7cHTfffNOc2c8Izh8he2tvlne1N6g7GtUdTb3d7QihxtoSEwWOAdderivOQ4N+rTuWJUitKDglunz82rUyrXZQqx188/VXd8VuJnvralfgQggpa4pMFjgGXPu4rjgPDfq14ljO+b0BAQGhwXNFl48P9PX0aVT9fV1yufz2228fO3Zs2ILXL2ee62itw4UQUsgLTBY4Blz7uK44Dw36tb6OIYSmPTH5wQfuO7BnS0frjd7ujrpa+dtvLxhzyy1/+ctfbrnlr5O9/l5TWapquYEQaqgSmitwDLh2cF1xHhr0a8Wx0tyjCKFfYjZM8Z70KOvh4HlzC6+cxa+DC/MEa6Kjxt9z961jxpxKPtTeLEcI1V3PtVDgGHDtc8y15qFBv9bXsRZFRaeqOe3swVdfed7L69H7Joxf9O6b2YLTrQpZW2NVW2OVpOQqvoAQqpXmWChwDLh2r2MuNA8N+iVkZqJ/PudGxeW+3k6x6PKqLyMfZT08xcfrvvvu/fe/fHf8/GNDTVmr8jouhNCNiiwLZUdv5h6eyYjFYpu2149QKLT7vsBljuuK89CgX6qfpbpefF7VUtPU2HD88N7ln3701JP/euSRh6ZNnTL+nrtfCXqhRSFtUUgRQvJygeWCdQy4Nm3vivPQoF8bPq9YVZahvFE02N/bqKwT5V1K/D3ui8+X+M54giCI5vprzfXXEELVZRlWCxwDLvW44jw06Nc2x/D7622NVZqejv7+PmWDvLQoiyCIptqyptoyhFBVSZrVAseASz2uOA8N+rXHMYVc3HijpLn+Wmdb/eBAn6fnI403ShpvlCCErhefo1LgGHApxhXnoUG/djqm/955U10ZvoAQkhWeoVLgGHApxhXnoUG/djlWXWiyEEIVBacoFjgGXCpxxXlo0K9tjm3ZuIazdmVDlchkIYQkwmSqBY4Bl0JccR4a9GuDYzu3ffvErH/88+VnF38YVleZZ1wIoWv5J6gXOAZcq3HFeWjQrw2Orfh0UcjS97bnnSAIolZ2xbgQQmW5R22p0eiYQCDgcrmxsbH4v8ht3ryZzWbHxsYyzTWI6zrm/PPQoF8bHLuaeezxKV7/fuelv0/yvCHNNi6EUOmVQ8Z14nBs2EeLH/GZ/v/uuof4I7fefsfDPjPmLQg7sPfH0eNYSkpKREQEQkgkEuELMplMJBJxuVybiPHx8TZxjeO6jjn/PDTo17bjsdTkvSuXfZidfrRGkmVcCKGS7AT9yk0/8Pxrb91+zwOPzw17LXrX4ti0rw6Lo48URR8pWrorM3T1Lt/gxXf+zXOG/9zU41tHg2P+/v4KhQJfTklJQaYcU6vVBheMg/10/n7pc11xHhr0a5tj8muZFgohVJR1QL/ufXTqMwuWb0mtsFxBkd/+7dEpGUlb3N4xLy8vY66+Y/Hx8aGhofoXFApFaGgol8sNDQ0ViUQIIS6X6+XlxeVyt2/fTt6Ly+VGRETg9Y3L5fr7+3O5XDabbUwkuTb3+UdG3DEnn4cG/drmWHX5RQuFEBJn8sh65ImZD3j/a/9lOZUad++Dzy2Kcm/HRCKRVccQQlgt8kJsbCy+VSQSkWsgvglzFQqFv78/vl7/Ankvkw/GpR1z8nlo0K8tjpWmWy6EUKHgN7IIggj+9vjZogYqRRDEC+uOurdj6H/XMSyMVccQQmw2m3RG/ybMxeqy2Ww2m03exd/f35xdOC7smNPPQ4N+rf+tgRlTJx/Zv1lWxK8sSbNcCKGCjN1kEQSxMDbnE57o0rXmvMpWCxWVUEgQxKtbs9zeMX9/f6lUii+bO+dBvkTEixJ++YcQ0j/9iLcpLCxUq9VSqZRcvvAxHnI7x1xrHhr0a30dO31k24xp3ks/WlCalyIr4lsohJDwQhxZBEGsiC/4dL9wYeyVD3df/YlfwcuqPl+irGxSXyhV8LKqfz4nXfxb3ls7cj7em2/cW+yPX3h4eNjUj/M7JhKJ8MEVm83GsuFz9/hKvA1esiIiIvz9/VNSUvBlkUjEZrPJ14r4N0RGRuIfIyIi2Gw2l8vFvwQfj7HZbPz2gMm4lmOuNQ8N+rW+jr0fNj8/89CXK8KneE868vtPUvFZc4UQyj8fSxbu7buTZdvOSX88I/kysfCLg4VvbM9+dWtWWGzOyoOFXyYU/nCq/OdzFd8ml+n3lrhrnf8zfkFBQRKJxKZ+nN8xHHIpM8fV3wCfXTRelKRSqT5XoVCQBlKJaznG7DxMtDIPs7Oz6fRrfR37fv2ySayH9uz4OvVE3Ixp3h+881rG6b0VBaeNCyF09dx2ssjedmZUnhDWZVU0X2vobOnqQwg1d2nKGzovSZqO59fFZVwne+Mf3rTwrdd8fX0tPAFbiKs4BlzqGY55WGFlHtLs17pjCXt/uHx+/7NP/zM0eG6+IHF1VMTEB+979ul//sBZUXTlmESUQhZCKDd1K1l2OMZisbZt22Z3P6Nhzo027nDMQyPHWCwWj8dzVL9EvZkQ5N9AnjPrlRf9s87xuJzlk1gTd2yOviZM3r19Q+j85+8d77HwjZeSErZeEyZfEyYjhHLObCHLDseqq6vFYrG5h2Q15eXldt8XuM7JHY55aORYdXW1A/uldO5+8/dfPMqayF3/2aXUvXPnzJr4wH1ffPpe2sm4q+m/b1i1JGT+c+V5J8rzTiCEsk//SJYdjiHXeX4F7vBwh2MeGjnm2H7NOubh4ZF5ZndJzqGyq8fKrh7LvbA/ZF6Av59v5tk955N/XbwoZOIDE/z9fDd/t7IgKxFvgxC6nLKRLHAMuPS5wzEPR8oxPp/v5+eXcuSXkiuHyYrbuvrBBya8Nm/OwT3f4R+DXnh6+hNe+FaE0KXk78kCx4BLnysWixmfhyPlmEwmk8vlAQEBibyfinMSycoXHPh2beT0Jx578IEJn0eGZZz6lbwJIZR54huywDHgOoTL+DwcQccQQiqVKigoaM1XK4ouHzSo1GMxH70XfO89dwXNfQpfgxASHOeQBY4B11FcZufhyDqGENJoNNHR0d6TJx/9fas463fjSj74I76AELp4dB1ZZG9PvfQGOAZcmlyNRhMVFUVnHjqvYzgSicTPz+/tha8LzuwqvLTfZCGE0g+vJuuW2+6YFrTou5NlBEFYdWzM7XcGLNtqzLUpo2rOjU4unXlIxTFyHjqwX6qO4fB4vPvvv//1kOAj+7cUCPYZFELoQuJXuJL3rXo9NPiOeye+tfoXq459wI2/+wGWsrXTHJdiRuGcG51c++ahVcf056FJrh2x2TGcQ4cO+fn5eU/24n7NTjq4VXTxN1wIobQE9qn9/1nxyfv4nfJSWc2jM54hCGLhFxuPCIoNeku6UvHeqp+8nnzx/sem5ZVVWuVazYiPPXCHk2vTPPSc5jfpXwHU56EFrk2x0zEciUQSGRnp6+s7duzYF+YGRH2+RC6Xb/jqYx8fn9WrV2s0GnJLgiD+/ULo2HHjCYIY/+Cjnk/MfOCxaQRBjLntDt/Zr6zdvLN/UEudayFOMvbAHU6uhXnI4XDIeSiTyTbE7DOYh7eNu9vcPLTKpRhajpHRaDR8Pp/D4Xh4eERGRiqVSoPHRH79pn9Qe0qQv+/omSOn0+lzjeNUYw/cYeYaz0NzXHIeUvxi2Mg7ZhxzjlF8TI7i2hTgjkIuOEaXa1OAOwq54Bhdrk0B7ijkgmN0uTYFuKOQC47R5doU4I5CLjhGl2tTgDsKueAYXa5NAe4o5IJjdLk2hVGuwFTwGzhu2a+rcIfJMZmZCIVCczdZjVgs1v+RIMxSGOXaFMdyBQLBN998M2fOnMcee4wwn7vuumvmzJlLly5NSUlxCJd63GM/0+RSnJk0ubCOOZjL4/F8fX0NXPLy8nr6f+Pl5WWwDYvFiomJ0f8Mmk1cW+Pq+9khXHitSJdrU+hz+Xw+i8UinZk6derq1auPHTtWVVVVbypVVVXHjh1bvXr1008/Td7r/vvv1/+rY1S49sV197MDueAYXa5NocmNjo7Gktx6660ff/zx1atXG2yJWCyOioq666678C8JCQlRqVRUuHY/Zhfdz47lgmN0uTbFbq5Go3nuueewGwsXLiwuLlbaG6lUunz5cvyrfH19rWrmNnN9pLjgGF2uTbGbGx4ejpevbdu2NToiSUlJeEHz9fW1fHjmNnN9pLjgGF2uTbGPm5ycjJedAwcONDsuFy9exJqtXLnSAt1t5vpIccExulybYgdXo9HgU4hLly5tcXQOHDhAEMTYsWMNvgc1gv26Hxcco8u1KXZwxWIx1kAikbQxkMmTJxMEcejQIQv9qqdbISYAAAXCSURBVFQquVw+PP3qc+2+r1NxwTG6XJtizJXL5ZbPOhw6dIggiJkzZ7Yzkw8//JAgiOjoaGO0SqXi8XhBQUEEQXA4HIf0Sz3gmE1ccMwsl8Ph4NPoPB7PpGx4g9dff72DmeD3A8LDw0kiViskJET/zWtwzG4uOEaXa1PMOUbGWDa8wfPPP9/JTJYsWYIdM6kWOEafC47R5doUq44Zy4Y3mDJlipqZBAYGEgRh+ROPEDqh+I+eXcAxDw+Pkd6ZjASfVLztttuqq6u7HZ3W1tY77riDIIjw8PDk5OTw8HBzuxHWMSfnDodjNsV5uObWMQ8PDzzv8QazZs167bXX2tvbex2aDz74YPbs2cT/Ho+ZlA0cc3IuOGaWa+AYqZbBBvPmzdu8efOcOXNu3LihcUQaGxsXLlzI4XAWL15s4BgZLNu4cePAMefngmNmuVghY7UMNpg3b55QKPzll198fHyOHz/eTy/p6enTp0/ftGmTUCi04BjZb3JyskAgcEi/1OMe4ztsXHDMLFcgEJhUi4y+Y2KxWCAQzJ0719fXNyEhYcD2nDlzJiAgYNasWadOnRKLxRQdc2C/1ANcm7jgmP1cA8dKS0slEklKSkpwcPC4cePCwsISExMLCgqGzKeysjIpKSkyMnLChAlz5syJj4+XSCSlpaXgmDtxwTH7uSYdk8lk1dXVZWVlv/76a0hIyNSpUwmCCDCVsWPHPvLIIy+//PKmTZsKCgqqq6tlMhk45n5cwuRXdOvr68VisbmbrKa8vNzu+7oQNyoqypxjtbW1DQ0NjY2Nra2tHR0dfD7//Pnz6enpAoEgPT09LS2Nz+fjWxsbGxsaGmpra805tmDBAifpF7j2cWEds59rYR0zcKy7u1uj0QwODiKEBgcH+/r6uru7Ozo6qDgG65irc8Ex+7ngGHCpcMEx+7lxcXEEQcyYMYMhx959912CICIjI52kX+DaxwXH7Ofm5uYSBHHnnXcy5Nj06dMJgoiJiXGSfoFrHxccs5+rUqluueUWgiA2b97scMcSEhLw50vEYrGT9Atc+7jgGC3uypUrCYKYMGHC2bNnHehYXl4eXsSCg4Mt0EfPfnZpLjhGi6tUKh966CGCILy8vK5cueIQx0Qi0VNPPUUQxJgxYywsYmg07WeX5oJjdLkSiQR/CcXDw2P37t00HTt79uykSZOwYHw+3zJ6VO1n1+WCYw7gZmZmPv744/jw6R//+EdiYqIdjuHPK+JfMn78eCqf9B1t+9lFueCYY7gajQYfm+E8/PDDn332WXp6ulXHSkpKNm3apP9vKF588UUqf4gbjcr97IpccMyRXLFYHBwcbPCdzmnTpi1btmzt2rXr16/ncDjr169ft27dmjVrZs6cib8ARsbf39+mL6qMeL/ApcIFxxzPlcvlMTEx+v+NxXJ8fHw4HI5EIqHJtSlusJ9dhQuOMcvNzc3l8XgcDofD4YSFhQUEBISFheEf4+LiBAKBm/ULXGMuOAZc4DLLBceAC1xmueAYcIHLLBccAy5wmeWCY8AFLrNccAy4wGWWS8jMRCgUmrvJasRisd33BS5w3YwL6xhwgcssFxwDLnCZ5YJjwAUus1xwDLjAZZYLjgEXuMxywTHgApdZLjgGXOAyywXHgAtcZrngGHCByywXHAMucJnlgmPABS6zXHAMuMBllguOARe4zHLBMeACl1kuOAZc4DLLBceAC1xmueAYcIHLLBccAy5wmeWCY8AFLrNcot5MxGKxuZuspry83O77Ahe4bsaFdQy4wGWWC44BF7jMcsEx4AKXWS44BlzgMssFx4ALXGa54BhwgcssFxwDLnCZ5YJjwAUus1xwDLjAZZYLjgEXuMxywTHgApdZLjgGXOAyywXHgAtcZrngGHCByywXHAMucJnlgmPABS6zXHAMuMBllguOARe4zHLBMeACl1kuITMToVBo7iarEYvFdt8XuMB1M+7/BzxU8bbwupxVAAAAAElFTkSuQmCC
说明:图中矩形部分代表存储,两台服务器做了双A的群集。
 
优点:Cluster能确保其中的一个服务器出现问题时所有的数据和服务能切换到另外一台机器,切换的时间很短,能尽快的恢复业务访问。
缺点:双A群集一般要求配置比较好,价格比较高;因数据都存放在存储上,所以群集不能保护数据,一旦数据或者存储出现问题,需要从备份中恢复数据;
SQLServer的群集不能提供负载均衡的功能。
 
阶段五:
Cluster(双A)+Mirror+BackUp方案:
 

说明:双A群集再加两个服务器上库的Mirror保护。
 
优点:这个方案能对数据提供可靠的保护,无论是服务器故障还是存储故障,都能保证数据的安全,而且数据恢复的时间比较短。
缺点:Mirror会消耗主服务器的部分性能,多了两台Mirror机器,成本会增加,如果存储出现问题,快速恢复的方案是启用Mirror机器,后面可能需要重做群集。
 
阶段六:
Cluster(双A)+Mirror+BackUp+Replication+单分发方案:
 

说明:双A 群集,Mirror保护,单分发机器和读写分离方案。
 
优点:群集和Mirror能充分保护数据的安全,读写分离能提高系统整体的性能。
缺点:成本较高,单分发机存在单点故障,如果分发机器出现问题,将需要重建,此时读和写都将集中到主库,压力会比较大。
 
Cluster(双A)+Mirror+BackUp+Replication+双分发方案:
 

 
优点:与单分发机相比,没有单点故障,即使某台分发机出现问题,也能保证读写分离机制继续运行。
缺点:成本增加,维护方面更复杂。
 
阶段七:
Cluster(双A)+双存储+BackUp+Replication+双分发方案:
 

优点:双存储方案使得数据能得到有效的保护,而且避开了Mirror和Replication同时在主库运行对主服务器造成的影响,节省主服务器资源,而且恢复比较方便。
缺点:成本增加。
 
阶段八:
Cluster(双A)+双存储+BackUp+Replication+双分发+SSB异步方案:
 

此方式的主要优势是将数据流异步处理,缓解瞬时高流量对主库的压力,因为此方案比较复杂,暂时不做说明,可以参考数据库架构 一问。
 
阶段九:
   (横向、纵向)拆分业务和数据、采用分布式数据库、使用能负载均衡集群功能的数据库等。
 
    此文档大致描述了随公司的发展、服务器压力的增加,数据库架构方面的变迁阶段,当然我们应该根据公司的具体情况,选择性的采用其中的技术,也可能是
直接跳过某些阶段,而上更高效的方案(如果成本能够接受),因此技术和方案的选择应该根据实际情况,灵活应对。

来源:程序园用户自行投稿发布,如果侵权,请联系站长删除
免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作!
页: [1]
查看完整版本: 数据库架构的升级和变更