{"rsdb":{"rid":"156648","subhead":"","postdate":"0","aid":"117570","fid":"57","uid":"1","topic":"1","content":"<p><img src=\"..\/..\/upload\/2017_03\/170301130425901.png\" alt=\"\" \/><\/p><br\/><p>\u9700\u8981\u81ea\u5b9a\u4e49\u6765\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002?<\/p><br\/><p>\u4e3b\u89d2\u8272\u4e2d\u7684\u8fde\u63a5<\/p><br\/><p>\u53ef\u8bfb\u8f85\u52a9\u526f\u672c<\/p><br\/><p>?<\/p><br\/><p>\u7b2c\u4e00\u79cd<\/p><br\/><p>\u7b2c\u4e8c\u79cd<\/p><br\/><p>\u7b2c\u4e00\u79cd\u65b9\u5f0f\u80fd\u591f\u8fdb\u884c\u66f4\u591a\u5730\u81ea\u5b9a\u4e49\uff0c\u4f46\u662f\u5df2\u7ecf\u8131\u79bbsqlserver always on\u6280\u672f\u4e86\uff0c\u56e0\u6b64\u4e0d\u8ba8\u8bba\u4e86<\/p><br\/><p>\u7b2c\u4e8c\u79cd\u65b9\u5f0f\u5bf9\u4e8e\u5ba2\u6237\u7aef\u6765\u8bb2\u66f4\u50bb\u74dc\u70b9\uff0c\u4f46\u662f\u81ea\u5b9a\u4e49\u529b\u5ea6\u5c0f\uff0c\u5168\u4f9d\u6258\u4e8ems\u672a\u6765\u600e\u4e48\u6539\u8fdb\u8fd9\u5757\u4e86\uff0c\u800c\u4e14\u8fd9\u91cc\u6709\u4e9b\u5751\u3002<\/p><br\/><p>\u57511\uff1aUI\u56fe\u5f62\u754c\u9762\u8bbe\u7f6e\u540e\uff0c\u8fd8\u9700\u8981\u6267\u884c\u811a\u672c\u6765\u5efa\u7acb\u8bfb\u5199\u5206\u79bb\u652f\u6301<\/p><br\/><p>\u5efa\u7acbread\u6307\u9488 - \u5728\u5f53\u524d\u7684primary\u4e0a\u4e3a\u6bcf\u4e2asqlserver instance\u5efa\u7acb[instance name=>instance tcp url] Map<\/p><br\/><p>\u5efa\u7acbprimary, read db ur list\u5173\u7cfb - \u5728\u5f53\u524d\u7684primary\u4e0a\u4e3a\u5404\u4e2aprimary\u5efa\u7acb\u5bf9\u5e94\u7684read only url \u5217\u8868\uff08\u6709\u4f18\u5148\u7ea7\u6982\u5ff5\uff09<\/p><br\/><p>\u53ef\u4ee5\u901a\u8fc7\u5982\u4e0b\u8bed\u53e5\u67e5\u770b\u8fd9\u4e2a\u5173\u7cfb\uff0c\u4ee5\u53ca\u76f8\u5e94\u7684\u4f18\u5148\u7ea7\uff1a<\/p><br\/><p><img src=\"..\/..\/upload\/2017_03\/170301130425904.png\" alt=\"\" \/><\/p><br\/><p>\u8fd9\u91cc\u7684routing_priority\u5c31\u662f\u4f18\u5148\u7ea7<\/p><br\/><p>\u57512\uff1a\u5ba2\u6237\u7aef\u9700\u8981\u6307\u5b9a\u8bbf\u95ee\u7684\u6570\u636e\u5e93\u4ee5\u53ca\u52a0\u5165ReadOnly\u5173\u952e\u5b57<\/p><br\/><p>C#\u8fde\u63a5\u5b57\u7b26\u4e32<\/p><br\/><p>SSMS\u65b9\u5f0f<\/p><br\/><p>\u57513\uff1aHosts\u6587\u4ef6\u8bbe\u7f6e<\/p><br\/><p>\u7531\u4e8eSQL Server Always On\u4f9d\u8d56\u4e8eWindows\u96c6\u7fa4\uff0c\u800cWindows\u96c6\u7fa4\u4f9d\u8d56\u4e8e\u6d3b\u52a8\u76ee\u5f55\uff0c\u800c\u5ba2\u6237\u7aef\u7a0b\u5e8f\u6240\u5728server\u5f88\u53ef\u80fd\u6ca1\u6709\u52a0\u5165\u57df\uff0c\u56e0\u6b64\u8fd9\u91cc\u7684\u89e3\u6790\u5b58\u5728\u95ee\u9898<\/p><br\/><p>\u7531\u4e8e\u8fd9\u79cd\u8bfb\u5199\u5206\u79bb\u7684\u65b9\u5f0f\uff0c\u5b9e\u9645\u4e0a\u662f\u5ba2\u6237\u7aef\u5148\u8fde\u63a5\u5230\u4fa6\u542c\u5668ip\uff0c\u7136\u540e\u901a\u8fc7\u534f\u5546\u540e\uff0c\u8ba9\u5ba2\u6237\u7aef\u518d\u8fde\u63a5\u5230\u5177\u4f53\u7684\u526f\u672c\u4e0a\uff08\u7528tcp url\uff0c\u4f7f\u7528\u4e86\u5168\u540d\u7684\uff0c\u5982\uff1asql1.ad.com\u8fd9\u79cd\u683c\u5f0f\uff0c\u5728ad\u5916\u90e8\u9ed8\u8ba4\u65e0\u6cd5\u89e3\u6790\uff09\uff0c\u56e0\u6b64\u9700\u8981\u4fee\u6539hosts\u6587\u4ef6\uff0c\u4e3a\u6bcf\u4e2a\u53ef\u80fd\u6210\u4e3aread\u7684\u5168\u540d\u589e\u52a0\u8bb0\u5f55\uff0c\u5982\u4e0b\uff1a<\/p><br\/>","orderid":"0","title":"SQL Server Always On \u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u65b9\u6cd5","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"408","pages":"1","comments":"0","posttime":"2017-03-03 08:15:38","list":"1488500138","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=SQL' target=_blank>SQL<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=Server' target=_blank>Server<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=Always' target=_blank>Always<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B6%C1%D0%B4' target=_blank>\u8bfb\u5199<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B7%D6%C0%EB' target=_blank>\u5206\u79bb<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%C5%E4%D6%C3' target=_blank>\u914d\u7f6e<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B7%BD%B7%A8' target=_blank>\u65b9\u6cd5<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"14.17.22.31","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"SQL Server Always On \u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u65b9\u6cd5","lastview":"1713606465","digg_num":"6696","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}