SQL Server 201X的高可用性ppt课件

SQLServer2012的高可用性,SQLServer高可用性,“Wereenjoying99.999%uptime,whichreallyhelpstokeepourbusinessrunning.”-MediterraneanShippingCompany,CustomersToday,复制,SQLServerAlwaysOn,SQLServer2012除了保留以前的Cluster、Mirror、Logshipping的所有功能，新增了AlwaysOn，其中的设置画面截图如下：,SQLServerAlwaysOn,增加应用程序高可用性，低TCO且容易使用快速转移多数据库故障转移多副本活动副本快速客户端重定向WindowsServerCore多站点群集,AlwaysOn技术,SQLServerAlwaysOn可用性组,可用性组为您的应用程序提供了高可用性和灾难恢复,多数据库故障转移多副本同步和异步数据移动内置压缩和加密自动和手动转移灵活的转移策略自动页面修复,活动副本使用虚拟名称自动重定向配置向导AlwaysOn仪表板SystemCenter集成使用PowerShell进行自动化管理丰富的调试基础架构基于文件流的复制,可用性组场景,可用性组为独立实例及故障转移群集实例上的数据库提供了冗余,可用性组体系架构,可用性组使用Windows服务器故障转移群集（WSFC)节点间健康检测协调故障转移主体健康检测分布式存储可用性组的设置和状态分布式更改通知,WindowsServer故障转移群集,WSFC-Microsoft可用性平台SQLServerAlwaysOn故障转移群集实例SQLServerAlwaysOn可用性组MicrosoftHyper-VMicrosoftExchange内置的WSFC应用程序，如文件共享，打印机等,AvailabilityGroupConceptsRecap,AvailabilityGroupDefinesthehighavailabilityrequirementsDatabases,Replicas,AvailabilityMode,FailoverModeetcAvailabilityReplicaSQLServerInstancesthatarepartoftheavailabilitygroupwhichhoststhephysicalcopyofthedatabaseRole:Primary,Secondary,ResolvingAvailabilityDatabaseSQLServerdatabasethatispartofanavailabilitygroupThiscanbearegulardatabaseorcontaineddatabase,AGResDLL,AGResDLL,AGResDLL,AvailabilityGroup1,AvailabilityGroup2,UsertellsSQLtofailoverAvailabilityGroup2toNode1,SQLconfirmsandtellsWSFC,WSFCtellsAGResDLLtobringAG2offline,WSFCtellsAGResDLLtobringAG2online,Notificationofnewprimary,Notificationofnewprimary,Secondariesrequestprimaryconnection,ClientsdisconnectedfromAG2,ClientconnectionstransparentlyredirectedtoprimaryviaIPandnetworknameresources,AvailabilityGroupArchitectureDrilldown,ClientFailoverusingVirtualName,AvailabilityGroupVirtualNameallowapplicationstofailoverseamlesslyonavailabilitygroupfailoverApplicationreconnectsusingavirtualnameafterafailovertoasecondary,AG_HR,HR_DB,HR_DB,Primary,Secondary,HR_VNN,-serverHR_VNN;-catalogHR_DB,Applicationretryduringfailover,Connecttonewprimaryoncefailoveriscompleteandthevirtualnameisonline,Primary,Secondary,Secondary,HR_DB,ServerA,ServerB,ServerC,只读副本,将查询的负载分到只读副本接近于实时数据,报表,对于这个新增的功能SQLServerAlwaysOn，实现了在多台Server的实例之间进行数据库分布，可以简单地用1-2-3-4来描述：1个主节点，可读可写最多2个自动故障转移节点（Clus