可用性组我们已经创建成功了,现在测试一下Node2 上读取数据以及Failover.
1.数据测据:Node1上创建表test插入记录
在Node2上访问test数据库,数据可以查到(在Mirror中是不可以查询的,而且数据同步不会导致Node2的连接断掉):
2.Failover测试:
连接到Node2:
Failover后(Primary已经变成Node2):
可以看到Always On group 既保证了高可用性,有可以实现同步数据库的只读访问,提供了硬件的利用率,非常给力的一个功能。
Part1:http://blog.csdn.net/smithliu328/article/details/7886455
Part2:http://blog.csdn.net/smithliu328/article/details/7886513
更多信息可以参考:MicrosoftSQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery:http://msdn.microsoft.com/en-us/library/hh781257.aspx
SQL Server 2012 AlwaysOn High Availability and Disaster Recovery DesignPatterns:http://sqlcat.com/sqlcat/b/msdnmirror/archive/2011/12/22/sql-server-2012-alwayson-high-availability-and-disaster-recovery-design-patterns.aspx
分享到:
相关推荐
Pro SQL Server Always On Availability Groups is aimed at SQL Server architects, database administrators, and IT professionals who are tasked with architecting and deploying a high-availability and ...
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows ...
Detailed Introduction. Kindle Version to Pdf.
6 SQL Server AlwaysOn and Availability Groups 7 SQL Server Database Snapshots 8 SQL Server Data Replication 9 SQL Server Log Shipping 10 High Availability Options in the Cloud 11 High Availability and...
To discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery ...
SQL Server 2008 High Availability SQL Server 2008 High Availability
This covers SQL Server 2005 features that enable appropriately designed solutions to achieve partial availability and remain online after a disk subsystem hardware failure.
Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server Walks you through ways to manage and monitor SQL Server and automate administration Guides you ...
Microsoft SQL Server 2008 High Availability
The book is based on Windows Server 2008 Step by step instructions of how to implement a failover cluster on Windows Server 2008 SQL Server PoweShell Administration Tasks Consolidate and virtualize ...
Filled with new real-world examples and hands-on exercises, Microsoft SQL Server 2016: A Beginner’s Guide, Sixth Edition 版本, starts by explaining fundamental relational database system concepts....
Packt.Microsoft.SQL.Server.2008.High.Availability.2011
This includes new chapters on SQL Server Analysis Services and SQL Server Reporting Services, the two key offerings in the Microsoft SQL Server BI stack. There is also a new chapter on optimizing SQL ...
通过适当的过程来帮助您计划和部署使用Microsoft SQL Server 2000的高度可用的数据中心,这些过程可以提高可用性,灾难性灾难恢复,停机预防和最小化。
Chapter 19 dives deeply into the role of log shipping in your high-availability strategy, and Chapter 20 presents a step-by-step guide to clustering your SQL Server and Windows 2008 server....
Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with ...
Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work “under the hood,” and how they communicate with each other. The detailed ...
For example, you will find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning ...